Issue regarding Continuous index processing in index management & product import in magento 1.9.2.4

[neha23]

Hello All,

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.

[Mukesh Tiwari · Accepted solution]

Hi @neha23

Do you have magento indexing mode set as "Update on save" in the admin panel?

If yes, I suggest to change it to  "Manual Update". Then after every import you can manually re index.

[neha23]

@Mukesh Tiwari, I'll check and set it for manual update, and update you if it is working or not for me.

Thanks.