[immich] Migration from pgvecto.rs to vectorchord

[cavazos-apps]

Chart Name

Immich

Operating System

Talos-OS 1.9

Deployment Method

Helm

Chart Version

19.34.1

Kubernetes Events

N/A

Chart Logs

[Nest] 7  - 09/09/2025, 3:17:02 PM   ERROR [Microservices:{"id":"81bbaba6-5adf-42ff-aa31-19c682fcb250"}] Unable to run job handler (AssetDetectFaces): PostgresError: pgvecto.rs: The index is not existing in the background worker.
ADVICE: Drop or rebuild the index.
PostgresError: pgvecto.rs: The index is not existing in the background worker.
ADVICE: Drop or rebuild the index.
    at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)
    at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6)
    at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9)
    at Socket.emit (node:events:519:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
    at Readable.push (node:internal/streams/readable:392:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
Query failed : {
  durationMs: 1.3347509987652302,
  error: PostgresError: pgvecto.rs: The index is not existing in the background worker.
  ADVICE: Drop or rebuild the index.
      at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)
      at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6)
      at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9)
      at Socket.emit (node:events:519:28)
      at addChunk (node:internal/streams/readable:561:12)
      at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
      at Readable.push (node:internal/streams/readable:392:5)
      at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
    severity_local: 'ERROR',
    severity: 'ERROR',
    code: 'XX000',
    file: 'error.rs',
    line: '7'
  },
  sql: 'with "added" as (insert into "asset_face" ("id", "assetId", "imageHeight", "imageWidth", "boundingBoxX1", "boundingBoxY1", "boundingBoxX2", "boundingBoxY2") values ($1, $2, $3, $4, $5, $6, $7, $8)), "added_embeddings" as (insert into "face_search" ("faceId", "embedding") values ($9, $10)) select from (select 1) as "dummy"',
  params: [
    '6d0d9c43-0985-4c50-b124-ec7c6615df40',
    'ca615887-6543-48bf-8b97-513cb089e524',
    480,
    360,
    -27,
    51,
    120,
    243,
    '6d0d9c43-0985-4c50-b124-ec7c6615df40',
    '[-1.1726642,-0.24358885,-0.6181337,-0.24040663,0.8067098,1.3521034,1.4527551,0.12863281,0.5169561,-1.9030522,0.18038473,0.76136667,1.5987953,0.20787929,-1.8049815,1.1525464,1.1633046,0.8298613,-1.3968112,0.9456803,1.3281443,0.9644588,-1.081645,0.42566442,-0.57284707,0.8852961,-0.94504064,-0.6625988,-1.4648792,1.4055786,1.2245358,-1.2801378,0.37199095,-0.22260377,2.2079804,2.1108522,0.24640113,-0.88314587,-0.6216134,-1.6361982,-0.08123825,-0.025642766,0.4268265,2.0422516,0.22468938,-0.6752527,0.81271267,0.3345948,1.7333843,0.7266641,-0.7352619,0.52816457,-0.0022572726,-1.3317577,-0.9610403,0.22135077,0.9114865,0.07755977,0.04607691,-0.016134113,-0.035452902,0.47713438,1.0861579,-0.72317857,-1.4882119,0.09688655,-0.8407503,0.5603784,-2.5504422,0.22811586,-0.24001932,0.38816726,0.059882864,0.31364378,0.57611674,-0.7270671,-0.08513902,0.33494148,-0.023753643,-1.6402507,-2.0582886,0.9640565,-0.32947168,-0.8554013,-0.6258948,0.8970857,-1.793352,-1.7445158,-0.108370975,0.7934216,-0.39816433,0.10316709,0.19761276,-1.9093645,0.3574353,-1.2738063,0.08163455,0.9638505,-0.6253935,1.3599877,1.9933844,-1.5068177,-0.24859363,-1.0990483,-1.0241235,0.4800346,0.8866172,-2.3792105,1.1594542,0.1460005,1.0953573,-0.73234284,2.6068814,-0.34872854,-1.2378796,-0.4147709,-0.10568637,0.07620538,0.83492893,0.8600057,0.9072751,-0.36950865,0.48016524,0.14423943,0.73960465,-0.8331404,-0.6173585,1.8813912,1.2867185,0.35903546,1.0828726,1.1527168,0.57997364,1.8729527,-2.0517337,0.45960015,0.9465839,1.6405212,-0.5865667,1.2982619,1.913178,0.44109723,-0.16109146,-0.8317849,-0.3613026,-0.69798195,0.6060594,1.0916845,1.4606935,-0.40990326,0.3370852,-0.2022065,-0.007820934,0.69856346,-1.3842677,-1.4074423,0.763702,-0.85890144,-0.18676059,0.53419745,-0.029127315,0.7725606,0.25557,0.58821136,0.64749336,0.1844863,0.04335013,-1.1355739,-0.6182035,-1.421552,0.51982695,-1.0500007,-3.6731908,-1.1491895,-0.19075654,-1.0906277,-0.52460116,-0.023856953,-1.3877383,-1.3218163,0.23568338,-0.9549488,-0.53174573,0.57774895,-0.3719285,-0.4364863,0.39894852,0.78571475,1.7773124,-0.331173,-0.2578709,0.41336024,0.98305416,-1.4678237,-0.2243925,-0.7782769,-0.10971445,-0.39178935,-2.022573,-1.1307889,-0.823611,-1.6860416,0.07877974,2.075443,0.8821079,0.44102013,0.5205954,0.015311316,0.31674364,-0.30127794,-0.6768329,0.7899311,0.05286604,0.53136617,1.3883209,1.8490615,-0.93220377,0.31114647,-2.531989,-1.4412565,-0.14753214,-1.2755519,-0.46462572,-1.6924794,1.4447049,0.62039864,0.9022684,-0.7272247,-1.5734911,0.72480214,0.7883913,1.1751992,0.5126436,-0.20603167,-0.69336575,1.1821172,-0.61590815,-0.08312751,-0.7852945,1.3201772,0.06787839,1.8573054,-1.1796253,-1.0256802,0.37719283,0.33317536,-1.4227728,-0.13976909,-0.29233372,-1.1624312,-1.0017543,0.26391694,1.6674194,0.65521234,-1.4644378,-0.19957168,-0.46668893,1.3465352,-0.04690382,0.77946067,-0.046040513,-2.3235705,-0.44327518,1.2915244,-1.4076208,-1.1492381,1.6816399,1.0861146,-0.6392469,-1.5628856,0.1857169,-0.22043751,0.6322721,-1.2195573,-0.6210298,1.7560847,-0.984613,-0.25432986,-0.3289644,-0.088421755,-0.42072645,0.13343737,1.5068946,0.46613848,0.022679076,-1.4712373,-1.1950905,-1.5923826,-0.2521422,1.1664714,2.228488,-1.3840464,-1.1487204,0.45013416,0.9069057,0.32787117,-1.4574093,-2.1693103,0.29304558,-1.448457,-0.8462949,-0.7036524,-1.5187827,1.3895223,-0.30854633,0.70876586,0.59850675,-0.15349597,1.0615561,-0.30213177,0.21392594,0.04162568,0.24845192,1.1023678,0.11905817,-0.9638286,0.84196806,1.17287,1.2193788,1.6155746,-0.12993594,1.1392623,0.3790815,0.15477692,0.37190115,1.1089239,-1.3057337,-0.36314166,0.041954353,1.069267,1.0519955,-0.63669956,-0.3890754,-0.5052148,2.144793,-0.9756358,-0.79152924,1.3592628,-0.6439928,0.6364018,0.8164061,1.2072675,0.32086515,-0.5493492,-0.3033499,-1.9864306,0.33097598,2.2868412,0.36888972,-0.16938096,-0.91531014,0.03671243,0.70948875,1.2442603,-0.61559534,0.21428275,0.00795234,-0.7466421,0.37279183,-0.7123786,1.3623545,-0.1876294,0.38346127,-0.9168256,0.117544316,-1.0979383,0.18844958,0.54471123,-0.08044094,1.4048629,0.4645223,-0.30026388,0.6883046,-0.11994377,-1.1659427,-0.17039788,-0.35348272,0.102360256,0.46132764,0.07222245,0.657926,-0.12388638,-0.8820852,-0.3437023,-0.37647545,0.64643633,-0.44721985,0.15061408,-0.6186672,-0.9315589,0.9414323,0.035771653,0.95890903,0.8478203,1.8867311,0.6938325,0.66133094,-0.5513744,0.64769554,1.3301916,0.48128664,-1.2877651,-0.5363217,-0.04028365,1.1306981,0.21779025,0.8947502,0.07315719,-0.11399478,-0.7872917,-1.1123676,0.58417225,0.11015707,-0.49324414,0.74994683,-0.44280675,0.70407593,0.2514207,0.04739124,0.123066835,-0.07920144,1.186059,1.3061006,-1.0938278,-0.8134891,-0.5082407,1.2331544,1.685423,-0.72032046,1.7678357,-1.8653738,0.6325359,-1.2556573,-2.2671375,-0.090816244,1.5595437,-0.4903159,-1.2779574,-0.12916578,-0.94319344,-0.07219582,0.30917257,-1.407427,1.2993406,0.05453852,0.52501225,0.4274741,-0.98538923,0.38092098,-2.045028,0.5968873,0.7343992,-1.4122168,0.045600712,-0.2018142,-1.1528169,0.77994317,-1.2381088,0.9808833,-0.6561486,-0.75722754,0.23809396,1.85683,1.18545,0.47559115,0.20025517,-1.044564,-0.27101296,0.21966645,-0.7410604,-2.6968248,0.40184334,-0.031871244,1.7646306,1.3261149,-1.1179994,-2.3974934,-1.1484544,-0.47245762,-0.3201119,0.52777076,0.2522286,0.11517447,-0.64299595,2.0279791,1.9606687,-0.3209691,0.46367386,0.60516894,0.040420175,-1.1016003,1.9979777,1.0274895,0.22859544,0.26826683,1.6513621,0.83303165,1.331626,0.7403731,-0.2716262,0.72799647,1.8571459,2.2023237,2.3681285,0.09452897,1.8719934,-0.31764558,-1.3877996,2.2342696,-1.2125862,-0.086686976,0.20713496]'
  ]
}

