Migration stuck on task 8 Migrate Others

We have run a number of trial runs exporting from m1 to m2. In each case they have been generally successfiul. However the last few migration test (into a clean magento 2) the migration is not extending beyond task 8 Migrate Others.The status just stays on ‘Migrating’. Previously this step completed without problem in minutes.
thanks
Paul

3 answers

Profile photo of Mall Staff 184060.00 $tone February 12, 2019
Public

Hi there,

beyond task 8 Migrate Others.The status just stays on ‘Migrating’. 

Let check in the log file at below path of our migration tool and provide me any error message if you see:
pub/ub-tool/protected/runtime/ub_data_migration.log
If you don’t see any error message, let continue with data migration in the step #8 by run CLI command:
php -f bin/ubdatamigration run --step=8
And tell me know how it goes then.
Regards,
Mall.

#1
Profile photo of create 30.00 $tone February 12, 2019
Public

hi
there was no error in the log file.
I ran the CLI command as you suggested -- it ran for awhile then i got the followign error message:
 
PHP Error[2]: Error while sending QUERY packet. PID=51
    in file /pub/ub-tool/yii-1.1.19/db/CDbCommand.php at line 508
#0 /pub/ub-tool/yii-1.1.19/db/CDbCommand.php(508): PDOStatement->execute()
#1 /pub/ub-tool/yii-1.1.19/db/CDbCommand.php(396): CDbCommand->queryInternal()
#2 /pub/ub-tool/yii-1.1.19/db/ar/CActiveRecord.php(1359): CDbCommand->queryAll()
#3 /pub/ub-tool/yii-1.1.19/db/ar/CActiveRecord.php(1478): Mage1CatalogruleGroupWebsite->query()
#4 /pub/ub-tool/protected/controllers/Step8Controller.php(1558): Mage1CatalogruleGroupWebsite->findAll()
#5 /pub/ub-tool/protected/controllers/Step8Controller.php(425): Step8Controller->_migrateCatalogRule()
#6 /pub/ub-tool/protected/commands/RunCommand.php(58): Step8Controller->actionRun()
#7 /pub/ub-tool/protected/commands/RunCommand.php(28): RunCommand->_migrateData()
#8 unknown(0): RunCommand->actionIndex()
#9 /pub/ub-tool/yii-1.1.19/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs()
#10 /pub/ub-tool/yii-1.1.19/console/CConsoleCommandRunner.php(71): RunCommand->run()
#11 /pub/ub-tool/yii-1.1.19/console/CConsoleApplication.php(92): CConsoleCommandRunner->run()
#12 /pub/ub-tool/yii-1.1.19/base/CApplication.php(185): CConsoleApplication->processRequest()
#13 /pub/ub-tool/yii-1.1.19/yiic.php(33): CConsoleApplication->run()
#14 /pub/ub-tool/protected/ubdatamigration_cli.php(5): require_once()
#15 /bin/ubdatamigration(4): require_once()

#2
Profile photo of Mall Staff 184060.00 $tone February 13, 2019
Public

Hi there,

PHP Error[2]: Error while sending QUERY packet. PID=51

There’s a high chance that the issue relates to your MySQL setting only. Please contact your system admin or hosting provider to increase the value of max_allowed_packet configuration in your MySQL settings.

You can learn more information about a similar issue in this post.
 
Regards,
Mall.
 

#3

Please login or Register to Submit Answer

Written By

Comments