Upload error: duplicate key value violates unique constraint "UQ_assets_owner_checksum" #15051

mmomjian · 2025-01-03T01:25:16Z

The bug

This is a bug/error log that has been present for quite some time.

At least some of the checksummed images are confirmed to not be Live photos on the source device. All errors seem to come from one user, despite the instance having two users.

All images were taken on and uploaded from the iOS client. I suspect it's some kind of upload race condition. It seems like the error only appears a max of one time per file.

The OS that Immich Server is running on

Debian

Version of Immich Server

v1.123.0

Version of Immich Mobile App

v1.123.0

Platform with the issue

Server
Web
Mobile

Your docker-compose.yml content

N/A

External Postgres

Your .env content

N/A

Reproduction steps

Upload an image

Relevant log output

2024-12-30 12:21:13.887 EST [3173250] immich@immich ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2024-12-30 12:21:13.887 EST [3173250] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x0f9a2bdb7971e7d8bb390ce718f0dd6263f07597) already exists.
2024-12-30 12:21:13.887 EST [3173250] immich@immich STATEMENT:  INSERT INTO "assets"("id", "deviceAssetId", "ownerId", "libraryId", "deviceId", "type", "status", "originalPath", "thumbhash"
, "encodedVideoPath", "createdAt", "updatedAt", "deletedAt", "fileCreatedAt", "localDateTime", "fileModifiedAt", "isFavorite", "isArchived", "isExternal", "isOffline", "checksum", "duration
", "isVisible", "livePhotoVideoId", "originalFileName", "sidecarPath", "stackId", "duplicateId") VALUES (DEFAULT, $1, $2, $3, $4, $5, DEFAULT, $6, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAUL
T, $7, $8, $9, $10, $11, DEFAULT, DEFAULT, $12, $13, $14, DEFAULT, $15, DEFAULT, DEFAULT, DEFAULT) RETURNING "id", "status", "encodedVideoPath", "createdAt", "updatedAt", "deletedAt", "isFa
vorite", "isArchived", "isExternal", "isOffline", "isVisible"
2024-12-30 12:21:17.670 EST [3173247] immich@immich ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2024-12-30 12:21:17.670 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x110514e48f93991b9499d6b2c1f8cd56d82c5298) already exists.
2024-12-30 12:21:17.670 EST [3173247] immich@immich STATEMENT:  INSERT INTO "assets"("id", "deviceAssetId", "ownerId", "libraryId", "deviceId", "type", "status", "originalPath", "thumbhash"
, "encodedVideoPath", "createdAt", "updatedAt", "deletedAt", "fileCreatedAt", "localDateTime", "fileModifiedAt", "isFavorite", "isArchived", "isExternal", "isOffline", "checksum", "duration
", "isVisible", "livePhotoVideoId", "originalFileName", "sidecarPath", "stackId", "duplicateId") VALUES (DEFAULT, $1, $2, $3, $4, $5, DEFAULT, $6, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAUL
T, $7, $8, $9, $10, $11, DEFAULT, DEFAULT, $12, $13, $14, DEFAULT, $15, DEFAULT, DEFAULT, DEFAULT) RETURNING "id", "status", "encodedVideoPath", "createdAt", "updatedAt", "deletedAt", "isFa
vorite", "isArchived", "isExternal", "isOffline", "isVisible"
2024-12-30 12:21:18.517 EST [3173247] immich@immich ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2024-12-30 12:21:18.517 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x91d246c5904b88187e2effa7a166bdbecf169088) already exists.
2024-12-30 12:21:18.517 EST [3173247] immich@immich STATEMENT:  INSERT INTO "assets"("id", "deviceAssetId", "ownerId", "libraryId", "deviceId", "type", "status", "originalPath", "thumbhash"
, "encodedVideoPath", "createdAt", "updatedAt", "deletedAt", "fileCreatedAt", "localDateTime", "fileModifiedAt", "isFavorite", "isArchived", "isExternal", "isOffline", "checksum", "duration
", "isVisible", "livePhotoVideoId", "originalFileName", "sidecarPath", "stackId", "duplicateId") VALUES (DEFAULT, $1, $2, $3, $4, $5, DEFAULT, $6, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAUL
T, $7, $8, $9, $10, $11, DEFAULT, DEFAULT, $12, $13, $14, DEFAULT, $15, DEFAULT, DEFAULT, DEFAULT) RETURNING "id", "status", "encodedVideoPath", "createdAt", "updatedAt", "deletedAt", "isFa
vorite", "isArchived", "isExternal", "isOffline", "isVisible"
2024-12-30 12:21:25.940 EST [3173247] immich@immich ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2024-12-30 12:21:25.940 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x554231ea0e5350be99b426f0904ab2bbd0972dc1) already exists.
2024-12-30 12:21:25.940 EST [3173247] immich@immich STATEMENT:  INSERT INTO "assets"("id", "deviceAssetId", "ownerId", "libraryId", "deviceId", "type", "status", "originalPath", "thumbhash"
, "encodedVideoPath", "createdAt", "updatedAt", "deletedAt", "fileCreatedAt", "localDateTime", "fileModifiedAt", "isFavorite", "isArchived", "isExternal", "isOffline", "checksum", "duration
", "isVisible", "livePhotoVideoId", "originalFileName", "sidecarPath", "stackId", "duplicateId") VALUES (DEFAULT, $1, $2, $3, $4, $5, DEFAULT, $6, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAUL
T, $7, $8, $9, $10, $11, DEFAULT, DEFAULT, $12, $13, $14, DEFAULT, $15, DEFAULT, DEFAULT, DEFAULT) RETURNING "id", "status", "encodedVideoPath", "createdAt", "updatedAt", "deletedAt", "isFa
vorite", "isArchived", "isExternal", "isOffline", "isVisible"
2024-12-30 12:21:26.614 EST [3173247] immich@immich ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2024-12-30 12:21:26.614 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x33f32a52dd750289326d8c517f67c428644ac92e) already exists.
2024-12-30 12:21:26.614 EST [3173247] immich@immich STATEMENT:  INSERT INTO "assets"("id", "deviceAssetId", "ownerId", "libraryId", "deviceId", "type", "status", "originalPath", "thumbhash", "encodedVideoPath", "createdAt", "updatedAt", "deletedAt", "fileCreatedAt", "localDateTime", "fileModifiedAt", "isFavorite", "isArchived", "isExternal", "isOffline", "checksum", "duration", "isVisible", "livePhotoVideoId", "originalFileName", "sidecarPath", "stackId", "duplicateId") VALUES (DEFAULT, $1, $2, $3, $4, $5, DEFAULT, $6, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, $7, $8, $9, $10, $11, DEFAULT, DEFAULT, $12, $13, $14, DEFAULT, $15, DEFAULT, DEFAULT, DEFAULT) RETURNING "id", "status", "encodedVideoPath", "createdAt", "updatedAt", "deletedAt", "isFavorite", "isArchived", "isExternal", "isOffline", "isVisible"
2024-12-30 12:21:32.670 EST [3173247] immich@immich ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2024-12-30 12:21:32.670 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x110514e48f93991b9499d6b2c1f8cd56d82c5298) already exists.
2024-12-30 12:21:32.670 EST [3173247] immich@immich STATEMENT:  INSERT INTO "assets"("id", "deviceAssetId", "ownerId", "libraryId", "deviceId", "type", "status", "originalPath", "thumbhash", "encodedVideoPath", "createdAt", "updatedAt", "deletedAt", "fileCreatedAt", "localDateTime", "fileModifiedAt", "isFavorite", "isArchived", "isExternal", "isOffline", "checksum", "duration", "isVisible", "livePhotoVideoId", "originalFileName", "sidecarPath", "stackId", "duplicateId") VALUES (DEFAULT, $1, $2, $3, $4, $5, DEFAULT, $6, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, $7, $8, $9, $10, $11, DEFAULT, DEFAULT, $12, $13, $14, DEFAULT, $15, DEFAULT, DEFAULT, DEFAULT) RETURNING "id", "status", "encodedVideoPath", "createdAt", "updatedAt", "deletedAt", "isFavorite", "isArchived", "isExternal", "isOffline", "isVisible"

