Catalog Search Full Text reIndex issue

[jason_reese]

The Catalog Search Full Text index keeps becoming invalidated and requires reindexing from the command line. It is currently set for 'Update on Save' but never seems to run the reindex.

There are no errors in the command line or the logs.

Magento 2.3.6 Community Edition

[johnwebdes40a5]

Hello @jason_reese 

If you're experiencing issues with the Catalog Search Full Text reindex process in Magento 2, there are several steps you can take to troubleshoot and resolve the problem:

1. Check system requirements: Ensure that your server meets the minimum system requirements for running Magento 2, including PHP version compatibility and required extensions.
2. Verify file and folder permissions: Make sure that the necessary files and folders have the correct permissions. Check the Magento documentation for the recommended file and folder permissions.
3. Increase PHP memory limit and execution time: Sometimes, the reindex process requires more memory or time to complete. Increase the PHP memory limit and execution time in your server's PHP configuration. You can do this by modifying the php.ini file or through the server control panel. Set memory_limit to a higher value (e.g., 2G) and increase max_execution_time to a longer duration (e.g., 1800).
4. Run reindex from the command line: Perform the reindexing process using the Magento command line interface (CLI) instead of the web interface. Open your command line terminal, navigate to your Magento installation directory, and run the following command:
   1. php bin/magento indexer:reindex catalogsearch_fulltext
      
      1. This command specifically reindexes the catalog search the full text. If you encounter any errors during the process, they will be displayed in the terminal, providing more details about the issue.
5. Clear cache: After reindexing, clear the Magento cache by running the following command:
   
   1. php bin/magento cache:clean
6. Check error logs: Review the Magento log files and server error logs for any error messages or exceptions related to the reindex process. The logs can be found in the Magento installation directory under the var/log/ folder, as well as in the server's log directory.
7. Rebuild search index tables manually (if necessary): In some cases, you may need to manually drop and recreate the search index tables. To do this, take a backup of your database and then run the following SQL commands:
   
   1. DROP TABLE catalogsearch_fulltext;
   2. DROP TABLE catalogsearch_fulltext_cl;
8. After executing these commands, run the reindex command again using the CLI:
   
   1. php bin/magento indexer:reindex catalogsearch_fulltext
      
      1. This will recreate the search index tables.

By following these steps, you should be able to troubleshoot and resolve the Catalog Search Full Text reindexing issue in Magento 2.

If you find our reply helpful, please give us kudos.

A Leading Magento Development Agency That Delivers Powerful Results, Innovation, and Secure Digital Transformation.

WebDesk Solution Support Team

Get a Free Quote | | Adobe Commerce Partner | Hire Us | Call Us 877.536.3789

[jason_reese]

Issue was resolved awhile ago, it wasn't database related, not memory, it actually had to do with a template file.

[la_madrilena]

Jason, can you explain a bit more? which template, wich file? because we are expericing the same after a migration to porto.

Thx in advance