Bug#1076451: qa.debian.org: UDD for ubuntu-sponsorships has stopped working.

[Ravi Kant Sharma <ravi.kant.sharma@canonical.com>]

Package: qa.debian.org
Severity: normal
X-Debbugs-Cc: ravi.kant.sharma@canonical.com
Usertags: udd

Dear Maintainer,

UDD ubuntu-sponsorships.cgi stopped working some time ago (>1 month).

example report: https://udd.debian.org/cgi-bin/ubuntu-sponsorships.cgi?render=html&sponsor=&sponsor_search=name&sponsoree=*ravi%20kant*&sponsoree_search=name
example of a missing upload: https://launchpad.net/ubuntu/+source/linssid/3.6-8ubuntu1

https://udd.debian.org/udd-status.cgi (ubuntu-upload-history) points to the following error -

Traceback (most recent call last):
  File "/srv/udd.debian.org/udd//udd.py", line 83, in <module>
    getattr(gatherer, command)()
  File "/srv/udd.debian.org/udd/udd/upload_history_gatherer.py", line 204, in run
    cursor.executemany(query, uploads)
psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "ubuntu_upload_history_pkey"
DETAIL:  Key (source, version)=(edubuntu-meta, 24.10.01) already exists.

Cheers!
Ravi