Ever faced an issue of the Customer Grid Indexer not working, when reindexing via CLI?!
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
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