I can't get any version past 1.125.7 to work #5709

New Issue

OVERLORD · 2026-02-05T11:40:51+03:00

OVERLORD commented

2026-02-05 11:40:51 +03:00

Originally created by @carterlando on GitHub (Mar 29, 2025).

I have searched the existing issues, both open and closed, to make sure this is not a duplicate report.

Yes

The bug

I've installed Immich with docker but watching it in Portainer immich_server and immich_postgres both show as either 'starting' or 'unhealthy'

I have no idea what I'm supposed to do to fix the issue.

The OS that Immich Server is running on

Ubuntu

Version of Immich Server

v1.130.3

Version of Immich Mobile App

v1.130.0

Platform with the issue

Server
Web
Mobile

Your docker-compose.yml content

#
# WARNING: To install Immich, follow our guide: https://immich.app/docs/install/docker-compose
#
# Make sure to use the docker-compose.yml of the current release:
#
# https://github.com/immich-app/immich/releases/latest/download/docker-compose.yml
#
# The compose file on main may not be compatible with the latest release.

name: immich

services:
  immich-server:
    container_name: immich_server
    image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release}
    # extends:
    #   file: hwaccel.transcoding.yml
    #   service: cpu # set to one of [nvenc, quicksync, rkmpp, vaapi, vaapi-wsl] for accelerated transcoding
    volumes:
      # Do not edit the next line. If you want to change the media storage location on your system, edit the value of UPLOAD_LOCATION in the .env file
      - ${UPLOAD_LOCATION}:/usr/src/app/upload
      - /etc/localtime:/etc/localtime:ro
      - ${EXTERNAL_PATH_MIHA}:/usr/src/app/external_miha
      - ${EXTERNAL_PATH_CATA}:/usr/src/app/external_cata
    env_file:
      - .env
    ports:
      - '2283:2283'
    depends_on:
      - redis
      - database
    restart: always
    healthcheck:
      disable: false

  immich-machine-learning:
    container_name: immich_machine_learning
    # For hardware acceleration, add one of -[armnn, cuda, rocm, openvino, rknn] to the image tag.
    # Example tag: ${IMMICH_VERSION:-release}-cuda
    image: ghcr.io/immich-app/immich-machine-learning:${IMMICH_VERSION:-release}
    # extends: # uncomment this section for hardware acceleration - see https://immich.app/docs/features/ml-hardware-acceleration
    #   file: hwaccel.ml.yml
    #   service: cpu # set to one of [armnn, cuda, rocm, openvino, openvino-wsl, rknn] for accelerated inference - use the `-wsl` version for WSL2 where applicable
    volumes:
      - model-cache:/cache
    env_file:
      - .env
    restart: always
    healthcheck:
      disable: false

  redis:
    container_name: immich_redis
    image: docker.io/redis:6.2-alpine@sha256:148bb5411c184abd288d9aaed139c98123eeb8824c5d3fce03cf721db58066d8
    healthcheck:
      test: redis-cli ping || exit 1
    command: redis-server --appendonly no --save ""
    restart: always

  database:
    container_name: immich_postgres
    image: docker.io/tensorchord/pgvecto-rs:pg14-v0.2.0@sha256:739cdd626151ff1f796dc95a6591b55a714f341c737e27f045019ceabf8e8c52
    environment:
      POSTGRES_PASSWORD: ${DB_PASSWORD}
      POSTGRES_USER: ${DB_USERNAME}
      POSTGRES_DB: ${DB_DATABASE_NAME}
      POSTGRES_INITDB_ARGS: '--data-checksums'
    volumes:
      # Do not edit the next line. If you want to change the database storage location on your system, edit the value of DB_DATA_LOCATION in the .env file
      - ${DB_DATA_LOCATION}:/var/lib/postgresql/data
    healthcheck:
      test: >-
        pg_isready --dbname="$${POSTGRES_DB}" --username="$${POSTGRES_USER}" || exit 1; Chksum="$$(psql --dbname="$${POSTGRES_DB}" --username="$${POSTGRES_USER}" --tuples-only --no-align --command='SELECT COALESCE(SUM(checksum_failures), 0) FROM pg_stat_database')"; echo "checksum failure count is $$Chksum"; [ "$$Chksum" = '0' ] || exit 1
      interval: 5m
      start_interval: 30s
      start_period: 5m
    command: >-
      postgres -c shared_preload_libraries=vectors.so -c 'search_path="$$user", public, vectors' -c logging_collector=on -c max_wal_size=2GB -c shared_buffers=512MB -c wal_compression=on
    restart: always

volumes:
  model-cache:

Your .env content

# You can find documentation for all the supported env variables at https://immich.app/docs/install/environment-variables

# The location where your uploaded files are stored
UPLOAD_LOCATION=/media/cata/ssd_1t/mediaLibrary
# The location where your database files are stored
DB_DATA_LOCATION=./postgres

# The Immich version to use. You can pin this to a specific version like "v1.71.0"
IMMICH_VERSION=release

# Connection secret for postgres. You should change it to a random password
DB_PASSWORD=hidden

