Error in Upgrade

Moderator: crythias

Post Reply
cfreire
Znuny newbie
Posts: 59
Joined: 24 Aug 2015, 16:40
Znuny Version: 3.3.x
Real Name: Carlos Freire
Company: Palosanto

Error in Upgrade

Post by cfreire »

Hi my friends....

Please if any people may to help me.... I have Otrs5 in Centos7, want to update this to OTRS6, but at the momento that I run the scripts/DBUpdate-to-6.pl, I receive the next error:

Step 7 of 42: Upgrade database structure ...
[Fri Dec 21 09:11:56 2018] DBUpdate-to-6.pl: DBD::mysql::db do failed: Can't create table 'otrs.#sql-68c_19' (errno: 150) at /opt/otrs/Kernel/System/DB.pm line 470.
ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-10 Perl: 5.16.3 OS: linux Time: Fri Dec 21 09:11:56 2018

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

Traceback (3067):
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 394
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 342
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::NewSysconfigTables::Run Line: 208
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::Run Line: 142
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: scripts/DBUpdate-to-6.pl Line: 87


ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-10 Perl: 5.16.3 OS: linux Time: Fri Dec 21 09:11:56 2018

Message: Error during execution of 'EXECUTE FKStatement'!

Traceback (3067):
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 397
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 342
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::NewSysconfigTables::Run Line: 208
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::Run Line: 142
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: scripts/DBUpdate-to-6.pl Line: 87


Please what can I do to fix it?

Thanks for your reading...
jff
Znuny newbie
Posts: 52
Joined: 23 Mar 2016, 14:17
Znuny Version: 6.0.8
Real Name: Jeff
Company: M

Re: Error in Upgrade

Post by jff »

Hi,

From which version are you upgrading from and to which 6 version? 6.0.14?
I've never see this issue but
Can't create table 'otrs.#sql-68c_19'
caught my attention as there is no such table in my 6 install.
Wolfgangf
Znuny ninja
Posts: 1029
Joined: 13 Apr 2009, 12:26
Znuny Version: 6.0.13
Real Name: Wolfgang Fürtbauer
Company: PBS Logitek GmbH
Location: Pinsdorf

Re: Error in Upgrade

Post by Wolfgangf »

Did you run a mysqlcheck already? corrupted tables or the like ?
Produktiv:
OTRS 6.0.13/ ITSM 6.0.13
OS: SUSE Linux (SLES 12, Leap), MySql 5.5.x, 5.6.x
Windows 2012 AD Integration (agents and customers), Nagios integration (incidents, CMDB), Survey, TimeAccounting
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Error in Upgrade

Post by root »

jff wrote: 26 Dec 2018, 11:13 Hi,

From which version are you upgrading from and to which 6 version? 6.0.14?
I've never see this issue but
Can't create table 'otrs.#sql-68c_19'
caught my attention as there is no such table in my 6 install.
Hi,

Usually, this is the name of a temporary table created while ALTER TABLE statements. None of these tables should be there after a migration. Can't create table is a hint for no space left on device. Check this during the migration.

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
cfreire
Znuny newbie
Posts: 59
Joined: 24 Aug 2015, 16:40
Znuny Version: 3.3.x
Real Name: Carlos Freire
Company: Palosanto

Re: Error in Upgrade

Post by cfreire »

Hi my friends, I solved the problem..... The issue was because the tables are in MyIsam, and in the Otrs6 shoukd be in InnoDB... I ran this :

su -c "bin/otrs.Console.pl Maint::Database::MySQL::InnoDBMigration" -s /bin/bash otrs

And later ran the upgrade command and ready...

Regards, and Happy new year to all.....
Post Reply