DBUpdate-to-6-pl fails.

Moderator: crythias

Post Reply
janjoh
OTRS newbie
Posts: 5
Joined: 21 Dec 2017, 14:35
OTRS Version?: 5.0.14
Real Name: Jan Johansson

DBUpdate-to-6-pl fails.

Post by janjoh » 16 Feb 2018, 14:29

We're trying to upgrade a OTRS5 to OTRS6. The database is about 800GB in size, and we run in to the following problem,

Code: Select all

-bash-4.2$ ./DBUpdate-to-6.pl

 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 ...


        The currently configured time offset is 1 hours, these are the suggestions for a corresponding OTRS time zone:

        Africa/Algiers
        Africa/Bangui
        Africa/Brazzaville
        Africa/Ceuta
        Africa/Douala
        Africa/Kinshasa
        Africa/Lagos
        Africa/Libreville
        Africa/Luanda
        Africa/Malabo
        Africa/Ndjamena
        Africa/Niamey
        Africa/Porto-Novo
        Africa/Tunis
        CET
        Europe/Amsterdam
        Europe/Andorra
        Europe/Belgrade
        Europe/Berlin
        Europe/Brussels
        Europe/Budapest
        Europe/Copenhagen
        Europe/Gibraltar
        Europe/Luxembourg
        Europe/Madrid
        Europe/Malta
        Europe/Monaco
        Europe/Oslo
        Europe/Paris
        Europe/Prague
        Europe/Rome
        Europe/Stockholm
        Europe/Tirane
        Europe/Vienna
        Europe/Warsaw
        Europe/Zurich
        MET


        It seems that Europe/Stockholm should be the correct time zone to set for your OTRS.

        Enter the time zone to use for OTRSTimeZone (leave empty to show a list of all available time zones): Europe/Stockholm

        Enter the time zone to use for UserDefaultTimeZone (leave empty to show a list of all available time zones): Europe/Stockholm

    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: Create entries in new article table ...
    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: Migrating time zone configuration ...
    Step 16 of 38: Create appointment calendar tables ...
    Step 17 of 38: Create ticket number counter tables ...
    Step 18 of 38: Update calendar appointment future tasks ...
    Step 19 of 38: Add basic appointment notification for reminders ...
    Step 20 of 38: Create Form Draft tables ...
    Step 21 of 38: Clean and drop group_user permission_value column ...
    Step 22 of 38: Migrate GenericAgent jobs configuration ...
    Step 23 of 38: Migrate TicketAppointment rules configuration ...
    Step 24 of 38: Migrate Merged Ticket history name values ...
    Step 25 of 38: Migrate ticket statistics ...
    Step 26 of 38: Migrate ticket notifications ...
    Step 27 of 38: Create entries in new article table ...
[Fri Feb 16 13:20:31 2018] DBUpdate-to-6.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`otrsprod`.`article`, CONSTRAINT `FK_article_article_sender_type_id_id` FOREIGN KEY (`article_sender_type_id`) REFERENCES `article_sender_type` (`id`)) 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 Feb 16 13:20:31 2018

 Message: Cannot add or update a child row: a foreign key constraint fails (`otrsprod`.`article`, CONSTRAINT `FK_article_article_sender_type_id_id` FOREIGN KEY (`article_sender_type_id`) REFERENCES `article_sender_type` (`id`)), SQL: '
                INSERT INTO article (
                    id,ticket_id,article_sender_type_id,communication_channel_id,
                    is_visible_for_customer,create_by,create_time,change_by,change_time
                )VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) '

 Traceback (23999):
   Module: scripts::DBUpdateTo6::MigrateArticleData::_MigrateData Line: 302
   Module: scripts::DBUpdateTo6::MigrateArticleData::Run Line: 136
   Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
   Module: scripts::DBUpdateTo6::Run Line: 69
   Module: ./DBUpdate-to-6.pl Line: 89

ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-10 Perl: 5.16.3 OS: linux Time: Fri Feb 16 13:20:31 2018

 Message: An error occurs during article data migration!

 Traceback (23999):
   Module: scripts::DBUpdateTo6::MigrateArticleData::Run Line: 142
   Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
   Module: scripts::DBUpdateTo6::Run Line: 69
   Module: ./DBUpdate-to-6.pl Line: 89


    An error occurs during article data migration!



 Not possible to complete migration, check previous messages for more information.

-bash-4.2$
Not really sure how to procede?

Code: Select all

mysql> select distinct article_sender_type_id from article;
+------------------------+
| article_sender_type_id |
+------------------------+
|                      1 |
|                      3 |
+------------------------+
2 rows in set (0.00 sec)

mysql>

mysql> select * from article_sender_type;
+----+----------+----------+----------+---------------------+-----------+---------------------+-----------+
| id | name     | comments | valid_id | create_time         | create_by | change_time         | change_by |
+----+----------+----------+----------+---------------------+-----------+---------------------+-----------+
|  1 | agent    | NULL     |        1 | 2016-11-01 07:59:18 |         1 | 2016-11-01 07:59:18 |         1 |
|  2 | system   | NULL     |        1 | 2016-11-01 07:59:18 |         1 | 2016-11-01 07:59:18 |         1 |
|  3 | customer | NULL     |        1 | 2016-11-01 07:59:18 |         1 | 2016-11-01 07:59:18 |         1 |
+----+----------+----------+----------+---------------------+-----------+---------------------+-----------+
3 rows in set (0.00 sec)

mysql>

Post Reply