# The values below this line do not need to be changed
###################################################################################
DB_USERNAME=postgres
DB_DATABASE_NAME=immich

EXTERNAL_PATH_MIHA=/media/cata/bkp_1t/Photos/Mihaela
EXTERNAL_PATH_CATA=/media/cata/bkp_1t/Photos/Catalin

Reproduction steps

I'm just using 'docker compose pull && docker compose up' to upgrade from v1.127.0

Relevant log output

immich_server            | Detected CPU Cores: 4
immich_server            | Starting api worker
immich_server            | Starting microservices worker
immich_server            | [Nest] 6  - 03/29/2025, 4:17:15 PM     LOG [Microservices:EventRepository] Initialized websocket server
immich_server            | [Nest] 6  - 03/29/2025, 4:17:15 PM     LOG [Microservices:DatabaseRepository] Running migrations, this may take a while
immich_server            | [Nest] 16  - 03/29/2025, 4:17:15 PM     LOG [Api:EventRepository] Initialized websocket server
immich_server            | Migration "AddUpdateIdColumns1740586617223" failed, error: invalid page in block 1289 of relation base/16384/17603
immich_server            | QueryFailedError: invalid page in block 1289 of relation base/16384/17603
immich_server            |     at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
immich_server            |     at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
immich_server            |     at async AddUpdateIdColumns1740586617223.up (/usr/src/app/dist/migrations/1740586617223-AddUpdateIdColumns.js:50:9)
immich_server            |     at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:225:17)
immich_server            |     at async DataSource.runMigrations (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:265:35)
immich_server            |     at async DatabaseRepository.runMigrations (/usr/src/app/dist/repositories/database.repository.js:188:9)
immich_server            |     at async /usr/src/app/dist/services/database.service.js:93:17
immich_server            |     at async /usr/src/app/dist/repositories/database.repository.js:197:27
immich_server            |     at async /usr/src/app/node_modules/kysely/dist/cjs/kysely.js:413:20
immich_server            |     at async DefaultConnectionProvider.provideConnection (/usr/src/app/node_modules/kysely/dist/cjs/driver/default-connection-provider.js:12:20) {
immich_server            |   query: 'UPDATE "asset_files" SET "updateId" = immich_uuid_v7("updatedAt")',
immich_server            |   parameters: undefined,
immich_server            |   driverError: error: invalid page in block 1289 of relation base/16384/17603
immich_server            |       at /usr/src/app/node_modules/pg/lib/client.js:545:17
immich_server            |       at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
immich_server            |       at async PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:184:25)
immich_server            |       at async AddUpdateIdColumns1740586617223.up (/usr/src/app/dist/migrations/1740586617223-AddUpdateIdColumns.js:50:9)
immich_server            |       at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:225:17)
immich_server            |       at async DataSource.runMigrations (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:265:35)
immich_server            |       at async DatabaseRepository.runMigrations (/usr/src/app/dist/repositories/database.repository.js:188:9)
immich_server            |       at async /usr/src/app/dist/services/database.service.js:93:17
immich_server            |       at async /usr/src/app/dist/repositories/database.repository.js:197:27
immich_server            |       at async /usr/src/app/node_modules/kysely/dist/cjs/kysely.js:413:20 {
immich_server            |     length: 118,
immich_server            |     severity: 'ERROR',
immich_server            |     code: 'XX001',
immich_server            |     detail: undefined,
immich_server            |     hint: undefined,
immich_server            |     position: undefined,
immich_server            |     internalPosition: undefined,
immich_server            |     internalQuery: undefined,
immich_server            |     where: undefined,
immich_server            |     schema: undefined,
immich_server            |     table: undefined,
immich_server            |     column: undefined,
immich_server            |     dataType: undefined,
immich_server            |     constraint: undefined,
immich_server            |     file: 'bufmgr.c',
immich_server            |     line: '1037',
immich_server            |     routine: 'ReadBuffer_common'
immich_server            |   },
immich_server            |   length: 118,
immich_server            |   severity: 'ERROR',
immich_server            |   code: 'XX001',
immich_server            |   detail: undefined,
immich_server            |   hint: undefined,
immich_server            |   position: undefined,
immich_server            |   internalPosition: undefined,
immich_server            |   internalQuery: undefined,
immich_server            |   where: undefined,
immich_server            |   schema: undefined,
immich_server            |   table: undefined,
immich_server            |   column: undefined,
immich_server            |   dataType: undefined,
immich_server            |   constraint: undefined,
immich_server            |   file: 'bufmgr.c',
immich_server            |   line: '1037',
immich_server            |   routine: 'ReadBuffer_common'
immich_server            | }
immich_server            | microservices worker error: QueryFailedError: invalid page in block 1289 of relation base/16384/17603, stack: QueryFailedError: invalid page in block 1289 of relation base/16384/17603
immich_server            |     at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
immich_server            |     at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
immich_server            |     at async AddUpdateIdColumns1740586617223.up (/usr/src/app/dist/migrations/1740586617223-AddUpdateIdColumns.js:50:9)
immich_server            |     at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:225:17)
immich_server            |     at async DataSource.runMigrations (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:265:35)
immich_server            |     at async DatabaseRepository.runMigrations (/usr/src/app/dist/repositories/database.repository.js:188:9)
immich_server            |     at async /usr/src/app/dist/services/database.service.js:93:17
immich_server            |     at async /usr/src/app/dist/repositories/database.repository.js:197:27
immich_server            |     at async /usr/src/app/node_modules/kysely/dist/cjs/kysely.js:413:20
immich_server            |     at async DefaultConnectionProvider.provideConnection (/usr/src/app/node_modules/kysely/dist/cjs/driver/default-connection-provider.js:12:20)
immich_server            | microservices worker exited with code 1
immich_server            | Killing api process
immich_server exited with code 0
immich_server            | Starting api worker
immich_server            | Starting microservices worker
immich_server            | [Nest] 7  - 03/29/2025, 4:18:47 PM     LOG [Microservices:EventRepository] Initialized websocket server
immich_server            | [Nest] 7  - 03/29/2025, 4:18:47 PM     LOG [Microservices:DatabaseRepository] Running migrations, this may take a while
immich_server            | [Nest] 17  - 03/29/2025, 4:18:47 PM     LOG [Api:EventRepository] Initialized websocket server
immich_server            | Migration "AddUpdateIdColumns1740586617223" failed, error: invalid page in block 1289 of relation base/16384/17603
immich_server            | QueryFailedError: invalid page in block 1289 of relation base/16384/17603
immich_server            |     at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
immich_server            |     at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
immich_server            |     at async AddUpdateIdColumns1740586617223.up (/usr/src/app/dist/migrations/1740586617223-AddUpdateIdColumns.js:50:9)
immich_server            |     at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:225:17)
immich_server            |     at async DataSource.runMigrations (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:265:35)
immich_server            |     at async DatabaseRepository.runMigrations (/usr/src/app/dist/repositories/database.repository.js:188:9)
immich_server            |     at async /usr/src/app/dist/services/database.service.js:93:17
immich_server            |     at async /usr/src/app/dist/repositories/database.repository.js:197:27
immich_server            |     at async /usr/src/app/node_modules/kysely/dist/cjs/kysely.js:413:20
immich_server            |     at async DefaultConnectionProvider.provideConnection (/usr/src/app/node_modules/kysely/dist/cjs/driver/default-connection-provider.js:12:20) {
immich_server            |   query: 'UPDATE "asset_files" SET "updateId" = immich_uuid_v7("updatedAt")',
immich_server            |   parameters: undefined,
immich_server            |   driverError: error: invalid page in block 1289 of relation base/16384/17603
immich_server            |       at /usr/src/app/node_modules/pg/lib/client.js:545:17
immich_server            |       at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
immich_server            |       at async PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:184:25)
immich_server            |       at async AddUpdateIdColumns1740586617223.up (/usr/src/app/dist/migrations/1740586617223-AddUpdateIdColumns.js:50:9)
immich_server            |       at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:225:17)
immich_server            |       at async DataSource.runMigrations (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:265:35)
immich_server            |       at async DatabaseRepository.runMigrations (/usr/src/app/dist/repositories/database.repository.js:188:9)
immich_server            |       at async /usr/src/app/dist/services/database.service.js:93:17
immich_server            |       at async /usr/src/app/dist/repositories/database.repository.js:197:27
immich_server            |       at async /usr/src/app/node_modules/kysely/dist/cjs/kysely.js:413:20 {
immich_server            |     length: 118,
immich_server            |     severity: 'ERROR',
immich_server            |     code: 'XX001',
immich_server            |     detail: undefined,
immich_server            |     hint: undefined,
immich_server            |     position: undefined,
immich_server            |     internalPosition: undefined,
immich_server            |     internalQuery: undefined,
immich_server            |     where: undefined,
immich_server            |     schema: undefined,
immich_server            |     table: undefined,
immich_server            |     column: undefined,
immich_server            |     dataType: undefined,
immich_server            |     constraint: undefined,
immich_server            |     file: 'bufmgr.c',
immich_server            |     line: '1037',
immich_server            |     routine: 'ReadBuffer_common'
immich_server            |   },
immich_server            |   length: 118,
immich_server            |   severity: 'ERROR',
immich_server            |   code: 'XX001',
immich_server            |   detail: undefined,
immich_server            |   hint: undefined,
immich_server            |   position: undefined,
immich_server            |   internalPosition: undefined,
immich_server            |   internalQuery: undefined,
immich_server            |   where: undefined,
immich_server            |   schema: undefined,
immich_server            |   table: undefined,
immich_server            |   column: undefined,
immich_server            |   dataType: undefined,
immich_server            |   constraint: undefined,
immich_server            |   file: 'bufmgr.c',
immich_server            |   line: '1037',
immich_server            |   routine: 'ReadBuffer_common'
immich_server            | }
immich_server            | microservices worker error: QueryFailedError: invalid page in block 1289 of relation base/16384/17603, stack: QueryFailedError: invalid page in block 1289 of relation base/16384/17603
immich_server            |     at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
immich_server            |     at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
immich_server            |     at async AddUpdateIdColumns1740586617223.up (/usr/src/app/dist/migrations/1740586617223-AddUpdateIdColumns.js:50:9)
immich_server            |     at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:225:17)
immich_server            |     at async DataSource.runMigrations (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:265:35)
immich_server            |     at async DatabaseRepository.runMigrations (/usr/src/app/dist/repositories/database.repository.js:188:9)
immich_server            |     at async /usr/src/app/dist/services/database.service.js:93:17
immich_server            |     at async /usr/src/app/dist/repositories/database.repository.js:197:27
immich_server            |     at async /usr/src/app/node_modules/kysely/dist/cjs/kysely.js:413:20
immich_server            |     at async DefaultConnectionProvider.provideConnection (/usr/src/app/node_modules/kysely/dist/cjs/driver/default-connection-provider.js:12:20)
immich_server            | microservices worker exited with code 1
immich_server            | Killing api process

