shinynecrid Comments - Answer Overflow

[Nest] 7  - 05/22/2025, 9:49:10 PM   FATAL [Microservices:DatabaseService] Failed to activate VectorChord extension.

    Please ensure the Postgres instance has VectorChord installed.

    If the Postgres instance already has VectorChord installed, Immich may not have the necessary permissions to activate it.

    In this case, please run 'CREATE EXTENSION IF NOT EXISTS vchord CASCADE' manually as a superuser.

    See https://immich.app/docs/guides/database-queries for how to query the database.

PostgresError: vchord must be loaded via shared_preload_libraries.

    at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26)

    at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6)

    at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)

    at Socket.emit (node:events:518: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: 'lib.rs',

  line: '15',

  routine: 'vchord::_PG_init::_PG_init_inner'

}

microservices worker error: PostgresError: vchord must be loaded via shared_preload_libraries., stack: PostgresError: vchord must be loaded via shared_preload_libraries.

    at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26)

    at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6)

    at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)

    at Socket.emit (node:events:518: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)

microservices worker exited with code 1

Killing api process

Initializing Immich v1.133.0

Detected CPU Cores: 4

Starting api worker

Starting microservices worker

[Nest] 7  - 05/22/2025, 9:49:10 PM   FATAL [Microservices:DatabaseService] Failed to activate VectorChord extension.

    Please ensure the Postgres instance has VectorChord installed.

    If the Postgres instance already has VectorChord installed, Immich may not have the necessary permissions to activate it.

    In this case, please run 'CREATE EXTENSION IF NOT EXISTS vchord CASCADE' manually as a superuser.

    See https://immich.app/docs/guides/database-queries for how to query the database.

PostgresError: vchord must be loaded via shared_preload_libraries.

    at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26)

    at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6)

    at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)

    at Socket.emit (node:events:518: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: 'lib.rs',

  line: '15',

  routine: 'vchord::_PG_init::_PG_init_inner'

}

microservices worker error: PostgresError: vchord must be loaded via shared_preload_libraries., stack: PostgresError: vchord must be loaded via shared_preload_libraries.

    at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26)

    at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6)

    at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)

    at Socket.emit (node:events:518: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)

microservices worker exited with code 1

Killing api process

Initializing Immich v1.133.0

Detected CPU Cores: 4

Starting api worker

Starting microservices worker