554086 - undef error - Not an ARRAY reference at Bugzilla/Object.pm line 202 after reassigning or closing bugs

Status: RESOLVED INVALID

(Bugzilla :: Creating/Changing Bugs, defect)

Description

[Pavel Pola]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; cs; rv:1.9.2) Gecko/20100115 Firefox/3.6 (.NET CLR 3.5.30729)
Build Identifier: 3.2.6

When trying to reassign a bug, the above message appears.

Reproducible: Sometimes

Steps to Reproduce:
1. edit a bug
2. change assignee to somebody else
3. enter a comment for reassign
4. commit changes
Actual Results:  
This message is displayed: 

Bugzilla has suffered an internal error. Please save this page and send it to [my e-mail address] with details of what you were doing at the time this message appeared.

URL: http://bugzilla.etnetera.cz/process_bug.cgi
undef error - Not an ARRAY reference at Bugzilla/Object.pm line 202. 

Notification e-mails are not sent to anybody.

Expected Results:  
Bug changes and notification e-mails are sent.

This "undef error" appeared last week. Nobody made any changes on the server or instalation. Maybe there is a problem in the database but how to find it?

Comment 1

[Max Kanat-Alexander]

  Are you running on PostgreSQL? If so, does upgrading DBD::Pg fix the problem?

Comment 2

[Pavel Pola]

No, we are running MySQL 4.1.11-Debian_4sarge7-log

Comment 3

[Max Kanat-Alexander]

  Okay. Run checksetup.pl --check-modules and attach the output here as an attachment (not as a comment)?

Comment 4

[Pavel Pola]

Attachment: Checksetup output

Here it goes...

Comment 5

[Max Kanat-Alexander]

  Okay, so I don't see anything strange in your checksetup output or your MySQL version (except that your MySQL version is very old).

  In Bugzilla.pm, there is a line that looks like this:

# $::SIG{__DIE__} = i_am_cgi() ? \&CGI::Carp::confess : \&Carp::confess;

  Remove the # from the front and produce the error again. It should be much longer. Copy the error here.

Comment 6

[Pavel Pola]

Here it is:

