[CentOS] Bugzilla not working following RHEL to CentOS migration

Chris Ross cnts5645 at tebibyte.org
Tue Aug 11 09:23:46 UTC 2009

Dear listmates,

I've recently moved a server from RHEL5 to CentOS 5.3 after it was 
decided not to renew the subscripton. Everything works beautifully 
except for Bugzilla, which throws MySQL errors. For example, the 
sanitycheck.cgi page says:

# # #

Bugzilla – Sanity Check

     * Home
     * | New
     * | Search
     * |
     * | Reports
     * | My Votes
     * | Preferences
     * | Administration
     * | Log out bugzilla at grandeye.com

Bugzilla is checking the referential integrity of your database. This 
may take several minutes to complete.

Errors, if any, will be emphasized like this. Depending on the errors 
found, some links will be displayed allowing you to easily fix them. 
Fixing these errors will automatically run this script again (so be 
aware that it may take an even longer time than the first run).

OK, now running sanity checks.

Checking references to classifications.id...

... from products.classification_id.

Checking references to keyworddefs.id...

... from keywords.keywordid.

Checking references to fielddefs.id...

... from bugs_activity.fieldid.

... from profiles_activity.fieldid.

Checking references to flagtypes.id...

... from flags.type_id.

... from flagexclusions.type_id.

... from flaginclusions.type_id.

Checking references to bugs.bug_id...

... from bugs_activity.bug_id.

... from bug_group_map.bug_id.

... from bugs_fulltext.bug_id.
Software error:

DBD::mysql::st execute failed: Table 'bugs.bugs_fulltext' doesn't exist 
[for Statement "SELECT DISTINCT bugs_fulltext.bug_id FROM bugs_fulltext
                     LEFT JOIN bugs
                            ON bugs_fulltext.bug_id = bugs.bug_id
                         WHERE bugs.bug_id IS NULL
                           AND bugs_fulltext.bug_id IS NOT NULL"] at 
/var/www/html/bugzilla/sanitycheck.cgi line 428
	main::CrossCheck('bugs', 'bug_id', 'ARRAY(0x1760b5a0)', 
'ARRAY(0x18298ba0)', 'ARRAY(0x18298830)', 'ARRAY(0x1814a150)', 
'ARRAY(0x17f0bf50)', 'ARRAY(0x18298840)', 'ARRAY(0x18298850)', ...) 
called at /var/www/html/bugzilla/sanitycheck.cgi line 469

For help, please send mail to the webmaster (root at localhost), giving 
this error message and the time and date of the error.

# # #

bugzilla, mysql and perl are fully up-to-date according to yum, I have 
checked that the database is OK but restored a suitable (mysqldump) 
backup anyway.

[root at neodymium bugzilla]# rpm -qa bugzilla mysql perl
[root at neodymium bugzilla]# perl --version

This is perl, v5.8.8 built for x86_64-linux-thread-multi

[root at neodymium bugzilla]# mysql --version
mysql  Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (x86_64) using 
readline 5.0

Googling hasn't helped beyond suggesting this has happened to others 
following RHEL upgrading Bugzilla 3.0.2 to 3.2.4 in July for security. 
Sadly, that didn't show the way out of it.

Any help would be gratefully accepted.

Many thanks,
Chris R.

More information about the CentOS mailing list