Issues migrating to 5.x on production

[mikejpeters]

I've successfully updated my dev site from Commerce 3 to 4 to 5, following the upgrade docs for both Commerce and Craft CMS (I hope!).

But re-running the steps as a trial run for production keeps failing:

1. Set CRAFT_ENVIRONMENT to something besides "dev" so allowAdminChanges is false
2. Restore database backup from Craft 3
3. Checkout site upgraded to Craft 4
4. Run composer install and then php craft up
5. Run php craft commerce/upgrade
6. Checkout site upgraded to Craft 5
7. Run composer install and then php craft up

At this point after the database migrations run, I get an error:

Migrated up successfully.

Applying changes from your project config files ...
- removing commerce.stores.xxxxxxxxxxx ...
error: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`db`.`commerce_taxrates`, CONSTRAINT `fk_qxcjdrmsquxyuxywxlghyommqsgpsbnyzyti` FOREIGN KEY (`taxZoneId`) REFERENCES `commerce_taxzones` (`id`) ON UPDATE CASCADE)
The SQL being executed was: DELETE FROM `commerce_stores` WHERE `id`=1

Should I be focusing on the SQL error, OR the fact that a store is being deleted at all?

When I query the database, it looks like the commerce_stores uid (e.g. "abc") is different from the uid being used in the project.yaml (e.g. xyz: 'Primary Store'). So is it trying to delete the old store and create a new one matching the project config? Is this normal expected behavior or does it indicate I've done something else wrong?

Sorry I know that I've left out a lot of details, but any help just looking in the right direction would be really appreciated!

[mikejpeters]

After re-attempting the upgrade multiple times, I'm pretty sure this is a bug so I opened an issue instead #3746