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

[BUG] live photos from external library displayed with separate movie file #1505

New Issue
Closed
opened 2026-02-05 02:08:29 +03:00 by OVERLORD · 8 comments
OVERLORD commented 2026-02-05 02:08:29 +03:00
Owner
Copy Link

Originally created by @zamszowy on GitHub (Oct 24, 2023).

The bug

After scanning photos from external library, live photos appear correctly, but corresponding movie file is not hidden and displayed alongside.
Screenshot from 2023-10-24 22-43-35

EXIF date and filename is the same:

mp4 jpg

The OS that Immich Server is running on

Debian testing

Version of Immich Server

v1.82.1

Version of Immich Mobile App

v1.82.0

Platform with the issue

  • Server
  • Web
  • Mobile

Your docker-compose.yml content

version: "3.8"

services:
  immich-server:
    container_name: immich_server
    image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release}
    command: ["start.sh", "immich"]
    volumes:
      - ${UPLOAD_LOCATION}:/usr/src/app/upload
      - /mnt/data/photos1:/mnt/data/photos1:ro
      - /mnt/data/photos2:/mnt/data/photos2:ro
      - /etc/localtime:/etc/localtime:ro
    env_file:
      - .env
    depends_on:
      - redis
      - database
      - typesense
    restart: always

  immich-microservices:
    container_name: immich_microservices
    image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release}
    extends:
      file: hwaccel.yml
      service: hwaccel
    command: ["start.sh", "microservices"]
    volumes:
      - ${UPLOAD_LOCATION}:/usr/src/app/upload
      - /mnt/data/photos1:/mnt/data/photos1:ro
      - /mnt/data/photos2:/mnt/data/photos2:ro
      - /etc/localtime:/etc/localtime:ro
    env_file:
      - .env
    depends_on:
      - redis
      - database
      - typesense
    restart: always

  immich-machine-learning:
    container_name: immich_machine_learning
    image: ghcr.io/immich-app/immich-machine-learning:${IMMICH_VERSION:-release}
    volumes:
      - model-cache:/cache
    env_file:
      - .env
    restart: always

  immich-web:
    container_name: immich_web
    image: ghcr.io/immich-app/immich-web:${IMMICH_VERSION:-release}
    env_file:
      - .env
    restart: always

  typesense:
    container_name: immich_typesense
    image: typesense/typesense:0.24.1@sha256:9bcff2b829f12074426ca044b56160ca9d777a0c488303469143dd9f8259d4dd
    environment:
      - TYPESENSE_API_KEY=${TYPESENSE_API_KEY}
      - TYPESENSE_DATA_DIR=/data
      # remove this to get debug messages
      - GLOG_minloglevel=1
    volumes:
      - tsdata:/data
    restart: always

  redis:
    container_name: immich_redis
    image: redis:6.2-alpine@sha256:70a7a5b641117670beae0d80658430853896b5ef269ccf00d1827427e3263fa3
    restart: always

  database:
    container_name: immich_postgres
    image: postgres:14-alpine@sha256:28407a9961e76f2d285dc6991e8e48893503cc3836a4755bbc2d40bcc272a441
    env_file:
      - .env
    environment:
      POSTGRES_PASSWORD: ${DB_PASSWORD}
      POSTGRES_USER: ${DB_USERNAME}
      POSTGRES_DB: ${DB_DATABASE_NAME}
    volumes:
      - pgdata:/var/lib/postgresql/data
    restart: always

  immich-proxy:
    container_name: immich_proxy
    image: ghcr.io/immich-app/immich-proxy:${IMMICH_VERSION:-release}
    environment:
      # Make sure these values get passed through from the env file
      - IMMICH_SERVER_URL
      - IMMICH_WEB_URL
    ports:
      - 2283:8080
    depends_on:
      - immich-server
      - immich-web
    restart: always

volumes:
  pgdata:
  model-cache:
  tsdata:

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=./library

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

# Connection secrets for postgres and typesense. You should change these to random passwords
TYPESENSE_API_KEY=some-random-text
DB_PASSWORD=postgres

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

REDIS_HOSTNAME=immich_redis

Reproduction steps

