search

magento-hackathon / AsyncIndex

MIT License
78 stars 37 forks source link

Incompatibility with JeroenVermeulen_Solarium #23

Open pervisio opened 8 years ago

pervisio commented 8 years ago

Hello,

looks like AsyncIndex and Solarium extension from Jeroen Vermeulen have some issues working together.

Automatic reindexing gets stuck when it comes to catalogsearch_fulltext. The process seems to run indefinitely, status is processing and tables get locked. Only server/mysql reboot helps unlocking the tables and running the reindex again.

Unfortunately there is no errors in system.log.

Manually running the indexer for catalogsearch_fulltext works well!

We have disable catalogsearch_fulltext from automatic reindexing for now but it would be great if someone can check this out.

Flyingmana commented 8 years ago

When a restart of mysql is needed, there should be a query listed in the mysql process list. Was there something?

Manually deactivating this may be good anyway, Solarium probably does not make use of this index or has modified it in some way.

For the case someone wants to look into it, here is the repo: https://github.com/jeroenvermeulen/magento-solarium