Sending this out again with some new information: **UPDATE** I was able to get our test machine upgraded by commenting out steps 1 through 5 in the DBUpgrade-to-3.1.pl script after it times out. Then I had to comment out lines 6 through 8 after the script timed out again (after step 8 ). Then the script would finish. I don't think anything was corrupted, but when I migrate production I really don't want to comment out code. I have tried increasing every timeout value I can think of both in Apache on the OTRS box and in MySQL on the DB machine. Does anyone have an idea for what timeout is causing the error below? ________________________________ I am attempting to run the DBUpgrade-to-3.1.pl script and get as far as step 5. After it finishes going through our rather large database (100000+) everything after step 5 fails. I saw another post where someone had the same error as me, and they mentioned increasing their mysql timeout. Anyone know what and where exactly needs to be changed so I can finish the upgrade? Here is the error I get: Migrated ticket 102000 of 102282 (with Free fields data). Migrated ticket 102100 of 102282 (with Free fields data). Migrated ticket 102200 of 102282 (with Free fields data). Migrated 102282 tickets of 102282 (with Free fields data). done. Step 6 of 24: Migrate article free fields to dynamic fields... DBD::mysql::db do failed: MySQL server has gone away at /opt/otrs-3.1.11/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-90 Perl: 5.8.8 OS: linux Time: Wed Jan 30 10:42:53 2013 Message: MySQL server has gone away, SQL: 'SELECT freekey1, freetext1, freetime1 FROM ticket' Traceback (30197): Module: main::_IsFreefieldsMigrationAlreadyDone (v1.85) Line: 417 Module: ./DBUpdate-to-3.1.pl (v1.85) Line: 109 DBD::mysql::db do failed: MySQL server has gone away at /opt/otrs-3.1.11/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-90 Perl: 5.8.8 OS: linux Time: Wed Jan 30 10:42:53 2013 Message: MySQL server has gone away, SQL: 'SELECT a_freekey1, a_freetext1 FROM article' Traceback (30197): Module: main::_IsFreefieldsMigrationAlreadyDone (v1.85) Line: 422 Module: ./DBUpdate-to-3.1.pl (v1.85) Line: 109 Free fields were deleted, migration is already done! done. Step 7 of 24: Verify if ticket data was successfully migrated... DBD::mysql::db do failed: MySQL server has gone away at /opt/otrs-3.1.11/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-90 Perl: 5.8.8 OS: linux Time: Wed Jan 30 10:42:53 2013 Message: MySQL server has gone away, SQL: 'SELECT freekey1, freetext1, freetime1 FROM ticket' Traceback (30197): Module: main::_IsFreefieldsMigrationAlreadyDone (v1.85) Line: 417 Module: ./DBUpdate-to-3.1.pl (v1.85) Line: 117 DBD::mysql::db do failed: MySQL server has gone away at /opt/otrs-3.1.11/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-90 Perl: 5.8.8 OS: linux Time: Wed Jan 30 10:42:53 2013 Message: MySQL server has gone away, SQL: 'SELECT a_freekey1, a_freetext1 FROM article' Traceback (30197): Module: main::_IsFreefieldsMigrationAlreadyDone (v1.85) Line: 422 Module: ./DBUpdate-to-3.1.pl (v1.85) Line: 117 Free fields were deleted, migration is already done! done. DBD::mysql::db do failed: MySQL server has gone away at /opt/otrs-3.1.11/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-90 Perl: 5.8.8 OS: linux Time: Wed Jan 30 10:42:53 2013 Message: MySQL server has gone away, SQL: 'SELECT freekey1, freetext1, freetime1 FROM ticket' Traceback (30197): Module: main::_IsFreefieldsMigrationAlreadyDone (v1.85) Line: 417 Module: ./DBUpdate-to-3.1.pl (v1.85) Line: 125 DBD::mysql::db do failed: MySQL server has gone away at /opt/otrs-3.1.11/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-90 Perl: 5.8.8 OS: linux Time: Wed Jan 30 10:42:53 2013 Message: MySQL server has gone away, SQL: 'SELECT a_freekey1, a_freetext1 FROM article' Traceback (30197): Module: main::_IsFreefieldsMigrationAlreadyDone (v1.85) Line: 422 Module: ./DBUpdate-to-3.1.pl (v1.85) Line: 125 Step 8 of 24: Verify if article data was successfully migrated... Free fields were deleted, migration is already done! done. DBD::mysql::st execute failed: MySQL server has gone away at /opt/otrs-3.1.11/Kernel/System/DB.pm line 618. ERROR: OTRS-DBUpdate-to-3.1-90 Perl: 5.8.8 OS: linux Time: Wed Jan 30 10:42:53 2013 Message: MySQL server has gone away, SQL: 'SELECT id, name, field_order FROM dynamic_field ORDER BY field_order, id' Traceback (30197): Module: Kernel::System::DynamicField::DynamicFieldList (v1.56.2.2) Line: 695 Module: main::_MigrateFreeFieldsConfiguration (v1.85) Line: 1095 Module: ./DBUpdate-to-3.1.pl (v1.85) Line: 139 Can't use an undefined value as a HASH reference at ./DBUpdate-to-3.1.pl line 1100. Step 9 of 24: Migrate free fields configuration... Thanks, Scott Bean IS Planning & Projects Washington State University scott_bean@wsu.edu [cid:image001.gif@01C96A96.DC53D510]https://mcp.support.microsoft.com/profile/Pinter This communication may contain privileged, non-public or other confidential information. If you have received it in error, please advise the sender by reply email and immediately delete the message and any attachments without copying or disclosing the contents. Thank you.
