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

Attempt to bulk update ratings using updateAssets fails with db error #6435

New Issue
Closed
opened 2026-02-05 12:17:24 +03:00 by OVERLORD · 1 comment
OVERLORD commented 2026-02-05 12:17:24 +03:00
Owner
Copy Link

Originally created by @momo-the-monster on GitHub (Jul 6, 2025).

I have searched the existing issues, both open and closed, to make sure this is not a duplicate report.

  • Yes

The bug

I'm trying to update the rating for multiple assets at once - using Python, but equivalent to:

curl -L -X PUT '/api/assets' \
-H 'Content-Type: application/json' \
-H 'x-api-key: XXXXXXXXXXXXXXXXXXXXXXXX' \
-d '{
  "ids": [
    "085eb7c3-3124-4cee-b528-38be78c1755b"
  ],
  "rating": 0
}'

This returns a 500 Internal Server Error.
Looking at the logs in the Docker container where Immich is running, I see:

2025-07-06 20:07:03.258 UTC [6329] ERROR:  column "rating" of relation "assets" does not exist at character 21
2025-07-06 20:07:03.258 UTC [6329] STATEMENT:  update "assets" set "rating" = $1 where "id" = any($2::uuid[])

Query failed : {
  error: PostgresError: column "rating" of relation "assets" does not exist
    severity_local: 'ERROR',
    severity: 'ERROR',
    code: '42703',
    position: '21',
    file: 'analyze.c',
    line: '2469',
    routine: 'transformUpdateTargetList'
  },

  sql: 'update "assets" set "rating" = $1 where "id" = any($2::uuid[])',
  params: [ 0, "{085eb7c3-3124-4cee-b528-38be78c1755b}" ]
}

Is it possible that something is wrong with the tables in my database? Ratings work properly through the Web UI and the api/:id endpoint for updating the rating of a single asset.

The OS that Immich Server is running on

Windows 11

Version of Immich Server

v1.135.3

Version of Immich Mobile App

N/A

Platform with the issue

  • Server
  • Web
  • Mobile

Your docker-compose.yml content

#
# WARNING: To install Immich, follow our guide: https://immich.app/docs/install/docker-compose
#
# Make sure to use the docker-compose.yml of the current release:
#
# https://github.com/immich-app/immich/releases/latest/download/docker-compose.yml
#
# The compose file on main may not be compatible with the latest release.

name: immich

services:
  immich-server:
    container_name: immich_server
    image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release}
    # extends:
    #   file: hwaccel.transcoding.yml
    #   service: cpu # set to one of [nvenc, quicksync, rkmpp, vaapi, vaapi-wsl] for accelerated transcoding
    volumes:
      # Do not edit the next line. If you want to change the media storage location on your system, edit the value of UPLOAD_LOCATION in the .env file
      - ${UPLOAD_LOCATION}:/usr/src/app/upload
      - /etc/localtime:/etc/localtime:ro
    env_file:
      - .env
    ports:
      - '2283:2283'
    depends_on:
      - redis
      - database
    restart: always
    healthcheck:
      disable: false

  immich-machine-learning:
    container_name: immich_machine_learning
    # For hardware acceleration, add one of -[armnn, cuda, rocm, openvino, rknn] to the image tag.
    # Example tag: ${IMMICH_VERSION:-release}-cuda
    image: ghcr.io/immich-app/immich-machine-learning:${IMMICH_VERSION:-release}
    # extends: # uncomment this section for hardware acceleration - see https://immich.app/docs/features/ml-hardware-acceleration
    #   file: hwaccel.ml.yml
    #   service: cpu # set to one of [armnn, cuda, rocm, openvino, openvino-wsl, rknn] for accelerated inference - use the `-wsl` version for WSL2 where applicable
    volumes:
      - model-cache:/cache
    env_file:
      - .env
    restart: always
    healthcheck:
      disable: false

  redis:
    container_name: immich_redis
    image: docker.io/valkey/valkey:8-bookworm@sha256:42cba146593a5ea9a622002c1b7cba5da7be248650cbb64ecb9c6c33d29794b1
    healthcheck:
      test: redis-cli ping || exit 1
    restart: always

  database:
    container_name: immich_postgres
    image: ghcr.io/immich-app/postgres:14-vectorchord0.3.0-pgvectors0.2.0
    environment:
      POSTGRES_PASSWORD: ${DB_PASSWORD}
      POSTGRES_USER: ${DB_USERNAME}
      POSTGRES_DB: ${DB_DATABASE_NAME}
      POSTGRES_INITDB_ARGS: '--data-checksums'
    volumes:
      # Do not edit the next line. If you want to change the database storage location on your system, edit the value of DB_DATA_LOCATION in the .env file
      - ${DB_DATA_LOCATION}:/var/lib/postgresql/data
    restart: always

  immich-kiosk:
    image: ghcr.io/damongolding/immich-kiosk:latest
    container_name: immich-kiosk
    tty: true
    environment:
      LANG: "en_GB"
      TZ: "America/Los_Angeles"
      KIOSK_IMMICH_API_KEY: "XXX"
      KIOSK_IMMICH_URL: "XXX"
    env_file:
      - .env
    ports:
      - 3000:3000
    volumes:
      - ./config:/config
    depends_on:
      - immich-server
    restart: always


