Bug#1057878: qa.debian.org: UDD upload_history has truncated email addresses
Package: qa.debian.org
Severity: normal
X-Debbugs-Cc: stuart@debian.org
The 'maintainer' and 'maintainer_email' columns of the upload_history table
in UDD have truncated email addresses. Somewhere the 'maintainer' data
is being truncated and then the maintainer_email is consequently broken.
udd=> SELECT maintainer, maintainer_email FROM upload_history WHERE maintainer_email LIKE '%=' LIMIT 10;
maintainer | maintainer_email
----------------------------------------------------------------+----------------------------------------------
Maintainers of GStreamer packages <pkg-gstreamer-maintainers@= | pkg-gstreamer-maintainers@=
Maintainers of GStreamer packages <pkg-gstreamer-maintainers@= | pkg-gstreamer-maintainers@=
Zenoss Packaging Team <pkg-zenoss-team@lists.alioth.debian.or= | pkg-zenoss-team@lists.alioth.debian.or=
Debian GNOME Maintainers <pkg-gnome-maintainers@lists.alioth.= | pkg-gnome-maintainers@lists.alioth.=
Debian Perl Group <pkg-perl-maintainers@lists.alioth.debian.o= | pkg-perl-maintainers@lists.alioth.debian.o=
Debian VoIP Team <pkg-voip-maintainers@lists.alioth.debian.or= | pkg-voip-maintainers@lists.alioth.debian.or=
Debian Python Modules Team <python-modules-team@lists.alioth.= | python-modules-team@lists.alioth.=
Debian Python Modules Team <python-modules-team@lists.alioth.= | python-modules-team@lists.alioth.=
Debian Firebird Group <pkg-firebird-general@lists.alioth.debi= | pkg-firebird-general@lists.alioth.debi=
Debian Samba Maintainers <pkg-samba-maint@lists.alioth.debian= | pkg-samba-maint@lists.alioth.debian=
(10 rows)
The input data from the d-d-c mailing list looks fine in the web archive,
but I can imagine this being due to linewrappig in the mbox files.
Looking at one specific example:
https://lists.debian.org/debian-devel-changes/2007/12/msg00466.html
udd=> SELECT maintainer, maintainer_email FROM upload_history WHERE maintainer_email LIKE '%=' AND source = 'libxml-rss-perl' AND version = '1.31-3';
maintainer | maintainer_email
----------------------------------------------------------------+---------------------------------------------
Debian Perl Group <pkg-perl-maintainers@lists.alioth.debian.o= | pkg-perl-maintainers@lists.alioth.debian.o=
(1 row)
This particular example is quite old but the problem also exists in
recent uploads; as of writing the most recent one is libgetdata (0.11.0-9)
that was uploaded today.
Of the 850k rows in upload_history, this data issue is in 70k of them.
cheers
Stuart
Reply to: