catalog_product_index_eav_idx

[abolivar]

Preconditions

1. Magento 2.1.3
2. PHP 7.0.13
3. Apache 2.4.23
4. Mysql 5.7.16

Steps to reproduce

1. After update to 2.1.3 from 2.1.2

Expected result

1. normal reindex

Actual result

1. SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '16671-174-1-149' for key 'PRIMARY', query was: INSERT INTO oo_catalog_product_index_eav_idx (entity_id,attribute_id,store_id,value) VALUES (?, ?, ?, ?),......

[shrinet]

I will suggest to check attributes specially attribute Id 149 in your case, you must get clue. In my case attribute value duplicated.

[feronera]

@abolivar as commented from @shrinet

Your issue are occurred from database integrity constraint. Not sure about root cause. But please try to resolve with these resolution.

entity_id	attribute_id	store_id	value
16671	174	1	149

See your magento2 database table "catalog_product_index_eav_idx" with prefix "oo_ ". And try to find datatype of attribute_id = 149 from eav_attribute. You need to the right magento2 table product_entity datatype for solve it. For example if you founded that "varchar". Just go to table "catalog_product_entity_varchar" then find that record by SQL such as:

SELECT * FROM catalog_product_entity_varchar where attribute_id=174 and entity_id=16671

You will find the duplicate on field value. Just fix it to not dup then try to reindex again.

See my example below.

[magento-engcom-team]

@abolivar is the issue actual yet?

[magento-engcom-team]

@abolivar, we are closing this issue due to inactivity. If you'd like to update it, please reopen the issue.