2024-12-29 04:40:29.631 EST [286228] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \xfc83718c4f963cd4c5768fff7060395210215eb1) already exists.
2024-12-30 12:21:13.887 EST [3173250] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x0f9a2bdb7971e7d8bb390ce718f0dd6263f07597) already exists.
2024-12-30 12:21:17.670 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x110514e48f93991b9499d6b2c1f8cd56d82c5298) already exists.
2024-12-30 12:21:18.517 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x91d246c5904b88187e2effa7a166bdbecf169088) already exists.
2024-12-30 12:21:25.940 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x554231ea0e5350be99b426f0904ab2bbd0972dc1) already exists.
2024-12-30 12:21:26.614 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x33f32a52dd750289326d8c517f67c428644ac92e) already exists.
2024-12-30 12:21:32.670 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x110514e48f93991b9499d6b2c1f8cd56d82c5298) already exists.
2024-12-30 12:21:33.085 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x33f32a52dd750289326d8c517f67c428644ac92e) already exists.
2024-12-30 12:21:33.609 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x7f8b2d0f7b121850a7d7b5ca0cf6590cb4cc5b78) already exists.
2024-12-30 12:21:33.707 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x554231ea0e5350be99b426f0904ab2bbd0972dc1) already exists.
2024-12-30 12:21:34.295 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x58d5c391c848c75bd923735908100755b3456276) already exists.
2024-12-30 12:21:34.334 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x91d246c5904b88187e2effa7a166bdbecf169088) already exists.
2024-12-30 12:21:34.775 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \xdb191ad14caee582a79e104d5d55ef82201caccf) already exists.
2024-12-30 12:21:34.832 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x0f9a2bdb7971e7d8bb390ce718f0dd6263f07597) already exists.
2024-12-30 12:21:34.992 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \xdbf54a03f65f772fbc987827786bc32684a7f855) already exists.
2024-12-30 12:21:35.001 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x70fd9a5103f28bd175c4939541c9e1689dad3aeb) already exists.
2024-12-30 12:21:35.906 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x1346d64b035da8736bbbc0f07a0cbe0b21ce272d) already exists.
2024-12-30 12:21:36.298 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x45b673caadc3f3e33d32aa1b6fe35ce354fdd48b) already exists.
2024-12-30 12:21:36.626 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x2de02c3e3debf675b6199c66b25f650e73585754) already exists.
2024-12-30 12:21:37.405 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \xec7e8e038669c1e3060f6f62b15b5e626d2af124) already exists.
2024-12-30 12:21:39.741 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x3feb81bc06fa5bd7585d417a5a299c213aa91cd4) already exists.
2024-12-30 12:21:40.277 EST [3173247] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x3fea3f61fafd36c2c66a645b2c5d0eb35cc0745a) already exists.
2024-12-30 12:21:40.879 EST [3173250] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x2d10b6716ed7086972b40e60be450309f3ac40e6) already exists.
2024-12-30 12:21:41.526 EST [3173250] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x575d2cbd9b86bc30d241a87e06ebd1250686c320) already exists.
2024-12-30 12:21:41.802 EST [3173250] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \xf08ea1600cfaeccfd3837f6b2158b1ce7292c0ad) already exists.
2025-01-02 13:04:53.611 EST [118038] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \xb40e611d175b59bbf1d3b945e136c902ff891a28) already exists.
2025-01-02 13:04:53.707 EST [118038] immich@immich DETAIL:  Key ("ownerId", checksum)=(c36ed9e6-26c9-4b89-b457-5b078897482d, \x18dfc4c838c25c7b9379ad29d7f143edb2497610) already exists.



