1.128+ error Microservice

[arne182]

I have this error now as well and my server does not allow me to open the webpage
immich_server | Initializing Immich v1.130.3
immich_server | Detected CPU Cores: 4
immich_server | Starting api worker
immich_server | Starting microservices worker
immich_server | [Nest] 6 - 03/29/2025, 8:17:53 PM LOG [Microservices:EventRepository] Initialized websocket server
immich_server | microservices worker error: TypeError: Cannot read properties of undefined (reading 'replace'), stack: TypeError: Cannot read properties of undefined (reading 'replace')
immich_server | at queryError (/usr/src/app/node_modules/postgres/cjs/src/connection.js:389:48)
immich_server | microservices worker exited with code 1
immich_server | Killing api process

immich_server exited with code 0

It is working when going back to v1.127.0

What else can I provide you to help debug

[bo0tzz]

It can't reach postgres. Please post the postgres container logs, as well as your compose and .env files.

[arne182]

2025-03-29 19:50:44.957 UTC [1] LOG: received fast shutdown request
2025-03-29 19:50:44.983 UTC [1] LOG: aborting any active transactions
2025-03-29 19:50:44.988 UTC [1] LOG: background worker "logical replication launcher" (PID 45) exited with exit code 1
2025-03-29 19:50:45.060 UTC [40] LOG: shutting down
2025-03-29 19:50:46.829 UTC [1] LOG: database system is shut down