Chart Configuration

global:
      stopAll: false
    credentials:
      backblaze:
        type: s3
        url: "${BACKBLAZE_URL}"
        bucket: "${BACKBLAZE_BUCKET}-immich"
        accessKey: "${BACKBLAZE_ID}"
        secretKey: "${BACKBLAZE_KEY}"
        encrKey: "${BACKBLAZE_KEY}"
    ingress:
      main:
        enabled: true
        ingressClassName: external
        hosts:
          - host: immich.${DOMAIN_0}
        integrations:
          nginx:
            enabled: true
          certManager:
            certificateIssuer: domain-0-le-prod
            enabled: true
    cnpg:
      main:
        mode: recovery
        password: ${IMMICH_CNPG_PASSWORD}
        backups:
          enabled: true
          credentials: backblaze
        recovery:
          credentials: backblaze
    persistence:
      library:
        type: nfs
        server: ${TRUENAS_IP}
        path: ${IMMICH_NFS}/library
      uploads:
        type: nfs
        server: ${TRUENAS_IP}
        path: ${IMMICH_NFS}/uploads
      backups:
        type: nfs
        server: ${TRUENAS_IP}
        path: ${IMMICH_NFS}/backups
      thumbs:
        type: nfs
        server: ${TRUENAS_IP}
        path: ${IMMICH_NFS}/thumbs
      profile:
        type: nfs
        server: ${TRUENAS_IP}
        path: ${IMMICH_NFS}/profile
      video:
        type: nfs
        server: ${TRUENAS_IP}
        path: ${IMMICH_NFS}/video
      imports:
        enabled: true
        type: nfs
        path: ${IMMICH_NFS}/import
        mountPath: /mnt/imports
        server: ${TRUENAS_IP}
        targetSelectAll: true
        readOnly: true

