Upgrade 5s to 6 fails

Moderator: crythias

Post Reply
finalbeta
OTRS newbie
Posts: 1
Joined: 12 Jul 2018, 12:19
OTRS Version?: 5.1.1.1.1

Upgrade 5s to 6 fails

Post by finalbeta » 12 Jul 2018, 14:07

I tried updating my OTRS 5.0.23 to the latest 6.
I'm running Centos7. Also using the ITSM bundle and the FAQ module. Some skin modifications where done (adding a link here and there, but nothing major)

The very first step fails as follows:

Code: Select all

[root@ot-someserver-01 ~]# rpm -Uvh otrs-6.0.8-01.noarch.rpm
Preparing... ################################# [100%]
Check OTRS user ... otrs exists.
usermod: no modifications
usermod: no modifications
Updating / installing...
1:otrs-6.0.8-01 warning: /opt/otrs/Kernel/Config.pm created as /opt/otrs/Kernel/Config.pm.rpmnew
################################# [ 50%]
Rebuilding the system configuration...
[Thu Jul 12 10:32:39 2018] otrs.Console.pl: DBD::mysql::st execute failed: Table 'otrs.sysconfig_deployment_lock' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 694.
ERROR: OTRS-otrs.Console.pl-Maint::Config::Rebuild-79 Perl: 5.16.3 OS: linux Time: Thu Jul 12 10:32:39 2018

Message: Table 'otrs.sysconfig_deployment_lock' doesn't exist, SQL: '
SELECT id, exclusive_lock_guid, exclusive_lock_user_id, exclusive_lock_expiry_time
FROM sysconfig_deployment_lock
ORDER BY exclusive_lock_expiry_time DESC LIMIT 1'

Traceback (2396):
Module: Kernel::System::SysConfig::DB::_DeploymentLockGet Line: 5273
Module: Kernel::System::SysConfig::DB::DeploymentIsLocked Line: 4913
Module: Kernel::System::SysConfig::DB::DefaultSettingLock Line: 1592
Module: Kernel::System::SysConfig::ConfigurationXML2DB Line: 2575
Module: Kernel::System::Console::Command::Maint::Config::Rebuild::Run Line: 51
Module: (eval) Line: 460
Module: Kernel::System::Console::BaseCommand::Execute Line: 454
Module: Kernel::System::Console::InterfaceConsole::Run Line: 80
Module: /opt/otrs/bin/otrs.Console.pl Line: 38

[Thu Jul 12 10:32:39 2018] otrs.Console.pl: DBD::mysql::db do failed: Table 'otrs.sysconfig_default' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 470.
ERROR: OTRS-otrs.Console.pl-Maint::Config::Rebuild-79 Perl: 5.16.3 OS: linux Time: Thu Jul 12 10:32:39 2018

Message: Table 'otrs.sysconfig_default' doesn't exist, SQL: '
UPDATE sysconfig_default
SET
exclusive_lock_guid = ?,
exclusive_lock_user_id = ?,
exclusive_lock_expiry_time = ?
'

Traceback (2396):
Module: Kernel::System::SysConfig::DB::DefaultSettingLock Line: 1677
Module: Kernel::System::SysConfig::ConfigurationXML2DB Line: 2575
Module: Kernel::System::Console::Command::Maint::Config::Rebuild::Run Line: 51
Module: (eval) Line: 460
Module: Kernel::System::Console::BaseCommand::Execute Line: 454
Module: Kernel::System::Console::InterfaceConsole::Run Line: 80
Module: /opt/otrs/bin/otrs.Console.pl Line: 38

ERROR: OTRS-otrs.Console.pl-Maint::Config::Rebuild-79 Perl: 5.16.3 OS: linux Time: Thu Jul 12 10:32:39 2018

Message: System was unable to lock Default Settings

Traceback (2396):
Module: Kernel::System::SysConfig::ConfigurationXML2DB Line: 2580
Module: Kernel::System::Console::Command::Maint::Config::Rebuild::Run Line: 51
Module: (eval) Line: 460
Module: Kernel::System::Console::BaseCommand::Execute Line: 454
Module: Kernel::System::Console::InterfaceConsole::Run Line: 80
Module: /opt/otrs/bin/otrs.Console.pl Line: 38

Error: There was a problem writing XML to DB.
Deleting cache...
Done.

Next steps:

[restart web server]
systemctl restart apache2.service

[install the OTRS database]
Make sure your database server is running.
Use a web browser and open this link:
http://ot-360-01/otrs/installer.pl

[start OTRS daemon and corresponding watchdog cronjob]
/opt/otrs/bin/otrs.Daemon.pl start
/opt/otrs/bin/Cron.sh start

((enjoy))
Your OTRS Team

Cleaning up / removing...
2:otrs-5.0.23-01 ################################# [100%]
I ended up trying to continue, but the result was a broken installation as expected.
I reverted to backups, but I would like to try this again sooner or later.

(In my database, I have no table sysconfig_default, perhaps that is the problem, but if so, how to resolve?)

marc_fauser
OTRS newbie
Posts: 19
Joined: 04 May 2010, 10:27
OTRS Version?: 5.0.16

Re: Upgrade 5s to 6 fails

Post by marc_fauser » 16 Aug 2018, 01:50

I hope you get an answer because exactly at the same time of your post I got the same error.

I'm trying to update Debian 9 OTRS 5.0.x with Debian Backport to OTRS 6.0.9 and get this
error. My database has no errors and everything is working.

jojo
Moderator
Posts: 14400
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: Upgrade 5s to 6 fails

Post by jojo » 16 Aug 2018, 08:29

you have to run the migration script as stated in the documentation
"Production": OTRS™ 6, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com :: Share your ideas

marc_fauser
OTRS newbie
Posts: 19
Joined: 04 May 2010, 10:27
OTRS Version?: 5.0.16

Re: Upgrade 5s to 6 fails

Post by marc_fauser » 16 Aug 2018, 22:34

In my case I get this error when I run
apt upgrade
and Debian upgrades OTRS from 5 to 6.
Then the update script aborts and I don't have any files from OTRS 6 installed and
no possibility to run an update script.

jojo
Moderator
Posts: 14400
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: Upgrade 5s to 6 fails

Post by jojo » 16 Aug 2018, 22:37

you should contact the debian maintainer as the package is not build by the OTRS group. I strongly advise to use the tar.gz officially provided
"Production": OTRS™ 6, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com :: Share your ideas

Post Reply