2025-03-29 19:51:21.530 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-03-29 19:51:21.530 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2025-03-29 19:51:21.530 UTC [1] LOG: listening on IPv6 address "::", port 5432
2025-03-29 19:51:21.645 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-03-29 19:51:22.453 UTC [28] LOG: database system was shut down at 2025-03-29 19:50:46 UTC
[2025-03-29T19:51:22Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332".
[2025-03-29T19:51:22Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17576".
[2025-03-29T19:51:22Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/404566de-faff-4c02-8e70-31e0b756e1f7".
[2025-03-29T19:51:22Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17576/segments/616c6723-4e3d-40da-91c8-2a00d3edeb6c".
2025-03-29 19:51:23.502 UTC [1] LOG: database system is ready to accept connections
2025-03-29 19:54:11.389 UTC [50] LOG: could not receive data from client: Connection reset by peer
2025-03-29 19:56:48.507 UTC [49] LOG: unexpected EOF on client connection with an open transaction
2025-03-29 20:00:15.912 UTC [64] LOG: could not receive data from client: Connection reset by peer
2025-03-29 20:00:41.522 UTC [1] LOG: received fast shutdown request
2025-03-29 20:00:42.845 UTC [1] LOG: aborting any active transactions
2025-03-29 20:00:42.847 UTC [1] LOG: background worker "logical replication launcher" (PID 45) exited with exit code 1
2025-03-29 20:00:42.872 UTC [63] FATAL: terminating connection due to administrator command
2025-03-29 20:00:42.872 UTC [63] STATEMENT: UPDATE "assets" SET "updateId" = immich_uuid_v7("updatedAt")

2025-03-29 20:02:54.654 UTC [1] LOG: starting PostgreSQL 14.17 (Debian 14.17-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-03-29 20:02:54.662 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2025-03-29 20:02:54.662 UTC [1] LOG: listening on IPv6 address "::", port 5432
2025-03-29 20:02:54.750 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-03-29 20:02:54.880 UTC [28] LOG: database system was interrupted; last known up at 2025-03-29 19:58:11 UTC
[2025-03-29T20:02:54Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332".
[2025-03-29T20:02:54Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17576".
[2025-03-29T20:02:54Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/404566de-faff-4c02-8e70-31e0b756e1f7".
[2025-03-29T20:02:55Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17576/segments/616c6723-4e3d-40da-91c8-2a00d3edeb6c".
2025-03-29 20:02:55.641 UTC [28] LOG: database system was not properly shut down; automatic recovery in progress
2025-03-29 20:02:55.732 UTC [28] LOG: redo starts at 18/179B5808
2025-03-29 20:03:09.775 UTC [40] FATAL: the database system is starting up
2025-03-29 20:03:14.006 UTC [28] LOG: invalid magic number 0000 in log segment 00000001000000180000009D, offset 9805824
2025-03-29 20:03:14.006 UTC [28] LOG: redo done at 18/9D959E68 system usage: CPU: user: 16.12 s, system: 1.90 s, elapsed: 18.27 s
2025-03-29 20:03:25.199 UTC [41] FATAL: the database system is starting up
2025-03-29 20:03:55.380 UTC [42] FATAL: the database system is starting up
2025-03-29 20:04:12.847 UTC [43] FATAL: the database system is starting up
2025-03-29 20:04:25.911 UTC [1] LOG: database system is ready to accept connections
2025-03-29 20:07:26.557 UTC [1] LOG: received fast shutdown request
2025-03-29 20:07:27.274 UTC [1] LOG: aborting any active transactions
2025-03-29 20:07:27.275 UTC [53] FATAL: terminating connection due to administrator command
2025-03-29 20:07:27.275 UTC [53] CONTEXT: SQL function "f_unaccent" statement 1
2025-03-29 20:07:27.275 UTC [53] STATEMENT: UPDATE "assets" SET "updateId" = immich_uuid_v7("updatedAt")
2025-03-29 20:07:27.277 UTC [1] LOG: background worker "logical replication launcher" (PID 49) exited with exit code 1

2025-03-29 20:17:35.534 UTC [1] LOG: starting PostgreSQL 14.17 (Debian 14.17-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-03-29 20:17:35.552 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2025-03-29 20:17:35.552 UTC [1] LOG: listening on IPv6 address "::", port 5432
2025-03-29 20:17:36.020 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-03-29 20:17:36.382 UTC [28] LOG: database system shutdown was interrupted; last known up at 2025-03-29 20:17:09 UTC
[2025-03-29T20:17:36Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332".
[2025-03-29T20:17:36Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17576".
[2025-03-29T20:17:36Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/404566de-faff-4c02-8e70-31e0b756e1f7".
[2025-03-29T20:17:37Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17576/segments/616c6723-4e3d-40da-91c8-2a00d3edeb6c".
2025-03-29 20:17:37.868 UTC [28] LOG: database system was not properly shut down; automatic recovery in progress
2025-03-29 20:17:38.193 UTC [28] LOG: redo starts at 19/47718AF0
2025-03-29 20:17:47.944 UTC [28] LOG: invalid record length at 19/8BBB0EC0: wanted 24, got 0
2025-03-29 20:17:47.944 UTC [28] LOG: redo done at 19/8BBB0E80 system usage: CPU: user: 8.28 s, system: 1.01 s, elapsed: 9.75 s
2025-03-29 20:17:53.576 UTC [40] FATAL: the database system is starting up
2025-03-29 20:18:23.299 UTC [41] FATAL: the database system is starting up
2025-03-29 20:18:28.563 UTC [1] LOG: database system is ready to accept connections
2025-03-29 20:19:30.483 UTC [1] LOG: received fast shutdown request
2025-03-29 20:19:30.526 UTC [1] LOG: aborting any active transactions
2025-03-29 20:19:30.526 UTC [52] FATAL: terminating connection due to administrator command
2025-03-29 20:19:30.526 UTC [52] STATEMENT: UPDATE "asset_files" SET "updateId" = immich_uuid_v7("updatedAt")
2025-03-29 20:19:30.527 UTC [1] LOG: background worker "logical replication launcher" (PID 47) exited with exit code 1
2025-03-29 20:19:30.591 UTC [42] LOG: shutting down

2025-03-29 21:19:53.360 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-03-29 21:19:53.360 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2025-03-29 21:19:53.360 UTC [1] LOG: listening on IPv6 address "::", port 5432
2025-03-29 21:19:53.777 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
[2025-03-29T21:19:54Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332".
[2025-03-29T21:19:54Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17576".
[2025-03-29T21:19:54Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17576/segments/616c6723-4e3d-40da-91c8-2a00d3edeb6c".
2025-03-29 21:19:54.323 UTC [28] LOG: database system was interrupted; last known up at 2025-03-29 21:17:09 UTC
[2025-03-29T21:19:54Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/404566de-faff-4c02-8e70-31e0b756e1f7".
2025-03-29 21:19:54.865 UTC [28] LOG: database system was not properly shut down; automatic recovery in progress
2025-03-29 21:19:55.079 UTC [28] LOG: redo starts at 1C/863C3BB0
2025-03-29 21:19:57.497 UTC [28] LOG: invalid record length at 1C/9D78AF88: wanted 24, got 0
2025-03-29 21:19:57.497 UTC [28] LOG: redo done at 1C/9D78AF50 system usage: CPU: user: 2.14 s, system: 0.23 s, elapsed: 2.41 s
2025-03-29 21:20:04.665 UTC [1] LOG: database system is ready to accept connections

[arne182]

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=./library

The location where your database files are stored

DB_DATA_LOCATION=./pgdata

To set a timezone, uncomment the next line and change Etc/UTC to a TZ identifier from this list: https://en.wikipedia.org/wiki/List_of_tz_database_time_zones#List

TZ=Etc/UTC

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=password

The values below this line do not need to be changed

###################################################################################
DB_USERNAME=postgres
DB_DATABASE_NAME=immich

WARNING: 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:
- ./tsdata:/usr/src/app/upload
- /etc/localtime:/etc/localtime:ro
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, 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
ports:
- 3003:3003
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 # did change this to newest one
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 # did change this to newest one
environment:
POSTGRES_PASSWORD: ${DB_PASSWORD}
POSTGRES_USER: ${DB_USERNAME}
POSTGRES_DB: ${DB_DATABASE_NAME}
POSTGRES_INITDB_ARGS: '--data-checksums'
volumes:
- ./pgdata:/var/lib/postgresql/data
ports:
- 16432:5432
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_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

[bo0tzz]

Your database is corrupted.

[arne182]

Going back to 1.127.0 makes it work perfectly. Can you explain why that is the case?

[alextran1502]

New migration might have use the code path or data path that have been corrupted which isn't exposed in 1.127

[arne182]

Any way I can fix the DB do that I can upgrade?

[alextran1502]

You can try using the database backups in UPLOAD_LOCATION/backups to perform the restore process to a new database location

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

What system are you running Immich on and has there been any interruptions or sudden shutdown/loss power?

Is the database running on the OS drive or network mounted?

Answering those questions can help prevent this to happen again

[arne182]

It is on a synology nas and there was a sudden power loss 2 weeks ago.

did a complete backup and restore, this is the log of the new DB after being freshly restored

2025-03-30 15:27:15.518 UTC [50] LOG: starting PostgreSQL 14.17 (Debian 14.17-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-03-30 15:27:15.531 UTC [50] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-03-30 15:27:15.635 UTC [52] LOG: database system was shut down at 2025-03-30 15:27:14 UTC
2025-03-30 15:27:15.669 UTC [50] LOG: database system is ready to accept connections
2025-03-30 15:27:19.476 UTC [50] LOG: received fast shutdown request
2025-03-30 15:27:19.613 UTC [50] LOG: aborting any active transactions
2025-03-30 15:27:19.617 UTC [50] LOG: background worker "logical replication launcher" (PID 61) exited with exit code 1
2025-03-30 15:27:19.617 UTC [56] LOG: shutting down
2025-03-30 15:27:20.078 UTC [50] LOG: database system is shut down

2025-03-30 15:27:20.456 UTC [1] LOG: starting PostgreSQL 14.17 (Debian 14.17-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-03-30 15:27:20.456 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2025-03-30 15:27:20.456 UTC [1] LOG: listening on IPv6 address "::", port 5432
2025-03-30 15:27:20.533 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-03-30 15:27:20.650 UTC [70] LOG: database system was shut down at 2025-03-30 15:27:20 UTC
2025-03-30 15:27:20.666 UTC [1] LOG: database system is ready to accept connections
2025-03-30 15:40:57.002 UTC [128] ERROR: current user cannot be dropped
2025-03-30 15:40:57.002 UTC [128] STATEMENT: DROP ROLE IF EXISTS postgres;
2025-03-30 15:40:57.002 UTC [128] ERROR: role "postgres" already exists
2025-03-30 15:40:57.002 UTC [128] STATEMENT: CREATE ROLE postgres;
2025-03-30 15:44:46.124 UTC [146] ERROR: canceling autovacuum task
2025-03-30 15:44:46.124 UTC [146] CONTEXT: while scanning block 3365 of relation "public.asset_job_status"
automatic vacuum of table "immich.public.asset_job_status"
2025-03-30 15:45:08.674 UTC [146] ERROR: canceling autovacuum task
2025-03-30 15:45:08.674 UTC [146] CONTEXT: while scanning block 370 of relation "public.exif"
automatic vacuum of table "immich.public.exif"
2025-03-30 15:45:11.773 UTC [134] ERROR: canceling autovacuum task
2025-03-30 15:45:11.773 UTC [134] CONTEXT: while scanning block 4246 of relation "public.asset_files"
automatic vacuum of table "immich.public.asset_files"
2025-03-30 15:45:18.949 UTC [149] ERROR: canceling autovacuum task
2025-03-30 15:45:18.949 UTC [149] CONTEXT: while scanning block 2250 of relation "public.assets"
automatic vacuum of table "immich.public.assets"
2025-03-30 15:45:36.584 UTC [149] ERROR: canceling autovacuum task
2025-03-30 15:45:36.584 UTC [149] CONTEXT: while scanning block 544 of relation "public.face_search"
automatic vacuum of table "immich.public.face_search"
2025-03-30 15:45:39.040 UTC [149] ERROR: canceling autovacuum task
2025-03-30 15:45:39.040 UTC [149] CONTEXT: while scanning block 158 of relation "public.geodata_places"
automatic vacuum of table "immich.public.geodata_places"
2025-03-30 15:45:42.332 UTC [149] ERROR: canceling autovacuum task
2025-03-30 15:45:42.332 UTC [149] CONTEXT: while scanning block 131 of relation "public.naturalearth_countries"
automatic vacuum of table "immich.public.naturalearth_countries"
2025-03-30 15:46:00.021 UTC [156] ERROR: canceling autovacuum task
2025-03-30 15:46:00.021 UTC [156] CONTEXT: while scanning block 3514 of relation "public.exif"
automatic vacuum of table "immich.public.exif"
2025-03-30 15:48:49.452 UTC [174] ERROR: canceling autovacuum task
2025-03-30 15:48:49.452 UTC [174] CONTEXT: while scanning block 8479 of relation "public.asset_files"
automatic vacuum of table "immich.public.asset_files"
2025-03-30 15:48:50.919 UTC [174] ERROR: canceling autovacuum task
2025-03-30 15:48:50.919 UTC [174] CONTEXT: while scanning block 2314 of relation "public.assets"
automatic vacuum of table "immich.public.assets"
2025-03-30 15:49:12.719 UTC [202] ERROR: canceling autovacuum task
2025-03-30 15:49:12.719 UTC [202] CONTEXT: while scanning block 6200 of relation "public.exif"
automatic vacuum of table "immich.public.exif"

2025-03-30 16:03:32.343 UTC [1] LOG: starting PostgreSQL 14.17 (Debian 14.17-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-03-30 16:03:32.343 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2025-03-30 16:03:32.343 UTC [1] LOG: listening on IPv6 address "::", port 5432
2025-03-30 16:03:33.013 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-03-30 16:03:33.721 UTC [27] LOG: database system was interrupted; last known up at 2025-03-30 16:00:04 UTC
[2025-03-30T16:03:33Z INFO service::utils::clean] Find directory "pg_vectors/indexes/728761".
[2025-03-30T16:03:33Z INFO service::utils::clean] Find directory "pg_vectors/indexes/728763".
[2025-03-30T16:03:33Z INFO service::utils::clean] Find directory "pg_vectors/indexes/728761/segments/d4534497-9cc5-4e5c-94b8-748e32b729de".
[2025-03-30T16:03:34Z INFO service::utils::clean] Find directory "pg_vectors/indexes/728763/segments/8b461f40-257e-44e3-9f4a-b6b64b6a0878".
[2025-03-30T16:03:34Z INFO service::utils::clean] Find directory "pg_vectors/indexes/728763/segments/8a569edd-3f1e-4e65-a9d3-8a07eb9b3229".
[2025-03-30T16:03:34Z INFO service::utils::clean] Delete outdated directory "pg_vectors/indexes/728763/segments/28901194-11e8-4d88-87ef-888a4d25d6ea".
2025-03-30 16:03:34.429 UTC [27] LOG: database system was not properly shut down; automatic recovery in progress
2025-03-30 16:03:34.485 UTC [27] LOG: redo starts at 1/3FE7188
2025-03-30 16:03:34.485 UTC [27] LOG: invalid record length at 1/3FE7270: wanted 24, got 0
2025-03-30 16:03:34.485 UTC [27] LOG: redo done at 1/3FE7238 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2025-03-30 16:03:37.457 UTC [1] LOG: database system is ready to accept connections

[arne182]

With
ghcr.io/immich-app/immich-server:release
front end does not start
with
ghcr.io/immich-app/immich-server:v1.127.0
log looks like this but starts.
2025-03-30 16:07:35.773 UTC [1] LOG: starting PostgreSQL 14.17 (Debian 14.17-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-03-30 16:07:35.773 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2025-03-30 16:07:35.773 UTC [1] LOG: listening on IPv6 address "::", port 5432
2025-03-30 16:07:36.558 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-03-30 16:07:37.039 UTC [27] LOG: database system was shut down at 2025-03-30 16:06:48 UTC
[2025-03-30T16:07:37Z INFO service::utils::clean] Find directory "pg_vectors/indexes/728761".
[2025-03-30T16:07:37Z INFO service::utils::clean] Find directory "pg_vectors/indexes/728763".
[2025-03-30T16:07:37Z INFO service::utils::clean] Find directory "pg_vectors/indexes/728761/segments/d4534497-9cc5-4e5c-94b8-748e32b729de".
[2025-03-30T16:07:37Z INFO service::utils::clean] Find directory "pg_vectors/indexes/728763/segments/8b461f40-257e-44e3-9f4a-b6b64b6a0878".
[2025-03-30T16:07:37Z INFO service::utils::clean] Find directory "pg_vectors/indexes/728763/segments/8a569edd-3f1e-4e65-a9d3-8a07eb9b3229".
[2025-03-30T16:07:37Z INFO service::utils::clean] Delete outdated directory "pg_vectors/indexes/728763/segments/734ef279-7952-4f67-8e30-1afd0a29aead".
2025-03-30 16:07:37.288 UTC [1] LOG: database system is ready to accept connections
2025-03-30 16:07:38.163 UTC [39] ERROR: type "citext" does not exist at character 8
2025-03-30 16:07:38.163 UTC [39] STATEMENT: SELECT 'citext'::regtype::oid

[arne182]

[arne182]

2025-03-30 16:19:33.616 UTC [1] LOG: starting PostgreSQL 14.17 (Debian 14.17-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-03-30 16:19:33.616 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2025-03-30 16:19:33.616 UTC [1] LOG: listening on IPv6 address "::", port 5432
2025-03-30 16:19:33.894 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-03-30 16:19:33.964 UTC [29] LOG: database system was shut down at 2025-03-30 16:19:00 UTC
[2025-03-30T16:19:33Z INFO service::utils::clean] Find directory "pg_vectors/indexes/728761".
[2025-03-30T16:19:33Z INFO service::utils::clean] Find directory "pg_vectors/indexes/728763".
[2025-03-30T16:19:33Z INFO service::utils::clean] Find directory "pg_vectors/indexes/728761/segments/d4534497-9cc5-4e5c-94b8-748e32b729de".
2025-03-30 16:19:34.273 UTC [1] LOG: database system is ready to accept connections
[2025-03-30T16:19:34Z INFO service::utils::clean] Find directory "pg_vectors/indexes/728763/segments/996b2f7c-55e2-4606-a220-12e64ea1afe1".
2025-03-30 16:22:06.941 UTC [54] ERROR: canceling statement due to statement timeout
2025-03-30 16:22:06.941 UTC [54] STATEMENT: SELECT *, pg_table_size(QUOTE_IDENT(t.TABLE_SCHEMA) || '.' || QUOTE_IDENT(t.TABLE_NAME))::bigint AS data_length, pg_relation_size(QUOTE_IDENT(t.TABLE_SCHEMA) || '.' || QUOTE_IDENT(t.TABLE_NAME))::bigint AS index_length, c.reltuples, obj_description(c.oid) AS comment FROM "information_schema"."tables" AS t LEFT JOIN "pg_namespace" n ON t.table_schema = n.nspname LEFT JOIN "pg_class" c ON n.oid = c.relnamespace AND c.relname=t.table_name WHERE t."table_schema"='public'

[dpkg-i-foo-deb]

Have you tried setting DB_HOSTNAME on immich_server? I had a very similar issue and I found out this variable is not set on the official .env file you get from the installation guide, I set mine to immich_postgres and now it works :)

[arne182]

Tried this, did not help.