0

design_config_grid and customer_grid stuck on processing when I use bin/magento indexer:reindex. Even after bin/magento indexer:reset and changing status to Invalid, when I reindex again, they stuck on processing and I get this message: State for the same view already exists.

2 Answers 2

0

I bumped into the same problem this week. Was able to fix it using the database. Don't know if all steps are necessary:

  1. Disable all cron's
  2. run bin/magento indexer:reindex
  3. Go to tabel mview_state in your db. Check for duplicate view_id entries (mine where: design_config_dummy & customer_dummy) and remove them.
  4. Run bin/magento setup:upgrade (pretty sure you can run bin/magento indexer:reindex as well)
  5. Enable all cron's
0

Can you please used this if you stuck

    php -dmemory_limit=6G bin/magento indexer:reset
    php -dmemory_limit=6G bin/magento indexer:reindex design_config_grid customer_grid
    php -dmemory_limit=6G bin/magento indexer:reindex catalog_category_product
    php -dmemory_limit=6G bin/magento indexer:reindex catalog_product_category
    php -dmemory_limit=6G bin/magento indexer:reindex catalog_product_price
    php -dmemory_limit=6G bin/magento indexer:reindex catalog_product_attribute
    php -dmemory_limit=6G bin/magento indexer:reindex catalogsearch_fulltext
    php -dmemory_limit=6G bin/magento indexer:reindex cataloginventory_stock
    php -dmemory_limit=6G bin/magento indexer:reindex catalogrule_rule
    php -dmemory_limit=6G bin/magento indexer:reindex catalogrule_product

Thank you

3
  • Same error message for design_config_grid and customer_grid . Apr 20, 2020 at 8:37
  • First reset all Apr 20, 2020 at 8:38
  • I did. Same error. Apr 20, 2020 at 8:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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