Bug#787075: UDD: bugs importer choking on invalid email fields
Package: qa.debian.org
Severity: normal
User: qa.debian.org@packages.debian.org
Usertags: udd
Hi,
UDD's bugs gatherer outputs errors caused by invalid email fields in archived bugs:
Unmatched () '(B <akira@debian.org>' '' at /usr/share/perl5/Mail/Address.pm line 86.
Mail::Address::_tokenise("akira yamada / \x{1b}\$B\$d\$^\$\@\$\"\$-\$i\x{1b}(B <akira\@debian.org>") called at /usr/share/perl5/Mail/Address.pm line 149
Mail::Address::parse("Mail::Address", "akira yamada / \x{1b}\$B\$d\$^\$\@\$\"\$-\$i\x{1b}(B <akira\@debian.org>") called at /srv/udd.debian.org/udd/udd/bugs_gatherer.pl line 302
main::update_bug(HASH(0x372fd40), "bugs-archive", DBI::db=HASH(0x37584d8), 72778) called at /srv/udd.debian.org/udd/udd/bugs_gatherer.pl line 462
main::update_bugs(HASH(0x372fd40), "bugs-archive", DBI::db=HASH(0x37584d8), ARRAY(0x1e0bf58), 10000) called at /srv/udd.debian.org/udd/udd/bugs_gatherer.pl line 526
main::run(HASH(0x372fd40), "bugs-archive", DBI::db=HASH(0x37584d8)) called at /srv/udd.debian.org/udd/udd/bugs_gatherer.pl line 643
main::main() called at /srv/udd.debian.org/udd/udd/bugs_gatherer.pl line 653
Unmatched () '(B <akira@debian.org>' '' at /usr/share/perl5/Mail/Address.pm line 86.
Mail::Address::_tokenise("akira yamada / \x{1b}\$B\$d\$^\$\@\$\"\$-\$i\x{1b}(B <akira\@debian.org>") called at /usr/share/perl5/Mail/Address.pm line 149
Mail::Address::parse("Mail::Address", "akira yamada / \x{1b}\$B\$d\$^\$\@\$\"\$-\$i\x{1b}(B <akira\@debian.org>") called at /srv/udd.debian.org/udd/udd/bugs_gatherer.pl line 320
main::update_bug(HASH(0x372fd40), "bugs-archive", DBI::db=HASH(0x37584d8), 46691) called at /srv/udd.debian.org/udd/udd/bugs_gatherer.pl line 462
main::update_bugs(HASH(0x372fd40), "bugs-archive", DBI::db=HASH(0x37584d8), ARRAY(0x1e0bf58), 10000) called at /srv/udd.debian.org/udd/udd/bugs_gatherer.pl line 526
main::run(HASH(0x372fd40), "bugs-archive", DBI::db=HASH(0x37584d8)) called at /srv/udd.debian.org/udd/udd/bugs_gatherer.pl line 643
main::main() called at /srv/udd.debian.org/udd/udd/bugs_gatherer.pl line 653
Unmatched () '(B 拓 <Taku.Akutsu@ma5.seikyou.ne.jp>' '' at /usr/share/perl5/Mail/Address.pm line 86.
Mail::Address::_tokenise("\x{1b}\$B0\$5WDE\x{1b}(B \x{1b}\$BBs\x{1b}(B <Taku.Akutsu\@ma5.seikyou.ne.jp>") called at /usr/share/perl5/Mail/Address.pm line 149
Mail::Address::parse("Mail::Address", "\x{1b}\$B0\$5WDE\x{1b}(B \x{1b}\$BBs\x{1b}(B <Taku.Akutsu\@ma5.seikyou.ne.jp>") called at /srv/udd.debian.org/udd/udd/bugs_gatherer.pl line 302
main::update_bug(HASH(0x372fd40), "bugs-archive", DBI::db=HASH(0x37584d8), 71082) called at /srv/udd.debian.org/udd/udd/bugs_gatherer.pl line 462
main::update_bugs(HASH(0x372fd40), "bugs-archive", DBI::db=HASH(0x37584d8), ARRAY(0x1e0bf58), 10000) called at /srv/udd.debian.org/udd/udd/bugs_gatherer.pl line 526
main::run(HASH(0x372fd40), "bugs-archive", DBI::db=HASH(0x37584d8)) called at /srv/udd.debian.org/udd/udd/bugs_gatherer.pl line 643
main::main() called at /srv/udd.debian.org/udd/udd/bugs_gatherer.pl line 653
There are also other errors.
failed to convert to utf8 (charset: UTF-8, data: �ric) at /srv/bugs.debian.org/perl/Debbugs/UTF8.pm line 187, <GEN3039> line 11.
failed to convert to utf8 (charset: UTF-8, data: �ric) at /srv/bugs.debian.org/perl/Debbugs/UTF8.pm line 187, <GEN4466> line 8.
failed to convert to utf8 (charset: UTF-8, data: �ric) at /srv/bugs.debian.org/perl/Debbugs/UTF8.pm line 187, <GEN4979> line 9.
The simplest way to fix that could be to unarchive the affected bugs, fix the submitter, and archive again...
select * from archived_bugs where submitter ~ 'akira yamada /'; only shows 27 affected bugs
Lucas
Reply to: