Search Does Not Work Logs Show QueryFailedError: pgvecto.rs: The given vector is invalid for input.

[Thoroslives]

The bug

I was having the issue getting error 500 like some others here when searching, I see they changed there CLIP model and removed hwacel openvino and then rebuilt smart search. I tried this but it wouldn't work. I then found that my tables seemed different. I followed a few peoples instructions through here and i ended up messing up and have dropped the index tables completely. I created them again but now i get this error and i cant seem to find any information on the github about it.

The dimensions were 512 as per the guide

I feel my DB is pretty far gone at this point i might just roll it back from a server backup i have and live with the 500 errors

The OS that Immich Server is running on

UNRAID 6.12.6

Version of Immich Server

1.95.1

Version of Immich Mobile App

1.95.0 build.122

Platform with the issue

• Server
• Web
• Mobile

Your docker-compose.yml content

Running the app from unraid community appstore

Your .env content

Running Stock as per appstore template

Reproduction steps

1. Attempt to search
2. Check Logs

Additional information

[Nest] 182 - 02/26/2024, 1:19:06 PM ERROR [QueryFailedError: pgvecto.rs: The given vector is invalid for input.
ADVICE: Check if dimensions and scalar type of the vector is matched with the index.
at PostgresQueryRunner.query (/app/immich/server/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async SelectQueryBuilder.loadRawResults (/app/immich/server/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2192:25)
at async SelectQueryBuilder.executeEntitiesAndRawResults (/app/immich/server/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2040:26)
at async SelectQueryBuilder.getRawAndEntities (/app/immich/server/node_modules/typeorm/query-builder/SelectQueryBuilder.js:684:29)
at async SelectQueryBuilder.getMany (/app/immich/server/node_modules/typeorm/query-builder/SelectQueryBuilder.js:750:25)
at async paginatedBuilder (/app/immich/server/dist/infra/infra.utils.js:49:19)
at async /app/immich/server/dist/infra/repositories/search.repository.js:74:23
at async EntityManager.transaction (/app/immich/server/node_modules/typeorm/entity-manager/EntityManager.js:73:28)
at async SearchRepository.searchSmart (/app/immich/server/dist/infra/repositories/search.repository.js:65:9)] Failed to search
[Nest] 182 - 02/26/2024, 1:19:06 PM ERROR [QueryFailedError: pgvecto.rs: The given vector is invalid for input.
ADVICE: Check if dimensions and scalar type of the vector is matched with the index.
at PostgresQueryRunner.query (/app/immich/server/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async SelectQueryBuilder.loadRawResults (/app/immich/server/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2192:25)
at async SelectQueryBuilder.executeEntitiesAndRawResults (/app/immich/server/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2040:26)
at async SelectQueryBuilder.getRawAndEntities (/app/immich/server/node_modules/typeorm/query-builder/SelectQueryBuilder.js:684:29)
at async SelectQueryBuilder.getMany (/app/immich/server/node_modules/typeorm/query-builder/SelectQueryBuilder.js:750:25)
at async paginatedBuilder (/app/immich/server/dist/infra/infra.utils.js:49:19)
at async /app/immich/server/dist/infra/repositories/search.repository.js:74:23
at async EntityManager.transaction (/app/immich/server/node_modules/typeorm/entity-manager/EntityManager.js:73:28)
at async SearchRepository.searchSmart (/app/immich/server/dist/infra/repositories/search.repository.js:65:9)] QueryFailedError: pgvecto.rs: The given vector is invalid for input.
ADVICE: Check if dimensions and scalar type of the vector is matched with the index.

[mertalev]

If you have a custom CLIP model, you need to change the 512 to the right number based on this.

[rickysarraf]

Should this be a setting in the UI ? Along with a check box saying Re-Initialize smart-search database ?

[rickysarraf]

Actually, I just learnt today that this is already the case :-)

immich_microservices       | [Nest] 7  - 04/27/2024, 4:46:31 PM     LOG [SystemConfigService] LogLevel=log (set via system config)
immich_microservices       | [Nest] 7  - 04/27/2024, 4:46:31 PM     LOG [MetadataRepository] Initializing metadata repository
immich_microservices       | [Nest] 7  - 04/27/2024, 4:46:31 PM     LOG [MetadataService] Initialized local reverse geocoder
immich_server              | [Nest] 7  - 04/27/2024, 4:47:02 PM     LOG [SystemConfigService] LogLevel=log (set via system config)
immich_server              | [Nest] 7  - 04/27/2024, 4:47:02 PM     LOG [SystemConfigService] LogLevel=log (set via system config)
immich_server              | [Nest] 7  - 04/27/2024, 4:47:02 PM     LOG [SearchRepository] Dimension size of model ViT-L-14-336__openai is 768, but database expects 512.
immich_server              | [Nest] 7  - 04/27/2024, 4:47:02 PM     LOG [SearchRepository] Updating database CLIP dimension size to 768.
immich_microservices       | [Nest] 7  - 04/27/2024, 4:47:02 PM     LOG [SystemConfigService] LogLevel=log (set via system config)
immich_microservices       | [Nest] 7  - 04/27/2024, 4:47:02 PM     LOG [MetadataRepository] Initializing metadata repository
immich_microservices       | [Nest] 7  - 04/27/2024, 4:47:02 PM     LOG [MetadataService] Initialized local reverse geocoder
immich_server              | [Nest] 7  - 04/27/2024, 4:47:02 PM     LOG [SearchRepository] Successfully updated database CLIP dimension size from 512 to 768.

[jsapede]

looks like i have similar error :

immich_server | [Nest] 7 - 05/15/2024, 12:03:35 PM ERROR [ImmichServer] [QueryFailedError: pgvecto.rs: The given vector is invalid for input.
immich_server | ADVICE: Check if dimensions and scalar type of the vector is matched with the index.

could you explain how you Re-Initialize smart-search database ?

[mertalev]

To fix that error, you can change the smart search model to another model, change it back, then re-run smart search on all assets.

[jsapede]

ok thanks !
i dont understand why it bugged (i tried to change the model) but it works again !