cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED

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

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:

index_mgmt.png

 

Please give any solution.

Thanks in anticipation.

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Issue regarding Continuous index processing in index management & product import in magento

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.

---
Problem Solved Click Accept as Solution!:Magento Community India Forum

View solution in original post

2 REPLIES 2

Re: Issue regarding Continuous index processing in index management & product import in magento

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.

---
Problem Solved Click Accept as Solution!:Magento Community India Forum

Re: Issue regarding Continuous index processing in index management & product import in magento

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

Thanks.