Cguijt Posts - Answer Overflow

Cguijt

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

Huge update, DB upgrade gives errors

I've been running Immich for quite a while now without issues, but I've been unable to keep up with the updates due to reasons. I'm running on a Kubernetes cluster and just migrated the database to cnpg using this (since the postgres subchart is being deprecated). Connection is fine, but the migrations keep running into the same error, which is:

query: 'INSERT INTO "migrations"("timestamp", "name") VALUES ($1, $2)',
  parameters: [ 1718486162779, 'AddFaceSearchRelation1718486162779' ],
  driverError: error: duplicate key value violates unique constraint "PK_8c82d7f526340ab734260ea46be"

query: 'INSERT INTO "migrations"("timestamp", "name") VALUES ($1, $2)',
  parameters: [ 1718486162779, 'AddFaceSearchRelation1718486162779' ],
  driverError: error: duplicate key value violates unique constraint "PK_8c82d7f526340ab734260ea46be"

I must say; my probes did make my pod reboot mid migration, I'm not sut if that could've caused this issue. I've walked through all releases for any breaking changes and I've searched the GitHub issue list for similair errors, but couldn't find anything relevant. I'm upgrading from 1.106.4 to 1.132.3 - a huge leap, I know...

12 replies

Gaming

Programming