Hey, after following all the instructions I am still having issues with the postgress database.
I updated immich from 134.0 to 137.3
Now immich is getting an error at startup, it is trying to update something called “vchord” but fails in doing so. It is suggesting to do it manually but I can’t figure it out how.
2025-08-04 06:51:17.208905+00:00Please run ‘ALTER EXTENSION vchord UPDATE’ manually as a superuser.
Does somebody have encountered this issue or know what should I do?
2025-08-04 06:51:13.428600+00:00Initializing Immich v1.137.3
2025-08-04 06:51:13.431419+00:00Detected CPU Cores: 4
2025-08-04 06:51:15.185387+00:00Starting api worker
2025-08-04 06:51:15.189894+00:00Starting microservices worker
2025-08-04 06:51:17.098652+00:00e[32m[Nest] 7 - e[39m08/03/2025, 11:51:17 PM e[32m LOGe[39m e[33m[Microservices:EventRepository]e[39m e[32mInitialized websocket servere[39m
2025-08-04 06:51:17.167034+00:00Postgres notice: {
2025-08-04 06:51:17.167070+00:00severity_local: 'WARNING',
2025-08-04 06:51:17.167079+00:00severity: 'WARNING',
2025-08-04 06:51:17.167086+00:00code: '42602',
2025-08-04 06:51:17.167092+00:00message: 'invalid configuration parameter name "vchordrq.prewarm_dim"',
2025-08-04 06:51:17.167098+00:00detail: '"vchordrq" is a reserved prefix.',
2025-08-04 06:51:17.167105+00:00file: 'guc.c',
2025-08-04 06:51:17.167111+00:00line: '5718',
2025-08-04 06:51:17.167118+00:00routine: 'find_option'
2025-08-04 06:51:17.167125+00:00}
2025-08-04 06:51:17.185048+00:00Postgres notice: {
2025-08-04 06:51:17.185081+00:00severity_local: 'WARNING',
2025-08-04 06:51:17.185090+00:00severity: 'WARNING',
2025-08-04 06:51:17.185097+00:00code: '42602',
2025-08-04 06:51:17.185103+00:00message: 'invalid configuration parameter name "vchordrq.prewarm_dim"',
2025-08-04 06:51:17.185109+00:00detail: '"vchordrq" is a reserved prefix.',
2025-08-04 06:51:17.185116+00:00file: 'guc.c',
2025-08-04 06:51:17.185122+00:00line: '5718',
2025-08-04 06:51:17.185128+00:00routine: 'find_option'
2025-08-04 06:51:17.185147+00:00}
2025-08-04 06:51:17.194702+00:00e[32m[Nest] 7 - e[39m08/03/2025, 11:51:17 PM e[32m LOGe[39m e[33m[Microservices:DatabaseService]e[39m e[32mUpdating VectorChord extension to 0.4.3e[39m
2025-08-04 06:51:17.203244+00:00Query failed : {
2025-08-04 06:51:17.203284+00:00durationMs: 1.7626599999998689,
2025-08-04 06:51:17.203292+00:00error: PostgresError: tuple concurrently updated
2025-08-04 06:51:17.203299+00:00at ErrorResponse (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:794:26)
2025-08-04 06:51:17.203306+00:00at handle (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:480:6)
2025-08-04 06:51:17.203312+00:00at Socket.data (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:315:9)
2025-08-04 06:51:17.203319+00:00at Socket.emit (node:events:518:28)
2025-08-04 06:51:17.203325+00:00at addChunk (node:internal/streams/readable:561:12)
2025-08-04 06:51:17.203331+00:00at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
2025-08-04 06:51:17.203338+00:00at Readable.push (node:internal/streams/readable:392:5)
2025-08-04 06:51:17.203344+00:00at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
2025-08-04 06:51:17.203350+00:00severity_local: 'ERROR',
2025-08-04 06:51:17.203357+00:00severity: 'ERROR',
2025-08-04 06:51:17.203363+00:00code: 'XX000',
2025-08-04 06:51:17.203370+00:00file: 'heapam.c',
2025-08-04 06:51:17.203376+00:00line: '4373',
2025-08-04 06:51:17.203382+00:00routine: 'simple_heap_update'
2025-08-04 06:51:17.203388+00:00},
2025-08-04 06:51:17.203394+00:00sql: "ALTER EXTENSION vchord UPDATE TO '0.4.3'",
2025-08-04 06:51:17.203401+00:00params: []
2025-08-04 06:51:17.203407+00:00}
2025-08-04 06:51:17.208873+00:00e[33m[Nest] 7 - e[39m08/03/2025, 11:51:17 PM e[33m WARNe[39m e[33m[Microservices:DatabaseService]e[39m e[33mThe VectorChord extension can be updated to 0.4.3.
2025-08-04 06:51:17.208885+00:00Immich attempted to update the extension, but failed to do so.
2025-08-04 06:51:17.208892+00:00This may be because Immich does not have the necessary permissions to update the extension.
2025-08-04 06:51:17.208899+00:002025-08-04T06:51:17.208899232Z
2025-08-04 06:51:17.208905+00:00Please run 'ALTER EXTENSION vchord UPDATE' manually as a superuser.
2025-08-04 06:51:17.208911+00:00See https://immich.app/docs/guides/database-queries for how to query the database.e[39m
2025-08-04 06:51:17.209103+00:00Postgres notice: {
2025-08-04 06:51:17.209119+00:00severity_local: 'WARNING',
2025-08-04 06:51:17.209126+00:00severity: 'WARNING',
2025-08-04 06:51:17.209132+00:00code: '42602',
2025-08-04 06:51:17.209139+00:00message: 'invalid configuration parameter name "vchordrq.prewarm_dim"',
2025-08-04 06:51:17.209145+00:00detail: '"vchordrq" is a reserved prefix.',
2025-08-04 06:51:17.209151+00:00file: 'guc.c',
2025-08-04 06:51:17.209157+00:00line: '5718',
2025-08-04 06:51:17.209163+00:00routine: 'find_option'
2025-08-04 06:51:17.209170+00:00}
2025-08-04 06:51:17.213781+00:00PostgresError: tuple concurrently updated
2025-08-04 06:51:17.214745+00:00at ErrorResponse (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:794:26)
2025-08-04 06:51:17.214765+00:00at handle (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:480:6)
2025-08-04 06:51:17.214772+00:00at Socket.data (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:315:9)
2025-08-04 06:51:17.214778+00:00at Socket.emit (node:events:518:28)
2025-08-04 06:51:17.214784+00:00at addChunk (node:internal/streams/readable:561:12)
2025-08-04 06:51:17.214791+00:00at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
2025-08-04 06:51:17.214797+00:00at Readable.push (node:internal/streams/readable:392:5)
2025-08-04 06:51:17.214803+00:00at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
2025-08-04 06:51:17.214809+00:00severity_local: 'ERROR',
2025-08-04 06:51:17.214815+00:00severity: 'ERROR',
2025-08-04 06:51:17.214821+00:00code: 'XX000',
2025-08-04 06:51:17.214827+00:00file: 'heapam.c',
2025-08-04 06:51:17.214833+00:00line: '4373',
2025-08-04 06:51:17.214840+00:00routine: 'simple_heap_update'
2025-08-04 06:51:17.214846+00:00}
2025-08-04 06:51:17.215475+00:00microservices worker error: PostgresError: tuple concurrently updated, stack: PostgresError: tuple concurrently updated
2025-08-04 06:51:17.215509+00:00at ErrorResponse (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:794:26)
2025-08-04 06:51:17.215516+00:00at handle (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:480:6)
2025-08-04 06:51:17.215523+00:00at Socket.data (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:315:9)
2025-08-04 06:51:17.215529+00:00at Socket.emit (node:events:518:28)
2025-08-04 06:51:17.215535+00:00at addChunk (node:internal/streams/readable:561:12)
2025-08-04 06:51:17.215542+00:00at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
2025-08-04 06:51:17.215548+00:00at Readable.push (node:internal/streams/readable:392:5)
2025-08-04 06:51:17.215554+00:00at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
2025-08-04 06:51:17.229382+00:00microservices worker exited with code 1
2025-08-04 06:51:17.229460+00:00Killing api process