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

Error uploading images - ERROR: record "new" has no field "updated_at" #4402

New Issue
Closed
opened 2026-02-05 10:19:29 +03:00 by OVERLORD · 1 comment
OVERLORD commented 2026-02-05 10:19:29 +03:00
Owner
Copy Link

Originally created by @ignaciolg on GitHub (Sep 25, 2024).

The bug

Before the 20th of September everything was working fine. Uploads with immich-go, with the phone app, etc
image

Now, If I try to upload new images, immich thrown an error and a broken thumbnail is being shown.

The image seems to not be written on disk (immich has write access to the upload folders, tested with podman exec -it immich_server bash and playing with the files)

The most weird thing is that the image do not exist on the disk, but I can download it from the web UI

image image

Searching for the broken images on disk return no results
image
image

I'm not aware on any change on the configuration of any of the pieces.

Could anyone help me?

The OS that Immich Server is running on

Debian

Version of Immich Server

v1.115.0

Version of Immich Mobile App

v1.115.0

Platform with the issue

  • Server
  • Web
  • Mobile

Your docker-compose.yml content

Using podman with quadlets (systemd auto-generated services)

Here are the used images for the different services

immich server - ghcr.io/immich-app/immich-server:release
immich postgres - docker.io/tensorchord/pgvecto-rs:pg14-v0.2.0@sha256:90724186f0a3517cf6914295b5ab410db9ce23190a2d9d0b9dd6463e3fa298f0
immich redis - docker.io/redis:6.2-alpine@sha256:2d1463258f2764328496376f5d965f20c6a67f66ea2b06dc42af351f75248792
immich machine learning - ghcr.io/immich-app/immich-machine-learning:release-cuda



### 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= /mnt/1.6TiB/containers/immich/upload
EXTERNAL_PATH=/mnt/1.6TiB/containers/immich/external

# 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=<redacted>

# The values below this line do not need to be changed
###################################################################################
DB_USERNAME=<redacted>
DB_DATABASE_NAME=<redacted>
DB_DATA_LOCATION= /mnt/1.6TiB/containers/immich/database

Reproduction steps

  1. Open Immich Web
  2. Upload a file
  3. A modal with an error will pop up
  4. Now a broken image will be shown on the timeline

Relevant log output

podman logs immich_server


Nest] 12  - 09/24/2024, 9:13:23 PM   ERROR [Api:AssetMediaService~nn50vkyr] Error uploading file QueryFailedError: record "new" has no field "updated_at"
QueryFailedError: record "new" has no field "updated_at"
    at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async UpdateQueryBuilder.execute (/usr/src/app/node_modules/typeorm/query-builder/UpdateQueryBuilder.js:83:33)
    at async UserRepository.updateUsage (/usr/src/app/dist/repositories/user.repository.js:114:9)
    at async AssetMediaService.uploadAsset (/usr/src/app/dist/services/asset-media.service.js:126:13)
    at async AssetMediaController.uploadAsset (/usr/src/app/dist/controllers/asset-media.controller.js:39:29)
[Nest] 12  - 09/24/2024, 9:13:23 PM   ERROR [Api:ErrorInterceptor~nn50vkyr] Database error: QueryFailedError: record "new" has no field "updated_at"
[Nest] 2  - 09/24/2024, 9:13:23 PM   ERROR [Microservices:JobService] Unable to run job handler (metadataExtraction/metadata-extraction): Error: ENOENT: no such file or directory, stat 'upload/upload/adce3531-3d90-4b7b-b089-551338128d8a/7f/bf/7fbf58d8-5133-435f-bd5f-ec68b08e7611.webp'
[Nest] 2  - 09/24/2024, 9:13:23 PM   ERROR [Microservices:JobService] Error: ENOENT: no such file or directory, stat 'upload/upload/adce3531-3d90-4b7b-b089-551338128d8a/7f/bf/7fbf58d8-5133-435f-bd5f-ec68b08e7611.webp'
    at async Object.stat (node:internal/fs/promises:1032:18)
    at async MetadataService.handleMetadataExtraction (/usr/src/app/dist/services/metadata.service.js:191:23)
    at async /usr/src/app/dist/services/job.service.js:148:36
    at async Worker.processJob (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:394:28)
    at async Worker.retryIfFailed (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:581:24)
[Nest] 2  - 09/24/2024, 9:13:23 PM   ERROR [Microservices:JobService] Object:
{
  "id": "aec6bfca-85d7-471d-857f-f118fe94f070",
  "source": "upload"
}

podman logs immich_postgres

2024-09-24 21:12:45.284 UTC [82] STATEMENT:  INSERT INTO "audit"("entityType", "entityId", "action", "ownerId", "createdAt") VALUES ($1, $2, $3, $4, DEFAULT) RETURNING "id", "createdAt"
2024-09-24 21:13:23.740 UTC [129] ERROR:  record "new" has no field "updated_at"
2024-09-24 21:13:23.740 UTC [129] CONTEXT:  PL/pgSQL assignment "NEW.updated_at = now()"
        PL/pgSQL function change_updated_at() line 4 at assignment



### Additional information

