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.