1216450 - DBD::mysql::db do failed: Can't create table 'bugzilla.#sql-3484_7' (errno: 150)

Status: RESOLVED INVALID

(Bugzilla :: Installation & Upgrading, defect)

Description

[Khireswar Kalita]

User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:40.0) Gecko/20100101 Firefox/40.0
Build ID: 20150826023504

Steps to reproduce:

I am upgrading bugzilla 4.2.2 version 5.0.1 version. I have followed the steps given https://www.bugzilla.org/docs/4.2/en/html/upgrade.html




Actual results:

While running ./checksetup.pl    I have encountered following issue:
Retried several times but no luck.
Removing existing compiled templates...
Precompiling templates...done.
Fixing file permissions...
Adding foreign key: test_case_components.component_id ->
components.id...
DBD::mysql::db do failed: Can't create table 'bugzilla.#sql-3484_7' (errno: 150) [for Statement "ALTER TABLE test_case_components ADD
     CONSTRAINT fk_test_case_components_component_id_components_id FOREIGN KEY (component_id)
     REFERENCES components(id)
      ON UPDATE CASCADE ON DELETE CASCADE"] at Bugzilla/DB.pm line 642
        Bugzilla::DB::bz_add_fks('Bugzilla::DB::Mysql=HASH(0x6687520)', 'test_case_components', 'HASH(0x5eb8428)', 'HASH(0x9944460)') called at Bugzilla/DB.pm line 546
        Bugzilla::DB::bz_setup_foreign_keys('Bugzilla::DB::Mysql=HASH(0x6687520)') called at Bugzilla/Install/DB.pm line 745
        Bugzilla::Install::DB::update_table_definitions('HASH(0x1fae058)') called at ./checksetup.pl line 172 


Expected results:

Expecting successful bugzilla upgrade.

Comment 1

[Andre Klapper]

For future reference I'd recommend http://bugzilla.readthedocs.org/en/5.0/installing/upgrading.html

> test_case_components

That sounds like Testopia. See bug 923865. 
Closing as INVALID as there is no problem created by the Bugzilla codebase in this task.