DB failure

[surbin004]

Hello, this evening i had an issue where immich server crashed continuously and i couldn't understand why. turns out when the server started running it would immediately crash and drop the port 2283.

further investigation yielded the Error: getaddrinfo ENOTFOUND database
at GetAddrInfoReqWrap.onlookupall [as oncomplete] (node:dns:122:26) {
errno: -3008,
code: 'ENOTFOUND',
syscall: 'getaddrinfo',
hostname: 'database'
}

i noticed that when i relaunched my stack it would not work, neither if i recreated the containers.

i then created a new stack and noticed that now
image: ghcr.io/immich-app/postgres:14-vectorchord0.4.3-pgvectors0.2.0@sha256:bcf63357191b76a916ae5eb93464d65c07511da41e3bf7a8416db519b40b1c23

the image i was using was:
image:docker.io/tensorchord/pgvecto-rs:pg14-v0.2.0@sha256:90724186f0a3517cf6914295b5ab410db9ce23190a2d9d0b9dd6463e3fa298f0

my question is is the backups that i had from before i.e. yesterday 11/18 viable to restore or "upgrade" to the new version?

i don't want to recreate all the albums and faces, etc. is there any way to salvage the db?

[laurentftech]

I have the same issue on my Synology .

After restarting Immich (I just added a network connection in the compose), I got:

Node.js v22.18.0
Initializing Immich v2.3.1
Detected CPU Cores: 2
Missing history for endpoint: Retrieve auth status
(node:7) ExperimentalWarning: WASI is an experimental feature and might change at any time
(Use node --trace-warnings ... to show where the warning was created)
node:internal/process/promises:394
triggerUncaughtException(err, true /* fromPromise */);
^

Error: getaddrinfo ENOTFOUND database
at GetAddrInfoReqWrap.onlookupall [as oncomplete] (node:dns:122:26) {
errno: -3008,
code: 'ENOTFOUND',
syscall: 'getaddrinfo',
hostname: 'database'
}

My docker-compose is for the immich-server part:

  immich-server:
    image: ghcr.io/immich-app/immich-server:release
    container_name: immich-server
    restart: unless-stopped
    env_file:
      - .env
    volumes:
      - /volume1/photo:/usr/src/app/external
      - /volume1/photo:/usr/src/app/upload/library
      - /volume1/Laurent/docker/immich/uploads:/usr/src/app/upload
    ports:
      - "2283:2283"
    depends_on:
      - redis
      - database
    networks:
      - caddy-network

  redis:
    image: redis:7-alpine
    container_name: immich-redis
    restart: unless-stopped
    mem_limit: 256m
    volumes:
      - /volume1/Laurent/docker/immich/redis:/data
    command: ["redis-server", "--maxmemory", "256mb", "--maxmemory-policy", "allkeys-lru"]

  database:
    image: tensorchord/pgvecto-rs:pg15-v0.2.0
    container_name: immich-db
    restart: unless-stopped
    mem_limit: 512m
    environment:
      POSTGRES_USER: immich
      POSTGRES_PASSWORD: immich
      POSTGRES_DB: immich
      POSTGRES_INITDB_ARGS: '-E UTF8 --lc-collate=C --lc-ctype=C'
      DB_STORAGE_TYPE: 'HDD'
    volumes:
      - /volume1/Laurent/docker/immich/postgres:/var/lib/postgresql/data

I checked the log of the database but there's nothing unusual:
2025-11-30 22:33:49.695 UTC [1] LOG: starting PostgreSQL 15.12 (Debian 15.12-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-11-30 22:33:49.707 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2025-11-30 22:33:49.707 UTC [1] LOG: listening on IPv6 address "::", port 5432
2025-11-30 22:33:52.317 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-11-30 22:33:53.770 UTC [30] LOG: database system was shut down at 2025-11-30 22:31:27 UTC
[2025-11-30T22:33:53Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17349".
[2025-11-30T22:33:53Z INFO service::utils::clean] Find directory "pg_vectors/indexes/35148".
[2025-11-30T22:33:53Z INFO service::utils::clean] Find directory "pg_vectors/indexes/35148/segments/e1edec8d-c69e-43e3-adf8-b67f0c37ca93".
[2025-11-30T22:33:55Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17349/segments/b2a32544-92d1-42f4-8767-e6e5df4a7b2c".
2025-11-30 22:33:56.076 UTC [1] LOG: database system is ready to accept connections
2025-11-30 22:38:53.867 UTC [28] LOG: checkpoint starting: time
2025-11-30 22:38:58.789 UTC [28] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=1.245 s, total=4.922 s; sync files=3, longest=1.244 s, average=0.415 s; distance=0 kB, estimate=0 kB

[skatsubo]

I just added a network connection in the compose

Actually it also removed immich_server from the "default" network where other containers are connected (postgres and Co).

Try

  immich-server:
    networks:
      - caddy-network
      - default

(Unrelated but important: also make sure that caddy-network does not contain Redis containers to avoid possible clash with the internal Immich's Redis)

[laurentftech]

Thank you very much for the quick answer. It is working.