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.
-
webstores ⋅500.00 $tone June 28, 2021
I have found out, that there isnt row with value_id = 2869807 in catalog_product_entiy_int.
webstores ⋅500.00 $tone
June 28, 2021
7 answers
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.
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.
Can u help me?
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.
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\\”: “”
}
}
}
I am sorry, I found the problem. We doest migrate database right.
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