Additional information

No response

Originally created by @carterlando on GitHub (Mar 29, 2025). ### I have searched the existing issues, both open and closed, to make sure this is not a duplicate report. - [x] Yes ### The bug I've installed Immich with docker but watching it in Portainer immich_server and immich_postgres both show as either 'starting' or 'unhealthy' I have no idea what I'm supposed to do to fix the issue. ### The OS that Immich Server is running on Ubuntu ### Version of Immich Server v1.130.3 ### Version of Immich Mobile App v1.130.0 ### Platform with the issue - [x] Server - [ ] Web - [ ] Mobile ### Your docker-compose.yml content ```YAML # # WARNING: To install Immich, follow our guide: https://immich.app/docs/install/docker-compose # # Make sure to use the docker-compose.yml of the current release: # # https://github.com/immich-app/immich/releases/latest/download/docker-compose.yml # # The compose file on main may not be compatible with the latest release. name: immich services: immich-server: container_name: immich_server image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release} # extends: # file: hwaccel.transcoding.yml # service: cpu # set to one of [nvenc, quicksync, rkmpp, vaapi, vaapi-wsl] for accelerated transcoding volumes: # Do not edit the next line. If you want to change the media storage location on your system, edit the value of UPLOAD_LOCATION in the .env file - ${UPLOAD_LOCATION}:/usr/src/app/upload - /etc/localtime:/etc/localtime:ro - ${EXTERNAL_PATH_MIHA}:/usr/src/app/external_miha - ${EXTERNAL_PATH_CATA}:/usr/src/app/external_cata env_file: - .env ports: - '2283:2283' depends_on: - redis - database restart: always healthcheck: disable: false immich-machine-learning: container_name: immich_machine_learning # For hardware acceleration, add one of -[armnn, cuda, rocm, openvino, rknn] to the image tag. # Example tag: ${IMMICH_VERSION:-release}-cuda image: ghcr.io/immich-app/immich-machine-learning:${IMMICH_VERSION:-release} # extends: # uncomment this section for hardware acceleration - see https://immich.app/docs/features/ml-hardware-acceleration # file: hwaccel.ml.yml # service: cpu # set to one of [armnn, cuda, rocm, openvino, openvino-wsl, rknn] for accelerated inference - use the `-wsl` version for WSL2 where applicable volumes: - model-cache:/cache env_file: - .env restart: always healthcheck: disable: false redis: container_name: immich_redis image: docker.io/redis:6.2-alpine@sha256:148bb5411c184abd288d9aaed139c98123eeb8824c5d3fce03cf721db58066d8 healthcheck: test: redis-cli ping || exit 1 command: redis-server --appendonly no --save "" restart: always database: container_name: immich_postgres image: docker.io/tensorchord/pgvecto-rs:pg14-v0.2.0@sha256:739cdd626151ff1f796dc95a6591b55a714f341c737e27f045019ceabf8e8c52 environment: POSTGRES_PASSWORD: ${DB_PASSWORD} POSTGRES_USER: ${DB_USERNAME} POSTGRES_DB: ${DB_DATABASE_NAME} POSTGRES_INITDB_ARGS: '--data-checksums' volumes: # Do not edit the next line. If you want to change the database storage location on your system, edit the value of DB_DATA_LOCATION in the .env file - ${DB_DATA_LOCATION}:/var/lib/postgresql/data healthcheck: test: >- pg_isready --dbname="$${POSTGRES_DB}" --username="$${POSTGRES_USER}" || exit 1; Chksum="$$(psql --dbname="$${POSTGRES_DB}" --username="$${POSTGRES_USER}" --tuples-only --no-align --command='SELECT COALESCE(SUM(checksum_failures), 0) FROM pg_stat_database')"; echo "checksum failure count is $$Chksum"; [ "$$Chksum" = '0' ] || exit 1 interval: 5m start_interval: 30s start_period: 5m command: >- postgres -c shared_preload_libraries=vectors.so -c 'search_path="$$user", public, vectors' -c logging_collector=on -c max_wal_size=2GB -c shared_buffers=512MB -c wal_compression=on restart: always volumes: model-cache: ``` ### Your .env content ```Shell # You can find documentation for all the supported env variables at https://immich.app/docs/install/environment-variables # The location where your uploaded files are stored UPLOAD_LOCATION=/media/cata/ssd_1t/mediaLibrary # The location where your database files are stored DB_DATA_LOCATION=./postgres # The Immich version to use. You can pin this to a specific version like "v1.71.0" IMMICH_VERSION=release # Connection secret for postgres. You should change it to a random password DB_PASSWORD=hidden # The values below this line do not need to be changed ################################################################################### DB_USERNAME=postgres DB_DATABASE_NAME=immich EXTERNAL_PATH_MIHA=/media/cata/bkp_1t/Photos/Mihaela EXTERNAL_PATH_CATA=/media/cata/bkp_1t/Photos/Catalin ``` ### Reproduction steps I'm just using 'docker compose pull && docker compose up' to upgrade from v1.127.0 ### Relevant log output ```shell immich_server | Detected CPU Cores: 4 immich_server | Starting api worker immich_server | Starting microservices worker immich_server | [Nest] 6 - 03/29/2025, 4:17:15 PM LOG [Microservices:EventRepository] Initialized websocket server immich_server | [Nest] 6 - 03/29/2025, 4:17:15 PM LOG [Microservices:DatabaseRepository] Running migrations, this may take a while immich_server | [Nest] 16 - 03/29/2025, 4:17:15 PM LOG [Api:EventRepository] Initialized websocket server immich_server | Migration "AddUpdateIdColumns1740586617223" failed, error: invalid page in block 1289 of relation base/16384/17603 immich_server | QueryFailedError: invalid page in block 1289 of relation base/16384/17603 immich_server | at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19) immich_server | at process.processTicksAndRejections (node:internal/process/task_queues:105:5) immich_server | at async AddUpdateIdColumns1740586617223.up (/usr/src/app/dist/migrations/1740586617223-AddUpdateIdColumns.js:50:9) immich_server | at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:225:17) immich_server | at async DataSource.runMigrations (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:265:35) immich_server | at async DatabaseRepository.runMigrations (/usr/src/app/dist/repositories/database.repository.js:188:9) immich_server | at async /usr/src/app/dist/services/database.service.js:93:17 immich_server | at async /usr/src/app/dist/repositories/database.repository.js:197:27 immich_server | at async /usr/src/app/node_modules/kysely/dist/cjs/kysely.js:413:20 immich_server | at async DefaultConnectionProvider.provideConnection (/usr/src/app/node_modules/kysely/dist/cjs/driver/default-connection-provider.js:12:20) { immich_server | query: 'UPDATE "asset_files" SET "updateId" = immich_uuid_v7("updatedAt")', immich_server | parameters: undefined, immich_server | driverError: error: invalid page in block 1289 of relation base/16384/17603 immich_server | at /usr/src/app/node_modules/pg/lib/client.js:545:17 immich_server | at process.processTicksAndRejections (node:internal/process/task_queues:105:5) immich_server | at async PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:184:25) immich_server | at async AddUpdateIdColumns1740586617223.up (/usr/src/app/dist/migrations/1740586617223-AddUpdateIdColumns.js:50:9) immich_server | at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:225:17) immich_server | at async DataSource.runMigrations (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:265:35) immich_server | at async DatabaseRepository.runMigrations (/usr/src/app/dist/repositories/database.repository.js:188:9) immich_server | at async /usr/src/app/dist/services/database.service.js:93:17 immich_server | at async /usr/src/app/dist/repositories/database.repository.js:197:27 immich_server | at async /usr/src/app/node_modules/kysely/dist/cjs/kysely.js:413:20 { immich_server | length: 118, immich_server | severity: 'ERROR', immich_server | code: 'XX001', immich_server | detail: undefined, immich_server | hint: undefined, immich_server | position: undefined, immich_server | internalPosition: undefined, immich_server | internalQuery: undefined, immich_server | where: undefined, immich_server | schema: undefined, immich_server | table: undefined, immich_server | column: undefined, immich_server | dataType: undefined, immich_server | constraint: undefined, immich_server | file: 'bufmgr.c', immich_server | line: '1037', immich_server | routine: 'ReadBuffer_common' immich_server | }, immich_server | length: 118, immich_server | severity: 'ERROR', immich_server | code: 'XX001', immich_server | detail: undefined, immich_server | hint: undefined, immich_server | position: undefined, immich_server | internalPosition: undefined, immich_server | internalQuery: undefined, immich_server | where: undefined, immich_server | schema: undefined, immich_server | table: undefined, immich_server | column: undefined, immich_server | dataType: undefined, immich_server | constraint: undefined, immich_server | file: 'bufmgr.c', immich_server | line: '1037', immich_server | routine: 'ReadBuffer_common' immich_server | } immich_server | microservices worker error: QueryFailedError: invalid page in block 1289 of relation base/16384/17603, stack: QueryFailedError: invalid page in block 1289 of relation base/16384/17603 immich_server | at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19) immich_server | at process.processTicksAndRejections (node:internal/process/task_queues:105:5) immich_server | at async AddUpdateIdColumns1740586617223.up (/usr/src/app/dist/migrations/1740586617223-AddUpdateIdColumns.js:50:9) immich_server | at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:225:17) immich_server | at async DataSource.runMigrations (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:265:35) immich_server | at async DatabaseRepository.runMigrations (/usr/src/app/dist/repositories/database.repository.js:188:9) immich_server | at async /usr/src/app/dist/services/database.service.js:93:17 immich_server | at async /usr/src/app/dist/repositories/database.repository.js:197:27 immich_server | at async /usr/src/app/node_modules/kysely/dist/cjs/kysely.js:413:20 immich_server | at async DefaultConnectionProvider.provideConnection (/usr/src/app/node_modules/kysely/dist/cjs/driver/default-connection-provider.js:12:20) immich_server | microservices worker exited with code 1 immich_server | Killing api process immich_server exited with code 0 immich_server | Starting api worker immich_server | Starting microservices worker immich_server | [Nest] 7 - 03/29/2025, 4:18:47 PM LOG [Microservices:EventRepository] Initialized websocket server immich_server | [Nest] 7 - 03/29/2025, 4:18:47 PM LOG [Microservices:DatabaseRepository] Running migrations, this may take a while immich_server | [Nest] 17 - 03/29/2025, 4:18:47 PM LOG [Api:EventRepository] Initialized websocket server immich_server | Migration "AddUpdateIdColumns1740586617223" failed, error: invalid page in block 1289 of relation base/16384/17603 immich_server | QueryFailedError: invalid page in block 1289 of relation base/16384/17603 immich_server | at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19) immich_server | at process.processTicksAndRejections (node:internal/process/task_queues:105:5) immich_server | at async AddUpdateIdColumns1740586617223.up (/usr/src/app/dist/migrations/1740586617223-AddUpdateIdColumns.js:50:9) immich_server | at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:225:17) immich_server | at async DataSource.runMigrations (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:265:35) immich_server | at async DatabaseRepository.runMigrations (/usr/src/app/dist/repositories/database.repository.js:188:9) immich_server | at async /usr/src/app/dist/services/database.service.js:93:17 immich_server | at async /usr/src/app/dist/repositories/database.repository.js:197:27 immich_server | at async /usr/src/app/node_modules/kysely/dist/cjs/kysely.js:413:20 immich_server | at async DefaultConnectionProvider.provideConnection (/usr/src/app/node_modules/kysely/dist/cjs/driver/default-connection-provider.js:12:20) { immich_server | query: 'UPDATE "asset_files" SET "updateId" = immich_uuid_v7("updatedAt")', immich_server | parameters: undefined, immich_server | driverError: error: invalid page in block 1289 of relation base/16384/17603 immich_server | at /usr/src/app/node_modules/pg/lib/client.js:545:17 immich_server | at process.processTicksAndRejections (node:internal/process/task_queues:105:5) immich_server | at async PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:184:25) immich_server | at async AddUpdateIdColumns1740586617223.up (/usr/src/app/dist/migrations/1740586617223-AddUpdateIdColumns.js:50:9) immich_server | at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:225:17) immich_server | at async DataSource.runMigrations (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:265:35) immich_server | at async DatabaseRepository.runMigrations (/usr/src/app/dist/repositories/database.repository.js:188:9) immich_server | at async /usr/src/app/dist/services/database.service.js:93:17 immich_server | at async /usr/src/app/dist/repositories/database.repository.js:197:27 immich_server | at async /usr/src/app/node_modules/kysely/dist/cjs/kysely.js:413:20 { immich_server | length: 118, immich_server | severity: 'ERROR', immich_server | code: 'XX001', immich_server | detail: undefined, immich_server | hint: undefined, immich_server | position: undefined, immich_server | internalPosition: undefined, immich_server | internalQuery: undefined, immich_server | where: undefined, immich_server | schema: undefined, immich_server | table: undefined, immich_server | column: undefined, immich_server | dataType: undefined, immich_server | constraint: undefined, immich_server | file: 'bufmgr.c', immich_server | line: '1037', immich_server | routine: 'ReadBuffer_common' immich_server | }, immich_server | length: 118, immich_server | severity: 'ERROR', immich_server | code: 'XX001', immich_server | detail: undefined, immich_server | hint: undefined, immich_server | position: undefined, immich_server | internalPosition: undefined, immich_server | internalQuery: undefined, immich_server | where: undefined, immich_server | schema: undefined, immich_server | table: undefined, immich_server | column: undefined, immich_server | dataType: undefined, immich_server | constraint: undefined, immich_server | file: 'bufmgr.c', immich_server | line: '1037', immich_server | routine: 'ReadBuffer_common' immich_server | } immich_server | microservices worker error: QueryFailedError: invalid page in block 1289 of relation base/16384/17603, stack: QueryFailedError: invalid page in block 1289 of relation base/16384/17603 immich_server | at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19) immich_server | at process.processTicksAndRejections (node:internal/process/task_queues:105:5) immich_server | at async AddUpdateIdColumns1740586617223.up (/usr/src/app/dist/migrations/1740586617223-AddUpdateIdColumns.js:50:9) immich_server | at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:225:17) immich_server | at async DataSource.runMigrations (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:265:35) immich_server | at async DatabaseRepository.runMigrations (/usr/src/app/dist/repositories/database.repository.js:188:9) immich_server | at async /usr/src/app/dist/services/database.service.js:93:17 immich_server | at async /usr/src/app/dist/repositories/database.repository.js:197:27 immich_server | at async /usr/src/app/node_modules/kysely/dist/cjs/kysely.js:413:20 immich_server | at async DefaultConnectionProvider.provideConnection (/usr/src/app/node_modules/kysely/dist/cjs/driver/default-connection-provider.js:12:20) immich_server | microservices worker exited with code 1 immich_server | Killing api process ``` ### Additional information _No response_

