immich-app/immich
1
0
Fork 0
mirror of https://github.com/immich-app/immich.git synced 2026-02-25 03:12:21 +03:00
Code Issues 783 Packages Projects Releases 12 Wiki Activity

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

New Issue
Closed
opened 2026-02-05 05:55:02 +03:00 by OVERLORD · 0 comments
OVERLORD commented 2026-02-05 05:55:02 +03:00
Owner
Copy Link

Originally created by @Thoroslives on GitHub (Feb 26, 2024).

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.

Originally created by @Thoroslives on GitHub (Feb 26, 2024). ### 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 - [X] Server - [ ] Web - [ ] Mobile ### Your docker-compose.yml content ```YAML Running the app from unraid community appstore ``` ### Your .env content ```Shell Running Stock as per appstore template ``` ### Reproduction steps ```bash 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.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
accessibility
changelog:enhancement
changelog:security
changelog:skip
changelog:translation
cli
date-time
dependencies
documentation
external-library
format
good first issue
mobile-beta
mobile-beta
mobile-beta
needs-answer
nice to have
pull-request
Mirrored from GitHub Pull Request
 sharing
tech-debt
📱mobile
🖥️web
🗄️server
🧠machine-learning
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
OVERLORD
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: immich-app/immich#2269
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?