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...
Error in Upgrade
Moderator: crythias
-
- Znuny newbie
- Posts: 52
- Joined: 23 Mar 2016, 14:17
- Znuny Version: 6.0.8
- Real Name: Jeff
- Company: M
Re: Error in Upgrade
Hi,
From which version are you upgrading from and to which 6 version? 6.0.14?
I've never see this issue but
From which version are you upgrading from and to which 6 version? 6.0.14?
I've never see this issue but
caught my attention as there is no such table in my 6 install.Can't create table 'otrs.#sql-68c_19'
-
- 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
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
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
-
- Administrator
- Posts: 4002
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Error in Upgrade
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 ?
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 ?
-
- 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
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.....
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.....