at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) at Socket.emit (node:events:518:28) at addChunk (node:internal/streams/readable:561:12) at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) at Readable.push (node:internal/streams/readable:392:5) at TCP.onStreamRead (node:internal/stream_base_commons:189:23) at TCP.callbackTrampoline (node:internal/async_hooks:130:17) Query failed : { durationMs: 0.7838230000052135, error: PostgresError: there is no unique or exclusion constraint matching the ON CONFLICT specification at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) at Socket.emit (node:events:518:28) at addChunk (node:internal/streams/readable:561:12) at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) at Readable.push (node:internal/streams/readable:392:5) at TCP.onStreamRead (node:internal/stream_base_commons:189:23) at TCP.callbackTrampoline (node:internal/async_hooks:130:17) { severity_local: 'ERROR', severity: 'ERROR', code: '42P10', file: 'plancat.c', line: '877', routine: 'infer_arbiter_indexes' }, sql: 'insert into "asset_exif" ("assetId", "fileSizeInByte") values ($1::uuid, $2) on conflict ("assetId") do update set "fileSizeInByte" = "excluded"."fileSizeInByte"', params: [ '31cd74bc-c908-4ff9-9c45-1044dd8bd77c', 818541 ] } [Nest] 32 - 09/23/2025, 12:58:32 PM ERROR [Api:AssetMediaService~ysu257mi] Error uploading file PostgresError: there is no unique or exclusion constraint matching the ON CONFLICT specification PostgresError: there is no unique or exclusion constraint matching the ON CONFLICT specification at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) at Socket.emit (node:events:518:28) at addChunk (node:internal/streams/readable:561:12) at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) at Readable.push (node:internal/streams/readable:392:5) at TCP.onStreamRead (node:internal/stream_base_commons:189:23) at TCP.callbackTrampoline (node:internal/async_hooks:130:17) [Nest] 32 - 09/23/2025, 12:58:32 PM ERROR [Api:ErrorInterceptor~ysu257mi] Unknown error: PostgresError: there is no unique or exclusion constraint matching the ON CONFLICT specification PostgresError: there is no unique or exclusion constraint matching the ON CONFLICT specification at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) at Socket.emit (node:events:518:28) at addChunk (node:internal/streams/readable:561:12) at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) at Readable.push (node:internal/streams/readable:392:5) at TCP.onStreamRead (node:internal/stream_base_commons:189:23) at TCP.callbackTrampoline (node:internal/async_hooks:130:17) Query failed : { durationMs: 1.05559699999867, error: PostgresError: there is no unique or exclusion constraint matching the ON CONFLICT specification at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) at Socket.emit (node:events:518:28) at addChunk (node:internal/streams/readable:561:12) at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) at Readable.push (node:internal/streams/readable:392:5) at TCP.onStreamRead (node:internal/stream_base_commons:189:23) at TCP.callbackTrampoline (node:internal/async_hooks:130:17) { severity_local: 'ERROR', severity: 'ERROR', code: '42P10', file: 'plancat.c', line: '877', routine: 'infer_arbiter_indexes' }, sql: 'insert into "asset_exif" ("assetId", "fileSizeInByte") values ($1::uuid, $2) on conflict ("assetId") do update set "fileSizeInByte" = "excluded"."fileSizeInByte"', params: [ 'a5da7b97-22c9-4824-88b0-fc889b3f9e33', 3178489 ] } [Nest] 32 - 09/23/2025, 12:58:32 PM ERROR [Api:AssetMediaService~tza2l33l] Error uploading file PostgresError: there is no unique or exclusion constraint matching the ON CONFLICT specification PostgresError: there is no unique or exclusion constraint matching the ON CONFLICT specification at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) at Socket.emit (node:events:518:28) at addChunk (node:internal/streams/readable:561:12) at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) at Readable.push (node:internal/streams/readable:392:5) at TCP.onStreamRead (node:internal/stream_base_commons:189:23) at TCP.callbackTrampoline (node:internal/async_hooks:130:17) [Nest] 32 - 09/23/2025, 12:58:32 PM ERROR [Api:ErrorInterceptor~tza2l33l] Unknown error: PostgresError: there is no unique or exclusion constraint matching the ON CONFLICT specification PostgresError: there is no unique or exclusion constraint matching the ON CONFLICT specification at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) at Socket.emit (node:events:518:28) at addChunk (node:internal/streams/readable:561:12) at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) at Readable.push (node:internal/streams/readable:392:5) at TCP.onStreamRead (node:internal/stream_base_commons:189:23) at TCP.callbackTrampoline (node:internal/async_hooks:130:17) [Nest] 32 - 09/23/2025, 12:58:59 PM LOG [Api:EventRepository] Websocket Disconnect: oH99QbYWoNAaMhfoAAAH [Nest] 32 - 09/23/2025, 1:01:56 PM LOG [Api:EventRepository] Websocket Connect: q0qYu43S46th8nlKAAAJ [Nest] 32 - 09/23/2025, 1:03:27 PM LOG [Api:EventRepository] Websocket Disconnect: q0qYu43S46th8nlKAAAJ