_No response_
Originally created by @ignaciolg on GitHub (Sep 25, 2024). ### The bug Before the 20th of September everything was working fine. Uploads with immich-go, with the phone app, etc <img width="206" alt="image" src="https://github.com/user-attachments/assets/df59fc87-55d5-41dc-bd52-67b64a869adc"> Now, If I try to upload new images, immich thrown an error and a broken thumbnail is being shown. The image seems to not be written on disk (immich has write access to the upload folders, tested with podman exec -it immich_server bash and playing with the files) The most weird thing is that the image do not exist on the disk, but I can download it from the web UI <img width="723" alt="image" src="https://github.com/user-attachments/assets/65e21bd9-0c66-4ec6-a3e2-f83295a2fd3c"> <img width="422" alt="image" src="https://github.com/user-attachments/assets/5c176d1e-2430-495b-a059-f7dbc3ec5e16"> Searching for the broken images on disk return no results <img width="494" alt="image" src="https://github.com/user-attachments/assets/eec09b46-c755-4ecd-84ab-ab448d662aaf"> <img width="434" alt="image" src="https://github.com/user-attachments/assets/cd360a78-6352-4920-82b8-dd44a4d8f452"> I'm not aware on any change on the configuration of any of the pieces. Could anyone help me? ### The OS that Immich Server is running on Debian ### Version of Immich Server v1.115.0 ### Version of Immich Mobile App v1.115.0 ### Platform with the issue - [ ] Server - [X] Web - [X] Mobile ### Your docker-compose.yml content ```YAML Using podman with quadlets (systemd auto-generated services) Here are the used images for the different services immich server - ghcr.io/immich-app/immich-server:release immich postgres - docker.io/tensorchord/pgvecto-rs:pg14-v0.2.0@sha256:90724186f0a3517cf6914295b5ab410db9ce23190a2d9d0b9dd6463e3fa298f0 immich redis - docker.io/redis:6.2-alpine@sha256:2d1463258f2764328496376f5d965f20c6a67f66ea2b06dc42af351f75248792 immich machine learning - ghcr.io/immich-app/immich-machine-learning:release-cuda ``` ``` ### 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= /mnt/1.6TiB/containers/immich/upload EXTERNAL_PATH=/mnt/1.6TiB/containers/immich/external # 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=<redacted> # The values below this line do not need to be changed ################################################################################### DB_USERNAME=<redacted> DB_DATABASE_NAME=<redacted> DB_DATA_LOCATION= /mnt/1.6TiB/containers/immich/database ``` ### Reproduction steps 1. Open Immich Web 2. Upload a file 3. A modal with an error will pop up 4. Now a broken image will be shown on the timeline ### Relevant log output `podman logs immich_server` ```shell Nest] 12 - 09/24/2024, 9:13:23 PM ERROR [Api:AssetMediaService~nn50vkyr] Error uploading file QueryFailedError: record "new" has no field "updated_at" QueryFailedError: record "new" has no field "updated_at" at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19) at process.processTicksAndRejections (node:internal/process/task_queues:95:5) at async UpdateQueryBuilder.execute (/usr/src/app/node_modules/typeorm/query-builder/UpdateQueryBuilder.js:83:33) at async UserRepository.updateUsage (/usr/src/app/dist/repositories/user.repository.js:114:9) at async AssetMediaService.uploadAsset (/usr/src/app/dist/services/asset-media.service.js:126:13) at async AssetMediaController.uploadAsset (/usr/src/app/dist/controllers/asset-media.controller.js:39:29) [Nest] 12 - 09/24/2024, 9:13:23 PM ERROR [Api:ErrorInterceptor~nn50vkyr] Database error: QueryFailedError: record "new" has no field "updated_at" [Nest] 2 - 09/24/2024, 9:13:23 PM ERROR [Microservices:JobService] Unable to run job handler (metadataExtraction/metadata-extraction): Error: ENOENT: no such file or directory, stat 'upload/upload/adce3531-3d90-4b7b-b089-551338128d8a/7f/bf/7fbf58d8-5133-435f-bd5f-ec68b08e7611.webp' [Nest] 2 - 09/24/2024, 9:13:23 PM ERROR [Microservices:JobService] Error: ENOENT: no such file or directory, stat 'upload/upload/adce3531-3d90-4b7b-b089-551338128d8a/7f/bf/7fbf58d8-5133-435f-bd5f-ec68b08e7611.webp' at async Object.stat (node:internal/fs/promises:1032:18) at async MetadataService.handleMetadataExtraction (/usr/src/app/dist/services/metadata.service.js:191:23) at async /usr/src/app/dist/services/job.service.js:148:36 at async Worker.processJob (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:394:28) at async Worker.retryIfFailed (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:581:24) [Nest] 2 - 09/24/2024, 9:13:23 PM ERROR [Microservices:JobService] Object: { "id": "aec6bfca-85d7-471d-857f-f118fe94f070", "source": "upload" } ``` `podman logs immich_postgres` ``` 2024-09-24 21:12:45.284 UTC [82] STATEMENT: INSERT INTO "audit"("entityType", "entityId", "action", "ownerId", "createdAt") VALUES ($1, $2, $3, $4, DEFAULT) RETURNING "id", "createdAt" 2024-09-24 21:13:23.740 UTC [129] ERROR: record "new" has no field "updated_at" 2024-09-24 21:13:23.740 UTC [129] CONTEXT: PL/pgSQL assignment "NEW.updated_at = now()" PL/pgSQL function change_updated_at() line 4 at assignment ``` ``` ### Additional information _No response_
OVERLORD commented 2026-02-05 10:19:33 +03:00
Author
Owner
Copy Link

@alextran1502 commented on GitHub (Sep 25, 2024):

Fixed, will be available in the next release

@alextran1502 commented on GitHub (Sep 25, 2024): Fixed, will be available in the next release
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#4402
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?