I have been getting this in my logs and phpmyadmin

main.CRITICAL: Table "catalogrule_product_replica" does not exist

when I try to run these 2 indexes they are failing php bin/magento indexer:reindex catalogrule_rule php bin/magento indexer:reindex catalogrule_product

Catalog rule indexing failed. See details in exception log.

I have tried to drop the table and import from backup working database however it still does not reindex. But the error does go away

Any help would be most appreicated as I am stuck for 2 days


1 Answer 1


Please copy this table :


From any other magento 2 project database and create it on your current database.Then Run this command:

php bin/magento indexer:reindex

It will be solved!

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.