Problem with migration of products

Hello,
if I run delta migration of products I get this error :
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction. The SQL statement executed was: UPDATE `catalog_product_entity_int` SET `value_id`=:yp0, `attribute_id`=:yp1, `store_id`=:yp2, `entity_id`=:yp3, `value`=:yp4 WHERE `catalog_product_entity_int`.`value_id`=2869807
 
I try to increase wait_timeout, but this doesnt help. Can you help me ASAP?
 
Thank you.

  1. Profile photo of webstoreswebstores 510.00 $tone June 28, 2021
    I have found out, that there isnt row with value_id = 2869807 in catalog_product_entiy_int.

7 answers

Profile photo of Mall Staff 167790.00 $tone June 28, 2021
Public

Hi there,

 UPDATE `catalog_product_entity_int` SET `value_id`=:yp0, `attribute_id`=:yp1, `store_id`=:yp2, `entity_id`=:yp3, `value`=:yp4 WHERE `catalog_product_entity_int`.`value_id`=2869807
I try to increase wait_timeout, but this doesnt help. Can you help me ASAP?
..
I have found out, that there isnt row with value_id = 2869807 in catalog_product_entiy_int.

That refers to a MySQL server issue only. Please contact your system admin or hosting provider to get further help on that.

Regards,
Mall.

#1
Profile photo of webstores 510.00 $tone June 28, 2021
Public

I dont think so, because sql query from migration module doesnt right.
Beacuse value_id doesnt exist in  table.
 
Migration of categories, parameter, custome, sales, last step (8) is working. Only there is error of migration products.

#2
Profile photo of Mall Staff 167790.00 $tone June 28, 2021
Public

Hi there,

I dont think so, because sql query from migration module doesnt right.
Beacuse value_id doesnt exist in  table.

Please confirm if you mentioned that the record which had value_id = 2869807 did not exist in the table ‘catalog_product_entity_int‘ in your M2 database. 

Did you delete any migrated product or product options in your M2 after the first migration? And what is the version of our module in your instance now?
 
Regards,
Mall.
 
 
 

#4
Profile photo of webstores 510.00 $tone June 28, 2021
Public

Yes, this value doesnt exist in table catalog_product_entity_id.
No I dont delete any data, dont add any data.
 
Version of module :
{
“name”: “ubertheme/module-ubdatamigration-pro”,
“description”: “This is a professional edition. This module allow migrate data from Magento 1.x to Magento 2.x”,
“require”: {
“php”: “~7.1.3||~7.2.0||~7.3.0”,
“magento/module-backend”: “>=100.0.0”,
“magento/framework”: “>=100.0.0”
},
“type”: “magento2-module”,
“version”: “3.2.6”,
“license”: [
“Proprietary”
],
“autoload”: {
“files”: [
“registration.php”
],
“psr-4”: {
“Ubertheme\\Ubdatamigration\\”: “”
}
}
}

#5
Profile photo of ubdev Staff 85420.00 $tone June 28, 2021
Public

Hi there, 

I am sorry, I found the problem. We doest migrate database right.

So please continue the migration at your end. If you have any additional questions, please get back to us here.
Regards,
Ubertheme team

#7

Please login or Register to Submit Answer

Written By

Comments