immich_server unable to connect to the database

[Pritski]

Hi - I am trying to install immich for the first time. I have tried via CLI but could not get the web UI to respond on
http://machine-ip-address:2283
as per the FAQ at https://immich.app/docs/install/post-install

I saw others had better success using Portainer CE so I have installed it in a container and followed the guide at
https://immich.app/docs/install/portainer

I have attached the docker compose file i used - which is the default version from github, just with the .env files renamed to stack.env

I have the following stack.env:
UPLOAD_LOCATION=./library
DB_DATA_LOCATION=./postgres
TZ=Australia/Brisbane
IMMICH_VERSION=release
DB_PASSWORD=postgres
DB_USERNAME=postgres
DB_DATABASE_NAME=immich

I have tried rebuilding the stack using random letters for the DB_PASSWORD, as well as setting my preferred UPLOAD_LOCATION which didnt work so I have gone back to the default setting to eliminate any possible source of errors, but it still doesnt work.

The immich_server logs are attached - showing the failure to connect. I cant connect to the WebUI on port 2283 or the container network or the container IP addresses. The database container logs look ok to me as far as I can tell?

Any help would be most appreciated

Device is QNAP running QTS 5.2.3.3006 8GB RAM
Portainer CE 2.21.5
immich 1.126.1

docker compose.txt
_immich_postgres_logs.txt
_immich_server_logs.txt

[bo0tzz]

Check the ./postgres/log folder for the actual postgres logs. Note that the compose file you posted is mangled so I can't read anything meaningful from that.

[Pritski]

compose file:

---

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
env_file:
- stack.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, openvino] 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, openvino, openvino-wsl] for accelerated inference - use the -wsl version for WSL2 where applicable
volumes:
- model-cache:/cache
env_file:
- stack.env
restart: always
healthcheck:
disable: false

redis:
container_name: immich_redis
image: docker.io/redis:6.2-alpine@sha256:905c4ee67b8e0aa955331960d2aa745781e6bd89afc44a8584bfd13bc890f0ae
healthcheck:
test: redis-cli ping || exit 1
restart: always

database:
container_name: immich_postgres
image: docker.io/tensorchord/pgvecto-rs:pg14-v0.2.0@sha256:90724186f0a3517cf6914295b5ab410db9ce23190a2d9d0b9dd6463e3fa298f0
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:

[Pritski]

postgres logs:

2025-02-18 20:46:21.978 UTC [1] LOG: starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-02-18 20:46:21.979 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2025-02-18 20:46:21.979 UTC [1] LOG: listening on IPv6 address "::", port 5432
2025-02-18 20:46:21.991 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-02-18 20:46:21.995 UTC [28] LOG: database system was interrupted while in recovery at 2025-02-18 20:45:21 UTC
2025-02-18 20:46:21.995 UTC [28] HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
[2025-02-18T20:46:21Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17575".
[2025-02-18T20:46:21Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331".
2025-02-18 20:46:22.104 UTC [28] LOG: database system was not properly shut down; automatic recovery in progress
2025-02-18 20:46:22.104 UTC [28] LOG: redo starts at 0/1951DB0
2025-02-18 20:46:22.159 UTC [28] LOG: redo done at 0/1FFFEE8 system usage: CPU: user: 0.04 s, system: 0.01 s, elapsed: 0.05 s
2025-02-18 20:46:22.164 UTC [28] PANIC: could not write to file "pg_wal/xlogtemp.28": No space left on device
2025-02-18 20:46:22.166 UTC [1] LOG: startup process (PID 28) was terminated by signal 6: Aborted
2025-02-18 20:46:22.166 UTC [1] LOG: aborting startup due to startup process failure

[Pritski]

within portainer the immich_postgres container status is "running"

I can see a pg_wal subdirectoy on the host at ./postgres/pg_wal with

• a 16.8MB file called "000000010000000000000001" which appears to be a binary file and
• a subdirectoy called archive_status which appears empty

[Pritski]

Could this be a permissions issue? I have recursively changed the entire ./postgres folder to 770 permissions and recreated the stack in portainer

similar issue persists:

2025-02-18 21:03:35.990 UTC [1] LOG: starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-02-18 21:03:35.990 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2025-02-18 21:03:35.990 UTC [1] LOG: listening on IPv6 address "::", port 5432
2025-02-18 21:03:36.003 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-02-18 21:03:36.005 UTC [27] LOG: database system was interrupted while in recovery at 2025-02-18 21:03:09 UTC
2025-02-18 21:03:36.005 UTC [27] HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
[2025-02-18T21:03:36Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17575".
[2025-02-18T21:03:36Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331".
2025-02-18 21:03:36.060 UTC [27] LOG: database system was not properly shut down; automatic recovery in progress
2025-02-18 21:03:36.060 UTC [27] LOG: redo starts at 0/1951DB0
2025-02-18 21:03:36.115 UTC [27] LOG: redo done at 0/1FFFEE8 system usage: CPU: user: 0.03 s, system: 0.01 s, elapsed: 0.05 s
2025-02-18 21:03:36.120 UTC [27] PANIC: could not write to file "pg_wal/xlogtemp.27": No space left on device
2025-02-18 21:03:36.122 UTC [1] LOG: startup process (PID 27) was terminated by signal 6: Aborted
2025-02-18 21:03:36.122 UTC [1] LOG: aborting startup due to startup process failure
2025-02-18 21:03:36.124 UTC [1] LOG: database system is shut down