### Additional information

_No response_

The text was updated successfully, but these errors were encountered:

dannyxu2015 · 2025-01-03T07:32:10Z

version: 1.123.0
OS: Debian 11(bullseye)
SoC: RK3588

[Nest] 17  - 01/03/2025, 3:27:33 PM     LOG [Api:EventRepository] Websocket Connect:    mKYXKKV-X9yflSPuAABF
[Nest] 7  - 01/03/2025, 3:27:39 PM     LOG [Microservices:LibraryService] Refreshing library bee24505-7455-44f3-b949-b617c326eafb for new assets
[Nest] 7  - 01/03/2025, 3:27:39 PM     LOG [Microservices:LibraryService] Scanning library bee24505-7455-44f3-b949-b617c326eafb for removed assets
[Nest] 7  - 01/03/2025, 3:27:39 PM     LOG [Microservices:LibraryService] Finished queueing check of 38 assets for library bee24505-7455-44f3-b949-b617c326eafb
[Nest] 7  - 01/03/2025, 3:27:41 PM   ERROR [Microservices:MetadataService] Failed to extract live photo /mnt/photos2/U1833403067267301378/我的相册/Samsung_Galaxy_S8+.jpg: QueryFailedError: duplicate key value violates unique constraint "UQ_assets_owner_library_checksum"
QueryFailedError: duplicate key value violates unique constraint "UQ_assets_owner_library_checksum"
    at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async InsertQueryBuilder.execute (/usr/src/app/node_modules/typeorm/query-builder/InsertQueryBuilder.js:106:33)
    at async SubjectExecutor.executeInsertOperations (/usr/src/app/node_modules/typeorm/persistence/SubjectExecutor.js:260:42)
    at async SubjectExecutor.execute (/usr/src/app/node_modules/typeorm/persistence/SubjectExecutor.js:92:9)
    at async EntityPersistExecutor.execute (/usr/src/app/node_modules/typeorm/persistence/EntityPersistExecutor.js:140:21)
    at async MetadataService.applyMotionPhotos (/usr/src/app/dist/services/metadata.service.js:339:31)
    at async MetadataService.handleMetadataExtraction (/usr/src/app/dist/services/metadata.service.js:164:9)
    at async JobService.onJobStart (/usr/src/app/dist/services/job.service.js:148:28)
    at async EventRepository.onEvent (/usr/src/app/dist/repositories/event.repository.js:134:13)
