v1.107.2 ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)...

[frankwuzp]

The bug

I can't open the website after upgrading the version,could you tell me what shoud I do next?

The OS that Immich Server is running on

Debian

Version of Immich Server

v1.107.2

Version of Immich Mobile App

v1.107.1

Platform with the issue

• Server
• Web
• Mobile

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:
      - ${UPLOAD_LOCATION}:/usr/src/app/upload
      - /etc/localtime:/etc/localtime:ro
    env_file:
      - .env
    ports:
      - 2283:3001
    depends_on:
      - redis
      - database
    restart: always

  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: always

  redis:
    container_name: immich_redis
    image: docker.io/redis:6.2-alpine@sha256:328fe6a5822256d065debb36617a8169dbfbd77b797c525288e465f56c1d392b
    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:
      - ${DB_DATA_LOCATION}:/var/lib/postgresql/data
    healthcheck:
      test: pg_isready --dbname='${DB_DATABASE_NAME}' --username='${DB_USERNAME}' || exit 1; Chksum="$$(psql --dbname='${DB_DATABASE_NAME}' --username='${DB_USERNAME}' --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=./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=release

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

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

Reproduction steps

1.updated server from 1.106.4 to 1.107.2
2.`docker compose up -d` start the server
3.saw the errors
...

Relevant log output

