I want to know what is meaning of this?

Magento no longer locks the category_product_entity table. Unlocking this table reduces the potential of lock-related timeouts that can occur when indexing and checkout operations run in parallel. Previously, Magento locked the category_product_entity table.

is it related to category product reindex? what related to this?


When you face indexing lock issue you can unlock by using below command

php bin/magento indexer:reset

This command just reset all indexing so indexing lock issue resolve and you can re-run

php bin/magento indexer:reindex

If you want to reset particular index (e.g. catalogsearch_fulltext), you can run the following command:

php bin/magento indexer:reset catalogsearch_fulltext
| improve this answer | |
  • If there is a error occurs while re indexing category_product_entity it will not skipped? – Alpha Jan 26 '18 at 8:08
  • it will skip and you need to reindex again – Navin Bhudiya Jan 26 '18 at 9:32

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.