2016-04-14T04:50:53+00:00 DEBUG (7): Exception message:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or
update a child row: a foreign key constraint fails
(`magento_repair_db`.`catalog_product_index_eav`, CONSTRAINT
`FK_CAT_PRD_IDX_EAV_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY
(`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`)),
query was: INSERT INTO `catalog_product_index_eav` (`entity_id`,
`attribute_id`, `store_id`, `value`) SELECT
`catalog_product_index_eav_idx`.`entity_id`,
`catalog_product_index_eav_idx`.`attribute_id`,
`catalog_product_index_eav_idx`.`store_id`,
`catalog_product_index_eav_idx`.`value` FROM
`catalog_product_index_eav_idx` ON DUPLICATE KEY UPDATE `entity_id` =
VALUES(`entity_id`), `attribute_id` = VALUES(`attribute_id`),
`store_id` = VALUES(`store_id`), `value` = VALUES(`value`)
I have issue during attribute reindexing for layered navigation filter.
How can i solve this issue?
Best Answer
Well I think your issue is due to the products which are creating hindrance in the Index process.
You have to run the below queries for re-indexing to work:
Hope this helps you out