Magento Forum

   
Category products index stuck on processing status
 
nara123
Sr. Member
 
Total Posts:  89
Joined:  2010-08-24
 

Hi All,
As mentioned in the subject, when trying to re-index from backend I got category products index stuck on Processing status. After reindexing I got “Category Products Index process is working now. Please try run this process later.” error message and the status of the category products remain processing at all.

Can anybody suggest me how to resolve this issue?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Turnkeye
Moderator
 
Avatar
Total Posts:  908
Joined:  2008-12-20
URL: turnkeye.com
 

The database is corrupted.

Seems that you import your products recently using some 3rd party tool, right?

 
Magento Community Magento Community
Magento Community
Magento Community
 
fmckinnon
Member
 
Total Posts:  38
Joined:  2011-01-27
 

Hi,
I’m having this same problem.  We have a very large store, with about 30,000 active products, and another 40,000 inactive products.

I’ve manually deleted the index_process.lock in my /var/locks/ folder (there were like 7 of them!).

Our products are being added (new products) and existing products updated (price, quantity) via an XML push from our supplier.

Thus far, it’s really hurting us, we can’t search, and I can’t seem to ever get the products reindexed with it crashing.  I eventually have to restart mySQL services.

Any advice?

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top