immich-machine-learning | [09/29/25 17:07:16] INFO Starting gunicorn 23.0.0 immich-machine-learning | [09/29/25 17:07:16] INFO Listening at: http://[::]:3003 (7) immich-machine-learning | [09/29/25 17:07:16] INFO Using worker: immich_ml.config.CustomUvicornWorker immich-machine-learning | [09/29/25 17:07:16] INFO Booting worker with pid: 8 immich-machine-learning | [09/29/25 17:07:20] INFO Started server process [8] immich-machine-learning | [09/29/25 17:07:20] INFO Waiting for application startup. immich-machine-learning | [09/29/25 17:07:20] INFO Created in-memory cache with unloading after 300s immich-machine-learning | of inactivity. immich-machine-learning | [09/29/25 17:07:20] INFO Initialized request thread pool with 6 threads. immich-machine-learning | [09/29/25 17:07:20] INFO Application startup complete. immich-server | Initializing Immich v1.143.1 immich-server | skipping libmimalloc - path not found /usr/lib/x86_64-linux-gnu/libmimalloc.so.2 immich-server | Detected CPU Cores: 6 immich-server | Starting api worker immich-server | Starting microservices worker immich-server | [Nest] 7 - 09/29/2025, 5:07:21 PM LOG [Microservices:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:07:21 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 7 - 09/29/2025, 5:07:21 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | [Nest] 26 - 09/29/2025, 5:07:22 PM LOG [Api:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:07:23 PM LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*) immich-server | Query failed : { immich-server | durationMs: 315.0870419999992, immich-server | error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | }, immich-server | sql: `UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL`, immich-server | params: [] immich-server | } immich-server | [Nest] 7 - 09/29/2025, 5:07:24 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:24 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | } immich-server | [Nest] 7 - 09/29/2025, 5:07:24 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:24 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:24 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:24 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:24 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:24 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:24 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:24 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:24 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:24 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:24 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:24 PM LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:24 PM WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed immich-server | microservices worker error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey", stack: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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 v1.143.1 immich-server | skipping libmimalloc - path not found /usr/lib/x86_64-linux-gnu/libmimalloc.so.2 immich-server | Detected CPU Cores: 6 immich-server | Starting api worker immich-server | Starting microservices worker immich-server | [Nest] 7 - 09/29/2025, 5:07:29 PM LOG [Microservices:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:07:29 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 7 - 09/29/2025, 5:07:29 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | [Nest] 26 - 09/29/2025, 5:07:29 PM LOG [Api:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:07:31 PM LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*) immich-server | Query failed : { immich-server | durationMs: 299.4634649999998, immich-server | error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | }, immich-server | sql: `UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL`, immich-server | params: [] immich-server | } immich-server | [Nest] 7 - 09/29/2025, 5:07:32 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:32 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | [Nest] 7 - 09/29/2025, 5:07:32 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:32 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:32 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:32 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:32 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:32 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:32 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:32 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:32 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:32 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:32 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:32 PM LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:32 PM WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed immich-server | PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | } immich-server | microservices worker error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey", stack: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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 v1.143.1 immich-server | skipping libmimalloc - path not found /usr/lib/x86_64-linux-gnu/libmimalloc.so.2 immich-server | Detected CPU Cores: 6 immich-server | Starting api worker immich-server | Starting microservices worker immich-server | [Nest] 7 - 09/29/2025, 5:07:37 PM LOG [Microservices:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:07:37 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 7 - 09/29/2025, 5:07:37 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | [Nest] 26 - 09/29/2025, 5:07:38 PM LOG [Api:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:07:39 PM LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*) immich-server | Query failed : { immich-server | durationMs: 318.1655289999999, immich-server | error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | }, immich-server | sql: `UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL`, immich-server | params: [] immich-server | } immich-server | [Nest] 7 - 09/29/2025, 5:07:40 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:40 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | [Nest] 7 - 09/29/2025, 5:07:40 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:40 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:40 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:40 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:40 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:40 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:40 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:40 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:40 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:40 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:40 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:40 PM LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:40 PM WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed immich-server | PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | } immich-server | microservices worker error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey", stack: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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 v1.143.1 immich-server | skipping libmimalloc - path not found /usr/lib/x86_64-linux-gnu/libmimalloc.so.2 immich-redis | 1:M 29 Sep 2025 09:07:14.990 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can also cause failures without low memory condition, see https://github.com/jemalloc/jemalloc/issues/1328. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect. immich-server | Detected CPU Cores: 6 immich-server | Starting api worker immich-server | Starting microservices worker immich-server | [Nest] 6 - 09/29/2025, 5:07:46 PM LOG [Microservices:EventRepository] Initialized websocket server immich-server | [Nest] 6 - 09/29/2025, 5:07:46 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 6 - 09/29/2025, 5:07:46 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | [Nest] 25 - 09/29/2025, 5:07:47 PM LOG [Api:EventRepository] Initialized websocket server immich-server | [Nest] 6 - 09/29/2025, 5:07:48 PM LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*) immich-redis | 1:M 29 Sep 2025 09:07:14.990 * oO0OoO0OoO0Oo Valkey is starting oO0OoO0OoO0Oo immich-redis | 1:M 29 Sep 2025 09:07:14.990 * Valkey version=8.1.3, bits=64, commit=00000000, modified=0, pid=1, just started immich-redis | 1:M 29 Sep 2025 09:07:14.990 # Warning: no config file specified, using the default config. In order to specify a config file use valkey-server /path/to/valkey.conf immich-redis | 1:M 29 Sep 2025 09:07:14.990 * monotonic clock: POSIX clock_gettime immich-redis | 1:M 29 Sep 2025 09:07:14.991 * Running mode=standalone, port=6379. immich-redis | 1:M 29 Sep 2025 09:07:14.991 * Server initialized immich-redis | 1:M 29 Sep 2025 09:07:14.991 * Ready to accept connections tcp immich-redis | 1:M 29 Sep 2025 09:12:15.089 * 100 changes in 300 seconds. Saving... immich-redis | 1:M 29 Sep 2025 09:12:15.089 * Background saving started by pid 77 immich-redis | 77:C 29 Sep 2025 09:12:15.093 * DB saved on disk immich-redis | 77:C 29 Sep 2025 09:12:15.093 * Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB immich-redis | 1:M 29 Sep 2025 09:12:15.190 * Background saving terminated with success immich-redis | 1:M 29 Sep 2025 09:17:16.064 * 100 changes in 300 seconds. Saving... immich-redis | 1:M 29 Sep 2025 09:17:16.064 * Background saving started by pid 147 immich-redis | 147:C 29 Sep 2025 09:17:16.068 * DB saved on disk immich-server | Query failed : { immich-server | durationMs: 369.12863000000016, immich-server | error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | }, immich-server | sql: `UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL`, immich-server | params: [] immich-server | } immich-server | [Nest] 6 - 09/29/2025, 5:07:49 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:07:49 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-redis | 147:C 29 Sep 2025 09:17:16.068 * Fork CoW for RDB: current 0 MB, peak 0 MB, average 0 MB immich-redis | 1:M 29 Sep 2025 09:17:16.165 * Background saving terminated with success immich-server | [Nest] 6 - 09/29/2025, 5:07:49 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:07:49 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:07:49 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:07:49 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:07:49 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:07:49 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:07:49 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:07:49 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:07:49 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:07:49 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:07:49 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:07:49 PM LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:07:49 PM WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed immich-server | PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | } immich-server | microservices worker error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey", stack: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392:5) immich-server | at TCP.onStreamRead (node:internal/stream_base_commons:189:23) immich-server | [Nest] 25 - 09/29/2025, 5:07:49 PM LOG [Api:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 25 - 09/29/2025, 5:07:49 PM LOG [Api:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | microservices worker exited with code 1 immich-server | Killing api process immich-server | Initializing Immich v1.143.1 immich-server | skipping libmimalloc - path not found /usr/lib/x86_64-linux-gnu/libmimalloc.so.2 immich-server | Detected CPU Cores: 6 immich-server | Starting api worker immich-server | Starting microservices worker immich-server | [Nest] 7 - 09/29/2025, 5:07:55 PM LOG [Microservices:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:07:55 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 7 - 09/29/2025, 5:07:55 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | [Nest] 26 - 09/29/2025, 5:07:55 PM LOG [Api:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:07:57 PM LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*) immich-server | Query failed : { immich-server | durationMs: 306.521033, immich-server | error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | }, immich-server | sql: `UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL`, immich-server | params: [] immich-server | } immich-server | [Nest] 7 - 09/29/2025, 5:07:58 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:58 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | [Nest] 7 - 09/29/2025, 5:07:58 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:58 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:58 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded immich-postgres | Using HDD storage immich-server | [Nest] 7 - 09/29/2025, 5:07:58 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:58 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:58 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:58 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:58 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:58 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:58 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:58 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:58 PM LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:07:58 PM WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed immich-server | PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | } immich-server | microservices worker error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey", stack: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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 v1.143.1 immich-server | skipping libmimalloc - path not found /usr/lib/x86_64-linux-gnu/libmimalloc.so.2 immich-server | Detected CPU Cores: 6 immich-server | Starting api worker immich-server | Starting microservices worker immich-server | [Nest] 7 - 09/29/2025, 5:08:04 PM LOG [Microservices:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:08:05 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 7 - 09/29/2025, 5:08:05 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | [Nest] 26 - 09/29/2025, 5:08:05 PM LOG [Api:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:08:06 PM LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*) immich-server | Query failed : { immich-server | durationMs: 299.7286119999999, immich-server | error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | }, immich-server | sql: `UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL`, immich-server | params: [] immich-server | } immich-server | [Nest] 7 - 09/29/2025, 5:08:07 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:07 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | [Nest] 7 - 09/29/2025, 5:08:07 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:07 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:07 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:07 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:07 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:07 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:07 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:07 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:07 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:07 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:07 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:07 PM LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:07 PM WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed immich-server | PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | } immich-server | microservices worker error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey", stack: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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 v1.143.1 immich-server | skipping libmimalloc - path not found /usr/lib/x86_64-linux-gnu/libmimalloc.so.2 immich-server | Detected CPU Cores: 6 immich-server | Starting api worker immich-server | Starting microservices worker immich-server | [Nest] 8 - 09/29/2025, 5:08:16 PM LOG [Microservices:EventRepository] Initialized websocket server immich-server | [Nest] 8 - 09/29/2025, 5:08:16 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 8 - 09/29/2025, 5:08:16 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | [Nest] 27 - 09/29/2025, 5:08:16 PM LOG [Api:EventRepository] Initialized websocket server immich-server | [Nest] 8 - 09/29/2025, 5:08:18 PM LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*) immich-server | Query failed : { immich-server | durationMs: 310.4514310000004, immich-server | error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | }, immich-server | sql: `UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL`, immich-server | params: [] immich-server | } immich-server | [Nest] 8 - 09/29/2025, 5:08:18 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded immich-server | [Nest] 8 - 09/29/2025, 5:08:18 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | [Nest] 8 - 09/29/2025, 5:08:18 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded immich-server | [Nest] 8 - 09/29/2025, 5:08:18 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded immich-server | [Nest] 8 - 09/29/2025, 5:08:18 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded immich-server | [Nest] 8 - 09/29/2025, 5:08:18 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded immich-server | [Nest] 8 - 09/29/2025, 5:08:18 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded immich-server | [Nest] 8 - 09/29/2025, 5:08:18 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded immich-server | [Nest] 8 - 09/29/2025, 5:08:18 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded immich-server | [Nest] 8 - 09/29/2025, 5:08:18 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded immich-server | [Nest] 8 - 09/29/2025, 5:08:18 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded immich-server | [Nest] 8 - 09/29/2025, 5:08:18 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded immich-server | [Nest] 8 - 09/29/2025, 5:08:18 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded immich-server | [Nest] 8 - 09/29/2025, 5:08:18 PM LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded immich-server | [Nest] 8 - 09/29/2025, 5:08:18 PM WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed immich-server | PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | } immich-server | microservices worker error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey", stack: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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 v1.143.1 immich-server | skipping libmimalloc - path not found /usr/lib/x86_64-linux-gnu/libmimalloc.so.2 immich-server | Detected CPU Cores: 6 immich-server | Starting api worker immich-server | Starting microservices worker immich-server | [Nest] 7 - 09/29/2025, 5:08:30 PM LOG [Microservices:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:08:30 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 7 - 09/29/2025, 5:08:30 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | [Nest] 26 - 09/29/2025, 5:08:30 PM LOG [Api:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:08:31 PM LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*) immich-server | Query failed : { immich-server | durationMs: 329.0024280000007, immich-server | error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | }, immich-postgres | immich-postgres | PostgreSQL Database directory appears to contain a database; Skipping initialization immich-postgres | immich-postgres | 2025-09-29 09:07:15.190 GMT [1] LOG: skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf" immich-postgres | 2025-09-29 09:07:15.190 GMT [1] LOG: skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf" immich-postgres | 2025-09-29 09:07:15.320 UTC [1] LOG: starting PostgreSQL 14.19 (Debian 14.19-1.pgdg12+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit immich-postgres | 2025-09-29 09:07:15.321 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 immich-postgres | 2025-09-29 09:07:15.321 UTC [1] LOG: listening on IPv6 address "::", port 5432 immich-postgres | 2025-09-29 09:07:15.342 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" immich-postgres | 2025-09-29 09:07:15.389 UTC [31] LOG: database system was shut down at 2025-09-29 09:07:10 UTC immich-postgres | 2025-09-29 09:07:15.431 UTC [1] LOG: database system is ready to accept connections immich-postgres | 2025-09-29 09:07:24.729 UTC [58] ERROR: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-postgres | 2025-09-29 09:07:24.729 UTC [58] DETAIL: Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset". immich-postgres | 2025-09-29 09:07:24.729 UTC [58] STATEMENT: UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL immich-postgres | 2025-09-29 09:07:24.774 UTC [62] LOG: could not receive data from client: Connection reset by peer immich-postgres | 2025-09-29 09:07:32.281 UTC [64] ERROR: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-postgres | 2025-09-29 09:07:32.281 UTC [64] DETAIL: Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset". immich-postgres | 2025-09-29 09:07:32.281 UTC [64] STATEMENT: UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL immich-postgres | 2025-09-29 09:07:32.333 UTC [69] LOG: could not receive data from client: Connection reset by peer immich-postgres | 2025-09-29 09:07:40.827 UTC [73] ERROR: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-postgres | 2025-09-29 09:07:40.827 UTC [73] DETAIL: Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset". immich-postgres | 2025-09-29 09:07:40.827 UTC [73] STATEMENT: UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL immich-postgres | 2025-09-29 09:07:40.873 UTC [77] LOG: could not receive data from client: Connection reset by peer immich-postgres | 2025-09-29 09:07:49.391 UTC [79] ERROR: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-postgres | 2025-09-29 09:07:49.391 UTC [79] DETAIL: Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset". immich-postgres | 2025-09-29 09:07:49.391 UTC [79] STATEMENT: UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL immich-postgres | 2025-09-29 09:07:58.407 UTC [88] ERROR: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-postgres | 2025-09-29 09:07:58.407 UTC [88] DETAIL: Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset". immich-postgres | 2025-09-29 09:07:58.407 UTC [88] STATEMENT: UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL immich-postgres | 2025-09-29 09:07:58.449 UTC [93] LOG: could not receive data from client: Connection reset by peer immich-postgres | 2025-09-29 09:08:07.593 UTC [96] ERROR: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-postgres | 2025-09-29 09:08:07.593 UTC [96] DETAIL: Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset". immich-postgres | 2025-09-29 09:08:07.593 UTC [96] STATEMENT: UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL immich-postgres | 2025-09-29 09:08:18.978 UTC [104] ERROR: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-postgres | 2025-09-29 09:08:18.978 UTC [104] DETAIL: Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset". immich-postgres | 2025-09-29 09:08:18.978 UTC [104] STATEMENT: UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL immich-postgres | 2025-09-29 09:08:19.028 UTC [108] LOG: could not receive data from client: Connection reset by peer immich-postgres | 2025-09-29 09:08:32.647 UTC [110] ERROR: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-postgres | 2025-09-29 09:08:32.647 UTC [110] DETAIL: Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset". immich-postgres | 2025-09-29 09:08:32.647 UTC [110] STATEMENT: UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL immich-postgres | 2025-09-29 09:08:32.701 UTC [115] LOG: could not receive data from client: Connection reset by peer immich-postgres | 2025-09-29 09:08:32.701 UTC [115] LOG: unexpected EOF on client connection with an open transaction immich-postgres | 2025-09-29 09:08:53.147 UTC [119] ERROR: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-postgres | 2025-09-29 09:08:53.147 UTC [119] DETAIL: Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset". immich-postgres | 2025-09-29 09:08:53.147 UTC [119] STATEMENT: UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL immich-postgres | 2025-09-29 09:09:26.029 UTC [127] ERROR: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-postgres | 2025-09-29 09:09:26.029 UTC [127] DETAIL: Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset". immich-postgres | 2025-09-29 09:09:26.029 UTC [127] STATEMENT: UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL immich-postgres | 2025-09-29 09:09:26.076 UTC [132] LOG: could not receive data from client: Connection reset by peer immich-postgres | 2025-09-29 09:10:24.531 UTC [137] ERROR: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-postgres | 2025-09-29 09:10:24.531 UTC [137] DETAIL: Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset". immich-postgres | 2025-09-29 09:10:24.531 UTC [137] STATEMENT: UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL immich-postgres | 2025-09-29 09:11:31.997 UTC [147] ERROR: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-postgres | 2025-09-29 09:11:31.997 UTC [147] DETAIL: Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset". immich-postgres | 2025-09-29 09:11:31.997 UTC [147] STATEMENT: UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL immich-postgres | 2025-09-29 09:11:32.046 UTC [152] LOG: could not receive data from client: Connection reset by peer immich-postgres | 2025-09-29 09:12:39.323 UTC [171] ERROR: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-postgres | 2025-09-29 09:12:39.323 UTC [171] DETAIL: Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset". immich-postgres | 2025-09-29 09:12:39.323 UTC [171] STATEMENT: UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL immich-postgres | 2025-09-29 09:13:47.135 UTC [182] ERROR: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-postgres | 2025-09-29 09:13:47.135 UTC [182] DETAIL: Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset". immich-postgres | 2025-09-29 09:13:47.135 UTC [182] STATEMENT: UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL immich-postgres | 2025-09-29 09:13:47.182 UTC [186] LOG: could not receive data from client: Connection reset by peer immich-postgres | 2025-09-29 09:14:55.070 UTC [191] ERROR: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-postgres | 2025-09-29 09:14:55.070 UTC [191] DETAIL: Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset". immich-postgres | 2025-09-29 09:14:55.070 UTC [191] STATEMENT: UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL immich-postgres | 2025-09-29 09:14:55.118 UTC [196] LOG: could not receive data from client: Connection reset by peer immich-postgres | 2025-09-29 09:14:55.118 UTC [196] LOG: unexpected EOF on client connection with an open transaction immich-postgres | 2025-09-29 09:16:02.269 UTC [202] ERROR: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-postgres | 2025-09-29 09:16:02.269 UTC [202] DETAIL: Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset". immich-postgres | 2025-09-29 09:16:02.269 UTC [202] STATEMENT: UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL immich-postgres | 2025-09-29 09:16:02.328 UTC [207] LOG: could not receive data from client: Connection reset by peer immich-postgres | 2025-09-29 09:17:09.901 UTC [212] ERROR: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-postgres | 2025-09-29 09:17:09.901 UTC [212] DETAIL: Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset". immich-postgres | 2025-09-29 09:17:09.901 UTC [212] STATEMENT: UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL immich-postgres | 2025-09-29 09:17:09.938 UTC [217] LOG: could not receive data from client: Connection reset by peer immich-postgres | 2025-09-29 09:18:17.191 UTC [236] ERROR: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-postgres | 2025-09-29 09:18:17.191 UTC [236] DETAIL: Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset". immich-postgres | 2025-09-29 09:18:17.191 UTC [236] STATEMENT: UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL immich-postgres | 2025-09-29 09:19:24.394 UTC [248] ERROR: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-postgres | 2025-09-29 09:19:24.394 UTC [248] DETAIL: Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset". immich-postgres | 2025-09-29 09:19:24.394 UTC [248] STATEMENT: UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL immich-postgres | 2025-09-29 09:19:24.437 UTC [252] LOG: could not receive data from client: Connection reset by peer immich-server | sql: `UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL`, immich-server | params: [] immich-server | } immich-server | [Nest] 7 - 09/29/2025, 5:08:32 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:32 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | [Nest] 7 - 09/29/2025, 5:08:32 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:32 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:32 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:32 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:32 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:32 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:32 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:32 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:32 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:32 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:32 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:32 PM LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:32 PM WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed immich-server | PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | } immich-server | microservices worker error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey", stack: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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 v1.143.1 immich-server | skipping libmimalloc - path not found /usr/lib/x86_64-linux-gnu/libmimalloc.so.2 immich-server | Detected CPU Cores: 6 immich-server | Starting api worker immich-server | Starting microservices worker immich-server | [Nest] 7 - 09/29/2025, 5:08:50 PM LOG [Microservices:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:08:50 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 7 - 09/29/2025, 5:08:50 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | [Nest] 26 - 09/29/2025, 5:08:50 PM LOG [Api:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:08:52 PM LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*) immich-server | Query failed : { immich-server | durationMs: 403.2978329999996, immich-server | error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | }, immich-server | sql: `UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL`, immich-server | params: [] immich-server | } immich-server | [Nest] 7 - 09/29/2025, 5:08:53 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:53 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | [Nest] 7 - 09/29/2025, 5:08:53 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:53 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:53 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:53 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:53 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:53 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:53 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:53 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:53 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:53 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:53 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:53 PM LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:08:53 PM WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed immich-server | PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(48f01616-5dc8-41b8-8144-24f773baf5f9) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | } immich-server | microservices worker error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey", stack: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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 v1.143.1 immich-server | skipping libmimalloc - path not found /usr/lib/x86_64-linux-gnu/libmimalloc.so.2 immich-server | Detected CPU Cores: 6 immich-server | Starting api worker immich-server | Starting microservices worker immich-server | [Nest] 7 - 09/29/2025, 5:09:23 PM LOG [Microservices:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:09:23 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 7 - 09/29/2025, 5:09:23 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | [Nest] 26 - 09/29/2025, 5:09:24 PM LOG [Api:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:09:25 PM LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*) immich-server | Query failed : { immich-server | durationMs: 285.860412, immich-server | error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | }, immich-server | sql: `UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL`, immich-server | params: [] immich-server | } immich-server | [Nest] 7 - 09/29/2025, 5:09:26 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:09:26 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | [Nest] 7 - 09/29/2025, 5:09:26 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:09:26 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:09:26 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:09:26 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:09:26 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:09:26 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:09:26 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded immich-server | PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | } immich-server | microservices worker error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey", stack: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392:5) immich-server | at TCP.onStreamRead (node:internal/stream_base_commons:189:23) immich-server | [Nest] 7 - 09/29/2025, 5:09:26 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:09:26 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:09:26 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:09:26 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:09:26 PM LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:09:26 PM WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed immich-server | microservices worker exited with code 1 immich-server | Killing api process immich-server | Initializing Immich v1.143.1 immich-server | skipping libmimalloc - path not found /usr/lib/x86_64-linux-gnu/libmimalloc.so.2 immich-server | Detected CPU Cores: 6 immich-server | Starting api worker immich-server | Starting microservices worker immich-server | [Nest] 7 - 09/29/2025, 5:10:22 PM LOG [Microservices:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:10:22 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 7 - 09/29/2025, 5:10:22 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | [Nest] 26 - 09/29/2025, 5:10:22 PM LOG [Api:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:10:23 PM LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*) immich-server | Query failed : { immich-server | durationMs: 281.02091800000017, immich-server | error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | }, immich-server | sql: `UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL`, immich-server | params: [] immich-server | } immich-server | [Nest] 7 - 09/29/2025, 5:10:24 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:10:24 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | [Nest] 7 - 09/29/2025, 5:10:24 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:10:24 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:10:24 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:10:24 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:10:24 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:10:24 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:10:24 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:10:24 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:10:24 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:10:24 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:10:24 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:10:24 PM LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:10:24 PM WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed immich-server | PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | } immich-server | microservices worker error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey", stack: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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 v1.143.1 immich-server | skipping libmimalloc - path not found /usr/lib/x86_64-linux-gnu/libmimalloc.so.2 immich-server | Detected CPU Cores: 6 immich-server | Starting api worker immich-server | Starting microservices worker immich-server | [Nest] 7 - 09/29/2025, 5:11:29 PM LOG [Microservices:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:11:29 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 7 - 09/29/2025, 5:11:29 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | [Nest] 26 - 09/29/2025, 5:11:29 PM LOG [Api:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:11:31 PM LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*) immich-server | Query failed : { immich-server | durationMs: 315.1191410000001, immich-server | error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | }, immich-server | sql: `UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL`, immich-server | params: [] immich-server | } immich-server | [Nest] 7 - 09/29/2025, 5:11:32 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:11:32 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | [Nest] 7 - 09/29/2025, 5:11:32 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:11:32 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:11:32 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:11:32 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:11:32 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:11:32 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:11:32 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:11:32 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:11:32 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:11:32 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:11:32 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:11:32 PM LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:11:32 PM WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed immich-server | PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | } immich-server | microservices worker error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey", stack: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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 v1.143.1 immich-server | skipping libmimalloc - path not found /usr/lib/x86_64-linux-gnu/libmimalloc.so.2 immich-server | Detected CPU Cores: 6 immich-server | Starting api worker immich-server | Starting microservices worker immich-server | [Nest] 7 - 09/29/2025, 5:12:36 PM LOG [Microservices:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:12:36 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 7 - 09/29/2025, 5:12:36 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | [Nest] 26 - 09/29/2025, 5:12:37 PM LOG [Api:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:12:38 PM LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*) immich-server | Query failed : { immich-server | durationMs: 280.3887000000004, immich-server | error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | }, immich-server | sql: `UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL`, immich-server | params: [] immich-server | } immich-server | [Nest] 7 - 09/29/2025, 5:12:39 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:12:39 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | [Nest] 7 - 09/29/2025, 5:12:39 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:12:39 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:12:39 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:12:39 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:12:39 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:12:39 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:12:39 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:12:39 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:12:39 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:12:39 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:12:39 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:12:39 PM LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:12:39 PM WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed immich-server | PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | } immich-server | microservices worker error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey", stack: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392:5) immich-server | at TCP.onStreamRead (node:internal/stream_base_commons:189:23) immich-server | [Nest] 26 - 09/29/2025, 5:12:39 PM LOG [Api:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 26 - 09/29/2025, 5:12:39 PM LOG [Api:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | microservices worker exited with code 1 immich-server | Killing api process immich-server | Initializing Immich v1.143.1 immich-server | skipping libmimalloc - path not found /usr/lib/x86_64-linux-gnu/libmimalloc.so.2 immich-server | Detected CPU Cores: 6 immich-server | Starting api worker immich-server | Starting microservices worker immich-server | [Nest] 7 - 09/29/2025, 5:13:44 PM LOG [Microservices:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:13:44 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 7 - 09/29/2025, 5:13:44 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | [Nest] 26 - 09/29/2025, 5:13:44 PM LOG [Api:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:13:46 PM LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*) immich-server | Query failed : { immich-server | durationMs: 440.9749819999997, immich-server | error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | }, immich-server | sql: `UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL`, immich-server | params: [] immich-server | } immich-server | [Nest] 7 - 09/29/2025, 5:13:47 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:13:47 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | [Nest] 7 - 09/29/2025, 5:13:47 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:13:47 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:13:47 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:13:47 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:13:47 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:13:47 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:13:47 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:13:47 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:13:47 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:13:47 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:13:47 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:13:47 PM LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:13:47 PM WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed immich-server | PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | } immich-server | microservices worker error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey", stack: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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 v1.143.1 immich-server | skipping libmimalloc - path not found /usr/lib/x86_64-linux-gnu/libmimalloc.so.2 immich-server | Detected CPU Cores: 6 immich-server | Starting api worker immich-server | Starting microservices worker immich-server | [Nest] 7 - 09/29/2025, 5:14:52 PM LOG [Microservices:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:14:52 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 7 - 09/29/2025, 5:14:52 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | [Nest] 26 - 09/29/2025, 5:14:52 PM LOG [Api:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:14:54 PM LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*) immich-server | Query failed : { immich-server | durationMs: 285.23126199999933, immich-server | error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | }, immich-server | sql: `UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL`, immich-server | params: [] immich-server | } immich-server | [Nest] 7 - 09/29/2025, 5:14:55 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:14:55 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | [Nest] 7 - 09/29/2025, 5:14:55 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:14:55 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:14:55 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:14:55 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:14:55 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:14:55 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:14:55 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:14:55 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:14:55 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:14:55 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:14:55 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:14:55 PM LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:14:55 PM WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed immich-server | PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | } immich-server | microservices worker error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey", stack: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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 v1.143.1 immich-server | skipping libmimalloc - path not found /usr/lib/x86_64-linux-gnu/libmimalloc.so.2 immich-server | Detected CPU Cores: 6 immich-server | Starting api worker immich-server | Starting microservices worker immich-server | [Nest] 6 - 09/29/2025, 5:15:59 PM LOG [Microservices:EventRepository] Initialized websocket server immich-server | [Nest] 6 - 09/29/2025, 5:15:59 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 6 - 09/29/2025, 5:15:59 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | [Nest] 25 - 09/29/2025, 5:16:00 PM LOG [Api:EventRepository] Initialized websocket server immich-server | [Nest] 6 - 09/29/2025, 5:16:01 PM LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*) immich-server | Query failed : { immich-server | durationMs: 287.4157519999999, immich-server | error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | [Nest] 6 - 09/29/2025, 5:16:02 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:16:02 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:16:02 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:16:02 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:16:02 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:16:02 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:16:02 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:16:02 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:16:02 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:16:02 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:16:02 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:16:02 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:16:02 PM LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded immich-server | [Nest] 6 - 09/29/2025, 5:16:02 PM WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | }, immich-server | sql: `UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL`, immich-server | params: [] immich-server | } immich-server | [Nest] 6 - 09/29/2025, 5:16:02 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | } immich-server | microservices worker error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey", stack: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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 v1.143.1 immich-server | skipping libmimalloc - path not found /usr/lib/x86_64-linux-gnu/libmimalloc.so.2 immich-server | Detected CPU Cores: 6 immich-server | Starting api worker immich-server | Starting microservices worker immich-server | [Nest] 7 - 09/29/2025, 5:17:07 PM LOG [Microservices:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:17:07 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 7 - 09/29/2025, 5:17:07 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | [Nest] 26 - 09/29/2025, 5:17:07 PM LOG [Api:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:17:09 PM LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*) immich-server | Query failed : { immich-server | durationMs: 289.70188899999994, immich-server | error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | }, immich-server | sql: `UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL`, immich-server | params: [] immich-server | } immich-server | [Nest] 7 - 09/29/2025, 5:17:09 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:17:09 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | [Nest] 7 - 09/29/2025, 5:17:09 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:17:09 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:17:09 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:17:09 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:17:09 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:17:09 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:17:09 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:17:09 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:17:09 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:17:09 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:17:09 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:17:09 PM LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:17:09 PM WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed immich-server | PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | } immich-server | microservices worker error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey", stack: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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 v1.143.1 immich-server | skipping libmimalloc - path not found /usr/lib/x86_64-linux-gnu/libmimalloc.so.2 immich-server | Detected CPU Cores: 6 immich-server | Starting api worker immich-server | Starting microservices worker immich-server | [Nest] 7 - 09/29/2025, 5:18:14 PM LOG [Microservices:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:18:14 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 7 - 09/29/2025, 5:18:14 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | [Nest] 26 - 09/29/2025, 5:18:15 PM LOG [Api:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:18:16 PM LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*) immich-server | Query failed : { immich-server | durationMs: 306.8383479999993, immich-server | error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | }, immich-server | sql: `UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL`, immich-server | params: [] immich-server | } immich-server | [Nest] 7 - 09/29/2025, 5:18:17 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:18:17 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | [Nest] 7 - 09/29/2025, 5:18:17 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:18:17 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:18:17 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:18:17 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:18:17 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:18:17 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:18:17 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:18:17 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:18:17 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:18:17 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:18:17 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:18:17 PM LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:18:17 PM WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed immich-server | PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | } immich-server | microservices worker error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey", stack: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392:5) immich-server | at TCP.onStreamRead (node:internal/stream_base_commons:189:23) immich-server | [Nest] 26 - 09/29/2025, 5:18:17 PM LOG [Api:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | microservices worker exited with code 1 immich-server | Killing api process immich-server | Initializing Immich v1.143.1 immich-server | skipping libmimalloc - path not found /usr/lib/x86_64-linux-gnu/libmimalloc.so.2 immich-server | Detected CPU Cores: 6 immich-server | Starting api worker immich-server | Starting microservices worker immich-server | [Nest] 7 - 09/29/2025, 5:19:22 PM LOG [Microservices:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:19:22 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 5212 rows immich-server | [Nest] 7 - 09/29/2025, 5:19:22 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3611 rows immich-server | [Nest] 26 - 09/29/2025, 5:19:22 PM LOG [Api:EventRepository] Initialized websocket server immich-server | [Nest] 7 - 09/29/2025, 5:19:23 PM LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*) immich-server | Query failed : { immich-server | durationMs: 317.7940400000007, immich-server | error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | }, immich-server | sql: `UPDATE "asset" SET "encodedVideoPath" = REGEXP_REPLACE("encodedVideoPath", '^upload', '/usr/src/app/upload') WHERE "encodedVideoPath" IS NOT NULL`, immich-server | params: [] immich-server | } immich-server | [Nest] 7 - 09/29/2025, 5:19:24 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:19:24 PM ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | [Nest] 7 - 09/29/2025, 5:19:24 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:19:24 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:19:24 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:19:24 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:19:24 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:19:24 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:19:24 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:19:24 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:19:24 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded immich-server | PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | [Nest] 7 - 09/29/2025, 5:19:24 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:19:24 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:19:24 PM LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded immich-server | [Nest] 7 - 09/29/2025, 5:19:24 PM WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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: '23503', immich-server | detail: 'Key (livePhotoVideoId)=(b68b3ae2-a920-4d7f-ba41-9a183c3288e4) is not present in table "asset".', immich-server | schema_name: 'public', immich-server | table_name: 'asset', immich-server | constraint_name: 'asset_livePhotoVideoId_fkey', immich-server | file: 'ri_triggers.c', immich-server | line: '2528', immich-server | routine: 'ri_ReportViolation' immich-server | } immich-server | microservices worker error: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey", stack: PostgresError: insert or update on table "asset" violates foreign key constraint "asset_livePhotoVideoId_fkey" immich-server | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich-server | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich-server | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich-server | at Socket.emit (node:events:518:28) immich-server | at addChunk (node:internal/streams/readable:561:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich-server | at Readable.push (node:internal/streams/readable:392: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