volumes:
  model-cache:

Your .env content

# You can find documentation for all the supported env variables at https://immich.app/docs/install/environment-variables

# The location where your uploaded files are stored
UPLOAD_LOCATION=./upload

# The location where your database files are stored. Network shares are not supported for the database
DB_DATA_LOCATION=./postgres

# To set a timezone, uncomment the next line and change Etc/UTC to a TZ identifier from this list: https://en.wikipedia.org/wiki/List_of_tz_database_time_zones#List
TZ=America/Los_Angeles

# The Immich version to use. You can pin this to a specific version like "v1.71.0"
IMMICH_VERSION=release

# Used by Immich Kiosk
IMMICH_API_KEY="XXX"

# Connection secret for postgres. You should change it to a random password
# Please use only the characters `A-Za-z0-9`, without special characters or spaces
DB_PASSWORD=XXX

# The values below this line do not need to be changed
###################################################################################
DB_USERNAME=postgres
DB_DATABASE_NAME=immich

Reproduction steps

  1. Make a PUT request to /api/assets with the body {"ids":["GUID"],"rating":0}, where GUID is a valid asset ID (and the request is properly authorized)
  2. The server returns a 500 Internal Server error instead of 200 or 204
    ...

Relevant log output

Additional information

No response

Originally created by @momo-the-monster on GitHub (Jul 6, 2025). ### I have searched the existing issues, both open and closed, to make sure this is not a duplicate report. - [x] Yes ### The bug I'm trying to update the `rating` for multiple assets at once - using Python, but equivalent to: ``` curl -L -X PUT '/api/assets' \ -H 'Content-Type: application/json' \ -H 'x-api-key: XXXXXXXXXXXXXXXXXXXXXXXX' \ -d '{ "ids": [ "085eb7c3-3124-4cee-b528-38be78c1755b" ], "rating": 0 }' ``` This returns a 500 Internal Server Error. Looking at the logs in the Docker container where Immich is running, I see: ``` 2025-07-06 20:07:03.258 UTC [6329] ERROR: column "rating" of relation "assets" does not exist at character 21 2025-07-06 20:07:03.258 UTC [6329] STATEMENT: update "assets" set "rating" = $1 where "id" = any($2::uuid[]) Query failed : { error: PostgresError: column "rating" of relation "assets" does not exist severity_local: 'ERROR', severity: 'ERROR', code: '42703', position: '21', file: 'analyze.c', line: '2469', routine: 'transformUpdateTargetList' }, sql: 'update "assets" set "rating" = $1 where "id" = any($2::uuid[])', params: [ 0, "{085eb7c3-3124-4cee-b528-38be78c1755b}" ] } ``` Is it possible that something is wrong with the tables in my database? Ratings work properly through the Web UI and the api/:id endpoint for updating the rating of a single asset. ### The OS that Immich Server is running on Windows 11 ### Version of Immich Server v1.135.3 ### Version of Immich Mobile App N/A ### Platform with the issue - [x] Server - [ ] Web - [ ] Mobile ### Your docker-compose.yml content ```YAML # # WARNING: To install Immich, follow our guide: https://immich.app/docs/install/docker-compose # # Make sure to use the docker-compose.yml of the current release: # # https://github.com/immich-app/immich/releases/latest/download/docker-compose.yml # # The compose file on main may not be compatible with the latest release. name: immich services: immich-server: container_name: immich_server image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release} # extends: # file: hwaccel.transcoding.yml # service: cpu # set to one of [nvenc, quicksync, rkmpp, vaapi, vaapi-wsl] for accelerated transcoding volumes: # Do not edit the next line. If you want to change the media storage location on your system, edit the value of UPLOAD_LOCATION in the .env file - ${UPLOAD_LOCATION}:/usr/src/app/upload - /etc/localtime:/etc/localtime:ro env_file: - .env ports: - '2283:2283' depends_on: - redis - database restart: always healthcheck: disable: false immich-machine-learning: container_name: immich_machine_learning # For hardware acceleration, add one of -[armnn, cuda, rocm, openvino, rknn] to the image tag. # Example tag: ${IMMICH_VERSION:-release}-cuda image: ghcr.io/immich-app/immich-machine-learning:${IMMICH_VERSION:-release} # extends: # uncomment this section for hardware acceleration - see https://immich.app/docs/features/ml-hardware-acceleration # file: hwaccel.ml.yml # service: cpu # set to one of [armnn, cuda, rocm, openvino, openvino-wsl, rknn] for accelerated inference - use the `-wsl` version for WSL2 where applicable volumes: - model-cache:/cache env_file: - .env restart: always healthcheck: disable: false redis: container_name: immich_redis image: docker.io/valkey/valkey:8-bookworm@sha256:42cba146593a5ea9a622002c1b7cba5da7be248650cbb64ecb9c6c33d29794b1 healthcheck: test: redis-cli ping || exit 1 restart: always database: container_name: immich_postgres image: ghcr.io/immich-app/postgres:14-vectorchord0.3.0-pgvectors0.2.0 environment: POSTGRES_PASSWORD: ${DB_PASSWORD} POSTGRES_USER: ${DB_USERNAME} POSTGRES_DB: ${DB_DATABASE_NAME} POSTGRES_INITDB_ARGS: '--data-checksums' volumes: # Do not edit the next line. If you want to change the database storage location on your system, edit the value of DB_DATA_LOCATION in the .env file - ${DB_DATA_LOCATION}:/var/lib/postgresql/data restart: always immich-kiosk: image: ghcr.io/damongolding/immich-kiosk:latest container_name: immich-kiosk tty: true environment: LANG: "en_GB" TZ: "America/Los_Angeles" KIOSK_IMMICH_API_KEY: "XXX" KIOSK_IMMICH_URL: "XXX" env_file: - .env ports: - 3000:3000 volumes: - ./config:/config depends_on: - immich-server restart: always volumes: model-cache: ``` ### Your .env content ```Shell # You can find documentation for all the supported env variables at https://immich.app/docs/install/environment-variables # The location where your uploaded files are stored UPLOAD_LOCATION=./upload # The location where your database files are stored. Network shares are not supported for the database DB_DATA_LOCATION=./postgres # To set a timezone, uncomment the next line and change Etc/UTC to a TZ identifier from this list: https://en.wikipedia.org/wiki/List_of_tz_database_time_zones#List TZ=America/Los_Angeles # The Immich version to use. You can pin this to a specific version like "v1.71.0" IMMICH_VERSION=release # Used by Immich Kiosk IMMICH_API_KEY="XXX" # Connection secret for postgres. You should change it to a random password # Please use only the characters `A-Za-z0-9`, without special characters or spaces DB_PASSWORD=XXX # The values below this line do not need to be changed ################################################################################### DB_USERNAME=postgres DB_DATABASE_NAME=immich ``` ### Reproduction steps 1. Make a PUT request to /api/assets with the body `{"ids":["GUID"],"rating":0}`, where GUID is a valid asset ID (and the request is properly authorized) 2. The server returns a 500 Internal Server error instead of 200 or 204 ... ### Relevant log output ```shell ``` ### Additional information _No response_
OVERLORD commented 2026-02-05 12:17:27 +03:00
Author
Owner
Copy Link

