cancel
Showing results for 
Search instead for 
Did you mean: 

Reindex catalog_category_product stalls

SOLVED

Reindex catalog_category_product stalls

We are running Magento Enterprise 1.14 and have been running it live for a couple weeks.  A couple days ago, the catalog_category_product didn't complete.  Upon checking it, it seems as though its not even trying to run.  There is no error, the reindexer just seems to stall with no cpu or mem usage showing in top, but it is an active process in ps -aux. We have tried deleting the lock file, giving the lock folder 777, restarting the server, restarting the database server, all to no avail.  We have made no code changes (outside of themes)  and are at a loss as to where to go with this.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Reindex catalog_category_product stalls

Our issue actually had nothing to do with Magento or the indexer; it was a mysql configuration issue.  The character_set_system was utf8 but all other char sets (client/connection etc) were latin1.  Setting everything as utf8 solved the issue.

View solution in original post

2 REPLIES 2

Re: Reindex catalog_category_product stalls

Upon further investigation, it seems as though our catalog is too large (750k products) and the indexer's sql queries eventually end up in a timeout and the whole thing goes silent.  Any recommendations?

Re: Reindex catalog_category_product stalls

Our issue actually had nothing to do with Magento or the indexer; it was a mysql configuration issue.  The character_set_system was utf8 but all other char sets (client/connection etc) were latin1.  Setting everything as utf8 solved the issue.