Magento 2.3 migration - How to solve Duplicate entry error after data migration?

Note: I did data migration couple of times, during data migration max_allowd_packet issue then update and again run the data migration.

How to solve the php bin/magento setup:upgrade error, If i try to run upgrade command i am getting following error,

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate
entry ’21’ for key ‘PRIMARY’, query was: INSERT INTO
eav_attribute_set (entity_type_id, attribute_set_name,
sort_order, attribute_set_id) VALUES (?, ?, ?, ?)

Queries :

  1. SELECT * FROM eav_attribute_set WHERE attribute_set_id = ’21’;

  2. SELECT * FROM eav_attribute_group WHERE attribute_set_id = ’21’;

Table : eav_attribute_set

enter image description here

What value should i delete?

Magento Asked by zus on November 9, 2020

0 Answers

Add your own answers!

Related Questions

How can I hide the store switcher

4  Asked on February 4, 2021 by nria


Magento 2 – Cant use product factory in plugin

1  Asked on February 3, 2021 by black


How to create custom link for category?

3  Asked on January 30, 2021 by r_solanki


Magento 2 cache_invalidate loop

2  Asked on January 29, 2021 by tjitse


Magento 2.2 ssh commands not executed

1  Asked on January 29, 2021 by jilco-tigchelaar


How to add new or customize existing top header links in Magento?

4  Asked on January 26, 2021 by tallal-hassan


Upload SVG files as product image

0  Asked on January 26, 2021 by francesco-terreni


Add custom parameter in order’s item in rest api magento 2

0  Asked on January 25, 2021 by vijay-gupta


Ask a Question

Get help from others!

© 2021 All rights reserved.