Bugzilla internal error

Bugzilla internal error

[Rene Sugar]

I was viewing bugs using the following query.

http://sourceware.org/bugzilla/buglist.cgi?bug_status=REOPENED&bug_status=SUSPENDED&bug_status=NEW&bug_status=WAITING&bug_status=ASSIGNED&bug_status=UNCONFIRMED&field0-0-0=product&field0-0-1=component&field0-0-2=alias&field0-0-3=short_d 
esc&field0-0-4=status_whiteboard&field0-0-5=content&query_format=advanced&type0-0-0=substring&type0-0-1=substring&type0-0-2=substring&type0-0-3=substring&type0-0-4=substring&type0-0-5=matches&value0-0-0=mingw&value0-0-1=mingw&value0-0-2=mingw&value0-0-3=mingw&value0-0-4=mingw&value0-0-5=%22mingw%22&order=bug_id%20DESC&query_based_on=


After clicking on a link to a bug report, I got the following error:

Sources Bugzilla has suffered an internal error. Please save this page 
and send it to overseers@sourceware.org with details of what you were 
doing at the time this message appeared.

URL: http://sourceware.org/bugzilla/show_bug.cgi?id=11539
undef error - Insecure dependency in parameter 3 of 
DBI::db=HASH(0xaa65d5c)->selectall_arrayref method call while running 
with -T switch at Bugzilla/Object.pm line 276.

Traceback:

Bugzilla internal error

[Andreas Schwab]

show_bug.cgi (with any bug number) currently throws this error:

undef error - DBD::mysql::st execute failed: Got error 28 from storage engine [for Statement "SELECT DISTINCT groups.id, name, description, CASE WHEN bug_group_map.group_id IS NOT NULL THEN 1 ELSE 0 END, CASE WHEN groups.id IN(7,6,5,8) THEN 1 ELSE 0 END, isactive, membercontrol, othercontrol FROM groups LEFT JOIN bug_group_map ON bug_group_map.group_id = groups.id AND bug_id = ? LEFT JOIN group_control_map ON group_control_map.group_id = groups.id AND group_control_map.product_id = ? WHERE isbuggroup = 1 ORDER BY description" with ParamValues: 0='67227', 1='1'] at Bugzilla/Bug.pm line 3866. Bugzilla::Bug::groups(Bugzilla::Bug=HASH(0x524d498)) called at template/en/default/bug/edit.html.tmpl line 629 eval {...} called at template/en/default/bug/edit.html.tmpl line 629 eval {...} called at template/en/default/bug/edit.html.tmpl line 718 Template::Provider::__ANON__(Bugzilla::Template::Context=HASH(0x4e557f8)) called at lib/x86_64-linux-thread-multi/Template/Context.pm line 348 eval {...} called at lib/x86_64-linux-thread-multi/Template/Context.pm line 321 Template::Context::process(Bugzilla::Template::Context=HASH(0x4e557f8), "section_restrict_visibility") called at Bugzilla/Template/Context.pm line 35 Bugzilla::Template::Context::process(Bugzilla::Template::Context=HASH(0x4e557f8), "section_restrict_visibility") called at template/en/default/bug/edit.html.tmpl line 162 eval {...} called at template/en/default/bug/edit.html.tmpl line 18 Template::Provider::__ANON__(Bugzilla::Template::Context=HASH(0x4e557f8)) called at lib/x86_64-linux-thread-multi/Template/Document.pm line 163 eval {...} called at lib/x86_64-linux-thread-multi/Template/Document.pm line 161 Template::Document::process(Template::Document=HASH(0x5995b68), Bugzilla::Template::Context=HASH(0x4e557f8)) called at lib/x86_64-linux-thread-multi/Template/Context.pm line 351 eval {...} called at lib/x86_64-linux-thread-multi/Template/Context.pm line 321 Template::Context::process(Bugzilla::Template::Context=HASH(0x4e557f8), "bug/edit.html.tmpl") called at Bugzilla/Template/Context.pm line 35 Bugzilla::Template::Context::process(Bugzilla::Template::Context=HASH(0x4e557f8), "bug/edit.html.tmpl") called at template/en/default/bug/show.html.tmpl line 28 eval {...} called at template/en/default/bug/show.html.tmpl line 18 Template::Provider::__ANON__(Bugzilla::Template::Context=HASH(0x4e557f8)) called at lib/x86_64-linux-thread-multi/Template/Document.pm line 163 eval {...} called at lib/x86_64-linux-thread-multi/Template/Document.pm line 161 Template::Document::process(Template::Document=HASH(0x4fe1f88), Bugzilla::Template::Context=HASH(0x4e557f8)) called at lib/x86_64-linux-thread-multi/Template/Context.pm line 351 eval {...} called at lib/x86_64-linux-thread-multi/Template/Context.pm line 321 Template::Context::process(Bugzilla::Template::Context=HASH(0x4e557f8), Template::Document=HASH(0x4fe1f88)) called at Bugzilla/Template/Context.pm line 35 Bugzilla::Template::Context::process(Bugzilla::Template::Context=HASH(0x4e557f8), Template::Document=HASH(0x4fe1f88)) called at lib/x86_64-linux-thread-multi/Template/Service.pm line 94 eval {...} called at lib/x86_64-linux-thread-multi/Template/Service.pm line 91 Template::Service::process(Template::Service=HASH(0x4da0050), "bug/show.html.tmpl", HASH(0x21eef28)) called at lib/x86_64-linux-thread-multi/Template.pm line 66 Template::process(Bugzilla::Template=HASH(0x4d8d408), "bug/show.html.tmpl", HASH(0x21eef28)) called at Bugzilla/Template.pm line 704 Bugzilla::Template::process(Bugzilla::Template=HASH(0x4d8d408), "bug/show.html.tmpl", HASH(0x21eef28)) called at /www/gcc/bugzilla/show_bug.cgi line 130