Describe the bug

Immich migrated from pgvecto.rs to Vectorchord and the base cloudnative-pg image is using pgvecto.rs. Support will be dropped in future releases.

To Reproduce

1. Install immich chart with default values
2. Import media
3. Observe DB Dump failures
4. Run facial recognition
5. Observe Facial Recognition failures in microservices pod logs

Expected Behavior

PG to use Vectorchord and no index failures for db dump or facial recognition.

Screenshots

No response

Additional Context

No response

I've read and agree with the following

• I've checked all open and closed issues and my issue is not there.
• I've prefixed my issue title with [Chart-Name]

[PrivatePuffin]

To be honest, I'm a tad done with Immich at this point.
They keep pulling shit like this.

For reference:
https://github.com/tensorchord/cloudnative-vectorchord

[cavazos-apps]

Ah, yeah I can see how that would be annoying. Fairly new to it, likely will just wait until it's stable then. Was having some issues with nextcloud and was looking for an alternative but that's a different issue. Feel free to close as not planned.

[kqmaverick]

Immich, Stable? Good luck with that.

[kqmaverick]

Unless I am missing it pgvector has not been depreciated yet. Maybe just need to set the DB_VECTOR_EXTENSION for now? https://immich.app/docs/install/environment-variables#database

[cavazos-apps]

Unless I am missing it pgvector has not been depreciated yet. Maybe just need to set the DB_VECTOR_EXTENSION for now? https://immich.app/docs/install/environment-variables#database

The documentation says it should auto-detect based on installed extensions:

If not provided, the appropriate extension to use is auto-detected at startup by introspecting the database. When multiple 
extensions are installed, the order of preference is VectorChord, pgvecto.rs, pgvector.

And I've confirmed the default extension in the image used is pgvector. The errors being thrown mention pgvecto.rs so I'm not sure.

[kallegrens]

Hopefully stable this year.

[kqmaverick]

I was unable to reproduce your issue with ML, I updated mine last night to latest.