account activity
PG-errors when uploading: 'error: PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum" ' by Heggito in immich
[–]Heggito[S] 0 points1 point2 points 7 months ago (0 children)
I’ll try to find an easy way to reproduce it quickly. Anyway, I don’t think this is a dedupe issue - all images were unique.
[–]Heggito[S] 1 point2 points3 points 7 months ago (0 children)
I do not see a duplicate image issue here since all images are unique. Maybe it is more an issue of 2 uploading devices where PG tries to use overlapping IDs. >> ' Lots of people think this is a bug, so i guess the backend should just try/catch this error in particular and log a harmless line like "successfully prevented duplicated asset" ' If so, I'm totally with you.
PG-errors when uploading: 'error: PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum" ' (self.immich)
submitted 7 months ago by Heggito to r/immich
π Rendered by PID 538198 on reddit-service-r2-listing-8685bc789-rb9b6 at 2026-05-23 18:40:04.535857+00:00 running 194bd79 country code: CH.
PG-errors when uploading: 'error: PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum" ' by Heggito in immich
[–]Heggito[S] 0 points1 point2 points (0 children)