Upgrade error 0.3.2 > 0.3.3 : duplicate key value violates unique constraint

duplicate key value violates unique constraint "IndexOnNamePluralAndWorkspaceIdUnique"

yarn command:prod workspace:health -w  75f6e77a-ec52-43fd-af2b-5e1ca8319b2e

yarn command:prod workspace:health -w  75f6e77a-ec52-43fd-af2b-5e1ca8319b2e

reports healthy but:

yarn command:prod workspace:sync-metadata -w 75f6e77a-ec52-43fd-af2b-5e1
ca8319b2e -d

yarn command:prod workspace:sync-metadata -w 75f6e77a-ec52-43fd-af2b-5e1
ca8319b2e -d

fails with:

detail: 'Key ("namePlural", "workspaceId")=(activityTargets, 75f6e77a-ec52-43fd-af2b-5e1ca8319b2e) already exists.'

detail: 'Key ("namePlural", "workspaceId")=(activityTargets, 75f6e77a-ec52-43fd-af2b-5e1ca8319b2e) already exists.'

I tried deleting in "metadata"."objectData" to see if it had any effect but it did not:

delete from "metadata"."objectMetadata" where "namePlural"='activityTargets';
DELETE 2

delete from "metadata"."objectMetadata" where "namePlural"='activityTargets';
DELETE 2

Twenty•2y ago•

216 replies

duplicate key value violates unique constraint "IndexOnNamePluralAndWorkspaceIdUnique"

yarn command:prod workspace:health -w  75f6e77a-ec52-43fd-af2b-5e1ca8319b2e

yarn command:prod workspace:health -w  75f6e77a-ec52-43fd-af2b-5e1ca8319b2e

reports healthy but:

yarn command:prod workspace:sync-metadata -w 75f6e77a-ec52-43fd-af2b-5e1
ca8319b2e -d

yarn command:prod workspace:sync-metadata -w 75f6e77a-ec52-43fd-af2b-5e1
ca8319b2e -d

fails with:

detail: 'Key ("namePlural", "workspaceId")=(activityTargets, 75f6e77a-ec52-43fd-af2b-5e1ca8319b2e) already exists.'

detail: 'Key ("namePlural", "workspaceId")=(activityTargets, 75f6e77a-ec52-43fd-af2b-5e1ca8319b2e) already exists.'

I tried deleting in "metadata"."objectData" to see if it had any effect but it did not:

delete from "metadata"."objectMetadata" where "namePlural"='activityTargets';
DELETE 2

delete from "metadata"."objectMetadata" where "namePlural"='activityTargets';
DELETE 2