Smart Search not working on release - v1.125.6 #15766

LuD1161 · 2025-01-29T16:59:55Z

LuD1161
Jan 29, 2025

The bug

Hello team,

Thanks for the awesome product.
I updated immich to v1.125.6 and am seeing this error on smart search. This is the bug I am facing -

Failed to search smart (Immich Server Error)

I am running immich as a docker compose -

Server Version

immich postgres logs

2025-01-29 04:36:42.652 UTC [113] ERROR:  pgvecto.rs: Bad literal.

	INFORMATION: hint = Bad character with ascii 0x2d.
2025-01-29 04:36:42.652 UTC [113] CONTEXT:  unnamed portal parameter $2 = '...'
2025-01-29 04:36:42.652 UTC [113] STATEMENT:  insert into "smart_search" ("assetId", "embedding") values ($1::uuid, $2) on conflict ("assetId") do update set "embedding" = $3
2025-01-29 04:36:42.656 UTC [69] ERROR:  pgvecto.rs: Bad literal.

	INFORMATION: hint = Bad character with ascii 0x2d.
2025-01-29 04:36:42.656 UTC [69] CONTEXT:  unnamed portal parameter $2 = '...'
2025-01-29 04:36:42.656 UTC [69] STATEMENT:  insert into "smart_search" ("assetId", "embedding") values ($1::uuid, $2) on conflict ("assetId") do update set "embedding" = $3
2025-01-29 04:49:35.843 UTC [79] ERROR:  pgvecto.rs: Bad literal.

	INFORMATION: hint = Bad character with ascii 0x30.
2025-01-29 04:49:35.843 UTC [79] CONTEXT:  unnamed portal parameter $4 = '...'
2025-01-29 04:49:35.843 UTC [79] STATEMENT:  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
2025-01-29 06:48:45.512 UTC [472] ERROR:  pgvecto.rs: Bad literal.

	INFORMATION: hint = Bad character with ascii 0x30.
2025-01-29 06:48:45.512 UTC [472] CONTEXT:  unnamed portal parameter $2 = '...'
2025-01-29 06:48:45.512 UTC [472] STATEMENT:  insert into "smart_search" ("assetId", "embedding") values ($1::uuid, $2) on conflict ("assetId") do update set "embedding" = $3
2025-01-29 16:33:04.463 UTC [2365] ERROR:  pgvecto.rs: Bad literal.

	INFORMATION: hint = Bad character with ascii 0x30.
2025-01-29 16:33:04.463 UTC [2365] CONTEXT:  unnamed portal parameter $4 = '...'
2025-01-29 16:33:04.463 UTC [2365] STATEMENT:  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

immich server logs

