cancel
Showing results for 
Search instead for 
Did you mean: 

Catalogsearch_fulltext index Not Doing Anything in Database

Catalogsearch_fulltext index Not Doing Anything in Database

Hi, we have a problem with a CE 2.1.8 install with around 250k SKUS. The site was migrated to a new higher spec VPS and everything initially indexed fine and the site works.

 

We then did a small CSV import with some product price updates. After the import we reindex as required, but the catalogsearch_fulltext index never seems to complete even when left overnight several times. As far as I know server spec is fine, and recommended configs have been made to improve performance.

The indexer stays on processing forever, but when I look in the database, nothing seems to be going into the 'catalogsearch_fulltext_scope1' table which I would expect the indexer to be populating.

Any ideas - super frustrating as while the index is running, no products are showing in the store categories.

Tags (2)