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
SELECTcatalog_product_index_price_replica
.* FROMcatalog_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?