[Nest] 7  - 01/03/2025, 3:27:48 PM     LOG [Microservices:TrashService] Queued 1 assets for deletion from the trash
[Nest] 7  - 01/03/2025, 3:27:48 PM    WARN [Microservices:StorageService] Unable to remove file from disk
[Nest] 7  - 01/03/2025, 3:27:48 PM    WARN [Microservices:StorageService] Error: EROFS: read-only file system, unlink '/mnt/photos2/U1833403067267301378/我的相册/Samsung_Galaxy_S8+.jpg'
[Nest] 17  - 01/03/2025, 3:27:54 PM    WARN [Api:PersonService~9u6foc25] Unknown keys found: {
  "machineLearning": {
    "url": "http://immich-machine-learning:3003"
  }
}

dannyxu2015 · 2025-01-03T07:35:34Z

It occurred occasionally, not every time when I upload the same photo

dannyxu2015 · 2025-01-03T07:41:32Z

Sometimes got "Duplicate SOI marker"

[Nest] 7  - 01/03/2025, 2:50:17 PM     LOG [Microservices:LibraryService] Importing new library asset: /mnt/photos2/U1833403067267301378/我的相册/Google_Pixel_2.jpg
[Nest] 7  - 01/03/2025, 2:50:17 PM     LOG [Microservices:LibraryService] Importing new library asset: /mnt/photos2/U1833403067267301378/我的相册/Samsung_Galaxy_Z_Fold4.heic
[Nest] 7  - 01/03/2025, 2:50:17 PM     LOG [Microservices:LibraryService] Importing new library asset: /mnt/photos2/U1833403067267301378/我的备份/来自： iPhone 12 Pro Max 的备份/相册备份/安卓 motion photo/Samsung_Galaxy_S8+.jpg
[Nest] 7  - 01/03/2025, 2:50:17 PM     LOG [Microservices:LibraryService] Importing new library asset: /mnt/photos2/U1833403067267301378/我的相册/Google_Pixel_2.jpg
[Nest] 7  - 01/03/2025, 2:50:17 PM     LOG [Microservices:LibraryService] Importing new library asset: /mnt/photos2/U1833403067267301378/我的相册/Samsung_Galaxy_Z_Fold4.heic
[Nest] 7  - 01/03/2025, 2:50:17 PM   ERROR [Microservices:JobService] Unable to run job handler (library/library-sync-file): QueryFailedError: duplicate key value violates unique constraint "UQ_assets_owner_library_checksum"
[Nest] 7  - 01/03/2025, 2:50:17 PM   ERROR [Microservices:JobService] QueryFailedError: duplicate key value violates unique constraint "UQ_assets_owner_library_checksum"
    at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async InsertQueryBuilder.execute (/usr/src/app/node_modules/typeorm/query-builder/InsertQueryBuilder.js:106:33)
    at async SubjectExecutor.executeInsertOperations (/usr/src/app/node_modules/typeorm/persistence/SubjectExecutor.js:260:42)
    at async SubjectExecutor.execute (/usr/src/app/node_modules/typeorm/persistence/SubjectExecutor.js:92:9)
    at async EntityPersistExecutor.execute (/usr/src/app/node_modules/typeorm/persistence/EntityPersistExecutor.js:140:21)
    at async LibraryService.handleSyncFile (/usr/src/app/dist/services/library.service.js:341:17)
    at async JobService.onJobStart (/usr/src/app/dist/services/job.service.js:148:28)
    at async EventRepository.onEvent (/usr/src/app/dist/repositories/event.repository.js:134:13)
    at async Worker.processJob (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:394:28)
[Nest] 7  - 01/03/2025, 2:50:17 PM   ERROR [Microservices:JobService] Object:
{
  "id": "bee24505-7455-44f3-b949-b617c326eafb",
  "assetPath": "/mnt/photos2/U1833403067267301378/我的相册/Google_Pixel_2.jpg",
  "ownerId": "2af2fdc1-f374-417e-9e0f-3660d26b9793"
}

