Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Migration and upgrade to 4.25 - checksetup.pl fails setting up foreign keys
29 views
Skip to first unread message
Phil Kasiecki
May 17, 2013, 5:56:48 PM5/17/13
to
We are trying to upgrade Bugzilla in conjunction with a new server that we have. I don't know the old version, but it's before 3.2, and we're going to 4.25. We're on Red Hat Enterprise Linux 6, and I have made it through most of the installation and configuration outlined on the Bugzilla page and the MozillaWiki page on moving a Bugzilla installation.
When I run checksetup.pl after importing the bugzilla-backup.sql file, it gets a lot of the way there but fails while attempting to set up foreign keys. I haven't figured out what to do from here despite lots of time looking up this or similar failures.
Any thoughts on what may be wrong/what we should try next would be much appreciated. Here's a look at the key output from the terminal during checksetup.pl:
Setting up foreign keys...
WARNING: There were invalid values in bugs_activity.attach_id that have
been deleted: 41
DBD::mysql::db do failed: Can't create table 'bugs.#sql-2f0e_4' (errno: 150) [for Statement "ALTER TABLE bugs_activity ADD
CONSTRAINT fk_bugs_activity_fieldid_fielddefs_id FOREIGN KEY (fieldid)
REFERENCES fielddefs(id)
ON UPDATE CASCADE ON DELETE RESTRICT, ADD
CONSTRAINT fk_bugs_activity_comment_id_longdescs_comment_id FOREIGN KEY (comment_id)
REFERENCES longdescs(comment_id)
ON UPDATE CASCADE ON DELETE CASCADE, ADD
CONSTRAINT fk_bugs_activity_who_profiles_userid FOREIGN KEY (who)
REFERENCES profiles(userid)
ON UPDATE CASCADE ON DELETE RESTRICT, ADD
CONSTRAINT fk_bugs_activity_bug_id_bugs_bug_id FOREIGN KEY (bug_id)
REFERENCES bugs(bug_id)
ON UPDATE CASCADE ON DELETE CASCADE, ADD
CONSTRAINT fk_bugs_activity_attach_id_attachments_attach_id FOREIGN KEY (attach_id)
REFERENCES attachments(attach_id)
ON UPDATE CASCADE ON DELETE CASCADE"] at Bugzilla/DB.pm line 654
Bugzilla::DB::bz_add_fks('Bugzilla::DB::Mysql=HASH(0x54f8020)', 'bugs_activity', 'HASH(0x4bb6338)', 'HASH(0x57476f8)') called at Bugzilla/DB.pm line 561
Bugzilla::DB::bz_setup_foreign_keys('Bugzilla::DB::Mysql=HASH(0x54f8020)') called at Bugzilla/Install/DB.pm line 685
Bugzilla::Install::DB::update_table_definitions('HASH(0x1f82b88)') called at ./checksetup.pl line 199
When I run checksetup.pl after importing the bugzilla-backup.sql file, it gets a lot of the way there but fails while attempting to set up foreign keys. I haven't figured out what to do from here despite lots of time looking up this or similar failures.
Any thoughts on what may be wrong/what we should try next would be much appreciated. Here's a look at the key output from the terminal during checksetup.pl:
Setting up foreign keys...
WARNING: There were invalid values in bugs_activity.attach_id that have
been deleted: 41
DBD::mysql::db do failed: Can't create table 'bugs.#sql-2f0e_4' (errno: 150) [for Statement "ALTER TABLE bugs_activity ADD
CONSTRAINT fk_bugs_activity_fieldid_fielddefs_id FOREIGN KEY (fieldid)
REFERENCES fielddefs(id)
ON UPDATE CASCADE ON DELETE RESTRICT, ADD
CONSTRAINT fk_bugs_activity_comment_id_longdescs_comment_id FOREIGN KEY (comment_id)
REFERENCES longdescs(comment_id)
ON UPDATE CASCADE ON DELETE CASCADE, ADD
CONSTRAINT fk_bugs_activity_who_profiles_userid FOREIGN KEY (who)
REFERENCES profiles(userid)
ON UPDATE CASCADE ON DELETE RESTRICT, ADD
CONSTRAINT fk_bugs_activity_bug_id_bugs_bug_id FOREIGN KEY (bug_id)
REFERENCES bugs(bug_id)
ON UPDATE CASCADE ON DELETE CASCADE, ADD
CONSTRAINT fk_bugs_activity_attach_id_attachments_attach_id FOREIGN KEY (attach_id)
REFERENCES attachments(attach_id)
ON UPDATE CASCADE ON DELETE CASCADE"] at Bugzilla/DB.pm line 654
Bugzilla::DB::bz_add_fks('Bugzilla::DB::Mysql=HASH(0x54f8020)', 'bugs_activity', 'HASH(0x4bb6338)', 'HASH(0x57476f8)') called at Bugzilla/DB.pm line 561
Bugzilla::DB::bz_setup_foreign_keys('Bugzilla::DB::Mysql=HASH(0x54f8020)') called at Bugzilla/Install/DB.pm line 685
Bugzilla::Install::DB::update_table_definitions('HASH(0x1f82b88)') called at ./checksetup.pl line 199
0 new messages