error: error: duplicate key value violates unique constraint

After upgrading to

v0.53

v0.53

v0.53

v0.53 (following help steps from: ❓︱helpError: Field Metadata of type RELATION with id befd9a49-20cc-4200-8a5c-e1ed07cb1e96 has no settings) I now see following repeating errors in the logs:

server-1  | error: error: duplicate key value violates unique constraint "IDX_UNIQUE_6d269465206d2f3e283ce479b2e"
server-1  | query failed: INSERT INTO "workspace_7p0vvem84hpqothgegpexvj81"."viewField"("fieldMetadataId", "isVisible", "size", "id", "position", "aggregateOperation", "createdAt", "upd
atedAt", "deletedAt", "viewId") VALUES ($1, $2, $3, $4, $5, DEFAULT, DEFAULT, DEFAULT, DEFAULT, $6) RETURNING "fieldMetadataId", "isVisible", "size", "id", "position", "aggregateOperati
on", "createdAt", "updatedAt", "deletedAt" -- PARAMETERS: ["da5e450b-f116-4228-8d3c-b9b76fd0bb6a",true,100,"94514f91-bad9-49e9-ab8d-30aa473c36bf",7,"09c365d1-a192-4394-af23-6c2ae74454ec
"]

server-1  | error: error: duplicate key value violates unique constraint "IDX_UNIQUE_6d269465206d2f3e283ce479b2e"
server-1  | query failed: INSERT INTO "workspace_7p0vvem84hpqothgegpexvj81"."viewField"("fieldMetadataId", "isVisible", "size", "id", "position", "aggregateOperation", "createdAt", "upd
atedAt", "deletedAt", "viewId") VALUES ($1, $2, $3, $4, $5, DEFAULT, DEFAULT, DEFAULT, DEFAULT, $6) RETURNING "fieldMetadataId", "isVisible", "size", "id", "position", "aggregateOperati
on", "createdAt", "updatedAt", "deletedAt" -- PARAMETERS: ["da5e450b-f116-4228-8d3c-b9b76fd0bb6a",true,100,"94514f91-bad9-49e9-ab8d-30aa473c36bf",7,"09c365d1-a192-4394-af23-6c2ae74454ec
"]

server-1  | error: error: duplicate key value violates unique constraint "IDX_UNIQUE_6d269465206d2f3e283ce479b2e"
server-1  | query failed: INSERT INTO "workspace_7p0vvem84hpqothgegpexvj81"."viewField"("fieldMetadataId", "isVisible", "size", "id", "position", "aggregateOperation", "createdAt", "upd
atedAt", "deletedAt", "viewId") VALUES ($1, $2, $3, $4, $5, DEFAULT, DEFAULT, DEFAULT, DEFAULT, $6) RETURNING "fieldMetadataId", "isVisible", "size", "id", "position", "aggregateOperati
on", "createdAt", "updatedAt", "deletedAt" -- PARAMETERS: ["da5e450b-f116-4228-8d3c-b9b76fd0bb6a",true,100,"94514f91-bad9-49e9-ab8d-30aa473c36bf",7,"09c365d1-a192-4394-af23-6c2ae74454ec
"]

server-1  | error: error: duplicate key value violates unique constraint "IDX_UNIQUE_6d269465206d2f3e283ce479b2e"
server-1  | query failed: INSERT INTO "workspace_7p0vvem84hpqothgegpexvj81"."viewField"("fieldMetadataId", "isVisible", "size", "id", "position", "aggregateOperation", "createdAt", "upd
atedAt", "deletedAt", "viewId") VALUES ($1, $2, $3, $4, $5, DEFAULT, DEFAULT, DEFAULT, DEFAULT, $6) RETURNING "fieldMetadataId", "isVisible", "size", "id", "position", "aggregateOperati
on", "createdAt", "updatedAt", "deletedAt" -- PARAMETERS: ["da5e450b-f116-4228-8d3c-b9b76fd0bb6a",true,100,"94514f91-bad9-49e9-ab8d-30aa473c36bf",7,"09c365d1-a192-4394-af23-6c2ae74454ec
"]

and users are complaining that there might be missing or disappeared data (see screenshot)

error: error: duplicate key value violates unique constraint

Similar Threads

Similar Threads

Similar Threads