1. Have directory with live photos on the server
2. Add External Library with import path set to directory with live photos
3. Scan External Library
4. Live photos will appear correctly, but with associated movie file also shown

Additional information

Don't know if this should matter, but live photos were taken with Samsung phone.

Originally created by @zamszowy on GitHub (Oct 24, 2023). ### The bug After scanning photos from external library, live photos appear correctly, but corresponding movie file is not hidden and displayed alongside. ![Screenshot from 2023-10-24 22-43-35](https://github.com/immich-app/immich/assets/13163734/26f6b4cd-b047-493a-85d1-fc64fae23f3f) EXIF date and filename is the same: ![mp4](https://github.com/immich-app/immich/assets/13163734/c55d022e-2ba6-4374-b024-7dfbf324d45b) ![jpg](https://github.com/immich-app/immich/assets/13163734/66c251ba-358d-44c9-884a-0d7ae0ae1f89) ### The OS that Immich Server is running on Debian testing ### Version of Immich Server v1.82.1 ### Version of Immich Mobile App v1.82.0 ### Platform with the issue - [X] Server - [ ] Web - [ ] Mobile ### Your docker-compose.yml content ```YAML version: "3.8" services: immich-server: container_name: immich_server image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release} command: ["start.sh", "immich"] volumes: - ${UPLOAD_LOCATION}:/usr/src/app/upload - /mnt/data/photos1:/mnt/data/photos1:ro - /mnt/data/photos2:/mnt/data/photos2:ro - /etc/localtime:/etc/localtime:ro env_file: - .env depends_on: - redis - database - typesense restart: always immich-microservices: container_name: immich_microservices image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release} extends: file: hwaccel.yml service: hwaccel command: ["start.sh", "microservices"] volumes: - ${UPLOAD_LOCATION}:/usr/src/app/upload - /mnt/data/photos1:/mnt/data/photos1:ro - /mnt/data/photos2:/mnt/data/photos2:ro - /etc/localtime:/etc/localtime:ro env_file: - .env depends_on: - redis - database - typesense restart: always immich-machine-learning: container_name: immich_machine_learning image: ghcr.io/immich-app/immich-machine-learning:${IMMICH_VERSION:-release} volumes: - model-cache:/cache env_file: - .env restart: always immich-web: container_name: immich_web image: ghcr.io/immich-app/immich-web:${IMMICH_VERSION:-release} env_file: - .env restart: always typesense: container_name: immich_typesense image: typesense/typesense:0.24.1@sha256:9bcff2b829f12074426ca044b56160ca9d777a0c488303469143dd9f8259d4dd environment: - TYPESENSE_API_KEY=${TYPESENSE_API_KEY} - TYPESENSE_DATA_DIR=/data # remove this to get debug messages - GLOG_minloglevel=1 volumes: - tsdata:/data restart: always redis: container_name: immich_redis image: redis:6.2-alpine@sha256:70a7a5b641117670beae0d80658430853896b5ef269ccf00d1827427e3263fa3 restart: always database: container_name: immich_postgres image: postgres:14-alpine@sha256:28407a9961e76f2d285dc6991e8e48893503cc3836a4755bbc2d40bcc272a441 env_file: - .env environment: POSTGRES_PASSWORD: ${DB_PASSWORD} POSTGRES_USER: ${DB_USERNAME} POSTGRES_DB: ${DB_DATABASE_NAME} volumes: - pgdata:/var/lib/postgresql/data restart: always immich-proxy: container_name: immich_proxy image: ghcr.io/immich-app/immich-proxy:${IMMICH_VERSION:-release} environment: # Make sure these values get passed through from the env file - IMMICH_SERVER_URL - IMMICH_WEB_URL ports: - 2283:8080 depends_on: - immich-server - immich-web restart: always volumes: pgdata: model-cache: tsdata: ``` ### 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=./library # The Immich version to use. You can pin this to a specific version like "v1.71.0" IMMICH_VERSION=release # Connection secrets for postgres and typesense. You should change these to random passwords TYPESENSE_API_KEY=some-random-text DB_PASSWORD=postgres # The values below this line do not need to be changed ################################################################################### DB_HOSTNAME=immich_postgres DB_USERNAME=postgres DB_DATABASE_NAME=immich REDIS_HOSTNAME=immich_redis ``` ### Reproduction steps ```bash 1. Have directory with live photos on the server 2. Add External Library with import path set to directory with live photos 3. Scan External Library 4. Live photos will appear correctly, but with associated movie file also shown ``` ### Additional information Don't know if this should matter, but live photos were taken with Samsung phone.
OVERLORD commented 2026-02-05 02:08:33 +03:00
Author
Owner
Copy Link

