Issue with yarn database:migrate:prod on version 0.43 โ duplicate key value error
Hey everyone,
I'm encountering an error while running the migration for version 0.43 with the following command:
Error Message: QueryFailedError: duplicate key value violates unique constraint "IndexOnNameObjectMetadataIdAndWorkspaceIdUnique"
Key (name, "objectMetadataId", "workspaceId")=(body, afd4a320-c752-43e2-a7ce-74bf2b4b84f9, a1efc3dc-e551-44bd-bf80-b053f3af3ada) already exists.
Is there a known fix for this duplicate key issue in 0.43?
I had the error on production and also locally. Using the postgres image and the twenty-postgres:v0.32 image.
Thanks in advance for your help!
I'm encountering an error while running the migration for version 0.43 with the following command:
yarn database:migrate:prodError Message: QueryFailedError: duplicate key value violates unique constraint "IndexOnNameObjectMetadataIdAndWorkspaceIdUnique"
Key (name, "objectMetadataId", "workspaceId")=(body, afd4a320-c752-43e2-a7ce-74bf2b4b84f9, a1efc3dc-e551-44bd-bf80-b053f3af3ada) already exists.
Is there a known fix for this duplicate key issue in 0.43?
I had the error on production and also locally. Using the postgres image and the twenty-postgres:v0.32 image.
Thanks in advance for your help!