schema_name: 'public', table_name: 'asset', constraint_name: 'UQ_assets_owner_checksum', file: 'nbtinsert.c', line: '666', 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: [ '5e83ea94-89ea-462b-b2cf-12babbde7b6c', null, , '/opt/immich/upload/upload/5e83ea94-89ea-462b-b2cf-12babbde7b6c/65/ed/65edd64f-48f8-4851-919b-b7550a2d3d53.jpg', '1A4B1D27-675B-4087-B12C-98468633306D/L0/001', 'c537193939cb9ebb328023c6910b2fc4d7ba56cccd7398192efb75bc99db5535', 2025-08-30T22:42:09.000Z, 2025-08-30T22:45:12.000Z, 2025-08-30T22:42:09.000Z, 'IMAGE', false, '0:00:00.000000', 'timeline', 'b6b44d54-a20f-4db5-8b98-d8ce28250a47.jpg' ] } Query failed : { durationMs: 2.5828568935394287, error: PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum" at ErrorResponse (/opt/immich/app/node_modules/postgres/cjs/src/connection.js:794:26) at handle (/opt/immich/app/node_modules/postgres/cjs/src/connection.js:480:6) at Socket.data (/opt/immich/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)=(5e83ea94-89ea-462b-b2cf-12babbde7b6c, \\x788a8a1c4d609a94d261c43ee4f62baf809974fe) already exists.', schema_name: 'public', table_name: 'asset', constraint_name: 'UQ_assets_owner_checksum', file: 'nbtinsert.c', line: '666', 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: [ '5e83ea94-89ea-462b-b2cf-12babbde7b6c', null, , '/opt/immich/upload/upload/5e83ea94-89ea-462b-b2cf-12babbde7b6c/45/d7/45d7d778-af26-47a6-8f89-03e2363ad346.jpg', '9A64AA7A-0358-41F7-9F1A-52FA695C56F8/L0/001', 'c537193939cb9ebb328023c6910b2fc4d7ba56cccd7398192efb75bc99db5535', 2025-08-27T00:34:08.000Z, 2025-03-13T17:39:32.000Z, 2025-08-27T00:34:08.000Z, 'IMAGE', false, '0:00:00.000000', 'timeline', '31207ed3-ed29-458e-af56-d01b62130ace.jpg' ] } Query failed : { durationMs: 6.909198999404907, error: PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum" at ErrorResponse (/opt/immich/app/node_modules/postgres/cjs/src/connection.js:794:26) at handle (/opt/immich/app/node_modules/postgres/cjs/src/connection.js:480:6) at Socket.data (/opt/immich/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)=(5e83ea94-89ea-462b-b2cf-12babbde7b6c, \\x8e6084494ce21b2bbc6278770d8a740b56dfb1e1) already exists.', schema_name: 'public', table_name: 'asset', constraint_name: 'UQ_assets_owner_checksum', file: 'nbtinsert.c', line: '666', 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: [ '5e83ea94-89ea-462b-b2cf-12babbde7b6c', null, , '/opt/immich/upload/upload/5e83ea94-89ea-462b-b2cf-12babbde7b6c/a0/6f/a06fdd10-62a4-41f9-ac62-f82c0c7ecb02.jpg', '7AE6D9BC-B9E5-4BA3-B6C2-7369C33114AF/L0/001', 'c537193939cb9ebb328023c6910b2fc4d7ba56cccd7398192efb75bc99db5535', 2025-08-26T03:18:54.000Z, 2025-07-16T04:15:05.000Z, 2025-08-26T03:18:54.000Z, 'IMAGE', false, '0:00:00.000000', 'timeline', 'ff0ce0ea-8f46-4eb4-90aa-ba395eddea38.jpg' ] }