0

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."

enter image description here

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 5:15
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

| improve this answer | |
  • 1st option worked for me – matinict Sep 30 '18 at 8:27
1

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

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.