OVERLORD closed this issue

2026-02-05 11:40:52 +03:00

OVERLORD commented

2026-02-05 11:40:54 +03:00

@alextran1502 commented on GitHub (Mar 29, 2025):

Your database looks to be corrupted, you should be able to create a new instance and use the database file dump in the UPLOAD_LOCATION/backups location to restore at your previous working snapshot

https://immich.app/docs/administration/backup-and-restore/

@alextran1502 commented on GitHub (Mar 29, 2025): Your database looks to be corrupted, you should be able to create a new instance and use the database file dump in the `UPLOAD_LOCATION/backups` location to restore at your previous working snapshot https://immich.app/docs/administration/backup-and-restore/

OVERLORD referenced this issue

2026-02-05 14:30:44 +03:00

[PR #5709] [MERGED] chore(deps): update dependency sql-formatter to v15 #10939

Sign in to join this conversation.

Branches Tags

main

chore/translations

fix/partner-ownership-contention

renovate/machine-learning

renovate/pypi-pillow-vulnerability

renovate/pypi-pydantic-settings-vulnerability

renovate/java-25.x

renovate/mobile

chore/harden-mobile-openapi-gen

renovate/java-21.x

fix/min-faces

refactor/asset-update

feat/merge-people-mobile

chore/face-cluster-abstraction

refactor/search-v3/pr-2a

fcast

fix/android-local-album-date

fix/24545-sync-retry-cx

fix/android-locked-folder-delete

make-sure-memory-widget-render

chore/freezed-example

fix/clamp-local-date-time-to-valid-value

fix/datetime-max-limit

fix/viewer-long-image-aspect

feat/native-core

feat/yucca-integration

refactor/mobile-actions

fix/ws-reconnect-battery

renovate/sharp

renovate/pigeon-27.x

refactor/auto-trash-sync

feat/release-source-branch

refactor/session-repository

fix/library-map-live-bounds-updates

renovate/permission_handler-12.x

renovate/node-24.x

fix/mobile-scroll-velocity-placeholders

fix/library-map-loading-flash

agg23/appbar-experiments

renovate/pep621-lock-file-maintenance-machine-learning

refactor/undo-actions

refactor/actions

feat/restore-action

feat/delete-action

fix/29853-thumbnail-decode-size

bugfix/live-photo-stuck

feature/load-previews

chore/pub-upgrade

custom-app-logo

fix/failed-sync-blocks-resume

feat/ml-hwaccel-testing

feat/workflow-logs

feat/server-chunked-uploads

feat/upload-action

fix-29727

feat/download-tag-action

feat/share-action

feat/album-actions

fix/android-cr3-save

feat/browser-profile-action

feat/cast-slideshow-action

feat/locked-folder-action

fix/unauthorized-memory-creation

feat/context-actions

refactor/action-class

feat/memories-view

refactor/asset-action-filter

feat/archive-action

feat/stack-action

feat/mobile-hls-player

refactor/stack-actions

feat/workflow-asset-tags

fix/timeline-drag-select-stops

fix/featured-photo-thumbnail-cache

fix/album-timeline-date-ordering

chore/album-remove-assets

feat/partner-table-permissions

fix/ocr-after-edit

fix/re-enable-pruning

refactor/delete-restore-actions

apk-build-deployment

edit-photo-stacking

fix/mise-lockfile

feat/web-hls-hover

refactor/store-cleanup

fix/hash-mismatch

refactor/app-metadata

refactor/advanced-settings

refactor/current-user

fix/dedupe-integrity-missing-paths

chore/albums-select

fix/fdroid-meta

refactor/per-asset-backup-flag

fix/av1-threads

fix/pass-secrets

fix/download-progress-stuck

fix/negative-backup-remainder

feat/map-asset-number

test-bump-prerelease

fix/handle-unlinking-motion-photos

fix/date-range-formatting

fix/mobile-album-action-msg

asset-add-to-album-trigger

refactor/face-editor-decoupling

feat/zoom-aware-face-editing

refactor/adaptive-image-dimensions

fix-face-editor-video-preview

fix-stack-face-tag-selection

fix/face-boxes-edit-panel

workflow-webhook-step

feat/hero_view_transitions

fix/map-sidepanel-queries

feat/dart-openapi-generator

claude/share-quality-5d7Gn

drag-drop-ghost-target

refactor/workflow-page

refactor/mobile-upload

fix-scroll-flicker-2

update-mise-lock-file

feat/kysely-0.29

release-candidate-flow-1

fix/mobile-22522-sqlite-2067

fix/job-lock

release-candidate-flow-3

release-candidate-flow-2

show-in-timeline-toggle

fix/mise-windows

plan-local-image-display

fix/remote-thumbnail-fallback

chore/riverpod-update

album-order-per-user

fix/web-timeline-dom-node-retention

chore/svelte-enable-state-referenced-locally

feat/favorite-albums

feat/patch-release-from-branch

fix/oauth-linking

feat/timeline_scroll_buffer

panorama-face-overlay

push-txxyuusptoru

push-zpwsovysllvn

chore/queue-endpoint-migration

fix/remove-from-album

chore/thumbnail-histogram

fix/video-thumbnail-bindthis-regression

fix/scrubber-drag-edge-cases

fix/timeline_layout_row_height

refactor-cancellable-task

uhthomas/fix-mobile-use-timer

uhthomas/fix-mobile-video-controls-key

uhthomas/chore-mobile-search-declarative

owner-role-album-user

feat/livephoto-editing

favorite-albums

uhthomas/fix-mobile-isolate-auth

fix/library-watcher-excludes

chore/library-e2e-to-medium

push-ynllunsvrpxy

fix/dont-delete-offline-library-files

push-zvwwxmvkrspv

push-kywsnvvkwzts

push-xxnxokokzrou

push-voozlrlkxsnu

view-in-timeline-transition

push-uymvmlknxpmx

push-qslzsplnusoz

fix/mobile-video-stall

uhthomas/draft-mobile-image-cache-cancel

push-yquostpqnkxp

feat/vitest-4

claude/offload-icloud-hashing-bI3GZ

midzelis/wip

uhthomas/fix-server-fsync-all

feat/mobile-widget-shared-client

push-lnyuzsutzkqq

push-vqqqxxvkunru

push-wvnmqoswptww

push-nwxlpmyzkyrl

fix/map-webgl-error

fix/mobile-player-fit

feat/panorama-tiles

csp-policy

push-rsywxvptwxuv

refactor/restores-file-interceptor

postgres-socketio

claude/auto-screenshot-web-changes-Y7efI

visual-review/pr-26535

push-lvyturrtwkrq

feat/library-offline-count

fix/mobile-video-aspect-ratio

uhthomas/fix-mobile-search-results

uhthomas/feat-sort-smart-search

uhthomas/chore-mobile-maplibre

uhthomas/mobile-fix-asset-details-album-pop

feat/crawl-wrapper

push-skvzqoozqkpl

feat/edit-filters

feat/pg-queue

refactor/asset-upload

better-project-structure

uhthomas/mobile-feat-asset-viewer-details

fix/ml-rocm-build

feat/asset-file-apis

feature/bottom-buttons-order

sqlite_thumbs

fix-keep-correct-ios-shared-album-asset

push-vpxwmwwxwnvw

fix-migration-width-height

shared-deep-link-handler

feat/thumbnail-native-clients

feat/platform-clients

fix/foreground-cloud-sync

filter-by-person

refactor/sidebar

fix/merged-edited-assets

feat/create-job-with-dto

feat/ios-fastlane-match

match-signing

fix-update-time-update-timeline

feat/modal-routes

feature/mobile-view-asset-owner

feat/system-settings

feature/show-activity-count

feat/location-favorites

feature/rearrange-buttons-2

fix/download-storage-template

chore/originals-in-asset-files

ben/tree-a11y

new-search-filter-ui

refactor/expectSelectedReadonly

refactor/mobile-grdb

feat/mobile-native-local-sync

refactor/timeline_ops

fix/scrubber_end

refactor/virtualsegment

refactor/rename_daymonth_groups

fix-remote-sync-clean-up

debug/cf-chunked-uploads

feat/search-filter-album/web

feat/session-permissions

feat/mobile-dynamic-thumbnails

refactor/extract_photostream

refactor/rename_load_api

refactor/timeline2

refactor/timeline3

feat-no-thumbhash-cache

feat/mobile-hdr-images

feat/beta-background-upload

fix/beta-timeline-memories-setting

fix/failed-uploads-not-removed

feat/groups

drift-map-page

feat/add-to-album-action

track-livephotos

feat/maintenance-worker

refactor/server-side-dedupe

feat/integrity-checks

dev/recognition-eval

lighter_buckets_test

perf/postgres-queue

tmp/demo-snapshot-preview

fix/server-migration-file-extension

rknn-toolkit-lite2

feature/Add-rocm-support-for-machine-learning

chore/async-hash-file

feat/shared-link-view-count

feat/graphql

no-video-player

fix/server-qsv-output-format

chore/server-geodata-tweaks

mobile/native-video-player-no-hero

feat/local-tileserver

feat/ml-armnn-conversion

chore/handle-output_dims

feat/capacitor-mobile-app-poc

feat/server-nvenc-hw-decoding

web/automation-ui

object-storage

ml/tflite

feat/ml-export-cli

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: immich-app/immich#5709