© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
ImmichI
Immich•3mo ago•
6 replies
Mashuuu

Error 500 immich_server, error in immich_postgresql

Hello, i got some errors where i need help :
I'm on the latest release tag, i did the migration when there were some break changes for the database needed.
As you can see in the picture i got the error in immich_postgres
ERROR [Api:ErrorInterceptor~pf9fbdqa] Database error: QueryFailedError: relation "users" does not exist


I compare with a friend that is on last release too, and in his database there is no "users" table, just "user" at least as mine

I have no clue

here my docker-compose.yml (it's behind traefik 3.3) :
services:
  immich-server:
    container_name: immich_server
    image: ghcr.io/immich-app/immich-server:release
    environment:
      DB_HOSTNAME: immich_postgres
      DB_PASSWORD: ${IMMICH_DB_PASSWORD}
      DB_USERNAME: postgres
      DB_DATABASE_NAME: immich
      REDIS_HOSTNAME: immich_redis
    volumes:
      - ${IMMICH_UPLOAD_LOCATION}:/usr/src/app/upload
      - /etc/localtime:/etc/localtime:ro
      - ${CONFIG_ROOT:-.}/immich/healthcheck:/healthcheck
    ports:
      - 2283:2283  
    depends_on:
      - immich-redis
      - immich-database
    restart: always
    labels:
      - traefik.enable=true
      - traefik.http.routers.immich.rule=Host(toto)
      - traefik.http.routers.immich.tls=true
      - traefik.http.routers.immich.tls.certresolver=myresolver
      - traefik.http.services.immich.loadbalancer.server.port=2283
    profiles:
      - immich

XXX

XXX

  immich-database:
    container_name: immich_postgres
    image: ghcr.io/immich-app/postgres:14-vectorchord0.3.0-pgvectors0.2.0
    environment:
      POSTGRES_PASSWORD: ${IMMICH_DB_PASSWORD}
      POSTGRES_USER: postgres
      POSTGRES_DB: immich
      POSTGRES_INITDB_ARGS: '--data-checksums'
      DB_STORAGE_TYPE: 'HDD'
    volumes:
      - ${CONFIG_ROOT:-.}/immich/postgresql:/var/lib/postgresql/data
    restart: always
    profiles:
      - immich

volumes:
  immich-model-cache: 
services:
  immich-server:
    container_name: immich_server
    image: ghcr.io/immich-app/immich-server:release
    environment:
      DB_HOSTNAME: immich_postgres
      DB_PASSWORD: ${IMMICH_DB_PASSWORD}
      DB_USERNAME: postgres
      DB_DATABASE_NAME: immich
      REDIS_HOSTNAME: immich_redis
    volumes:
      - ${IMMICH_UPLOAD_LOCATION}:/usr/src/app/upload
      - /etc/localtime:/etc/localtime:ro
      - ${CONFIG_ROOT:-.}/immich/healthcheck:/healthcheck
    ports:
      - 2283:2283  
    depends_on:
      - immich-redis
      - immich-database
    restart: always
    labels:
      - traefik.enable=true
      - traefik.http.routers.immich.rule=Host(toto)
      - traefik.http.routers.immich.tls=true
      - traefik.http.routers.immich.tls.certresolver=myresolver
      - traefik.http.services.immich.loadbalancer.server.port=2283
    profiles:
      - immich

XXX

XXX

  immich-database:
    container_name: immich_postgres
    image: ghcr.io/immich-app/postgres:14-vectorchord0.3.0-pgvectors0.2.0
    environment:
      POSTGRES_PASSWORD: ${IMMICH_DB_PASSWORD}
      POSTGRES_USER: postgres
      POSTGRES_DB: immich
      POSTGRES_INITDB_ARGS: '--data-checksums'
      DB_STORAGE_TYPE: 'HDD'
    volumes:
      - ${CONFIG_ROOT:-.}/immich/postgresql:/var/lib/postgresql/data
    restart: always
    profiles:
      - immich

volumes:
  immich-model-cache: 
image.png
docker-compose.yml1.91KB
ImmichJoin
A place to hang out, get support, discuss Immich, get announcements about releases and anything else going on.
36,590Members
Resources
Was this page helpful?

Similar Threads

Recent Announcements

Similar Threads

Immich server 500 error after updating
ImmichIImmich / help-desk-support
3y ago
500 ENOTFOUND immich_server
ImmichIImmich / help-desk-support
3y ago
immich CLI import 500 internal server error
ImmichIImmich / help-desk-support
3y ago
Immich ML error 500
ImmichIImmich / help-desk-support
9mo ago