How To Fix “Indexer Reindex Required” Error In Magento 2

Ever faced an issue of the Customer Grid Indexer not working, when reindexing via CLI?!

Me too!!!

Sometimes, while running a command in Magento 2, “indexer re-index required” error is faced.

This is due to an issue in Magento 2 table. The table might have been corrupted in the database where it existed but something was missing.

Run the command php bin/magento indexer:status to check the status of indexer:

Design Config Grid: Reindex required
Customer Grid: Reindex required
Category Products: Ready
Product Categories: Ready
Product Price: Ready
Product EAV: Ready
Catalog Search: Reindex required
Stock: Ready Catalog Rule Product: Ready
Catalog Product Rule: Ready

When you run the command php bin/magento indexer:reindex – you get the error as shown below:

Method To Fix Indexer ReIndex Required Error in Magento 2:

Locate customer_grid_flat.ibd table on the customer grid.

Rename it to customer_grid_flat.ibd.old

That’s it.

Once the issue is solved, you can run the command – php bin/magento indexer:reindex without any issue as shown below:

Hope this article will help you in some way, You can see useful articles in the next articles.

Anything you need support from Magento 2 feel free to contact us at Alothemes and

Phone: (+84)865633728

Email: support@alothemes.com