@githubkusi commented on GitHub (Sep 11, 2025):

Same here. With the very same code I can e.g set the description but not the rating.

This payload on the /api/assets endpoint

{
            "ids": ids,
            "description": "my text"
}

This payload returns 500, but still sets the description correctly

{
            "ids": ids,
            "description": "my text",
            "rating": 3
}

And this payload just returns 500 and doesn't do anything

{
            "ids": ids,
            "rating": 3
}

In docker, I see the following error message

immich_postgres_test          | 2025-09-11 15:08:47.188 UTC [60] ERROR:  column "rating" of relation "asset" does not exist at character 20
immich_postgres_test          | 2025-09-11 15:08:47.188 UTC [60] STATEMENT:  update "asset" set "rating" = $1 where "id" = any($2::uuid[])
immich_server_test            | Query failed : {
immich_postgres_test          | 2025-09-11 15:08:47.188 UTC [60] ERROR:  column "rating" of relation "asset" does not exist at character 20
immich_postgres_test          | 2025-09-11 15:08:47.188 UTC [60] STATEMENT:  update "asset" set "rating" = $1 where "id" = any($2::uuid[])
immich_server_test            |   durationMs: 1.3973629999964032,
immich_server_test            |   error: PostgresError: column "rating" of relation "asset" does not exist
immich_server_test            |       at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)
immich_server_test            |       at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6)
immich_server_test            |       at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9)
immich_server_test            |       at Socket.emit (node:events:519:28)
immich_server_test            |       at addChunk (node:internal/streams/readable:561:12)
immich_server_test            |       at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
immich_server_test            |       at Readable.push (node:internal/streams/readable:392:5)
immich_server_test            |       at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
immich_server_test            |       at TCP.callbackTrampoline (node:internal/async_hooks:130:17) {
immich_server_test            |     severity_local: 'ERROR',
immich_server_test            |     severity: 'ERROR',
immich_server_test            |     code: '42703',
immich_server_test            |     position: '20',
immich_server_test            |     file: 'analyze.c',
immich_server_test            |     line: '2469',
immich_server_test            |     routine: 'transformUpdateTargetList'
immich_server_test            |   },
immich_server_test            |   sql: 'update "asset" set "rating" = $1 where "id" = any($2::uuid[])',
immich_server_test            |   params: [
immich_server_test            |     0,
immich_server_test            |     '{cbd0a4c6-c4f2-4f8e-b175-8f65e5017156,36673863-119b-44b9-b3c5-8ee4fcf709f3}'

Immich version 1.141.1

@githubkusi commented on GitHub (Sep 11, 2025): Same here. With the very same code I can e.g set the description but not the rating. This payload on the /api/assets endpoint ``` { "ids": ids, "description": "my text" } ``` This payload returns 500, but still sets the description correctly ``` { "ids": ids, "description": "my text", "rating": 3 } ``` And this payload just returns 500 and doesn't do anything ``` { "ids": ids, "rating": 3 } ``` In docker, I see the following error message ``` immich_postgres_test | 2025-09-11 15:08:47.188 UTC [60] ERROR: column "rating" of relation "asset" does not exist at character 20 immich_postgres_test | 2025-09-11 15:08:47.188 UTC [60] STATEMENT: update "asset" set "rating" = $1 where "id" = any($2::uuid[]) immich_server_test | Query failed : { immich_postgres_test | 2025-09-11 15:08:47.188 UTC [60] ERROR: column "rating" of relation "asset" does not exist at character 20 immich_postgres_test | 2025-09-11 15:08:47.188 UTC [60] STATEMENT: update "asset" set "rating" = $1 where "id" = any($2::uuid[]) immich_server_test | durationMs: 1.3973629999964032, immich_server_test | error: PostgresError: column "rating" of relation "asset" does not exist immich_server_test | at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) immich_server_test | at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) immich_server_test | at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) immich_server_test | at Socket.emit (node:events:519:28) immich_server_test | at addChunk (node:internal/streams/readable:561:12) immich_server_test | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich_server_test | at Readable.push (node:internal/streams/readable:392:5) immich_server_test | at TCP.onStreamRead (node:internal/stream_base_commons:189:23) immich_server_test | at TCP.callbackTrampoline (node:internal/async_hooks:130:17) { immich_server_test | severity_local: 'ERROR', immich_server_test | severity: 'ERROR', immich_server_test | code: '42703', immich_server_test | position: '20', immich_server_test | file: 'analyze.c', immich_server_test | line: '2469', immich_server_test | routine: 'transformUpdateTargetList' immich_server_test | }, immich_server_test | sql: 'update "asset" set "rating" = $1 where "id" = any($2::uuid[])', immich_server_test | params: [ immich_server_test | 0, immich_server_test | '{cbd0a4c6-c4f2-4f8e-b175-8f65e5017156,36673863-119b-44b9-b3c5-8ee4fcf709f3}' ``` Immich version 1.141.1
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#6435
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?