Andreas.

-- 
Andreas Schwab, schwab@linux-m68k.org
GPG Key fingerprint = 58CA 54C7 6D53 942B 1756  01D3 44D5 214B 8276 4ED5
"And now for something completely different."

Re: Bugzilla internal error

[Frank Ch. Eigler]

Hi -

On Mon, Sep 27, 2010 at 03:14:24PM +0200, Andreas Schwab wrote:
> URL: http://sourceware.org/bugzilla/show_bug.cgi?id=11611
> 
> undef error - DBD::mysql::st execute failed: Table 'longdescs' is marked as crashed and last (automatic?) repair failed [for Statement "SELECT  profiles.realname, profiles.login_name, 
> [...]

I set up and ran a weekly mysqlcheck cron job that runs -a
--auto-repair.  It cleaned up this error.

- FChE

Bugzilla internal error

[Andreas Schwab]

URL: http://sourceware.org/bugzilla/show_bug.cgi?id=11611

undef error - DBD::mysql::st execute failed: Table 'longdescs' is marked as crashed and last (automatic?) repair failed [for Statement "SELECT  profiles.realname, profiles.login_name, 
                     date_format(longdescs.bug_when,'%Y.%m.%d %H:%i'), 
                     longdescs.thetext, longdescs.work_time,
                     isprivate,
                     date_format(longdescs.bug_when,'%Y%m%d%H%i%s') 
            FROM     longdescs, profiles
            WHERE    profiles.userid = longdescs.who 
              AND    longdescs.bug_id = 11615 
            ORDER BY longdescs.bug_when"] at Bugzilla/DB.pm line 66
	Bugzilla::DB::SendSQL('SELECT  profiles.realname, profiles.login_name, \x{a}            ...') called at globals.pl line 1100
	main::GetComments(11615) called at /www/sourceware/bugzilla/Bug.pm line 304
	Bug::longdescs('Bug=HASH(0x974c710)') called at data/template/en/custom/bug/edit.html.tmpl line 35
	eval {...} called at data/template/en/custom/bug/edit.html.tmpl line 35
	eval {...} called at data/template/en/custom/bug/edit.html.tmpl line 16
	Template::Provider::__ANON__('Template::Context=HASH(0x9bfa0fc)') called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/Template/Document.pm line 151
	eval {...} called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/Template/Document.pm line 149
	Template::Document::process('Template::Document=HASH(0x9dc270c)', 'Template::Context=HASH(0x9bfa0fc)') called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/Template/Context.pm line 351
	eval {...} called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/Template/Context.pm line 321
	Template::Context::process('Template::Context=HASH(0x9bfa0fc)', 'bug/edit.html.tmpl') called at data/template/en/default/bug/show.html.tmpl line 65
	eval {...} called at data/template/en/default/bug/show.html.tmpl line 16
	Template::Provider::__ANON__('Template::Context=HASH(0x9bfa0fc)') called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/Template/Document.pm line 151
	eval {...} called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/Template/Document.pm line 149
	Template::Document::process('Template::Document=HASH(0x974d2b0)', 'Template::Context=HASH(0x9bfa0fc)') called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/Template/Context.pm line 351
	eval {...} called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/Template/Context.pm line 321
	Template::Context::process('Template::Context=HASH(0x9bfa0fc)', 'Template::Document=HASH(0x974d2b0)') called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/Template/Service.pm line 94
	eval {...} called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/Template/Service.pm line 91
	Template::Service::process('Template::Service=HASH(0x9bc3edc)', 'bug/show.html.tmpl', 'HASH(0x9b926b8)') called at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/Template.pm line 66
	Template::process('Bugzilla::Template=HASH(0x9b92b6c)', 'bug/show.html.tmpl', 'HASH(0x9b926b8)') called at /www/sourceware/bugzilla/show_bug.cgi line 115

Andreas.

-- 
Andreas Schwab, schwab@redhat.com
GPG Key fingerprint = D4E8 DBE3 3813 BB5D FA84  5EC7 45C6 250E 6F00 984E
"And now for something completely different."