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?)

Post Reply