WARN [Microservices:DatabaseService] Could not run vector reindexing checks. If the extension was updated, please restart the Postgres instance.

[Handrail9]

Not really sure what's going on. I keep getting this error and I can't figure out how to fix it. It appeared after a power cycle of the host machine due to a power outage. I tried enabling the "full PostgreSQL log" but I can't tell if it actually worked or if I did something wrong. I also tried bash on the postgres container and running some commands I found that seemed related to this error but nothing has changed so far.

immich_server            | [Nest] 7  - 01/17/2025, 2:08:28 AM     LOG [Microservices:EventRepository] Initialized websocket server
immich_server            | [Nest] 17  - 01/17/2025, 2:08:28 AM     LOG [Api:EventRepository] Initialized websocket server
immich_server            | [Nest] 7  - 01/17/2025, 2:08:43 AM    WARN [Microservices:DatabaseService] Could not run vector reindexing checks. If the extension was updated, please restart the Postgres instance.
immich_server            | QueryFailedError: pgvecto.rs: IPC connection is closed unexpected.
immich_server            | ADVICE: The error is raisen by background worker errors. Please check the full PostgreSQL log to get more information. Please read `https://docs.pgvecto.rs/admin/configuration.html`.
immich_server            |     at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
immich_server            |     at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
immich_server            |     at async DataSource.query (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:350:20)
immich_server            |     at async DatabaseRepository.shouldReindex (/usr/src/app/dist/repositories/database.repository.js:136:25)
immich_server            |     at async DatabaseService.checkReindexing (/usr/src/app/dist/services/database.service.js:144:17)
immich_server            |     at async /usr/src/app/dist/services/database.service.js:93:13
immich_server            |     at async /usr/src/app/dist/repositories/database.repository.js:197:23 {
immich_server            |   query: 'SELECT idx_status FROM pg_vector_index_stat WHERE indexname = $1',
immich_server            |   parameters: [ 'clip_index' ],
immich_server            |   driverError: error: pgvecto.rs: IPC connection is closed unexpected.
immich_server            |   ADVICE: The error is raisen by background worker errors. Please check the full PostgreSQL log to get more information. Please read `https://docs.pgvecto.rs/admin/configuration.html`.
immich_server            |       at /usr/src/app/node_modules/pg/lib/client.js:535:17
immich_server            |       at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
immich_server            |       at async PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:184:25)
immich_server            |       at async DataSource.query (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:350:20)
immich_server            |       at async DatabaseRepository.shouldReindex (/usr/src/app/dist/repositories/database.repository.js:136:25)
immich_server            |       at async DatabaseService.checkReindexing (/usr/src/app/dist/services/database.service.js:144:17)
immich_server            |       at async /usr/src/app/dist/services/database.service.js:93:13
immich_server            |       at async /usr/src/app/dist/repositories/database.repository.js:197:23 {
immich_server            |     length: 272,
immich_server            |     severity: 'ERROR',
immich_server            |     code: 'XX000',
immich_server            |     detail: undefined,
immich_server            |     hint: undefined,
immich_server            |     position: undefined,
immich_server            |     internalPosition: undefined,
immich_server            |     internalQuery: undefined,
immich_server            |     where: undefined,
immich_server            |     schema: undefined,
immich_server            |     table: undefined,
immich_server            |     column: undefined,
immich_server            |     dataType: undefined,
immich_server            |     constraint: undefined,
immich_server            |     file: 'error.rs',
immich_server            |     line: '7',
immich_server            |     routine: undefined
immich_server            |   },
immich_server            |   length: 272,
immich_server            |   severity: 'ERROR',
immich_server            |   code: 'XX000',
immich_server            |   detail: undefined,
immich_server            |   hint: undefined,
immich_server            |   position: undefined,
immich_server            |   internalPosition: undefined,
immich_server            |   internalQuery: undefined,
immich_server            |   where: undefined,
immich_server            |   schema: undefined,
immich_server            |   table: undefined,
immich_server            |   column: undefined,
immich_server            |   dataType: undefined,
immich_server            |   constraint: undefined,
immich_server            |   file: 'error.rs',
immich_server            |   line: '7',
immich_server            |   routine: undefined
immich_server            | }
immich_server            | microservices worker error: QueryFailedError: pgvecto.rs: IPC connection is closed unexpected.
immich_server            | ADVICE: The error is raisen by background worker errors. Please check the full PostgreSQL log to get more information. Please read `https://docs.pgvecto.rs/admin/configuration.html`.
immich_server            | microservices worker exited with code 1
immich_server            | Killing api process

[YowFung]

Is there a solution?
@Handrail9

[Handrail9]

Not that I am currently aware of

[Handrail9]

@YowFung Got a solution that works for me from the discord with the help of Mraedis, mertalev and bo0tzz.

1. Stop your Immich containers
2. Locate your postgres volume (Should be specified in your .env file), and move ./postgres/pg_vectors somewhere outside of immich.
3. Start immich
4. bash into your postgres container, log in and run
   DROP INDEX IF EXISTS clip_index;
   SET vectors.pgvector_compatibility=on;

CREATE INDEX clip_index ON smart_search
USING hnsw (embedding vector_cosine_ops)
WITH (ef_construction = 300, m = 16);
5. Wait a couple minutes and you should be good IF YOU HAVE THE EXACT SAME ERROR I DID
Good luck :)

[Handrail9]

Are bumps acceptable here? I've been a week without my immich library and I cant figure out what I need to do :(