aktuell versuche ich ein Klonsystem von 5.0.26 auf 6.0.7 upzugraden. Ich konnte schon diverse Fehler beheben, bzw. habe im Forum weitere Schritte gefunden. Leider habe ich aktuell eine Fehlermeldung, welche sich nicht mit bisher beschriebenen Ansätzen lösen lässt und hoffe ihr könnt mir hier helfen.
Fehlermeldung:
Code: Select all
root@otrs:/opt/otrs# su -c "/opt/otrs/scripts/DBUpdate-to-6.pl" -s /bin/bash otrs
Migration started ...
Checking requirements ...
Requirement check for: Check framework version ...
Requirement check for: Check required Perl version ...
Requirement check for: Check required database version ...
Requirement check for: Check database charset ...
Requirement check for: Check required Perl modules ...
Requirement check for: Check if database has been backed up ...
Did you backup the database? [Y]es/[N]o: y
Requirement check for: Upgrade database structure ...
Requirement check for: Migrating time zone configuration ...
Requirement check for: Update calendar appointment future tasks ...
Requirement check for: Migrate GenericAgent jobs configuration ...
Requirement check for: Migrate TicketAppointment rules configuration ...
Requirement check for: Migrate ArticleType in ProcessManagement Data ...
Requirement check for: Migrate ArticleType in PostMaster filters ...
Executing tasks ...
Step 1 of 38: Check framework version ...
Step 2 of 38: Check required Perl version ...
Step 3 of 38: Check required database version ...
Step 4 of 38: Check database charset ...
Step 5 of 38: Check required Perl modules ...
Step 6 of 38: Check if database has been backed up ...
Step 7 of 38: Upgrade database structure ...
Step 8 of 38: Migrate configuration ...
Step 9 of 38: Refresh configuration cache after migration of OTRS 5 settings...
Step 10 of 38: Migrating ticket storage configuration ...
Step 11 of 38: Migrating article search index configuration ...
Step 12 of 38: Migrating ticket zoom customer information widget configuration ...
Step 13 of 38: Drop deprecated table gi_object_lock_state ...
Step 14 of 38: Migrate PossibleNextActions setting ...
Step 15 of 38: Migrate ZoomExpand setting ...
Step 16 of 38: Migrating time zone configuration ...
Step 17 of 38: Create appointment calendar tables ...
Step 18 of 38: Create ticket number counter tables ...
Step 19 of 38: Update calendar appointment future tasks ...
Step 20 of 38: Add basic appointment notification for reminders ...
Step 21 of 38: Create Form Draft tables ...
Step 22 of 38: Clean and drop group_user permission_value column ...
Step 23 of 38: Migrate GenericAgent jobs configuration ...
Step 24 of 38: Migrate TicketAppointment rules configuration ...
Step 25 of 38: Migrate Merged Ticket history name values ...
Step 26 of 38: Migrate ticket statistics ...
Step 27 of 38: Migrate ticket notifications ...
Step 28 of 38: Post changes on article related tables ...
[Thu May 17 13:20:12 2018] DBUpdate-to-6.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`otrs`.`#sql-47b8_b7`, CONSTRAINT `FK_article_data_mime_article_id_id` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`)) at /opt/otrs/Kernel/System/DB.pm line 470.
ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-10 Perl: 5.18.2 OS: linux Time: Thu May 17 13:20:12 2018
Message: Cannot add or update a child row: a foreign key constraint fails (`otrs`.`#sql-47b8_b7`, CONSTRAINT `FK_article_data_mime_article_id_id` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`)), SQL: 'EXECUTE FKStatement'
Traceback (27276):
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 363
Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::_UpdateArticleDataMimeTable Line: 295
Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::Run Line: 51
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: /opt/otrs/scripts/DBUpdate-to-6.pl Line: 84
ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-10 Perl: 5.18.2 OS: linux Time: Thu May 17 13:20:12 2018
Message: Error during execution of 'EXECUTE FKStatement'!
Traceback (27276):
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 366
Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::_UpdateArticleDataMimeTable Line: 295
Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::Run Line: 51
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: /opt/otrs/scripts/DBUpdate-to-6.pl Line: 84
Not possible to complete migration, check previous messages for more information.
Dieser Ansatz bringt mich ebenfalls zu keiner Lösung.
PS: Da im orginalen Migrationskript meine Ticketinhalte komplett entfernt werden, habe ich folgende Zeile aus der Datei /opt/otrs/scripts/DBUpdateTo6.pm entfernt:
Code: Select all
{
Message => 'Create entries in new article table',
Module => 'MigrateArticleData',
},
Code: Select all
root@otrs:/opt/otrs# /opt/otrs/bin/otrs.CheckModules.pl
o Apache::DBI......................ok (v1.12)
o Apache2::Reload..................ok (v0.13)
o Archive::Tar.....................ok (v1.90)
o Archive::Zip.....................ok (v1.30)
o Crypt::Eksblowfish::Bcrypt.......ok (v0.009)
o Crypt::SSLeay....................ok (v0.58)
o Date::Format.....................ok (v2.24)
o DateTime.........................ok (v1.06)
o DBI..............................ok (v1.630)
o DBD::mysql.......................ok (v4.025)
o DBD::ODBC........................ok (v1.45)
o DBD::Oracle......................Not installed! (optional - Required to connect to a Oracle database.)
o DBD::Pg..........................ok (v2.19.3)
o Digest::SHA......................ok (v5.84_01)
o Encode::HanExtra.................ok (v0.23)
o IO::Socket::SSL..................ok (v1.965)
o JSON::XS.........................ok (v2.34)
o List::Util::XS...................ok (v1.27)
o LWP::UserAgent...................ok (v6.26)
o Mail::IMAPClient.................ok (v3.35)
o IO::Socket::SSL................ok (v1.965)
o Authen::SASL...................ok (v2.15)
o Authen::NTLM...................Not installed! Use: 'apt-get install -y libauthen-ntlm-perl' (optional - Required for NTLM authentication mechanism in IMAP connections.)
o ModPerl::Util....................ok (v2.000008)
o Net::DNS.........................ok (v0.68)
o Net::LDAP........................ok (v0.58)
o Template.........................ok (v2.24)
o Template::Stash::XS..............ok (undef)
o Text::CSV_XS.....................ok (v1.02)
o Time::HiRes......................ok (v1.9725)
o XML::LibXML......................ok (v2.0108)
o XML::LibXSLT.....................ok (v1.84)
o XML::Parser......................ok (v2.41)
o YAML::XS.........................ok (v0.41)
Über konstruktive Lösungsvorschläge würde ich mich sehr freuen.
Mit freundlichen Grüßen
Sascha Sebastian Wieth