RubenHensen
RubenHensen
PostsComments
IImmich
Created by RubenHensen on 12/15/2024 in #help-desk-support
Immich server and Postgresql crashes when upgrading Helm chart to v1.122.3
If you have problem that your Immich and Postgres containers crash when you upgrade you Immich version to v1.122.3? You might even get the error ERROR [Microservices:MetadataService] Unable to initialize reverse geocoding: QueryRunnerAlreadyReleasedError or something about the database closing abruptly. Solution: the MapRepository microservice is trying to import about 200000 geo data records with crashes the server because the helm chart adds a limit on the postgresql instance. Increase or remove the limit of the postgresql container to fix the crashing. Example of values.yaml: 
...

image:
  tag: v1.122.3

...

# Dependencies

postgresql:
  enabled: true
  image:
    repository: tensorchord/pgvecto-rs
    tag: pg14-v0.2.0
  global:
    postgresql:
      auth:
        username: immich
        database: immich
        password: immich
  primary:
    containerSecurityContext:
      readOnlyRootFilesystem: false
    initdb:
      scripts:
        create-extensions.sql: |
          CREATE EXTENSION cube;
          CREATE EXTENSION earthdistance;
          CREATE EXTENSION vectors;
    resources:
      limits: {}
      requests:
        cpu: 200m
        memory: 256Mi

...
...

image:
  tag: v1.122.3

...

# Dependencies

postgresql:
  enabled: true
  image:
    repository: tensorchord/pgvecto-rs
    tag: pg14-v0.2.0
  global:
    postgresql:
      auth:
        username: immich
        database: immich
        password: immich
  primary:
    containerSecurityContext:
      readOnlyRootFilesystem: false
    initdb:
      scripts:
        create-extensions.sql: |
          CREATE EXTENSION cube;
          CREATE EXTENSION earthdistance;
          CREATE EXTENSION vectors;
    resources:
      limits: {}
      requests:
        cpu: 200m
        memory: 256Mi

...
4 replies