HttpException(500): {"message":"Failed to update asset","error":"Internal Server Error","statusCode":500} #15903

satmandu · 2025-02-04T17:26:55Z

satmandu
Feb 4, 2025

The bug

This is the blocking error I am seeing with a particular upload. Backing up postgres and restoring gets me further....

Feb 04 09:09:23 bash[599564]: immich_server            | [Nest] 17  - 02/04/2025, 9:09:23 AM   DEBUG [Api:GlobalExceptionFilter~c0xq6c5g] HttpException(400): {"message":["each value in assetIds must be a UUID"],"error":"Bad Request","statusCode":400}
Feb 04 09:09:23 bash[599564]: immich_server            | Query failed : {
Feb 04 09:09:23 bash[599564]: immich_server            |   durationMs: 0.6355020003393292,
Feb 04 09:09:23 bash[599564]: immich_server            |   error: PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum"
Feb 04 09:09:23 bash[599564]: immich_server            |       at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:788:26)
Feb 04 09:09:23 bash[599564]: immich_server            |       at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:474:6)
Feb 04 09:09:23 bash[599564]: immich_server            |       at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)
Feb 04 09:09:23 bash[599564]: immich_server            |       at Socket.emit (node:events:524:28)
Feb 04 09:09:23 bash[599564]: immich_server            |       at addChunk (node:internal/streams/readable:561:12)
Feb 04 09:09:23 bash[599564]: immich_server            |       at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
Feb 04 09:09:23 bash[599564]: immich_server            |       at Readable.push (node:internal/streams/readable:392:5)
Feb 04 09:09:23 bash[599564]: immich_server            |       at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
Feb 04 09:09:23 bash[599564]: immich_server            |       at TCP.callbackTrampoline (node:internal/async_hooks:130:17) {
Feb 04 09:09:23 bash[599564]: immich_server            |     severity_local: 'ERROR',
Feb 04 09:09:23 bash[599564]: immich_server            |     severity: 'ERROR',
Feb 04 09:09:23 bash[599564]: immich_server            |     code: '23505',
Feb 04 09:09:23 bash[599564]: immich_server            |     detail: 'Key ("ownerId", checksum)=(849e2118-be86-425e-b85d-204e074806fa, \\x177f67ba925b909be81d5d995a55b5761c9e86fa) already exists.',
Feb 04 09:09:23 bash[599564]: immich_server            |     schema_name: 'public',
Feb 04 09:09:23 bash[599564]: immich_server            |     table_name: 'assets',
Feb 04 09:09:23 bash[599564]: immich_server            |     constraint_name: 'UQ_assets_owner_checksum',
Feb 04 09:09:23 bash[599564]: immich_server            |     file: 'nbtinsert.c',
Feb 04 09:09:23 bash[599564]: immich_server            |     line: '663',
Feb 04 09:09:23 bash[599564]: immich_server            |     routine: '_bt_check_unique'
Feb 04 09:09:23 bash[599564]: immich_server            |   },
Feb 04 09:09:23 bash[599564]: immich_server            |   sql: 'insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "isArchived", "duration", "isVisible", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15) returning *',
Feb 04 09:09:23 bash[599564]: immich_server            |   params: [
Feb 04 09:09:23 bash[599564]: immich_server            |     '849e2118-be86-425e-b85d-204e074806fa',
Feb 04 09:09:23 bash[599564]: immich_server            |     null,
Feb 04 09:09:23 bash[599564]: immich_server            |     <Buffer 17 7f 67 ba 92 5b 90 9b e8 1d 5d 99 5a 55 b5 76 1c 9e 86 fa>,
Feb 04 09:09:23 bash[599564]: immich_server            |     'upload/upload/849e2118-be86-425e-b85d-204e074806fa/b1/47/b147679e-2969-49d6-aaac-d12e2f85ec82.MP4',
Feb 04 09:09:23 bash[599564]: immich_server            |     'IMG_5856.MP4-1914499',
Feb 04 09:09:23 bash[599564]: immich_server            |     'buppie',
Feb 04 09:09:23 bash[599564]: immich_server            |     2022-10-23T18:22:03.000Z,
Feb 04 09:09:23 bash[599564]: immich_server            |     2025-02-04T09:09:23.000Z,
Feb 04 09:09:23 bash[599564]: immich_server            |     2022-10-23T18:22:03.000Z,
Feb 04 09:09:23 bash[599564]: immich_server            |     'VIDEO',
Feb 04 09:09:23 bash[599564]: immich_server            |     false,
Feb 04 09:09:23 bash[599564]: immich_server            |     false,
Feb 04 09:09:23 bash[599564]: immich_server            |     '00:00:00.000000',
Feb 04 09:09:23 bash[599564]: immich_server            |     true,
Feb 04 09:09:23 bash[599564]: immich_server            |     'IMG_5856.MP4'
Feb 04 09:09:23 bash[599564]: immich_server            |   ]
Feb 04 09:09:23 bash[599564]: immich_server            | }
Feb 04 09:09:23 bash[599564]: immich_server            | Query failed : {
Feb 04 09:09:23 bash[599564]: immich_server            |   durationMs: 0.262085999827832,
Feb 04 09:09:23 bash[599564]: immich_server            |   error: Error: write CONNECTION_DESTROYED database:5432
Feb 04 09:09:23 bash[599564]: immich_server            |       at Object.execute (/usr/src/app/node_modules/postgres/cjs/src/connection.js:156:35)
Feb 04 09:09:23 bash[599564]: immich_server            |       at Query.handler (/usr/src/app/node_modules/postgres/cjs/src/index.js:229:13)
Feb 04 09:09:23 bash[599564]: immich_server            |       at Query.handle (/usr/src/app/node_modules/postgres/cjs/src/query.js:140:65)
Feb 04 09:09:23 bash[599564]: immich_server            |       at process.processTicksAndRejections (node:internal/process/task_queues:105:5) {
Feb 04 09:09:23 bash[599564]: immich_server            |     code: 'CONNECTION_DESTROYED',
Feb 04 09:09:23 bash[599564]: immich_server            |     errno: 'CONNECTION_DESTROYED',
Feb 04 09:09:23 bash[599564]: immich_server            |     address: [ 'database' ],
Feb 04 09:09:23 bash[599564]: immich_server            |     port: [ 5432 ]
Feb 04 09:09:23 bash[599564]: immich_server            |   },
Feb 04 09:09:23 bash[599564]: immich_server            |   sql: 'insert into "exif" ("assetId", "dateTimeOriginal", "latitude", "longitude") values ($1::uuid, $2, $3, $4) on conflict ("assetId") do update set "dateTimeOriginal" = excluded."dateTimeOriginal", "latitude" = excluded."latitude", "longitude" = excluded."longitude"',
Feb 04 09:09:23 bash[599564]: immich_server            |   params: [
Feb 04 09:09:23 bash[599564]: immich_server            |     '61b4bf04-03a3-44a8-9927-e414d7f5b9ef',
Feb 04 09:09:23 bash[599564]: immich_server            |     '2022-10-23T18:22:03-04:00',
Feb 04 09:09:23 bash[599564]: immich_server            |     40.7791,
Feb 04 09:09:23 bash[599564]: immich_server            |     -73.985
Feb 04 09:09:23 bash[599564]: immich_server            |   ]
Feb 04 09:09:23 bash[599564]: immich_server            | }
Feb 04 09:09:23 bash[599564]: immich_server            | [Nest] 17  - 02/04/2025, 9:09:23 AM   ERROR [Api:ErrorInterceptor~55cht7iw] Unknown error: Error: write CONNECTION_DESTROYED database:5432
Feb 04 09:09:23 bash[599564]: immich_server            | Error: write CONNECTION_DESTROYED database:5432
Feb 04 09:09:23 bash[599564]: immich_server            |     at Object.execute (/usr/src/app/node_modules/postgres/cjs/src/connection.js:156:35)
Feb 04 09:09:23 bash[599564]: immich_server            |     at Query.handler (/usr/src/app/node_modules/postgres/cjs/src/index.js:229:13)
Feb 04 09:09:23 bash[599564]: immich_server            |     at Query.handle (/usr/src/app/node_modules/postgres/cjs/src/query.js:140:65)
Feb 04 09:09:23 bash[599564]: immich_server            |     at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
Feb 04 09:09:23 bash[599564]: immich_server            | [Nest] 17  - 02/04/2025, 9:09:23 AM   DEBUG [Api:GlobalExceptionFilter~55cht7iw] HttpException(500): {"message":"Failed to update asset","error":"Internal Server Error","statusCode":500}

