2025-09-10 13:17:40.587425+00:00Initializing Immich v1.136.0
2025-09-10 13:17:40.626867+00:00Detected CPU Cores: 2
2025-09-10 13:17:42.282161+00:00Starting api worker
2025-09-10 13:17:42.286071+00:00Starting microservices worker
2025-09-10 13:17:43.768229+00:00[Nest] 7  - 09/10/2025, 9:17:43 AM     LOG [Microservices:EventRepository] Initialized websocket server
2025-09-10 13:17:43.850322+00:00[Nest] 7  - 09/10/2025, 9:17:43 AM     LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 11928 rows
2025-09-10 13:17:43.852009+00:00[Nest] 7  - 09/10/2025, 9:17:43 AM     LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 3945 rows
2025-09-10 13:17:43.852469+00:00[Nest] 7  - 09/10/2025, 9:17:43 AM     LOG [Microservices:DatabaseRepository] Running migrations, this may take a while
2025-09-10 13:17:43.902398+00:00[Nest] 17  - 09/10/2025, 9:17:43 AM     LOG [Api:EventRepository] Initialized websocket server
2025-09-10 13:17:45.987410+00:00[Nest] 7  - 09/10/2025, 9:17:45 AM     LOG [Microservices:LoggingRepository] Database has up to date TypeORM migrations, skipping initial Kysely migration
2025-09-10 13:17:49.111143+00:00Query failed : {
2025-09-10 13:17:49.111190+00:00durationMs: 17.93930999999975,
2025-09-10 13:17:49.111196+00:00error: PostgresError: multiple primary keys for table "geodata_places" are not allowed
2025-09-10 13:17:49.111202+00:00at ErrorResponse (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:794:26)
2025-09-10 13:17:49.111208+00:00at handle (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:480:6)
2025-09-10 13:17:49.111217+00:00at Socket.data (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:315:9)
2025-09-10 13:17:49.111222+00:00at Socket.emit (node:events:518:28)
2025-09-10 13:17:49.111228+00:00at addChunk (node:internal/streams/readable:561:12)
2025-09-10 13:17:49.111242+00:00at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
2025-09-10 13:17:49.111248+00:00at Readable.push (node:internal/streams/readable:392:5)
2025-09-10 13:17:49.111254+00:00at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
2025-09-10 13:17:49.111259+00:00severity_local: 'ERROR',
2025-09-10 13:17:49.111267+00:00severity: 'ERROR',
2025-09-10 13:17:49.111273+00:00code: '42P16',
2025-09-10 13:17:49.111278+00:00file: 'index.c',
2025-09-10 13:17:49.111284+00:00line: '222',
2025-09-10 13:17:49.111289+00:00routine: 'index_check_primary_key'
2025-09-10 13:17:49.111297+00:00},
2025-09-10 13:17:49.111324+00:00sql: 'ALTER TABLE "geodata_places" ADD CONSTRAINT "geodata_places_pkey" PRIMARY KEY ("id");',
2025-09-10 13:17:49.111334+00:00params: []
2025-09-10 13:17:49.111344+00:00}
2025-09-10 13:17:49.114529+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1744910873969-InitialMigration" succeeded
2025-09-10 13:17:49.114960+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM   ERROR [Microservices:DatabaseRepository] Kysely migrations failed: PostgresError: multiple primary keys for table "geodata_places" are not allowed
2025-09-10 13:17:49.115100+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1744991379464-AddNotificationsTable" succeeded
2025-09-10 13:17:49.115167+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1745244781846-AddUserAvatarColorColumn" succeeded
2025-09-10 13:17:49.115202+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1745902563899-AddAssetVisibilityColumn" succeeded
2025-09-10 13:17:49.115211+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1746636476623-DropExtraIndexes" succeeded
2025-09-10 13:17:49.115226+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1746768490606-AddUserPincode" succeeded
2025-09-10 13:17:49.115234+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1746844028242-AddLockedVisibilityEnum" succeeded
2025-09-10 13:17:49.115255+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1746987967923-AddPinExpiresAtColumn" succeeded
2025-09-10 13:17:49.115264+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1747329504572-AddNewSessionColumns" succeeded
2025-09-10 13:17:49.115283+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1747338664832-SessionRename" succeeded
2025-09-10 13:17:49.115292+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1747664684909-AddAlbumAuditTables" succeeded
2025-09-10 13:17:49.115298+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1749067526135-UserOnboardingDefault" succeeded
2025-09-10 13:17:49.115314+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1750107668827-PartnerCreateId" succeeded
2025-09-10 13:17:49.115320+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1750189909087-AddAlbumUserCreateFields" succeeded
2025-09-10 13:17:49.115329+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1750323941566-UnsetPrewarmDimParameter" succeeded
2025-09-10 13:17:49.115335+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded
2025-09-10 13:17:49.115349+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded
2025-09-10 13:17:49.115356+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded
2025-09-10 13:17:49.115370+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded
2025-09-10 13:17:49.115381+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded
2025-09-10 13:17:49.115388+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded
2025-09-10 13:17:49.115413+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded
2025-09-10 13:17:49.115419+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM     LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded
2025-09-10 13:17:49.115428+00:00[Nest] 7  - 09/10/2025, 9:17:49 AM    WARN [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" failed
2025-09-10 13:17:49.115878+00:00PostgresError: multiple primary keys for table "geodata_places" are not allowed
2025-09-10 13:17:49.115909+00:00at ErrorResponse (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:794:26)
2025-09-10 13:17:49.115922+00:00at handle (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:480:6)
2025-09-10 13:17:49.115935+00:00at Socket.data (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:315:9)
2025-09-10 13:17:49.115954+00:00at Socket.emit (node:events:518:28)
2025-09-10 13:17:49.115964+00:00at addChunk (node:internal/streams/readable:561:12)
2025-09-10 13:17:49.115973+00:00at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
2025-09-10 13:17:49.115983+00:00at Readable.push (node:internal/streams/readable:392:5)
2025-09-10 13:17:49.116000+00:00at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
2025-09-10 13:17:49.116013+00:00severity_local: 'ERROR',
2025-09-10 13:17:49.116025+00:00severity: 'ERROR',
2025-09-10 13:17:49.116037+00:00code: '42P16',
2025-09-10 13:17:49.116048+00:00file: 'index.c',
2025-09-10 13:17:49.116063+00:00line: '222',
2025-09-10 13:17:49.116073+00:00routine: 'index_check_primary_key'
2025-09-10 13:17:49.116082+00:00}
2025-09-10 13:17:49.116890+00:00microservices worker error: PostgresError: multiple primary keys for table "geodata_places" are not allowed, stack: PostgresError: multiple primary keys for table "geodata_places" are not allowed
2025-09-10 13:17:49.116913+00:00at ErrorResponse (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:794:26)
2025-09-10 13:17:49.116920+00:00at handle (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:480:6)
2025-09-10 13:17:49.116927+00:00at Socket.data (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:315:9)
2025-09-10 13:17:49.116939+00:00at Socket.emit (node:events:518:28)
2025-09-10 13:17:49.116945+00:00at addChunk (node:internal/streams/readable:561:12)
2025-09-10 13:17:49.116950+00:00at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
2025-09-10 13:17:49.116955+00:00at Readable.push (node:internal/streams/readable:392:5)
2025-09-10 13:17:49.116969+00:00at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
2025-09-10 13:17:49.129268+00:00[Nest] 17  - 09/10/2025, 9:17:49 AM     LOG [Api:DatabaseRepository] targetLists=1, current=1 for clip_index of 11928 rows
2025-09-10 13:17:49.129692+00:00[Nest] 17  - 09/10/2025, 9:17:49 AM     LOG [Api:DatabaseRepository] targetLists=1, current=1 for face_index of 3945 rows
2025-09-10 13:17:49.129805+00:00[Nest] 17  - 09/10/2025, 9:17:49 AM     LOG [Api:DatabaseRepository] Running migrations, this may take a while
2025-09-10 13:17:49.130090+00:00microservices worker exited with code 1
2025-09-10 13:17:49.130129+00:00Killing api process