undef error - Not an ARRAY reference at Bugzilla/Object.pm line 202. at Bugzilla/Object.pm line 202 Bugzilla::Object::_do_list_select('Bugzilla::Product', ' id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?...', 'ARRAY(0x2241360)') called at Bugzilla/Object.pm line 185 Bugzilla::Object::match('Bugzilla::Product', 'HASH(0x22613a0)') called at Bugzilla/Object.pm line 145 Bugzilla::Object::new_from_list('Bugzilla::Product', 'ARRAY(0x224a5d0)') called at Bugzilla/User.pm line 649 Bugzilla::User::get_selectable_products('Bugzilla::User=HASH(0x1db5de0)') called at Bugzilla/User.pm line 539 Bugzilla::User::get_products_by_permission('Bugzilla::User=HASH(0x1db5de0)', 'editcomponents') called at data/template/template/en/default/global/site-navigation.html.tmpl line 340 eval {...} called at data/template/template/en/default/global/site-navigation.html.tmpl line 340 eval {...} called at data/template/template/en/default/global/site-navigation.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x1e57250)') called at /usr/local/lib/perl/5.8.8/Template/Document.pm line 155 eval {...} called at /usr/local/lib/perl/5.8.8/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0x20d12a0)', 'Template::Context=HASH(0x1e57250)') called at /usr/local/lib/perl/5.8.8/Template/Context.pm line 349 eval {...} called at /usr/local/lib/perl/5.8.8/Template/Context.pm line 319 Template::Context::process('Template::Context=HASH(0x1e57250)', 'global/site-navigation.html.tmpl') called at data/template/template/en/default/global/header.html.tmpl line 44 eval {...} called at data/template/template/en/default/global/header.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x1e57250)') called at /usr/local/lib/perl/5.8.8/Template/Document.pm line 155 eval {...} called at /usr/local/lib/perl/5.8.8/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0x20a53e0)', 'Template::Context=HASH(0x1e57250)') called at /usr/local/lib/perl/5.8.8/Template/Context.pm line 349 eval {...} called at /usr/local/lib/perl/5.8.8/Template/Context.pm line 319 Template::Context::process('Template::Context=HASH(0x1e57250)', 'global/header.html.tmpl', 'HASH(0x2064060)') called at data/template/template/en/default/bug/process/header.html.tmpl line 74 eval {...} called at data/template/template/en/default/bug/process/header.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x1e57250)') called at /usr/local/lib/perl/5.8.8/Template/Document.pm line 155 eval {...} called at /usr/local/lib/perl/5.8.8/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0x205db00)', 'Template::Context=HASH(0x1e57250)') called at /usr/local/lib/perl/5.8.8/Template/Context.pm line 349 eval {...} called at /usr/local/lib/perl/5.8.8/Template/Context.pm line 319 Template::Context::process('Template::Context=HASH(0x1e57250)', 'bug/process/header.html.tmpl') called at data/template/template/en/default/bug/process/results.html.tmpl line 25 eval {...} called at data/template/template/en/default/bug/process/results.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x1e57250)') called at /usr/local/lib/perl/5.8.8/Template/Document.pm line 155 eval {...} called at /usr/local/lib/perl/5.8.8/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0x1ff0110)', 'Template::Context=HASH(0x1e57250)') called at /usr/local/lib/perl/5.8.8/Template/Context.pm line 349 eval {...} called at /usr/local/lib/perl/5.8.8/Template/Context.pm line 319 Template::Context::process('Template::Context=HASH(0x1e57250)', 'Template::Document=HASH(0x1ff0110)') called at /usr/local/lib/perl/5.8.8/Template/Service.pm line 94 eval {...} called at /usr/local/lib/perl/5.8.8/Template/Service.pm line 91 Template::Service::process('Template::Service=HASH(0x1e57160)', 'bug/process/results.html.tmpl', 'HASH(0x1dc5260)') called at /usr/local/lib/perl/5.8.8/Template.pm line 68 Template::process('Bugzilla::Template=HASH(0x1dbf410)', 'bug/process/results.html.tmpl', 'HASH(0x1dc5260)') called at /srv/www/bugzilla.etnetera.cz/process_bug.cgi line 86 main::send_results(8885, 'HASH(0x1dc5260)') called at /srv/www/bugzilla.etnetera.cz/process_bug.cgi line 605 at data/template/template/en/default/global/site-navigation.html.tmpl line 340 eval {...} called at data/template/template/en/default/global/site-navigation.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x1e57250)') called at /usr/local/lib/perl/5.8.8/Template/Document.pm line 155 eval {...} called at /usr/local/lib/perl/5.8.8/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0x20d12a0)', 'Template::Context=HASH(0x1e57250)') called at /usr/local/lib/perl/5.8.8/Template/Context.pm line 349 eval {...} called at /usr/local/lib/perl/5.8.8/Template/Context.pm line 319 Template::Context::process('Template::Context=HASH(0x1e57250)', 'global/site-navigation.html.tmpl') called at data/template/template/en/default/global/header.html.tmpl line 44 eval {...} called at data/template/template/en/default/global/header.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x1e57250)') called at /usr/local/lib/perl/5.8.8/Template/Document.pm line 155 eval {...} called at /usr/local/lib/perl/5.8.8/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0x20a53e0)', 'Template::Context=HASH(0x1e57250)') called at /usr/local/lib/perl/5.8.8/Template/Context.pm line 349 eval {...} called at /usr/local/lib/perl/5.8.8/Template/Context.pm line 319 Template::Context::process('Template::Context=HASH(0x1e57250)', 'global/header.html.tmpl', 'HASH(0x2064060)') called at data/template/template/en/default/bug/process/header.html.tmpl line 74 eval {...} called at data/template/template/en/default/bug/process/header.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x1e57250)') called at /usr/local/lib/perl/5.8.8/Template/Document.pm line 155 eval {...} called at /usr/local/lib/perl/5.8.8/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0x205db00)', 'Template::Context=HASH(0x1e57250)') called at /usr/local/lib/perl/5.8.8/Template/Context.pm line 349 eval {...} called at /usr/local/lib/perl/5.8.8/Template/Context.pm line 319 Template::Context::process('Template::Context=HASH(0x1e57250)', 'bug/process/header.html.tmpl') called at data/template/template/en/default/bug/process/results.html.tmpl line 25 eval {...} called at data/template/template/en/default/bug/process/results.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x1e57250)') called at /usr/local/lib/perl/5.8.8/Template/Document.pm line 155 eval {...} called at /usr/local/lib/perl/5.8.8/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0x1ff0110)', 'Template::Context=HASH(0x1e57250)') called at /usr/local/lib/perl/5.8.8/Template/Context.pm line 349 eval {...} called at /usr/local/lib/perl/5.8.8/Template/Context.pm line 319 Template::Context::process('Template::Context=HASH(0x1e57250)', 'Template::Document=HASH(0x1ff0110)') called at /usr/local/lib/perl/5.8.8/Template/Service.pm line 94 eval {...} called at /usr/local/lib/perl/5.8.8/Template/Service.pm line 91 Template::Service::process('Template::Service=HASH(0x1e57160)', 'bug/process/results.html.tmpl', 'HASH(0x1dc5260)') called at /usr/local/lib/perl/5.8.8/Template.pm line 68 Template::process('Bugzilla::Template=HASH(0x1dbf410)', 'bug/process/results.html.tmpl', 'HASH(0x1dc5260)') called at /srv/www/bugzilla.etnetera.cz/process_bug.cgi line 86 main::send_results(8885, 'HASH(0x1dc5260)') called at /srv/www/bugzilla.etnetera.cz/process_bug.cgi line 605

Comment 7

[Max Kanat-Alexander]

  I'm guessing there's a bug in the interaction between your version of DBD::mysql (which is very new) and your version of MySQL (which is very old). I'm also guessing that this happened after you added a new product, and the bug was triggered by having too many products.

  (The error you're seeing indicates that the database returned "undef" to us in a situation where returning "undef" is supposed to be impossible.)

  So this is INVALID because it's not a bug in Bugzilla, but rather a bug in some external software.