Query failed : { durationMs: 1.28834000043571, error: PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum" at ErrorResponse (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:794:26) at handle (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:480:6) at Socket.data (/usr/src/app/server/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)=(2b4f5239-1677-4347-90e3-e50fff09e66f, \\xda39a3ee5e6b4b0d3255bfef95601890afd80709) already exists.', schema_name: 'public', table_name: 'asset', constraint_name: 'UQ_assets_owner_checksum', file: 'nbtinsert.c', line: '663', routine: '_bt_check_unique' }, sql: 'insert into "asset" ("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: [ '2b4f5239-1677-4347-90e3-e50fff09e66f', null, , '/usr/src/app/upload/upload/2b4f5239-1677-4347-90e3-e50fff09e66f/82/b6/82b67af2-52cf-4b4a-9a94-948e7128d926.JPG', 'web-IMG_2299.JPG-1755352892115', 'WEB', 2025-08-16T14:01:32.115Z, 2025-08-16T14:01:32.116Z, 2025-08-16T14:01:32.115Z, 'IMAGE', false, '0:00:00.000000', 'timeline', 'IMG_2299.JPG' ] } [Nest] 17 - 08/16/2025, 4:05:08 PM LOG [Api:EventRepository] Websocket Disconnect: fb1gkpU6wfbtBIifAAAz [Nest] 17 - 08/16/2025, 4:05:39 PM LOG [Api:EventRepository] Websocket Connect: vzKrPToGCaAQEmaFAAA1 Query failed : { durationMs: 1.7409339994192123, error: PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum" at ErrorResponse (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:794:26) at handle (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:480:6) at Socket.data (/usr/src/app/server/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)=(2b4f5239-1677-4347-90e3-e50fff09e66f, \\xda39a3ee5e6b4b0d3255bfef95601890afd80709) already exists.', schema_name: 'public', table_name: 'asset', constraint_name: 'UQ_assets_owner_checksum', file: 'nbtinsert.c', line: '663', routine: '_bt_check_unique' }, sql: 'insert into "asset" ("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: [ '2b4f5239-1677-4347-90e3-e50fff09e66f', null, , '/usr/src/app/upload/upload/2b4f5239-1677-4347-90e3-e50fff09e66f/37/18/3718781d-23bb-4444-a132-46038f08fec1.JPG', 'web-IMG_2299.JPG-1755353148278', 'WEB', 2025-08-16T14:05:48.279Z, 2025-08-16T14:05:48.279Z, 2025-08-16T14:05:48.279Z, 'IMAGE', false, '0:00:00.000000', 'timeline', 'IMG_2299.JPG' ] } [Nest] 17 - 08/16/2025, 4:05:51 PM LOG [Api:EventRepository] Websocket Connect: aK6vvCaFKqEcWCBPAAA3 Query failed : { durationMs: 1.68108900077641, error: PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum" at ErrorResponse (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:794:26) at handle (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:480:6) at Socket.data (/usr/src/app/server/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)=(2b4f5239-1677-4347-90e3-e50fff09e66f, \\xda39a3ee5e6b4b0d3255bfef95601890afd80709) already exists.', schema_name: 'public', table_name: 'asset', constraint_name: 'UQ_assets_owner_checksum', file: 'nbtinsert.c', line: '663', routine: '_bt_check_unique' }, sql: 'insert into "asset" ("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: [ '2b4f5239-1677-4347-90e3-e50fff09e66f', null, , '/usr/src/app/upload/upload/2b4f5239-1677-4347-90e3-e50fff09e66f/0a/15/0a155426-043f-40eb-bf59-9b2fbe05a306.HEIC', 'web-IMG_0065.HEIC-1755353165183', 'WEB', 2025-08-16T14:06:05.184Z, 2025-08-16T14:06:05.184Z, 2025-08-16T14:06:05.184Z, 'IMAGE', false, '0:00:00.000000', 'timeline', 'IMG_0065.HEIC' ] }