@alextran1502 commented on GitHub (Oct 25, 2023):

Have all the jobs finished running yet?

@alextran1502 commented on GitHub (Oct 25, 2023): Have all the jobs finished running yet?
OVERLORD commented 2026-02-05 02:08:36 +03:00
Author
Owner
Copy Link

@zamszowy commented on GitHub (Oct 25, 2023):

Have all the jobs finished running yet?

Yes, tried even force-rescanning all the library several times after previous ones finished, but it didn't help.

@zamszowy commented on GitHub (Oct 25, 2023): > Have all the jobs finished running yet? Yes, tried even force-rescanning all the library several times after previous ones finished, but it didn't help.
OVERLORD commented 2026-02-05 02:08:39 +03:00
Author
Owner
Copy Link

@jrasm91 commented on GitHub (Oct 25, 2023):

On those two specific assets you can multi-select them and then re-run the metadata extraction jobs from the three dots menu. After you do that can you check the immich-microservices logs for errors? If there are none, would you be able to share the files for debugging?

@jrasm91 commented on GitHub (Oct 25, 2023): On those two specific assets you can multi-select them and then re-run the metadata extraction jobs from the three dots menu. After you do that can you check the immich-microservices logs for errors? If there are none, would you be able to share the files for debugging?
OVERLORD commented 2026-02-05 02:08:47 +03:00
Author
Owner
Copy Link

@zamszowy commented on GitHub (Oct 25, 2023):

Refreshing metadata on those two items yielded no logs in immich-microservices, but when I clicked "Refresh thumbnails" on those, I got:

[Nest] 7  - 10/25/2023, 5:41:26 PM     LOG [MediaService] Successfully generated JPEG video thumbnail for asset 5aaa40fe-122b-4fea-8edb-4a3bbce430c1
 [Nest] 7  - 10/25/2023, 5:41:27 PM     LOG [MediaService] Successfully generated JPEG image thumbnail for asset 630d7599-fddc-45bf-827b-5a78f6e84319
 [Nest] 7  - 10/25/2023, 5:41:27 PM     LOG [MediaService] Successfully generated WEBP video thumbnail for asset 5aaa40fe-122b-4fea-8edb-4a3bbce430c1
 [Nest] 7  - 10/25/2023, 5:41:28 PM     LOG [MediaService] Successfully generated WEBP image thumbnail for asset 630d7599-fddc-45bf-827b-5a78f6e84319
 [Nest] 7  - 10/25/2023, 5:41:28 PM   ERROR [JobService] Unable to run job handler (clipEncoding/clip-encode): Error: Request for clip failed with status 500: Internal Server Error
 [Nest] 7  - 10/25/2023, 5:41:28 PM   ERROR [JobService] Error: Request for clip failed with status 500: Internal Server Error
     at MachineLearningRepository.post (/usr/src/app/dist/infra/repositories/machine-learning.repository.js:29:19)
     at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
     at async SmartInfoService.handleEncodeClip (/usr/src/app/dist/domain/smart-info/smart-info.service.js:118:31)
     at async /usr/src/app/dist/domain/job/job.service.js:108:37
     at async Worker.processJob (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:350:28)
     at async Worker.retryIfFailed (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:535:24)
 [Nest] 7  - 10/25/2023, 5:41:28 PM   ERROR [JobService] Object:
 {
   "id": "5aaa40fe-122b-4fea-8edb-4a3bbce430c1"
 }
 
 [Nest] 7  - 10/25/2023, 5:41:30 PM   ERROR [JobService] Unable to run job handler (clipEncoding/clip-encode): Error: Request for clip failed with status 500: Internal Server Error
 [Nest] 7  - 10/25/2023, 5:41:30 PM   ERROR [JobService] Error: Request for clip failed with status 500: Internal Server Error
     at MachineLearningRepository.post (/usr/src/app/dist/infra/repositories/machine-learning.repository.js:29:19)
     at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
     at async SmartInfoService.handleEncodeClip (/usr/src/app/dist/domain/smart-info/smart-info.service.js:118:31)
     at async /usr/src/app/dist/domain/job/job.service.js:108:37
     at async Worker.processJob (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:350:28)
     at async Worker.retryIfFailed (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:535:24)
 [Nest] 7  - 10/25/2023, 5:41:30 PM   ERROR [JobService] Object:
 {
   "id": "630d7599-fddc-45bf-827b-5a78f6e84319"
 }

