Cguijt Comments - Answer Overflow

Cguijt

•Created by Cguijt on 5/19/2025 in #help-desk-support

Huge update, DB upgrade gives errors

Hmm, even though I haven't changed the database details, v1.124.2 throws ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)...

12 replies

IImmich

•Created by Cguijt on 5/19/2025 in #help-desk-support

Huge update, DB upgrade gives errors

Logs aren't progressing past this, probe just cause a first reset:

Initializing Immich v1.124.2
Detected CPU Cores: 4
Starting api worker
Starting microservices worker

Initializing Immich v1.124.2
Detected CPU Cores: 4
Starting api worker
Starting microservices worker

No errors on the database node

12 replies

IImmich

•Created by Cguijt on 5/19/2025 in #help-desk-support

Huge update, DB upgrade gives errors

Just to be complete, the full error: https://pastebin.com/CfKMzA8H

12 replies

IImmich

•Created by Cguijt on 5/19/2025 in #help-desk-support

Huge update, DB upgrade gives errors

The error seems to be originating from detail: 'Key (id)=(264) already exists.',

12 replies

IImmich

•Created by Cguijt on 5/19/2025 in #help-desk-support

Huge update, DB upgrade gives errors

Hmm, there are no matches if I run SELECT * FROM migrations WHERE name = 'AddFaceSearchRelation1718486162779';

12 replies

IImmich

•Created by Cguijt on 5/19/2025 in #help-desk-support

Huge update, DB upgrade gives errors

values.yaml for Helm chart version 0.9.3:

env:
  REDIS_HOSTNAME: 'immich-redis-master.immich.svc.cluster.local'
  DB_HOSTNAME: "immich-rw.cnpg"
  DB_USERNAME: "immich"
  DB_DATABASE_NAME: "immich"
  # -- You should provide your own secret outside of this helm-chart and use `postgresql.global.postgresql.auth.existingSecret` to provide credentials to the postgresql instance
  DB_PASSWORD: [redacted]
    #DB_HOSTNAME: "{{ .Release.Name }}-postgresql"
    #DB_USERNAME: "{{ .Values.postgresql.global.postgresql.auth.username }}"
    #DB_DATABASE_NAME: "{{ .Values.postgresql.global.postgresql.auth.database }}"
  IMMICH_MACHINE_LEARNING_URL: '{{ printf "http://%s-machine-learning:3003" .Release.Name }}'

image:
  tag: v1.132.3

immich:
  persistence:
    # Main data store for all photos shared between different components.
    library:
      # Automatically creating the library volume is not supported by this chart
      # You have to specify an existing PVC to use
      existingClaim: immich-pvc

redis:
  enabled: false
  architecture: standalone
  auth:
    enabled: false

# Immich components

server:
  enabled: true
  image:
    repository: ghcr.io/immich-app/immich-server
    pullPolicy: IfNotPresent

  probes:
    readiness:
      custom: true
      spec:
        initialDelaySeconds: 30
        periodSeconds: 10
        timeoutSeconds: 5
        failureThreshold: 3
    startup:
      custom: true
      spec:
        initialDelaySeconds: 60
        timeoutSeconds: 5
        ## This means it has a maximum of 5*30=150 seconds to start up before it fails
        periodSeconds: 60
        failureThreshold: 60

  persistence:
    external:
      existingClaim: immich-photos-pvc
      enabled: true
      readOnly: true

  ingress:
    main:
      enabled: true
      annotations:
        # proxy-body-size is set to 0 to remove the body limit on file uploads
        nginx.ingress.kubernetes.io/proxy-body-size: "0"

env:
  REDIS_HOSTNAME: 'immich-redis-master.immich.svc.cluster.local'
  DB_HOSTNAME: "immich-rw.cnpg"
  DB_USERNAME: "immich"
  DB_DATABASE_NAME: "immich"
  # -- You should provide your own secret outside of this helm-chart and use `postgresql.global.postgresql.auth.existingSecret` to provide credentials to the postgresql instance
  DB_PASSWORD: [redacted]
    #DB_HOSTNAME: "{{ .Release.Name }}-postgresql"
    #DB_USERNAME: "{{ .Values.postgresql.global.postgresql.auth.username }}"
    #DB_DATABASE_NAME: "{{ .Values.postgresql.global.postgresql.auth.database }}"
  IMMICH_MACHINE_LEARNING_URL: '{{ printf "http://%s-machine-learning:3003" .Release.Name }}'

image:
  tag: v1.132.3

immich:
  persistence:
    # Main data store for all photos shared between different components.
    library:
      # Automatically creating the library volume is not supported by this chart
      # You have to specify an existing PVC to use
      existingClaim: immich-pvc

redis:
  enabled: false
  architecture: standalone
  auth:
    enabled: false

# Immich components

server:
  enabled: true
  image:
    repository: ghcr.io/immich-app/immich-server
    pullPolicy: IfNotPresent

  probes:
    readiness:
      custom: true
      spec:
        initialDelaySeconds: 30
        periodSeconds: 10
        timeoutSeconds: 5
        failureThreshold: 3
    startup:
      custom: true
      spec:
        initialDelaySeconds: 60
        timeoutSeconds: 5
        ## This means it has a maximum of 5*30=150 seconds to start up before it fails
        periodSeconds: 60
        failureThreshold: 60

  persistence:
    external:
      existingClaim: immich-photos-pvc
      enabled: true
      readOnly: true

  ingress:
    main:
      enabled: true
      annotations:
        # proxy-body-size is set to 0 to remove the body limit on file uploads
        nginx.ingress.kubernetes.io/proxy-body-size: "0"

12 replies

Gaming

Programming