DB Migration script Error during update to 6.0.6-01

[pmn]

hello,

Could anyone give some direction where to trace the error when running the dB migration script. I'm upgrading from 5.0.27 on CentOS 7 which was running well without errors.


Step 1 of 39: Check framework version ...
Step 2 of 39: Check required Perl version ...
Step 3 of 39: Check required database version ...
Step 4 of 39: Check database charset ...
Step 5 of 39: Check required Perl modules ...
Step 6 of 39: Check if database has been backed up ...
Step 7 of 39: Upgrade database structure ...
[Wed Apr 25 15:32:49 2018] DBUpdate-to-6.pl: DBD::mysql::db do failed: Can't create table 'otrs.#sql-70e_9' (errno: 150) at /opt/otrs/Kernel/System/DB.pm line 470.
ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-01 Perl: 5.16.3 OS: linux Time: Wed Apr 25 15:32:49 2018

Message: Can't create table 'otrs.#sql-70e_9' (errno: 150), SQL: 'EXECUTE FKStatement'

Traceback (3426):
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 363
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 311
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::NewSysconfigTables::Run Line: 208
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::Run Line: 134
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: scripts/DBUpdate-to-6.pl Line: 89


ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-01 Perl: 5.16.3 OS: linux Time: Wed Apr 25 15:32:49 2018

Message: Error during execution of 'EXECUTE FKStatement'!

Traceback (3426):
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 366
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 311
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::NewSysconfigTables::Run Line: 208
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::Run Line: 134
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: scripts/DBUpdate-to-6.pl Line: 89

CheckModules.pl Output

o Apache::DBI......................ok (v1.12)
o Apache2::Reload..................ok (v0.13)
o Archive::Tar.....................ok (v1.92)
o Archive::Zip.....................ok (v1.30)
o Crypt::Eksblowfish::Bcrypt.......Not installed! Use: 'yum install "perl(Crypt::Eksblowfish::Bcrypt)"' (optional - For strong password hashing.)
o Crypt::SSLeay....................ok (v0.64)
o Date::Format.....................ok (v2.24)
o DateTime.........................ok (v1.04)
o DBI..............................ok (v1.627)
o DBD::mysql.......................ok (v4.023)
o DBD::ODBC........................Not installed! (optional - Required to connect to a MS-SQL database.)
o DBD::Oracle......................Not installed! (optional - Required to connect to a Oracle database.)
o DBD::Pg..........................Not installed! Use: 'yum install "perl(DBD::Pg)"' (optional - Required to connect to a PostgreSQL database.)
o Digest::SHA......................ok (v5.85)
o Encode::HanExtra.................Not installed! Use: 'yum install "perl(Encode::HanExtra)"' (optional - Required to handle mails with several Chinese character sets.)
o IO::Socket::SSL..................ok (v1.94)
o JSON::XS.........................Not installed! Use: 'yum install "perl(JSON::XS)"' (optional - Recommended for faster AJAX/JavaScript handling.)
o List::Util::XS...................ok (v1.27)
o LWP::UserAgent...................ok (v6.26)
o Mail::IMAPClient.................ok (v3.37)
o IO::Socket::SSL................ok (v1.94)
o Authen::SASL...................ok (v2.15)
o Authen::NTLM...................Not installed! Use: 'yum install "perl(Authen::NTLM)"' (optional - Required for NTLM authentication mechanism in IMAP connections.)
o ModPerl::Util....................ok (v2.000010)
o Net::DNS.........................ok (v0.72)
o Net::LDAP........................ok (v0.56)
o Template.........................ok (v2.24)
o Template::Stash::XS..............ok (undef)
o Text::CSV_XS.....................ok (v1.00)
o Time::HiRes......................ok (v1.9725)
o XML::LibXML......................ok (v2.0018)
o XML::LibXSLT.....................ok (v1.80)
o XML::Parser......................ok (v2.41)
o YAML::XS.........................ok (v0.54)

[root]

Hi,

Which table engine do you use? MyISAM or InnoDB.

- Roy

[pmn]

INNODB

[root]

Hi,

And you have enough space free on the disk which contains the mysql datadir?

- Roy

[fsidoli]

I'm seeing the same issue and have just posted here:

viewtopic.php?f=62&t=39145&p=158807#p158507