2025-01-29T16:33:04.464893356Z   sql: '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',
2025-01-29T16:33:04.464903916Z   params: [
2025-01-29T16:33:04.464910728Z     '{566b512c-bf0b-499a-9e75-a303bdd4a6cb}',
2025-01-29T16:33:04.464917801Z     true,
2025-01-29T16:33:04.464924774Z     false,
2025-01-29T16:33:04.464931547Z     [
2025-01-29T16:33:04.464938179Z          0.03438305,   -0.0039922805,  -0.035299666, -0.011745944,
2025-01-29T16:33:04.464945413Z        0.0008810943,    0.0042589614,  -0.023644619, -0.109826535,
2025-01-29T16:33:04.464952315Z       -0.0024685622,     0.030193796,  0.0054982645, -0.029647326,
2025-01-29T16:33:04.464959288Z         0.010167585,     -0.06628607,   0.035559535,  0.034497846,
2025-01-29T16:33:04.464966241Z        0.0070405877,    -0.013231606,  -0.021678237,   0.04845447,
2025-01-29T16:33:04.464972843Z          0.04536473,    0.0013058144,  0.0041307863,  0.021857943,
2025-01-29T16:33:04.464979436Z        -0.049352102,     0.005661142,  -0.020661008, -0.031669583,
2025-01-29T16:33:04.464986298Z        0.0060676234,     0.033778388,  -0.067927904,  0.020547744,
2025-01-29T16:33:04.464992921Z        -0.024290219,    -0.030969612,   -0.02683663,   0.03226615,
2025-01-29T16:33:04.465000856Z        0.0054513207,    -0.010438763,  -0.055654105,  0.012751421,
2025-01-29T16:33:04.465007828Z         0.044819582,     -0.01693526,   0.009037694, -0.040353946,
2025-01-29T16:33:04.465014691Z         0.012040831,    0.0054741073, -0.0070524067, -0.030281967,
2025-01-29T16:33:04.465021995Z       -0.0059282193,   -0.0045499927,   0.011425865, -0.024093695,
2025-01-29T16:33:04.465028898Z         0.037319046,     0.018298548,  -0.011946825,  -0.04854716,
2025-01-29T16:33:04.465035600Z         0.018672459,    -0.045897994,   0.022947017,  0.042828325,
2025-01-29T16:33:04.465042483Z          0.01875422,     -0.06881133,  -0.008909957, -0.026967634,
2025-01-29T16:33:04.465049336Z        -0.023485435,    -0.058724787,  -0.049769565,  0.031365182,
2025-01-29T16:33:04.465056489Z        -0.015569258,    0.0035234662,  0.0048468392,  -0.07755273,
2025-01-29T16:33:04.465063873Z        0.0040942277,    0.0080939215,  -0.011192934, -0.004168612,
2025-01-29T16:33:04.465071096Z        -0.007088193,     0.017981136,  0.0012953025,  -0.01841601,
2025-01-29T16:33:04.465077578Z        -0.044893164,    -0.009435973,  -0.042443164,  0.004004369,
2025-01-29T16:33:04.465093728Z         0.021441806, -0.000061570056,  -0.017892808, -0.060524702,
2025-01-29T16:33:04.465101052Z        -0.062941216,    0.0011523172,  -0.042431254, -0.004605327,
2025-01-29T16:33:04.465108055Z         -0.13594183,     0.035053976,  -0.018202454,  0.032966014,
2025-01-29T16:33:04.465114797Z        -0.017059522,     0.011407024,    0.01381222, -0.031854697,
2025-01-29T16:33:04.465121469Z       ... 412 more items
2025-01-29T16:33:04.465128222Z     ],
2025-01-29T16:33:04.465134684Z     101,
2025-01-29T16:33:04.465141617Z     0
2025-01-29T16:33:04.465148570Z   ]
2025-01-29T16:33:04.465155232Z }
2025-01-29T16:33:04.465317674Z [Nest] 16  - 01/29/2025, 4:33:04 PM   ERROR [Api:PostgresError: pgvecto.rs: Bad literal.
2025-01-29T16:33:04.465324597Z INFORMATION: hint = Bad character with ascii 0x30.
2025-01-29T16:33:04.465327292Z     at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:788:26)
2025-01-29T16:33:04.465329436Z     at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:474:6)
2025-01-29T16:33:04.465331359Z     at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)
2025-01-29T16:33:04.465333333Z     at Socket.emit (node:events:524:28)
2025-01-29T16:33:04.465335276Z     at addChunk (node:internal/streams/readable:561:12)
2025-01-29T16:33:04.465337120Z     at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
2025-01-29T16:33:04.465339013Z     at Readable.push (node:internal/streams/readable:392:5)
2025-01-29T16:33:04.465340897Z     at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
2025-01-29T16:33:04.465342800Z     at TCP.callbackTrampoline (node:internal/async_hooks:130:17)~y0fyrnaa] Unknown error: PostgresError: pgvecto.rs: Bad literal.
2025-01-29T16:33:04.465344814Z INFORMATION: hint = Bad character with ascii 0x30.

### The OS that Immich Server is running on

Debian 12

### Version of Immich Server

v1.125.6

### Version of Immich Mobile App

na

### Platform with the issue

- [x] Server
- [ ] Web
- [ ] Mobile

### Your docker-compose.yml content