The OS that Immich Server is running on

Ubuntu 24.10 (x86_64)

Version of Immich Server

v1.125.7

Version of Immich Mobile App

v1.125.5

Platform with the issue

Server
Web
Mobile

Your docker-compose.yml content

#
# WARNING: 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}
    user: $IMMICH_UID:$IMMICH_GID
    # extends:
    #   file: hwaccel.transcoding.yml
    #   service: cpu # set to one of [nvenc, quicksync, rkmpp, vaapi, vaapi-wsl] for accelerated transcoding
    # cpu_shares: 512
    # mem_limit: 10G
    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
    deploy:
      restart_policy:
        condition: on-failure
        delay: 5s

  immich-machine-learning:
    container_name: immich_machine_learning
    # For hardware acceleration, add one of -[armnn, cuda, openvino] to the image tag.
    # Example tag: ${IMMICH_VERSION:-release}-cuda
    image: ghcr.io/immich-app/immich-machine-learning:${IMMICH_VERSION:-release}
    user: $IMMICH_UID:$IMMICH_GID
    extends: # uncomment this section for hardware acceleration - see https://immich.app/docs/features/ml-hardware-acceleration
      file: hwaccel.ml.yml
      service: openvino # set to one of [armnn, cuda, openvino, openvino-wsl] for accelerated inference - use the `-wsl` version for WSL2 where applicable
    # cpu_shares: 512
    # mem_limit: 15G
    volumes:
      - ${IMMICH_HOME}/.var/cache:/cache
      - ${IMMICH_HOME}/.var/.config:/.config
    env_file:
      - .env
    restart: always
    healthcheck:
      disable: false
    deploy:
      restart_policy:
        condition: on-failure
        delay: 5s

  redis:
    container_name: immich_redis
    image: docker.io/redis:6.2-alpine@sha256:905c4ee67b8e0aa955331960d2aa745781e6bd89afc44a8584bfd13bc890f0ae
    user: $IMMICH_UID:$IMMICH_GID
    volumes:
      - ${IMMICH_HOME}/.var/data:/data
    healthcheck:
      test: redis-cli ping || exit 1
    restart: always
    deploy:
      restart_policy:
        condition: on-failure
        delay: 5s

  database:
    container_name: immich_postgres
    image: docker.io/tensorchord/pgvecto-rs:pg14-v0.2.0@sha256:90724186f0a3517cf6914295b5ab410db9ce23190a2d9d0b9dd6463e3fa298f0
    environment:
      POSTGRES_PASSWORD: ${DB_PASSWORD}
      POSTGRES_USER: ${DB_USERNAME}
      POSTGRES_DB: ${DB_DATABASE_NAME}
      POSTGRES_INITDB_ARGS: '--data-checksums'
    volumes:
      - ${IMMICH_HOME}/.var/database:/var/lib/postgresql/data
    healthcheck:
      test: >-
        pg_isready --dbname="$${POSTGRES_DB}" --username="$${POSTGRES_USER}" || exit 1;
        Chksum="$$(psql --dbname="$${POSTGRES_DB}" --username="$${POSTGRES_USER}" --tuples-only --no-align
        --command='SELECT COALESCE(SUM(checksum_failures), 0) FROM pg_stat_database')";
        echo "checksum failure count is $$Chksum";
        [ "$$Chksum" = '0' ] || exit 1
      interval: 5m
      start_interval: 30s
      start_period: 5m
    command: >-
      postgres
      -c shared_preload_libraries=vectors.so
      -c 'search_path="$$user", public, vectors'
      -c logging_collector=on
      -c max_wal_size=2GB
      -c shared_buffers=512MB
      -c wal_compression=on
    restart: always
    deploy:
      restart_policy:
        condition: on-failure
        delay: 5s

