SphinxSearch icon indicating copy to clipboard operation
SphinxSearch copied to clipboard

Reindex gets stuck/finishes early

Open Quazz opened this issue 8 years ago • 1 comments

We have ~80 000 products, 6 store views.

I can see in catalogsearch_fulltext table that there's 500 000+ entries.

sphinx_catalogsearch_fulltext_tmp gets stuck somewhere around 27 000 (and thus never transfers the data to sphinx_catalogsearch_fulltext)

No errors show up in Mysql error log.

I do get some errors near the start of reindex, though, in system.log

User Error: DDL statements are not allowed in transactions in /home/user/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php on line 484

Magento 1.9.3.2

Quazz avatar Mar 16 '17 10:03 Quazz

Seems like PHP runs out of memory. I had it set to 1024M by the way.

Does this keep everything in memory until it's done?

Quazz avatar Mar 17 '17 11:03 Quazz