Error in reindex process in Magento 2

Question

Due to error in reindex, Reindex process for 'design_config_grid ' is Skipping

Design Config Grid index is locked by another reindex process. Skipping.
Customer Grid index has been rebuilt successfully in 00:00:10
Category Products index has been rebuilt successfully in 00:00:05
Product Categories index has been rebuilt successfully in 00:00:00
Product Price index has been rebuilt successfully in 00:00:13
Product EAV index has been rebuilt successfully in 00:00:11
Catalog Search index has been rebuilt successfully in 00:00:47
Catalog Rule Product index has been rebuilt successfully in 00:00:04
Catalog Product Rule index has been rebuilt successfully in 00:00:00
Stock index has been rebuilt successfully in 00:00:06
Search Spell-Correction index has been rebuilt successfully in 00:00:06

So I have taken help from here : Magento 2 How to unlock reindex process

But, now I am getting this error message -> "Design Config Grid indexer has been invalidated."

Please help me to remove this error.

it has been invalidated so did you try to do again re indexing ? — Ansar Husain, Sep 12 '18 at 05:15

score 2 · Answer 1 · answered Sep 12 '18 at 06:12

2

Use the following commands -

php bin/magento indexer:reset
php bin/magento indexer:reindex

If did not worked try to run the command in mysql -

SET SQL_SAFE_UPDATES = 0;
update indexer_state set status = 'invalid' where status != 'valid';

And then run the indexer reset and reindex commands

answered Sep 12 '18 at 06:12

Gagan

1,478
13
32

1st option worked for me – matinict Sep 30 '18 at 08:27

score 1 · Answer 2 · answered Sep 12 '18 at 05:46

For any reason,you design flat is not working

In this case, you have to reset that design indexing using the command line

php bin/magento indexer:reset design_config_grid

then do reindex this index individually

php bin/magento indexer:reindex design_config_grid

Error in reindex process in Magento 2

2 Answers2