Schema update failure: Duplicated key name

[almeidarobertop]

When upgrading module from 1.2.9.1 to 2.0.0 we faced an error with duplicate key name.

Preconditions

Adobe Cloud

Magento Version :
Commerce 2.4.6-p3

Module Retailer Version :
1.2.9.1

Environment :
Production

Third party modules :
no

Steps to reproduce

1. Composer update smile/module-retailer
2. bin/magento setup:upgrade

Expected result

1. Complete setup with no error

Actual result

1. SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'SMILE_RETAILER_ADDRESS_RETAILER_ID', query was: ALTER TABLE smile_retailer_address ADD CONSTRAINT SMILE_RETAILER_ADDRESS_RETAILER_ID UNIQUE KEY (retailer_id)
2.

[sylvester-c]

I faced this same issue, any solution for this?

[sylvesterdacosta]

The solution for this is before upgrade use this command:

ALTER TABLE smile_retailer_address
DROP FOREIGN KEY SMILE_RETAILER_ADDRESS_RETAILER_ID_SMILE_SELLER_ENTITY_ENTITY_ID,
DROP INDEX SMILE_RETAILER_ADDRESS_RETAILER_ID;