Skip to content

How to fix this indexing error?

When I am running indexer:reindex command, I am getting this error.

Integrity constraint violation: 1062 Duplicate entry ‘1448-0-1’ for key ‘PRIMARY’, query was: INSERT INTO catalog_product_index_price_temp SELECT catalog_product_index_price_replica.* FROM catalog_product_index_price_replica WHERE (entity_id IN(‘5472’, ‘5842’, ‘5848’, ‘5467’, ‘5468’, ‘5471’, ‘5848’, ‘5467’, ‘5468’, ‘5851’, ‘5855’, ‘5467’, ‘5471’, ‘5472’, ‘5848’, ‘5467’, ‘5468’, ‘5851’, ‘5855’, ‘5466’, ‘5467’, ‘5468’, ‘1603’, ‘1604’, ‘1605’, ‘1606’, ‘1607’, ‘5472’, ‘5842’, ‘5467’, ‘5468’, ‘5467’, ‘5468’, ‘6214’, ‘6215’, ‘6216’, ‘6217’, ‘1448’, ‘1449’, ‘1450’, ‘1451’, ‘1452’, ‘5696’, ‘5697’, ‘5698’, ‘5699’, ‘5700’))

I tried to disable this product and tried again the command, Again I am getting another set of products as this.

I tried php bin/magento index:reset command, It invalidates the index, and when I am running php bin/magento indexer: reindex it will keep running but not complete.

Any suggestion or help to fix this issue?