In my library there seems to be just one image file that have embedded video inside. I was able to extract it using ExifTool:

exiftool -b -EmbeddedVideoFile 20231008_174840.jpg > video.mp4

I'm also attaching this image here (in zip archive, as I don't know if plain image would be somehow stripped of metadata when uploaded here).

20231008_174840.zip

@zamszowy commented on GitHub (Oct 25, 2023): Refreshing metadata on those two items yielded no logs in immich-microservices, but when I clicked "Refresh thumbnails" on those, I got: ```log [Nest] 7 - 10/25/2023, 5:41:26 PM LOG [MediaService] Successfully generated JPEG video thumbnail for asset 5aaa40fe-122b-4fea-8edb-4a3bbce430c1 [Nest] 7 - 10/25/2023, 5:41:27 PM LOG [MediaService] Successfully generated JPEG image thumbnail for asset 630d7599-fddc-45bf-827b-5a78f6e84319 [Nest] 7 - 10/25/2023, 5:41:27 PM LOG [MediaService] Successfully generated WEBP video thumbnail for asset 5aaa40fe-122b-4fea-8edb-4a3bbce430c1 [Nest] 7 - 10/25/2023, 5:41:28 PM LOG [MediaService] Successfully generated WEBP image thumbnail for asset 630d7599-fddc-45bf-827b-5a78f6e84319 [Nest] 7 - 10/25/2023, 5:41:28 PM ERROR [JobService] Unable to run job handler (clipEncoding/clip-encode): Error: Request for clip failed with status 500: Internal Server Error [Nest] 7 - 10/25/2023, 5:41:28 PM ERROR [JobService] Error: Request for clip failed with status 500: Internal Server Error at MachineLearningRepository.post (/usr/src/app/dist/infra/repositories/machine-learning.repository.js:29:19) at process.processTicksAndRejections (node:internal/process/task_queues:95:5) at async SmartInfoService.handleEncodeClip (/usr/src/app/dist/domain/smart-info/smart-info.service.js:118:31) at async /usr/src/app/dist/domain/job/job.service.js:108:37 at async Worker.processJob (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:350:28) at async Worker.retryIfFailed (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:535:24) [Nest] 7 - 10/25/2023, 5:41:28 PM ERROR [JobService] Object: { "id": "5aaa40fe-122b-4fea-8edb-4a3bbce430c1" } [Nest] 7 - 10/25/2023, 5:41:30 PM ERROR [JobService] Unable to run job handler (clipEncoding/clip-encode): Error: Request for clip failed with status 500: Internal Server Error [Nest] 7 - 10/25/2023, 5:41:30 PM ERROR [JobService] Error: Request for clip failed with status 500: Internal Server Error at MachineLearningRepository.post (/usr/src/app/dist/infra/repositories/machine-learning.repository.js:29:19) at process.processTicksAndRejections (node:internal/process/task_queues:95:5) at async SmartInfoService.handleEncodeClip (/usr/src/app/dist/domain/smart-info/smart-info.service.js:118:31) at async /usr/src/app/dist/domain/job/job.service.js:108:37 at async Worker.processJob (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:350:28) at async Worker.retryIfFailed (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:535:24) [Nest] 7 - 10/25/2023, 5:41:30 PM ERROR [JobService] Object: { "id": "630d7599-fddc-45bf-827b-5a78f6e84319" } ``` In my library there seems to be just one image file that have embedded video inside. I was able to extract it using ExifTool: ```bash exiftool -b -EmbeddedVideoFile 20231008_174840.jpg > video.mp4 ``` I'm also attaching this image here (in zip archive, as I don't know if plain image would be somehow stripped of metadata when uploaded here). [20231008_174840.zip](https://github.com/immich-app/immich/files/13169471/20231008_174840.zip)
OVERLORD commented 2026-02-05 02:08:50 +03:00
Author
Owner
Copy Link

@jrasm91 commented on GitHub (Oct 25, 2023):

Oh, this is specifically for android live photos and actually, after looking more closely at the screenshot, it appears the asset on the right is a live motion asset (two assets linked together), and the asset on the left is a separate video file. It is unclear if the motion part just needs to be hidden or if there is actually an entirely separate asset that has been crated for some reason. Can you share the asset id and livePhotoVideoId of both of these? Either going to the detail viewer and inspecting the response in the network tab, or by using some database queries.

https://immich.app/docs/guides/database-queries

@jrasm91 commented on GitHub (Oct 25, 2023): Oh, this is specifically for android live photos and actually, after looking more closely at the screenshot, it appears the asset on the right is a live _motion_ asset (two assets linked together), and the asset on the left is _a separate_ video file. It is unclear if the motion part just needs to be hidden or if there is actually an entirely separate asset that has been crated for some reason. Can you share the asset id and livePhotoVideoId of both of these? Either going to the detail viewer and inspecting the response in the network tab, or by using some database queries. https://immich.app/docs/guides/database-queries
OVERLORD commented 2026-02-05 02:08:52 +03:00
Author
Owner
Copy Link

@zamszowy commented on GitHub (Oct 25, 2023):

Ach, now I see what happened - I have a separate movie file on other docker data volume.

I have one volume with pictures from current phone, and a second one with google photos takeout.
It seems that when uploading picture to google photos, it extracts the embedded video file from picture and saves as a separate file.

Images from current photos volume were also existing in google photos volume, so before scanning libraries I removed duplicated pictures from google photos volume, but I didn't know that I need to also do it for the video leftover files, since they've been separated.
My fault for overlooking this.

I'm pasting database query just in case:

immich=# SELECT * FROM "assets" WHERE "originalFileName" = '20231008_174840';
                  id                  |    deviceAssetId    |               ownerId                |    deviceId    | type  |                                                originalPath                                                 |                                             resizePath                                             |       fileCreatedAt        |       fileModifiedAt       | isFavorite |   duration   |                                              webpPath                                              | encodedVideoPath |                  checksum                  | isVisible |           livePhotoVideoId           |           updatedAt           |           createdAt           | isArchived | originalFileName | sidecarPath | isReadOnly |                  thumbhash                   | isOffline |              libraryId               | isExternal | deletedAt |       localDateTime        
--------------------------------------+---------------------+--------------------------------------+----------------+-------+-------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------+----------------------------+------------+--------------+----------------------------------------------------------------------------------------------------+------------------+--------------------------------------------+-----------+--------------------------------------+-------------------------------+-------------------------------+------------+------------------+-------------+------------+----------------------------------------------+-----------+--------------------------------------+------------+-----------+----------------------------
 630d7599-fddc-45bf-827b-5a78f6e84319 | 20231008_174840.jpg | 6296827d-e3b5-4d79-a3ca-30ff63b347f8 | Library Import | IMAGE | /mnt/data/photos1/DCIM/Camera/20231008_174840.jpg                                                           | upload/thumbs/6296827d-e3b5-4d79-a3ca-30ff63b347f8/63/0d/630d7599-fddc-45bf-827b-5a78f6e84319.jpeg | 2023-10-08 15:48:40.094+00 | 2023-10-08 15:48:43.448+00 | f          |              | upload/thumbs/6296827d-e3b5-4d79-a3ca-30ff63b347f8/63/0d/630d7599-fddc-45bf-827b-5a78f6e84319.webp |                  | \xbf1d368c05b30c378140c755b3c9f9bb4c053525 | t         | 5f444eef-9a01-498a-a911-913521bc9b34 | 2023-10-25 07:10:54.949922+00 | 2023-10-24 17:18:26.157251+00 | f          | 20231008_174840  |             | t          | \x20f8051580f7967be859979764866886676f0c03a8 | f         | 41311003-ff05-4ebe-a59e-36e980a95068 | t          |           | 2023-10-08 17:48:40.094+00
 5f444eef-9a01-498a-a911-913521bc9b34 | NONE                | 6296827d-e3b5-4d79-a3ca-30ff63b347f8 | NONE           | VIDEO | upload/encoded-video/6296827d-e3b5-4d79-a3ca-30ff63b347f8/63/0d/630d7599-fddc-45bf-827b-5a78f6e84319-MP.mp4 |                                                                                                    | 2023-10-08 15:48:43.448+00 | 2023-10-08 15:48:43.448+00 | f          |              |                                                                                                    |                  | \x0f3e50b692dd6f148b0188fa70c8c5f73d88e1c3 | f         |                                      | 2023-10-25 07:10:54.752249+00 | 2023-10-25 07:10:54.752249+00 | f          | 20231008_174840  |             | f          |                                              | f         | 41311003-ff05-4ebe-a59e-36e980a95068 | f          |           | 2023-10-08 15:48:43.448+00
 5aaa40fe-122b-4fea-8edb-4a3bbce430c1 | 20231008_174840.MP4 | 6296827d-e3b5-4d79-a3ca-30ff63b347f8 | Library Import | VIDEO | /mnt/data/photos2/takeout/Takeout/google-photos/Photos from 2023/20231008_174840.MP4                        | upload/thumbs/6296827d-e3b5-4d79-a3ca-30ff63b347f8/5a/aa/5aaa40fe-122b-4fea-8edb-4a3bbce430c1.jpeg | 2023-10-08 15:48:41+00     | 2023-10-10 08:51:48+00     | f          | 00:00:01.121 | upload/thumbs/6296827d-e3b5-4d79-a3ca-30ff63b347f8/5a/aa/5aaa40fe-122b-4fea-8edb-4a3bbce430c1.webp |                  | \xbe9223e5518cff35c231b8bed2197eaa57d2b9af | t         |                                      | 2023-10-25 07:13:22.609341+00 | 2023-10-24 17:23:17.994494+00 | f          | 20231008_174840  |             | t          | \x28080605804256784f6977a6988696769e50360564 | f         | 41311003-ff05-4ebe-a59e-36e980a95068 | t          |           | 2023-10-08 17:48:41+00
(3 rows)

Now that I think of, option to display full path (instead of just file name) in the information window would probably have saved some time discovering the culprit. :)