Detected CPU Cores: 4
Starting api worker
Starting microservices worker
[Nest] 118  - 07/03/2024, 3:52:49 PM     LOG [NestFactory] Starting Nest application...
[Nest] 118  - 07/03/2024, 3:52:49 PM    WARN [ModuleTokenFactory] The module "ClsModule" is taking 83.50ms to serialize, this may be caused by larger objects statically assigned to the module. More details: https://github.com/nestjs/nest/issues/12738 +86ms
[Nest] 118  - 07/03/2024, 3:52:49 PM     LOG [InstanceLoader] BullModule dependencies initialized +3ms
[Nest] 118  - 07/03/2024, 3:52:49 PM     LOG [InstanceLoader] OpenTelemetryModule dependencies initialized +4ms
[Nest] 118  - 07/03/2024, 3:52:49 PM     LOG [InstanceLoader] TypeOrmModule dependencies initialized +2ms
[Nest] 118  - 07/03/2024, 3:52:49 PM     LOG [InstanceLoader] OpenTelemetryCoreModule dependencies initialized +2ms
[Nest] 118  - 07/03/2024, 3:52:49 PM     LOG [InstanceLoader] ConfigHostModule dependencies initialized +3ms
[Nest] 118  - 07/03/2024, 3:52:49 PM     LOG [InstanceLoader] DiscoveryModule dependencies initialized +2ms
[Nest] 118  - 07/03/2024, 3:52:49 PM     LOG [InstanceLoader] ClsModule dependencies initialized +3ms
[Nest] 118  - 07/03/2024, 3:52:49 PM     LOG [InstanceLoader] ConfigModule dependencies initialized +3ms
[Nest] 118  - 07/03/2024, 3:52:49 PM     LOG [InstanceLoader] EventEmitterModule dependencies initialized +2ms
[Nest] 118  - 07/03/2024, 3:52:49 PM     LOG [InstanceLoader] ScheduleModule dependencies initialized +2ms
[Nest] 118  - 07/03/2024, 3:52:49 PM     LOG [InstanceLoader] BullModule dependencies initialized +2ms
[Nest] 118  - 07/03/2024, 3:52:49 PM     LOG [InstanceLoader] BullModule dependencies initialized +2ms
[Nest] 118  - 07/03/2024, 3:52:49 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)...
error: the database system is starting up
    at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:283:98)
    at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:122:29)
    at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:35:38)
    at Socket.<anonymous> (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (node:events:519:28)
    at addChunk (node:internal/streams/readable:559:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
    at Readable.push (node:internal/streams/readable:390:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:191:23)
[Nest] 118  - 07/03/2024, 3:52:49 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (2)...
error: the database system is starting up
    at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:283:98)
    at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:122:29)
    at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:35:38)
    at Socket.<anonymous> (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (node:events:519:28)
    at addChunk (node:internal/streams/readable:559:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
    at Readable.push (node:internal/streams/readable:390:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:191:23)
[Nest] 118  - 07/03/2024, 3:52:49 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (3)...
Error: connect ECONNREFUSED 172.26.0.3:5432
    at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1606:16)
[Nest] 118  - 07/03/2024, 3:52:49 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (4)...
error: the database system is starting up
    at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:283:98)
    at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:122:29)
    at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:35:38)
    at Socket.<anonymous> (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (node:events:519:28)
    at addChunk (node:internal/streams/readable:559:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
    at Readable.push (node:internal/streams/readable:390:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:191:23)
[Nest] 118  - 07/03/2024, 3:52:49 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (5)...
error: the database system is starting up
    at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:283:98)
    at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:122:29)
    at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:35:38)
    at Socket.<anonymous> (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (node:events:519:28)
    at addChunk (node:internal/streams/readable:559:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
    at Readable.push (node:internal/streams/readable:390:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:191:23)
[Nest] 118  - 07/03/2024, 3:52:49 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (6)...
error: the database system is starting up
    at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:283:98)
    at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:122:29)
    at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:35:38)
    at Socket.<anonymous> (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (node:events:519:28)
    at addChunk (node:internal/streams/readable:559:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
    at Readable.push (node:internal/streams/readable:390:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:191:23)
[Nest] 118  - 07/03/2024, 3:52:49 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (7)...
error: the database system is starting up
    at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:283:98)
    at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:122:29)
    at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:35:38)
    at Socket.<anonymous> (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (node:events:519:28)
    at addChunk (node:internal/streams/readable:559:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
    at Readable.push (node:internal/streams/readable:390:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:191:23)
[Nest] 118  - 07/03/2024, 3:52:49 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (8)...
error: the database system is starting up
    at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:283:98)
    at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:122:29)
    at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:35:38)
    at Socket.<anonymous> (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (node:events:519:28)
    at addChunk (node:internal/streams/readable:559:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
    at Readable.push (node:internal/streams/readable:390:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:191:23)
[Nest] 118  - 07/03/2024, 3:52:49 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (9)...
error: the database system is starting up
    at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:283:98)
    at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:122:29)
    at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:35:38)
    at Socket.<anonymous> (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (node:events:519:28)
    at addChunk (node:internal/streams/readable:559:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
    at Readable.push (node:internal/streams/readable:390:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:191:23)
[Nest] 118  - 07/03/2024, 3:52:49 PM   ERROR [ExceptionHandler] the database system is starting up
error: the database system is starting up
    at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:283:98)
    at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:122:29)
    at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:35:38)
    at Socket.<anonymous> (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (node:events:519:28)
    at addChunk (node:internal/streams/readable:559:12)
    at readableAddChunkPushByteMode (node:internal/streams/readab
le:510:3)
    at Readable.push (node:internal/streams/readable:390:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:191:23)
[Nest] 7  - 07/03/2024, 3:52:49 PM     LOG [NestFactory] Starting Nest application...
[Nest] 7  - 07/03/2024, 3:52:49 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)...
microservices worker exited with code 1

Additional information

what shoud I do next? many thanks!

[gerolori]

Did you ever get this sorted out?

[Deses]

Oh no, that moment when you get here from Google and not only there's no solution but there's more people asking for a follow-up.

Did you ever get this sorted out?

Please tell me you did. 😂

[bo0tzz]

This error is very generic. You should open a new QA thread, and post more info than OP did ;)

[gerolori]

Oh no, that moment when you get here from Google and not only there's no solution but there's more people asking for a follow-up.

Did you ever get this sorted out?

Please tell me you did. 😂

Nah I didn't, I've accidentally updated images and the thing broke, 1.5 months and I'm still here with no immich 😂

[Deses]

I resolved my issue tho! The password I successfully used for a very long time and confirmed that worked with DBeaver, stopped working through Docker. The password contained several special characters like \, so maybe that was cause of my issue (but again I assure this password used to work). I changed to a completely alphanumerical one and Immich started working again.