ImmichI
Immich•6mo ago
whalewoad

Duplicate Key Error that Prevents Mobile Upload

Hi there! 👋 I'm new to immich, but I've been amazed by the community and codebase! Thank you for all your work. 🙏
I've been encountering an issue where after uploading many photos, I cannot upload any more. When I look at the immich server logs, I see several errors for different photos and videos like in the log below. Do you know why this is happening? Sometimes I am uploading photos under poor network conditions. Could that be part of issue?

Any advice would be appreciated! 

Query failed : {

  durationMs: 2.6932680010795593,

  error: PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum"

      at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26)

      at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6)

      at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)

      at Socket.emit (node:events:518:28)

      at addChunk (node:internal/streams/readable:561:12)

      at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)

      at Readable.push (node:internal/streams/readable:392:5)

      at TCP.onStreamRead (node:internal/stream_base_commons:189:23)

      at TCP.callbackTrampoline (node:internal/async_hooks:130:17) {

    severity_local: 'ERROR',

    severity: 'ERROR',

    code: '23505',

    detail: 'Key ("ownerId", checksum)=(0daa50a3-04fa-47ee-b88a-ef50f4936e9e, \\x17dd9edd6528fb3f1c9f9de1f55a2446ca5abdb7) already exists.
Was this page helpful?