@zamszowy commented on GitHub (Oct 25, 2023): Ach, now I see what happened - I _have_ a separate movie file on other docker data volume. I have one volume with pictures from current phone, and a second one with google photos takeout. It seems that when uploading picture to google photos, it extracts the embedded video file from picture and saves as a separate file. Images from current photos volume were also existing in google photos volume, so before scanning libraries I removed duplicated pictures from google photos volume, but I didn't know that I need to also do it for the video leftover files, since they've been separated. My fault for overlooking this. I'm pasting database query just in case: ``` immich=# SELECT * FROM "assets" WHERE "originalFileName" = '20231008_174840'; id | deviceAssetId | ownerId | deviceId | type | originalPath | resizePath | fileCreatedAt | fileModifiedAt | isFavorite | duration | webpPath | encodedVideoPath | checksum | isVisible | livePhotoVideoId | updatedAt | createdAt | isArchived | originalFileName | sidecarPath | isReadOnly | thumbhash | isOffline | libraryId | isExternal | deletedAt | localDateTime --------------------------------------+---------------------+--------------------------------------+----------------+-------+-------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------+----------------------------+------------+--------------+----------------------------------------------------------------------------------------------------+------------------+--------------------------------------------+-----------+--------------------------------------+-------------------------------+-------------------------------+------------+------------------+-------------+------------+----------------------------------------------+-----------+--------------------------------------+------------+-----------+---------------------------- 630d7599-fddc-45bf-827b-5a78f6e84319 | 20231008_174840.jpg | 6296827d-e3b5-4d79-a3ca-30ff63b347f8 | Library Import | IMAGE | /mnt/data/photos1/DCIM/Camera/20231008_174840.jpg | upload/thumbs/6296827d-e3b5-4d79-a3ca-30ff63b347f8/63/0d/630d7599-fddc-45bf-827b-5a78f6e84319.jpeg | 2023-10-08 15:48:40.094+00 | 2023-10-08 15:48:43.448+00 | f | | upload/thumbs/6296827d-e3b5-4d79-a3ca-30ff63b347f8/63/0d/630d7599-fddc-45bf-827b-5a78f6e84319.webp | | \xbf1d368c05b30c378140c755b3c9f9bb4c053525 | t | 5f444eef-9a01-498a-a911-913521bc9b34 | 2023-10-25 07:10:54.949922+00 | 2023-10-24 17:18:26.157251+00 | f | 20231008_174840 | | t | \x20f8051580f7967be859979764866886676f0c03a8 | f | 41311003-ff05-4ebe-a59e-36e980a95068 | t | | 2023-10-08 17:48:40.094+00 5f444eef-9a01-498a-a911-913521bc9b34 | NONE | 6296827d-e3b5-4d79-a3ca-30ff63b347f8 | NONE | VIDEO | upload/encoded-video/6296827d-e3b5-4d79-a3ca-30ff63b347f8/63/0d/630d7599-fddc-45bf-827b-5a78f6e84319-MP.mp4 | | 2023-10-08 15:48:43.448+00 | 2023-10-08 15:48:43.448+00 | f | | | | \x0f3e50b692dd6f148b0188fa70c8c5f73d88e1c3 | f | | 2023-10-25 07:10:54.752249+00 | 2023-10-25 07:10:54.752249+00 | f | 20231008_174840 | | f | | f | 41311003-ff05-4ebe-a59e-36e980a95068 | f | | 2023-10-08 15:48:43.448+00 5aaa40fe-122b-4fea-8edb-4a3bbce430c1 | 20231008_174840.MP4 | 6296827d-e3b5-4d79-a3ca-30ff63b347f8 | Library Import | VIDEO | /mnt/data/photos2/takeout/Takeout/google-photos/Photos from 2023/20231008_174840.MP4 | upload/thumbs/6296827d-e3b5-4d79-a3ca-30ff63b347f8/5a/aa/5aaa40fe-122b-4fea-8edb-4a3bbce430c1.jpeg | 2023-10-08 15:48:41+00 | 2023-10-10 08:51:48+00 | f | 00:00:01.121 | upload/thumbs/6296827d-e3b5-4d79-a3ca-30ff63b347f8/5a/aa/5aaa40fe-122b-4fea-8edb-4a3bbce430c1.webp | | \xbe9223e5518cff35c231b8bed2197eaa57d2b9af | t | | 2023-10-25 07:13:22.609341+00 | 2023-10-24 17:23:17.994494+00 | f | 20231008_174840 | | t | \x28080605804256784f6977a6988696769e50360564 | f | 41311003-ff05-4ebe-a59e-36e980a95068 | t | | 2023-10-08 17:48:41+00 (3 rows) ``` Now that I think of, option to display full path (instead of just file name) in the information window would probably have saved some time discovering the culprit. :)
OVERLORD commented 2026-02-05 02:08:54 +03:00
Author
Owner
Copy Link

@jrasm91 commented on GitHub (Oct 25, 2023):

Yes, we need to add that and a few other ways of easily inspecting the json/debug info for a specific asset. :-)

@jrasm91 commented on GitHub (Oct 25, 2023): Yes, we need to add that and a few other ways of easily inspecting the json/debug info for a specific asset. :-)
OVERLORD commented 2026-02-05 02:08:55 +03:00
Author
Owner
Copy Link

@zamszowy commented on GitHub (Oct 26, 2023):

Thank you very much for all your help, I will now close this.

@zamszowy commented on GitHub (Oct 26, 2023): Thank you very much for all your help, I will now close this.
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#1505
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?