Initializing Immich v1.138.0
Detected CPU Cores: 16
Starting api worker
Starting microservices worker
[Nest] 7  - 08/16/2025, 1:06:27 AM     LOG [Microservices:EventRepository] Initialized websocket server
[Nest] 7  - 08/16/2025, 1:06:28 AM     LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 42289 rows
[Nest] 7  - 08/16/2025, 1:06:28 AM     LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 49757 rows
[Nest] 18  - 08/16/2025, 1:06:28 AM     LOG [Api:EventRepository] Initialized websocket server
[Nest] 7  - 08/16/2025, 1:06:29 AM     LOG [Microservices:Migrations] Converting database file paths from relative to absolute (source=upload/*, target=/usr/src/app/upload/*)
Query failed : {
  durationMs: 31.60507400000097,
  error: PostgresError: index "asset_fileCreatedAt_idx" contains unexpected zero page at block 342
      at ErrorResponse (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:794:26)
      at handle (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:480:6)
      at Socket.data (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:315:9)
      at Socket.emit (node:events:518:28)
      at addChunk (node:internal/streams/readable:561:12)
      at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
      at Readable.push (node:internal/streams/readable:392:5)
      at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
    severity_local: 'ERROR',
    severity: 'ERROR',
    code: 'XX002',
    hint: 'Please REINDEX it.',
    file: 'nbtpage.c',
    line: '805',
    routine: '_bt_checkpage'
  },
  sql: `UPDATE "asset" SET "originalPath" = REGEXP_REPLACE("originalPath", '^upload', '/usr/src/app/upload') WHERE "originalPath" IS NOT NULL`,
  params: []
}
[Nest] 7  - 08/16/2025, 1:06:30 AM     LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded
[Nest] 7  - 08/16/2025, 1:06:30 AM   ERROR [Microservices:DatabaseRepository] Migrations failed: PostgresError: index "asset_fileCreatedAt_idx" contains unexpected zero page at block 342
[Nest] 7  - 08/16/2025, 1:06:30 AM     LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded
[Nest] 7  - 08/16/2025, 1:06:30 AM     LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded
[Nest] 7  - 08/16/2025, 1:06:30 AM     LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded
[Nest] 7  - 08/16/2025, 1:06:30 AM     LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded
[Nest] 7  - 08/16/2025, 1:06:30 AM     LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded
[Nest] 7  - 08/16/2025, 1:06:30 AM     LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded
[Nest] 7  - 08/16/2025, 1:06:30 AM     LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded
[Nest] 7  - 08/16/2025, 1:06:30 AM     LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded
[Nest] 7  - 08/16/2025, 1:06:30 AM     LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded
[Nest] 7  - 08/16/2025, 1:06:30 AM     LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded
[Nest] 7  - 08/16/2025, 1:06:30 AM     LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded
[Nest] 7  - 08/16/2025, 1:06:30 AM     LOG [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" succeeded
[Nest] 7  - 08/16/2025, 1:06:30 AM    WARN [Microservices:DatabaseRepository] Migration "1752759108283-ConvertToAbsolutePaths" failed
PostgresError: index "asset_fileCreatedAt_idx" contains unexpected zero page at block 342
    at ErrorResponse (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:794:26)
    at handle (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:480:6)
    at Socket.data (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:315:9)
    at Socket.emit (node:events:518:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
    at Readable.push (node:internal/streams/readable:392:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
  severity_local: 'ERROR',
  severity: 'ERROR',
  code: 'XX002',
  hint: 'Please REINDEX it.',
  file: 'nbtpage.c',
  line: '805',
  routine: '_bt_checkpage'
}
microservices worker error: PostgresError: index "asset_fileCreatedAt_idx" contains unexpected zero page at block 342, stack: PostgresError: index "asset_fileCreatedAt_idx" contains unexpected zero page at block 342
    at ErrorResponse (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:794:26)
    at handle (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:480:6)
    at Socket.data (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:315:9)
    at Socket.emit (node:events:518:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
    at Readable.push (node:internal/streams/readable:392:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
microservices worker exited with code 1