-
The bugWithin the deployment process I set the following as environment variable:
and receive the following error whenever starting immich_server: `[Nest] 7 - 12/23/2024, 1:50:16 PM LOG [NestFactory] Starting Nest application... [Nest] 7 - 12/23/2024, 1:50:16 PM ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)... microservices worker exited with code 1` Whenever I set DB_PASSWORD to default "postgres" it's working and the immich_server is fully starting. Looks like just immich_server is affected as the other containers are starting in any case as they should. I wonder if "postgres" as password is a default value within the image of immich_server and it's not being overwritten by the .env-variable? Sorry if my description is not perfect, as I'm not a developer, trying my best :-) Merry Christmas! The OS that Immich Server is running onPortainer 2.21.4 Version of Immich Serverv1.123.0 Version of Immich Mobile Appv1.123.0 Platform with the issue
Your docker-compose.yml content#
# 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:
# 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:
# - .env
ports:
- '2283:2283'
depends_on:
- redis
- database
restart: unless-stopped
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:
# - .env
restart: unless-stopped
healthcheck:
disable: false
redis:
container_name: immich_redis
image: docker.io/redis:6.2-alpine@sha256:eaba718fecd1196d88533de7ba49bf903ad33664a92debb24660a922ecd9cac8
healthcheck:
test: redis-cli ping || exit 1
restart: unless-stopped
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
- pgdata-immich:/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: unless-stopped
volumes:
model-cache:
pgdata-immich: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=./library
# The location where your database files are stored
DB_DATA_LOCATION=./postgres
# 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=v1.123.0
# Connection secret for postgres. You should change it to a random password
# Please use only the characters `A-Za-z0-9`, without special characters or spaces
DB_PASSWORD=justatest
# The values below this line do not need to be changed
###################################################################################
DB_USERNAME=postgres
DB_DATABASE_NAME=immich
TZ=Europe/BerlinReproduction steps
Relevant log outputInitializing Immich v1.123.0
Detected CPU Cores: 4
Starting api worker
Starting microservices worker
(node:7) [DEP0060] DeprecationWarning: The `util._extend` API is deprecated. Please use Object.assign() instead.
(Use `node --trace-deprecation ...` to show where the warning was created)
(node:7) [DEP0060] DeprecationWarning: The `util._extend` API is deprecated. Please use Object.assign() instead.
(Use `node --trace-deprecation ...` to show where the warning was created)
(node:17) [DEP0060] DeprecationWarning: The `util._extend` API is deprecated. Please use Object.assign() instead.
(Use `node --trace-deprecation ...` to show where the warning was created)
[Nest] 7 - 12/23/2024, 2:01:12 PM LOG [NestFactory] Starting Nest application...
[Nest] 7 - 12/23/2024, 2:01:12 PM ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)...
microservices worker exited with code 1
Killing api processAdditional informationNo response |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments 12 replies
-
|
The correct password must be set on initial startup of the DB, since that's the when this stuff is configured. If you later want to change it you need to do that manually in the DB |
Beta Was this translation helpful? Give feedback.
-
|
it's a fully fresh deployment starting from scratch without and existing volume |
Beta Was this translation helpful? Give feedback.
-
|
Make sure the folder created in |
Beta Was this translation helpful? Give feedback.
-
|
I did empty it before every deployment when it pointes to my local disk and I deleted all volumes before every deployment when I changed it to an own volume. Did not help and it's still fully reproducable |
Beta Was this translation helpful? Give feedback.
-
|
You have commented out the env_file from being passed to the immich server. How do you expect it to pick up the env var for the password? |
Beta Was this translation helpful? Give feedback.
-
|
I'm providing all environment variables within the portainer stack when deploying. Working perfectly for this and multiple other deployment. This should not be the issue. But let's pretend it WOULD be the issue, the postgres couldn't be fully initialized and would show that a superuser password is missing within the startup logs (had that before) |
Beta Was this translation helpful? Give feedback.
-
|
It’s passed to Postgres with this line:
however it never gets passed to immich. Compose file / portainer envs don’t get passed into the containers. If you’re using portainer I think you need to pass it as stack.env? This is all in documentation |
Beta Was this translation helpful? Give feedback.
-
|
this is not being passed to immich? It's working like this for a lot of other deployments. Can you explain me why this is not being passed in this special case? |
Beta Was this translation helpful? Give feedback.
-
|
I’m not interested in wasting my time debating docker basics. Please follow our portainer guide: https://immich.app/docs/install/portainer/ I’m closing this as the answer has been provided but if you have continued issues after trying the recommended way feel free to reply with more screenshots. |
Beta Was this translation helpful? Give feedback.
-
|
Sorry, I'm not trying to waste your time and your link helped me to understand, that it needs to be adjusted to stack.env, which I did withing the compose-file. Also the variables are and were already as mentioned in your link:
As said, I also adjusted the docker-compose file, thanks for pointing that out:
I still get the same error: If you think that I'm just being stupid, feel free to keep it closed but something is still strange. Am I missing any variable that is needed? Sorry for the discussion, just trying to finally setup immich within my vacation. |
Beta Was this translation helpful? Give feedback.
-
|
Please post the new compose and env, and confirm you did all this with a fresh database location folder that has never been started before. |
Beta Was this translation helpful? Give feedback.
-
|
Please change pgdata-immich to pgdata-immich-2 and re deploy the stack |
Beta Was this translation helpful? Give feedback.
-
|
it's indeed including "stack.env" withing the compose-file which fixed the issue for me. I forgot to clean the pgdata-immich folder as I re-deployed but as I just did and did a full clean deployment, it finally worked! I was not aware of this link https://immich.app/docs/install/portainer/ and this solved it for me by pointing out the stack.env! Thanks A LOT for your help and sorry for not knowing better :-( I wish you a merry christmas |
Beta Was this translation helpful? Give feedback.
I’m not interested in wasting my time debating docker basics. Please follow our portainer guide: https://immich.app/docs/install/portainer/
I’m closing this as the answer has been provided but if you have continued issues after trying the recommended way feel free to reply with more screenshots.