Your .env content

# You can find documentation for all the supported env variables at https://immich.app/docs/install/environment-variables
IMMICH_HOME=*****
IMMICH_UID=1005
IMMICH_GID=1005

# The location where your uploaded files are stored
UPLOAD_LOCATION=*****
# The location where your database files are stored
DB_DATA_LOCATION=$IMMICH_HOME/postgres

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

# Connection secret for postgres. You should change it to a random password
DB_PASSWORD=*****

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

TZ=America/New_York

Reproduction steps

Uploading from a Google Takeout using immich-go. (Consistently there is a 500 error.)

Relevant log output

journalctl -u immich.service -b -l -g immich_server --no-hostname --no-pager | grep -v "Microservices:MapRepository\|LoggingInterceptor" | grep 09:09:23 > immich_server_error.log

[immich_server_error.log](https://github.com/user-attachments/files/18660955/immich_server_error.log)

Additional information

No response

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

HttpException(500): {"message":"Failed to update asset","error":"Internal Server Error","statusCode":500} #15903

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 0 comments

Select a reply

HttpException(500): {"message":"Failed to update asset","error":"Internal Server Error","statusCode":500} #15903

satmandu Feb 4, 2025

The bug

The OS that Immich Server is running on

Version of Immich Server

Version of Immich Mobile App

Platform with the issue

Your docker-compose.yml content

Your .env content

Reproduction steps

Relevant log output

Additional information

Replies: 0 comments

satmandu
Feb 4, 2025