"Unique constraint violation found" when adding New Attribute Set

[shusha]

When I try to add New Attribute Set based on Default Set I get error "Unique constraint violation found". Set is created but it empty. If I create Set from this empty Set it create it without errors. If I add in empty Set group and add some attributes and then try create Set based on it I have error again. Can anybody help with it and what information I should show to find resolve?

[theMageComp]

Hello @shusha 

https://magecomp.com/blog/fix-unique-constraint-violation-found-magento-2-checkout-after-migration/

This is not related exactly about attribute you asked, but if it can give you some idea on solution.

[garzonstudio]

I have added these changes on my database tables 

sales_sequence_meta
sales_sequence_profile

and the error results are the same after I clear catch and re run "php bin/magento setup:db-data:upgrade" SSH command

Why do we need to add a repeated invoice, creditmemo, shipment, order for store id 2 if I use store id 1 and 0 is not used at all?

Also, if I insert those rows to the table, do I need to create also the sequence tables for _2 suffix entries?