immich_server | line: '663', immich_server | routine: '_bt_check_unique' immich_server | } immich_server | microservices worker error: PostgresError: duplicate key value violates unique constraint "asset_file_assetId_type_isEdited_uq", stack: PostgresError: duplicate key value violates unique constraint "asset_file_assetId_type_isEdited_uq" immich_server | at ErrorResponse (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.8/node_modules/postgres/src/connection.js:815:30) immich_server | at handle (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.8/node_modules/postgres/src/connection.js:489:6) immich_server | at Socket.data (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.8/node_modules/postgres/src/connection.js:324:9) immich_server | at Socket.emit (node:events:508:28) immich_server | at addChunk (node:internal/streams/readable:559:12) immich_server | at readableAddChunkPushByteMode (node:internal/streams/readable:510:3) immich_server | at Readable.push (node:internal/streams/readable:390:5) immich_server | at TCP.onStreamRead (node:internal/stream_base_commons:189:23) immich_server | microservices worker exited with code 1 immich_server | Killing api process immich_server | Initializing Immich v2.6.1 immich_server | Detected CPU Cores: 12 immich_server | (node:7) ExperimentalWarning: WASI is an experimental feature and might change at any time immich_server | (Use `node --trace-warnings ...` to show where the warning was created) immich_server | Starting api worker immich_server | Starting microservices worker immich_server | (node:7) ExperimentalWarning: WASI is an experimental feature and might change at any time immich_server | (Use `node --trace-warnings ...` to show where the warning was created) immich_server | (node:31) ExperimentalWarning: WASI is an experimental feature and might change at any time immich_server | (Use `node --trace-warnings ...` to show where the warning was created) immich_server | [Nest] 7 - 03/22/2026, 1:24:23 PM LOG [Microservices:WebsocketRepository] Initialized websocket server immich_server | [Nest] 7 - 03/22/2026, 1:24:23 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 3908 rows immich_server | [Nest] 7 - 03/22/2026, 1:24:23 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 2406 rows immich_server | [Nest] 7 - 03/22/2026, 1:24:23 PM LOG [Microservices:DatabaseRepository] Running migrations immich_server | [Nest] 31 - 03/22/2026, 1:24:23 PM LOG [Api:WebsocketRepository] Initialized websocket server immich_server | Query failed : { immich_server | durationMs: 8.015454000000318, immich_server | error: PostgresError: duplicate key value violates unique constraint "asset_file_assetId_type_isEdited_uq" immich_server | at ErrorResponse (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.8/node_modules/postgres/src/connection.js:815:30) immich_server | at handle (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.8/node_modules/postgres/src/connection.js:489:6) immich_server | at Socket.data (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.8/node_modules/postgres/src/connection.js:324:9) immich_server | at Socket.emit (node:events:508:28) immich_server | at addChunk (node:internal/streams/readable:559:12) immich_server | at readableAddChunkPushByteMode (node:internal/streams/readable:510:3) immich_server | at Readable.push (node:internal/streams/readable:390:5) immich_server | at TCP.onStreamRead (node:internal/stream_base_commons:189:23) { immich_server | severity_local: 'ERROR', immich_server | severity: 'ERROR', immich_server | code: '23505', immich_server | detail: 'Key ("assetId", type, "isEdited")=(0e8d8460-d89f-4b42-83a4-002ff58bb137, encoded_video, f) already exists.', immich_server | schema_name: 'public', immich_server | table_name: 'asset_file', immich_server | constraint_name: 'asset_file_assetId_type_isEdited_uq', immich_server | file: 'nbtinsert.c', immich_server | line: '663', immich_server | routine: '_bt_check_unique' immich_server | }, immich_server | sql: '\n' + immich_server | ' INSERT INTO "asset_file" ("assetId", "type", "path")\n' + immich_server | ` SELECT "id", 'encoded_video', "encodedVideoPath"\n` + immich_server | ' FROM "asset"\n' + immich_server | ` WHERE "encodedVideoPath" IS NOT NULL AND "encodedVideoPath" != '';\n` + immich_server | ' ', immich_server | params: [] immich_server | } immich_server | [Nest] 7 - 03/22/2026, 1:24:23 PM LOG [Microservices:DatabaseRepository] Migration "1771478781948-PeopleSearchIndex" succeeded immich_server | [Nest] 7 - 03/22/2026, 1:24:23 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: duplicate key value violates unique constraint "asset_file_assetId_type_isEdited_uq" immich_server | [Nest] 7 - 03/22/2026, 1:24:23 PM LOG [Microservices:DatabaseRepository] Migration "1771535611395-ConvertRating0ToNull" succeeded immich_server | [Nest] 7 - 03/22/2026, 1:24:23 PM LOG [Microservices:DatabaseRepository] Migration "1771639515206-AddIsTransparentColumn" succeeded immich_server | [Nest] 7 - 03/22/2026, 1:24:23 PM LOG [Microservices:DatabaseRepository] Migration "1771873044511-ChangesTokensToBuffers" succeeded immich_server | [Nest] 7 - 03/22/2026, 1:24:23 PM LOG [Microservices:DatabaseRepository] Migration "1771873813973-AssetEditSync" succeeded immich_server | [Nest] 7 - 03/22/2026, 1:24:23 PM LOG [Microservices:DatabaseRepository] Migration "1772121424533-AddAssetExifGistEarthcoord" succeeded immich_server | [Nest] 7 - 03/22/2026, 1:24:23 PM LOG [Microservices:DatabaseRepository] Migration "1772129818245-FixStupidWhiteSpace" succeeded immich_server | [Nest] 7 - 03/22/2026, 1:24:23 PM LOG [Microservices:DatabaseRepository] Migration "1772609167000-UpdateOpusCodecName" succeeded immich_server | [Nest] 7 - 03/22/2026, 1:24:23 PM WARN [Microservices:DatabaseRepository] Migration "1773242919341-EncodedVideoAssetFiles" failed immich_server | PostgresError: duplicate key value violates unique constraint "asset_file_assetId_type_isEdited_uq" immich_server | at ErrorResponse (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.8/node_modules/postgres/src/connection.js:815:30) immich_server | at handle (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.8/node_modules/postgres/src/connection.js:489:6) immich_server | at Socket.data (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.8/node_modules/postgres/src/connection.js:324:9) immich_server | at Socket.emit (node:events:508:28) immich_server | at addChunk (node:internal/streams/readable:559:12) immich_server | at readableAddChunkPushByteMode (node:internal/streams/readable:510:3) immich_server | at Readable.push (node:internal/streams/readable:390:5) immich_server | at TCP.onStreamRead (node:internal/stream_base_commons:189:23) { immich_server | severity_local: 'ERROR', immich_server | severity: 'ERROR', immich_server | code: '23505', immich_server | detail: 'Key ("assetId", type, "isEdited")=(0e8d8460-d89f-4b42-83a4-002ff58bb137, encoded_video, f) already exists.', immich_server | schema_name: 'public', immich_server | table_name: 'asset_file', immich_server | constraint_name: 'asset_file_assetId_type_isEdited_uq', immich_server | file: 'nbtinsert.c', immich_server | line: '663', immich_server | routine: '_bt_check_unique' immich_server | } immich_server | microservices worker error: PostgresError: duplicate key value violates unique constraint "asset_file_assetId_type_isEdited_uq", stack: PostgresError: duplicate key value violates unique constraint "asset_file_assetId_type_isEdited_uq" immich_server | at ErrorResponse (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.8/node_modules/postgres/src/connection.js:815:30) immich_server | at handle (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.8/node_modules/postgres/src/connection.js:489:6) immich_server | at Socket.data (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.8/node_modules/postgres/src/connection.js:324:9) immich_server | at Socket.emit (node:events:508:28)