Package: qa.debian.org
Severity: normal
X-Debbugs-Cc: [email protected]
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 <[email protected]= |
[email protected]=
Debian GNOME Maintainers <[email protected].= |
[email protected].=
Debian Perl Group <[email protected]= |
[email protected]=
Debian VoIP Team <[email protected]= |
[email protected]=
Debian Python Modules Team <[email protected].= |
[email protected].=
Debian Python Modules Team <[email protected].= |
[email protected].=
Debian Firebird Group <[email protected]= |
[email protected]=
Debian Samba Maintainers <[email protected]= |
[email protected]=
(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 <[email protected]= |
[email protected]=
(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
