Andrew_S
IImmich
•Created by Andrew_S on 2/7/2025 in #help-desk-support
Smart Search doesn't work. Shows immich server error.
Parsing the logs it seems like pgvector extension fails to read vector value.
The error points to a bad character with ASCII 0x30, which is zero
In particular this query fails:
SELECT "assets".*, to_json("exif") as "exifInfo"
FROM "assets"
INNER JOIN "exif" ON "assets"."id" = "exif"."assetId"
INNER JOIN "smart_search" ON "assets"."id" = "smart_search"."assetId"
WHERE "assets"."ownerId" = ANY($1::uuid[])
AND "assets"."isVisible" = $2
AND "assets"."isArchived" = $3
AND "assets"."deletedAt" IS NULL
ORDER BY smart_search.embedding <=> $4
LIMIT $5 OFFSET $6
Any clue how to fix that?
9 replies