My customer doing instant of create a new product they duplicate the product and change the attributes,inventory,name,sku,etc to make it a new product.
Since We are facing randomly database innodb error like below
"SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction, query was: UPDATE catalog_product_entity SET entity_type_id = ?, attribute_set_id = ?, type_id = ?, sku = ?, has_options = ?, required_options = ?, created_at = '2015-07-22 21:31:59', updated_at = '2016-03-17 14:58:23' WHERE (entity_id=1395)"
This error not happening every time it is happening randomly or some times only. when i get this error after some minutes i will try again with successfully product duplication. I really don't have any idea why its happening.
I have not touch any core functionality yet. I have not installed any extensions related to duplicate or product.
I am nearly struggling more then a week to find the problem. But no luck yet. So please kindly give me your suggestions to fix the issue.