Bug#1126068: ubuntu-sponsorships is returning no results (for "recent" uploads?)

Hey Lucas, thanks for the reply and for fixing the code issue and 
investigating the connection problem.

1. About the blocked IP, I talked to Launchpad team and indeed 
firewalled on their side and they removed the restriction now.

2. They are facing load problems due to LLM scrapers, which is why they 
ended up blocking a range of machines including ullmann. Would it 
possible for UDD to use launchpad API to get those information instead 
of scraping the pages?

3. Following your comment to Laney, it seems UDD is parsing 
<release>-changes Ubuntu lists? As a FYI there is a plan to stop 
providing those, probably starting next cycle
In fact that was tried early this cycle but since there was no 
replacement ready we ended up creating resolute-changes@. We had a few 
days where resolute was open without having the list which probably 
means UDD has a data gap between Octobre 20th and 22th)

Cheers,
Sébastien

Le 31/01/2026 à 08:26, Lucas Nussbaum a écrit :
> Hi,
>
> On 26/01/26 at 14:55 +0100, Lucas Nussbaum wrote:
>> On 21/01/26 at 16:04 +0100, Sebastien Bacher wrote:
>>> Package: qa.debian.org
>>> User: [email protected]
>>> Usertags: udd
>>>
>>> It seems UDD ubuntu-sponsoring  is failing to return (recent?) uploads,
>>> example URL from https://discourse.ubuntu.com/t/application-ubuntu-contributing-developer-nadzeya-hutsko
>>>
>>> https://udd.debian.org/cgi-bin/ubuntu-sponsorships.cgi?render=html&sponsor=Nick+Rosbrook&sponsor_search=name&sponsoree=Nadzeya+Hutsko&sponsoree_search=name
>>>
>>> is returning an empty list
>>>
>>> where it should be listing entries like those
>>> https://launchpad.net/ubuntu/+source/vim/2:9.1.1882-1ubuntu1
>>> https://launchpad.net/ubuntu/+source/rust-rav1e/0.8.1-6ubuntu1
>>>
>>> Checking my firefox history I've an URL example which I think worked some
>>> months ago and is returning no result now
>>> https://udd.debian.org/cgi-bin/ubuntu-sponsorships.cgi?render=html&sponsor=Sebastien+Bacher&sponsor_search=name&sponsoree=Alessandro+Astone&sponsoree_search=name
>>>
>>> Searching for packages I sponsored return a list starting in 2007 though so
>>> the service has still some data/is at least partially working...
>> Hi,
>>
>> Right, I introduced a regression a few days ago. Thanks for spotting.
>> FTR this is fixed in 70b546f54c05569385782e2ee72007ef617c977e
>>
>> However there's another issue: it looks like the process of converting
>> Ubuntu email archives to summarized files broke after December 19th.
>> That process is managed by Iain Lane.
> Hi,
>
> Further debugging indicates that the host used to download data from
> launchpad's API is blacklisted somehow on the launchpad side.
>
> It's ullmann.debian.org / 2607:f8f0:614:1::1274:38
> And the problem started happening on 2025-12-19.
>
> $ tcptraceroute6 2620:2d:4000:1009::3ba 443
> traceroute to 2620:2d:4000:1009::3ba (2620:2d:4000:1009::3ba) from 2607:f8f0:614:1::1274:38, port 443, from port 32386, 30 hops max, 60 bytes packets
> [...]
> 17  port-channel1.core1.lon6.he.net (2001:470:0:680::2)  127.643 ms  127.838 ms  *
> 18  swp9.il3-core1.canonical.com (2001:470:1:c32::2)  127.342 ms  127.343 ms  127.313 ms
> 19  vrrp.bond-core.il3-fw.canonical.com (2620:2d:4000:1::13)  127.291 ms  129.606 ms  127.347 ms
> 20  * * *
> 21  * * *
> 22  * * *
>
> It works over IPv4, but I'd rather not ignore IPv6 on the client side.
>
> I believe the behaviour of the script is sane.
>
> Any help with getting it unblacklisted on the Canonical/Launchpad side
> would be very welcomed.
>
> Lucas