[Nest] 7  - 01/03/2025, 2:50:17 PM   ERROR [Microservices:JobService] Unable to run job handler (library/library-sync-file): QueryFailedError: duplicate key value violates unique constraint "UQ_assets_owner_library_checksum"
[Nest] 7  - 01/03/2025, 2:50:17 PM   ERROR [Microservices:JobService] QueryFailedError: duplicate key value violates unique constraint "UQ_assets_owner_library_checksum"
    at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async InsertQueryBuilder.execute (/usr/src/app/node_modules/typeorm/query-builder/InsertQueryBuilder.js:106:33)
    at async SubjectExecutor.executeInsertOperations (/usr/src/app/node_modules/typeorm/persistence/SubjectExecutor.js:260:42)
    at async SubjectExecutor.execute (/usr/src/app/node_modules/typeorm/persistence/SubjectExecutor.js:92:9)
    at async EntityPersistExecutor.execute (/usr/src/app/node_modules/typeorm/persistence/EntityPersistExecutor.js:140:21)
    at async LibraryService.handleSyncFile (/usr/src/app/dist/services/library.service.js:341:17)
    at async JobService.onJobStart (/usr/src/app/dist/services/job.service.js:148:28)
    at async EventRepository.onEvent (/usr/src/app/dist/repositories/event.repository.js:134:13)
    at async Worker.processJob (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:394:28)
[Nest] 7  - 01/03/2025, 2:50:17 PM   ERROR [Microservices:JobService] Object:
{
  "id": "bee24505-7455-44f3-b949-b617c326eafb",
  "assetPath": "/mnt/photos2/U1833403067267301378/我的相册/Samsung_Galaxy_Z_Fold4.heic",
  "ownerId": "2af2fdc1-f374-417e-9e0f-3660d26b9793"
}

[Nest] 7  - 01/03/2025, 2:50:18 PM     LOG [Microservices:MetadataService] Wrote motion photo video to upload/encoded-video/2af2fdc1-f374-417e-9e0f-3660d26b9793/14/0b/140b2f6e-744a-47c2-83eb-5c0a792beb80-MP.mp4
[Nest] 7  - 01/03/2025, 2:50:18 PM   ERROR [Microservices:JobService] Unable to run job handler (thumbnailGeneration/generate-thumbnails): Error: VipsJpeg: ./lib/jpegli/decode_scan.cc:535: Incomplete scan detected.
VipsJpeg: ./lib/jpegli/decode_marker.cc:448: Duplicate SOI marker
[Nest] 7  - 01/03/2025, 2:50:18 PM   ERROR [Microservices:JobService] Error: VipsJpeg: ./lib/jpegli/decode_scan.cc:535: Incomplete scan detected.
VipsJpeg: ./lib/jpegli/decode_marker.cc:448: Duplicate SOI marker
    at Sharp.toBuffer (/usr/src/app/node_modules/sharp/lib/output.js:163:17)
    at MediaRepository.decodeImage (/usr/src/app/dist/repositories/media.repository.js:57:68)
    at MediaService.generateImageThumbnails (/usr/src/app/dist/services/media.service.js:161:63)
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async MediaService.handleGenerateThumbnails (/usr/src/app/dist/services/media.service.js:111:25)
    at async JobService.onJobStart (/usr/src/app/dist/services/job.service.js:148:28)
    at async EventRepository.onEvent (/usr/src/app/dist/repositories/event.repository.js:134:13)
    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] 7  - 01/03/2025, 2:50:18 PM   ERROR [Microservices:JobService] Object:
{
  "id": "2a6b6254-163a-4670-a240-f93526241240",
  "source": "upload"
}

mmomjian mentioned this issue Jan 3, 2025

[BUG] duplicate key value violates unique constraint "UQ_assets_owner_library_checksum" #5067

Closed

3 tasks

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Upload error: duplicate key value violates unique constraint "UQ_assets_owner_checksum" #15051

Upload error: duplicate key value violates unique constraint "UQ_assets_owner_checksum" #15051

mmomjian commented Jan 3, 2025 •

edited

Loading

dannyxu2015 commented Jan 3, 2025

dannyxu2015 commented Jan 3, 2025

dannyxu2015 commented Jan 3, 2025

Upload error: duplicate key value violates unique constraint "UQ_assets_owner_checksum" #15051

Upload error: duplicate key value violates unique constraint "UQ_assets_owner_checksum" #15051

Comments

mmomjian commented Jan 3, 2025 • edited Loading

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

dannyxu2015 commented Jan 3, 2025

dannyxu2015 commented Jan 3, 2025

dannyxu2015 commented Jan 3, 2025

mmomjian commented Jan 3, 2025 •

edited

Loading