I am having an issue, i.e. Whenever we do import using CSV, the magento software gets completely slow and it does not allow us to do anything for at least 2 hours and then it becomes normal. We get a SQL wait error during that time. The error is like :
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` = '2016-06-19 10:51:26', `updated_at` = '2016-06-19 09:40:50' WHERE (`entity_id`=1813)
And as i go to Index Management than i see that 'Catalog URL Rewrites' Index is always shown 'Processing'. Please look at the image below:
Please give any solution.
Thanks in anticipation.
Solved! Go to Solution.
@muk_t, I'll check and set it for manual update, and update you if it is working or not for me.