at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26) at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6) at Socket.data (/usr/src/app/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: '23505', detail: 'Key ("ownerId", checksum)=(4ed7504c-f323-4d87-b8bd-451a12575e7e, \\xb8ea175f367ec72d7d0be07bfb433ce8248270f2) already exists.', schema_name: 'public', table_name: 'assets', constraint_name: 'UQ_assets_owner_checksum', file: 'nbtinsert.c', line: '663', routine: '_bt_check_unique' }, sql: 'insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *', params: [ '4ed7504c-f323-4d87-b8bd-451a12575e7e',  , , 'upload/upload/4ed7504c-f323-4d87-b8bd-451a12575e7e/68/c9/68c9f9fb-cde7-4a4e-ad03-a864ca106593.JPG', '3508AC1E-D69B-424D-88FA-39712034AAD9/L0/001', 'ed55d7a17423bbaf300c07f44540aa0688587c74c7ed556287edcb085dfe22e2', 2024-05-02T20:06:16.000Z, 2024-05-04T10:23:24.000Z, 2024-05-02T20:06:16.000Z,  'IMAGE', false, '0:00:00.000000', 'timeline', 'IMG_0013.JPG' ] } Query failed : { durationMs: 0.48179799993522465, error: PostgresError: there is no unique or exclusion constraint matching the ON CONFLICT specification at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26) at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6) at Socket.data (/usr/src/app/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 "exif" ("assetId", "fileSizeInByte") values ($1::uuid, $2) on conflict ("assetId") do update set "fileSizeInByte" = "excluded"."fileSizeInByte"', params: [ '4fe96cde-1e00-4d5e-866f-b3dcfdadad17', 507874 ] } [Nest] 17 - 05/29/2025, 5:22:41 AM ERROR [Api:AssetMediaService~vs2ex4hl] 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/node_modules/postgres/cjs/src/connection.js:790:26) at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6) at Socket.data (/usr/src/app/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] 17 - 05/29/2025, 5:22:41 AM ERROR [Api:ErrorInterceptor~vs2ex4hl] 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/node_modules/postgres/cjs/src/connection.js:790:26) at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6) at Socket.data (/usr/src/app/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] 17 - 05/29/2025, 5:24:23 AM LOG [Api:EventRepository] Websocket Disconnect: ErewposYCDW2xVMhAAAN [Nest] 17 - 05/29/2025, 5:24:23 AM LOG [Api:EventRepository] Websocket Connect: 68y_yhJbMRYPE0X_AAAP [Nest] 17 - 05/29/2025, 5:24:54 AM LOG [Api:EventRepository] Websocket Connect: yKS8f059_keN3hM9AAAR [Nest] 17 - 05/29/2025, 5:24:56 AM LOG [Api:EventRepository] Websocket Disconnect: yKS8f059_keN3hM9AAAR [Nest] 17 - 05/29/2025, 5:24:58 AM LOG [Api:EventRepository] Websocket Connect: qDwAgwNCQ5GTWix2AAAT [Nest] 17 - 05/29/2025, 5:25:29 AM LOG [Api:EventRepository] Websocket Disconnect: qDwAgwNCQ5GTWix2AAAT [Nest] 17 - 05/29/2025, 5:26:34 AM LOG [Api:EventRepository] Websocket Connect: xQNSTDCDO5iTeLULAAAV [Nest] 17 - 05/29/2025, 5:27:00 AM LOG [Api:EventRepository] Websocket Disconnect: xQNSTDCDO5iTeLULAAAV [Nest] 17 - 05/29/2025, 5:28:08 AM LOG [Api:EventRepository] Websocket Disconnect: 68y_yhJbMRYPE0X_AAAP [Nest] 17 - 05/29/2025, 5:28:08 AM LOG [Api:EventRepository] Websocket Connect: jvfzDTEgGbM3YNBnAAAX [Nest] 17 - 05/29/2025, 5:28:10 AM LOG [Api:EventRepository] Websocket Disconnect: jvfzDTEgGbM3YNBnAAAX [Nest] 17 - 05/29/2025, 5:28:10 AM LOG [Api:EventRepository] Websocket Connect: Wk704y3YjAnh0xAXAAAZ [Nest] 17 - 05/29/2025, 5:28:10 AM LOG [Api:EventRepository] Websocket Disconnect: Wk704y3YjAnh0xAXAAAZ [Nest] 17 - 05/29/2025, 5:28:11 AM LOG [Api:EventRepository] Websocket Connect: oGAi04jNRuH33e1SAAAb [Nest] 17 - 05/29/2025, 5:28:11 AM LOG [Api:EventRepository] Websocket Disconnect: oGAi04jNRuH33e1SAAAb [Nest] 17 - 05/29/2025, 5:28:11 AM LOG [Api:EventRepository] Websocket Connect: 1VpX2X7EALl_6hUUAAAd [Nest] 17 - 05/29/2025, 5:29:31 AM LOG [Api:EventRepository] Websocket Connect: ch7SpN2U3rRuyj9pAAAf [Nest] 17 - 05/29/2025, 5:31:21 AM LOG [Api:EventRepository] Websocket Disconnect: ch7SpN2U3rRuyj9pAAAf