Magento – Magento 2.2.5 – Table catalogsearch_fulltext_scope1 not being automatically generated

magento2reindexsearch

Summary
The exception log becomes bloated with "main.CRITICAL: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'catalogsearch_fulltext_scope1' doesn't exist". sometimes reindexing cycle is working properly.but sometime it's not generated/rename from catalogsearch_fulltext_scope1_tmp folder. If we check in database, table is not exist but if you try to create, it will show table is already exists. and if we rename 'catalogsearch_fulltext_scope1_tmp' table to 'catalogsearch_fulltext_scope1', it will show table is already exist. If you try to delete it, it will show table is not exist

Environment
Magento 2.2.5 and possibly earlier versions
PHP 7.0
Custom extensions are installed but are up to date with magento version

Steps to reproduce
1.Check that cron jobs are set up and running
2.Check exceptions log

Expected result
On indexing cycle, no errors should occur.

Actual result
On indexing cycle, error "main.CRITICAL: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'catalogsearch_fulltext_scope1' doesn't exist" appears.

Best Answer

I just fixed same issue on my server. Access to server and run:

("Magento" is my database name)

cd /var/lib/mysql/Magento
rm -rf catalogsearch_fulltext_scope1.ibd
php bin/magento indexer:reindex catalogsearch_fulltext

After that, the table catalogsearch_fulltext_scope1 will be regenerated.

I hope this helps someone else.

Related Topic