```YAML
name: big-bear-immich
services:
  database:
    cpu_shares: 90
    command: []
    container_name: immich-postgres
    deploy:
      resources:
        limits:
          memory: 28889M
    environment:
      - PG_DATA=/var/lib/postgresql/data
      - POSTGRES_DB=immich
      - POSTGRES_PASSWORD=casaos
      - POSTGRES_USER=casaos
    hostname: immich-postgres
    image: tensorchord/pgvecto-rs:pg14-v0.2.0@sha256:90724186f0a3517cf6914295b5ab410db9ce23190a2d9d0b9dd6463e3fa298f0
    labels:
      icon: https://cdn.jsdelivr.net/gh/walkxcode/dashboard-icons/png/immich.png
    restart: unless-stopped
    volumes:
      - type: bind
        source: /DATA/AppData/big-bear-immich/pgdata
        target: /var/lib/postgresql/data
        bind:
          create_host_path: true
    x-casaos:
      envs:
        - container: POSTGRES_PASSWORD
          description:
            en_us: Database Password
        - container: POSTGRES_USER
          description:
            en_us: Database Username
        - container: POSTGRES_DB
          description:
            en_us: Database Name
        - container: PG_DATA
          description:
            en_us: "Container Path: /var/lib/postgresql/data"
      volumes:
        - container: /var/lib/postgresql/data
          description:
            en_us: "Container Path: /var/lib/postgresql/data"
    ports: []
    devices: []
    cap_add: []
    networks:
      - big_bear_immich_network
    privileged: false
  immich-machine-learning:
    cpu_shares: 90
    command: []
    container_name: immich-machine-learning
    deploy:
      resources:
        limits:
          memory: 28889M
    environment:
      - DB_DATABASE_NAME=casaos
      - DB_HOSTNAME=immich-postgres
      - DB_PASSWORD=casaos
      - DB_PORT=5432
      - DB_USERNAME=casaos
      - REDIS_HOSTNAME=immich-redis
    hostname: immich-machine-learning
    image: ghcr.io/immich-app/immich-machine-learning:v1.123.0
    labels:
      icon: https://cdn.jsdelivr.net/gh/walkxcode/dashboard-icons/png/immich.png
    restart: unless-stopped
    volumes:
      - type: bind
        source: /DATA/AppData/big-bear-immich/model-cache
        target: /cache
        bind:
          create_host_path: true
    x-casaos:
      envs:
        - container: DB_HOSTNAME
          description:
            en_us: Database Hostname
        - container: DB_USERNAME
          description:
            en_us: Database Username
        - container: DB_PASSWORD
          description:
            en_us: Database Password
        - container: DB_DATABASE_NAME
          description:
            en_us: Database Name
        - container: DB_PORT
          description:
            en_us: Database Port
        - container: REDIS_HOSTNAME
          description:
            en_us: Redis Hostname
      volumes:
        - container: /cache
          description:
            en_us: "Container Path: /cache"
    ports: []
    devices: []
    cap_add: []
    networks:
      - big_bear_immich_network
    privileged: false
  immich-server:
    cpu_shares: 90
    command: []
    container_name: immich-server
    depends_on:
      database:
        condition: service_started
        required: true
      redis:
        condition: service_started
        required: true
    deploy:
      resources:
        limits:
          memory: 28889M
    environment:
      - DB_DATABASE_NAME=immich
      - DB_HOSTNAME=immich-postgres
      - DB_PASSWORD=casaos
      - DB_PORT=5432
      - DB_USERNAME=casaos
      - IMMICH_MACHINE_LEARNING_URL=http://immich-machine-learning:3003
      - REDIS_HOSTNAME=immich-redis
    hostname: immich-server
    image: ghcr.io/immich-app/immich-server:release
    labels:
      icon: https://cdn.jsdelivr.net/gh/walkxcode/dashboard-icons/png/immich.png
    ports:
      - mode: ingress
        target: 2283
        published: "2283"
        protocol: tcp
    restart: unless-stopped
    volumes:
      - type: bind
        source: /DATA/AppData/big-bear-immich/upload
        target: /usr/src/app/upload
        bind:
          create_host_path: true
    x-casaos:
      envs:
        - container: DB_HOSTNAME
          description:
            en_us: Database Hostname
        - container: DB_USERNAME
          description:
            en_us: Database Username
        - container: DB_PASSWORD
          description:
            en_us: Database Password
        - container: DB_DATABASE_NAME
          description:
            en_us: Database Name
        - container: DB_PORT
          description:
            en_us: Database Port
        - container: REDIS_HOSTNAME
          description:
            en_us: Redis Hostname
        - container: IMMICH_MACHINE_LEARNING_URL
          description:
            en_us: Immich Machine Learning URL
      ports:
        - container: "2283"
          description:
            en_us: "Container Port: 2283"
      volumes:
        - container: /usr/src/app/upload
          description:
            en_us: "Container Path: /usr/src/app/upload"
    devices: []
    cap_add: []
    networks:
      - big_bear_immich_network
    privileged: false
  redis:
    cpu_shares: 90
    command: []
    container_name: immich-redis
    deploy:
      resources:
        limits:
          memory: 28889M
    hostname: immich-redis
    image: redis:6.2-alpine@sha256:70a7a5b641117670beae0d80658430853896b5ef269ccf00d1827427e3263fa3
    labels:
      icon: https://cdn.jsdelivr.net/gh/walkxcode/dashboard-icons/png/immich.png
    restart: always
    ports: []
    volumes: []
    devices: []
    cap_add: []
    environment: []
    networks:
      - big_bear_immich_network
    privileged: false
networks:
  big_bear_immich_network:
    name: big-bear-immich_big_bear_immich_network
    driver: bridge
x-casaos:
  architectures:
    - amd64
    - arm64
  author: BigBearTechWorld
  category: BigBearCasaOS
  description:
    en_us: Self-hosted photo and video storage.
  developer: ""
  hostname: ""
  icon: https://cdn.jsdelivr.net/gh/walkxcode/dashboard-icons/png/immich.png
  index: /
  is_uncontrolled: true
  main: immich-server
  port_map: "2283"
  scheme: http
  store_app_id: big-bear-immich
  tagline:
    en_us: Immich
  thumbnail: ""
  title:
    custom: ""
    en_us: Immich

Your .env content

nothing

Reproduction steps

Upgrade immich to v1.125.6
Search in the smart search
You'll see the error

Relevant log output

2025-01-29T16:33:04.464893356Z   sql: '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',
2025-01-29T16:33:04.464903916Z   params: [
2025-01-29T16:33:04.464910728Z     '{566b512c-bf0b-499a-9e75-a303bdd4a6cb}',
2025-01-29T16:33:04.464917801Z     true,
2025-01-29T16:33:04.464924774Z     false,
2025-01-29T16:33:04.464931547Z     [
2025-01-29T16:33:04.464938179Z          0.03438305,   -0.0039922805,  -0.035299666, -0.011745944,
2025-01-29T16:33:04.464945413Z        0.0008810943,    0.0042589614,  -0.023644619, -0.109826535,
2025-01-29T16:33:04.464952315Z       -0.0024685622,     0.030193796,  0.0054982645, -0.029647326,
2025-01-29T16:33:04.464959288Z         0.010167585,     -0.06628607,   0.035559535,  0.034497846,
2025-01-29T16:33:04.464966241Z        0.0070405877,    -0.013231606,  -0.021678237,   0.04845447,
2025-01-29T16:33:04.464972843Z          0.04536473,    0.0013058144,  0.0041307863,  0.021857943,
2025-01-29T16:33:04.464979436Z        -0.049352102,     0.005661142,  -0.020661008, -0.031669583,
2025-01-29T16:33:04.464986298Z        0.0060676234,     0.033778388,  -0.067927904,  0.020547744,
2025-01-29T16:33:04.464992921Z        -0.024290219,    -0.030969612,   -0.02683663,   0.03226615,
2025-01-29T16:33:04.465000856Z        0.0054513207,    -0.010438763,  -0.055654105,  0.012751421,
2025-01-29T16:33:04.465007828Z         0.044819582,     -0.01693526,   0.009037694, -0.040353946,
2025-01-29T16:33:04.465014691Z         0.012040831,    0.0054741073, -0.0070524067, -0.030281967,
2025-01-29T16:33:04.465021995Z       -0.0059282193,   -0.0045499927,   0.011425865, -0.024093695,
2025-01-29T16:33:04.465028898Z         0.037319046,     0.018298548,  -0.011946825,  -0.04854716,
2025-01-29T16:33:04.465035600Z         0.018672459,    -0.045897994,   0.022947017,  0.042828325,
2025-01-29T16:33:04.465042483Z          0.01875422,     -0.06881133,  -0.008909957, -0.026967634,
2025-01-29T16:33:04.465049336Z        -0.023485435,    -0.058724787,  -0.049769565,  0.031365182,
2025-01-29T16:33:04.465056489Z        -0.015569258,    0.0035234662,  0.0048468392,  -0.07755273,
2025-01-29T16:33:04.465063873Z        0.0040942277,    0.0080939215,  -0.011192934, -0.004168612,
2025-01-29T16:33:04.465071096Z        -0.007088193,     0.017981136,  0.0012953025,  -0.01841601,
2025-01-29T16:33:04.465077578Z        -0.044893164,    -0.009435973,  -0.042443164,  0.004004369,
2025-01-29T16:33:04.465093728Z         0.021441806, -0.000061570056,  -0.017892808, -0.060524702,
2025-01-29T16:33:04.465101052Z        -0.062941216,    0.0011523172,  -0.042431254, -0.004605327,
2025-01-29T16:33:04.465108055Z         -0.13594183,     0.035053976,  -0.018202454,  0.032966014,
2025-01-29T16:33:04.465114797Z        -0.017059522,     0.011407024,    0.01381222, -0.031854697,
2025-01-29T16:33:04.465121469Z       ... 412 more items
2025-01-29T16:33:04.465128222Z     ],
2025-01-29T16:33:04.465134684Z     101,
2025-01-29T16:33:04.465141617Z     0
2025-01-29T16:33:04.465148570Z   ]
2025-01-29T16:33:04.465155232Z }
2025-01-29T16:33:04.465317674Z [Nest] 16  - 01/29/2025, 4:33:04 PM   ERROR [Api:PostgresError: pgvecto.rs: Bad literal.
2025-01-29T16:33:04.465324597Z INFORMATION: hint = Bad character with ascii 0x30.
2025-01-29T16:33:04.465327292Z     at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:788:26)
2025-01-29T16:33:04.465329436Z     at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:474:6)
2025-01-29T16:33:04.465331359Z     at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)
2025-01-29T16:33:04.465333333Z     at Socket.emit (node:events:524:28)
2025-01-29T16:33:04.465335276Z     at addChunk (node:internal/streams/readable:561:12)
2025-01-29T16:33:04.465337120Z     at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
2025-01-29T16:33:04.465339013Z     at Readable.push (node:internal/streams/readable:392:5)
2025-01-29T16:33:04.465340897Z     at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
2025-01-29T16:33:04.465342800Z     at TCP.callbackTrampoline (node:internal/async_hooks:130:17)~y0fyrnaa] Unknown error: PostgresError: pgvecto.rs: Bad literal.
2025-01-29T16:33:04.465344814Z INFORMATION: hint = Bad character with ascii 0x30.

Additional information

No response

Answered by schuhbacca

Jan 29, 2025

You need to make sure you have the latest Machine Learning Container everywhere. If you are running remote ML make sure it's updated there as well. See examples: #15714

View full answer

schuhbacca · 2025-01-29T17:01:22Z

schuhbacca
Jan 29, 2025
Collaborator

You need to make sure you have the latest Machine Learning Container everywhere. If you are running remote ML make sure it's updated there as well. See examples: #15714

1 reply

LuD1161 Jan 29, 2025
Author

It's working. Thanks. I've set the tag for each container to be release so that both the container are on the same release version.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Smart Search not working on release - v1.125.6 #15766

{{title}}

Replies: 1 comment 1 reply

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

Select a reply

Smart Search not working on release - v1.125.6 #15766

LuD1161 Jan 29, 2025

The bug

Server Version

immich postgres logs

immich server logs

Your .env content

Reproduction steps

Relevant log output

Additional information

Replies: 1 comment · 1 reply

schuhbacca Jan 29, 2025 Collaborator

LuD1161 Jan 29, 2025 Author

LuD1161
Jan 29, 2025

Replies: 1 comment 1 reply

schuhbacca
Jan 29, 2025
Collaborator

LuD1161 Jan 29, 2025
Author