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:
|
1 2 3 4 5 6 7 8 9 |
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:
Go to C:\xampp\mysql\data\mag232
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:
Any doubt on the topic can be mentioned in the Comments section below. I’d be happy to help.
Do share the solution with the Magento community via social media.
Thanks.
Also Read:
10 Comments
Hi,
I have imported the database into my local project but here we are getting a very strange issue when we run the upgrade command and reindex command then getting this error, and when we tried to import manually customer_grid_flat this table, so after running command the table is deleted automatically, please suggest what we can do?
SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed, the query was: CREATE TABLE IF NOT EXISTS
customer_grid_flat(Hey Saurabh , Actually it is mysql error ,
You may have added more then 16 column in multicolumn index,
so you may be facing the error. Thank You!!
Please help me with this issue..
C:\M\xampp8.1\htdocs\magento2>php bin/magento indexer:reindex
Design Config Grid index has been rebuilt successfully in 00:00:00
Customer Grid index has been rebuilt successfully in 00:00:01
Category Products index has been rebuilt successfully in 00:00:01
Product Categories index has been rebuilt successfully in 00:00:00
Catalog Rule Product index has been rebuilt successfully in 00:00:02
Product EAV index has been rebuilt successfully in 00:00:00
Stock index has been rebuilt successfully in 00:00:00
Inventory index has been rebuilt successfully in 00:00:00
Catalog Product Rule index has been rebuilt successfully in 00:00:00
Product Price index has been rebuilt successfully in 00:00:01
Catalog Search index process error during indexation process:
Unknown 503 error from Elasticsearch null
Hello Kumar,
In that case, please check the elastic search log from the log directory for a detailed idea of the issue.
Thank You
Hi,
I have faced the below error during reindex process.
I have reset the index > Customer Grid and reindexed it. but getting below error
please check
Customer Grid indexer process unknown error:
SQLSTATE[HY000] [2002] Connection refused
Thanks
Hello,
It seems like an error of the server as the above code is properly working from our end.
Thank You
Hello bro, I am getting Magento error in the same table customer_grid_flat
See error is below.
syntax error or access violation: 1170 BLOB/TEXT column ‘create_in’ used in key specification without a key length, query was: CREATE TABLE IF NOT EXISTS
customer_grid_flat(Hello Kartik,
Please be informed that the above blog is already for local
Thank You
Hi,
I have some issues with the index error. I could not get a solution on this.
Could you provide me your point of view please?
Indexer: Category product > Status: Busy in process
Indexer: Catalog product rule > Status: Again index required.
I don’t have access to the server… is it possible to bring a functional solution on this?
Thanks
Hello Marie,
Set on index’s product on save:
System -> Index Management
https://drops.meetanshi.com/YCWjpX
If the index in stuck busy in process, you can reset/ stop the process using the below command:
bin/magento indexer:reset catalog_product_category
Thank you.