immich_postgres | Using SSD storage immich_postgres | immich_postgres | PostgreSQL Database directory appears to contain a database; Skipping initialization immich_postgres | immich_postgres | 2025-06-24 10:05:20.548 GMT [1] LOG: skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf" immich_postgres | 2025-06-24 10:05:20.549 GMT [1] LOG: skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf" immich_postgres | 2025-06-24 10:05:24.564 UTC [1] LOG: starting PostgreSQL 14.17 (Debian 14.17-1.pgdg120+1) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit immich_postgres | 2025-06-24 10:05:24.570 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 immich_postgres | 2025-06-24 10:05:24.570 UTC [1] LOG: listening on IPv6 address "::", port 5432 immich_postgres | 2025-06-24 10:05:24.574 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" immich_postgres | 2025-06-24 10:05:24.579 UTC [32] LOG: database system was shut down at 2025-06-24 10:05:19 UTC immich_postgres | 2025-06-24 10:05:24.603 UTC [1] LOG: database system is ready to accept connections immich_postgres | 2025-06-24 12:59:42.084 UTC [1090] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 12:59:42.084 UTC [1090] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \xe1fae3aa2c78e22211aef5e7a205267669ea2813) already exists. immich_postgres | 2025-06-24 12:59:42.084 UTC [1090] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:25:34.717 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:25:34.717 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x52f74f9d6512ec17ea526e3e9724d86a38a77582) already exists. immich_postgres | 2025-06-24 22:25:34.717 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:25:41.252 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:25:41.252 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x1021055aee0bfb052ea780d192f0a3b758f93cca) already exists. immich_postgres | 2025-06-24 22:25:41.252 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:25:46.658 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:25:46.658 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \xd0b558c90a537bfa2b004b6aa95410c1bf9f7a20) already exists. immich_postgres | 2025-06-24 22:25:46.658 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:25:50.822 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:25:50.822 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x805c704c6629ea91e9a787aa0229e233a5e8bbd1) already exists. immich_postgres | 2025-06-24 22:25:50.822 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:25:58.286 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:25:58.286 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \xc62a1ad739f6bcb88eb6ecab77e1bbebd806fad9) already exists. immich_postgres | 2025-06-24 22:25:58.286 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:26:08.043 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:26:08.043 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x7f970a89e495f94cd9483151274fb8f4d9b26034) already exists. immich_postgres | 2025-06-24 22:26:08.043 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:26:19.148 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:26:19.148 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \xc7cc2c4e50978979fd7cbc625a5c0fd356b275e4) already exists. immich_postgres | 2025-06-24 22:26:19.148 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:26:29.714 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:26:29.714 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \xcb2e60102f598613ff6b7bccf72da667790fedb9) already exists. immich_postgres | 2025-06-24 22:26:29.714 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:26:36.059 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:26:36.059 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \xdfe196bba0e2f33a6b15a2726401c89a9a34818d) already exists. immich_postgres | 2025-06-24 22:26:36.059 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:26:41.413 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:26:41.413 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x34ab651b024102756cf81a023be8c9d9b49c6fbc) already exists. immich_postgres | 2025-06-24 22:26:41.413 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:26:53.611 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:26:53.611 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x35fa132df2a25370e11819cd6d01b6e6d037263d) already exists. immich_postgres | 2025-06-24 22:26:53.611 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:27:00.535 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:27:00.535 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x407274a730e76fc216458cb79f1113d26bd5904c) already exists. immich_postgres | 2025-06-24 22:27:00.535 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:27:07.766 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:27:07.766 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x8be4697d3cdf92a20435e933f451dbd8060c96f0) already exists. immich_postgres | 2025-06-24 22:27:07.766 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:27:14.404 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:27:14.404 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x6e7ba508ef13419fe2f7c9b16048c3969c5b2be1) already exists. immich_postgres | 2025-06-24 22:27:14.404 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:27:21.364 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:27:21.364 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x4bc2379328f49dbaef8eef442cd0cb7870bda065) already exists. immich_postgres | 2025-06-24 22:27:21.364 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:27:27.672 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:27:27.672 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x40647e27d9d538ef37c10fd7ecd564d848383feb) already exists. immich_postgres | 2025-06-24 22:27:27.672 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:27:32.738 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:27:32.738 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \xeefebfbf6a7bee752466f8eb562f70d03f1e254e) already exists. immich_postgres | 2025-06-24 22:27:32.738 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:27:38.389 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:27:38.389 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x38214b490ada42fd61a181f1ba3fca91926390a5) already exists. immich_postgres | 2025-06-24 22:27:38.389 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:27:42.901 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:27:42.901 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x70b28fa6d5c8813af6c0687db08f0e35224d3787) already exists. immich_postgres | 2025-06-24 22:27:42.901 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:27:48.191 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:27:48.191 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \xe207cffbf75a01c43329e29a1b8f7bedb393c444) already exists. immich_postgres | 2025-06-24 22:27:48.191 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:27:54.271 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:27:54.271 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x9c28a8d09f496c1ac3869d1a6f4abf4a634637e9) already exists. immich_postgres | 2025-06-24 22:27:54.271 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:28:00.579 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:28:00.579 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x26999e0e9b26186120a065f07ea9e63372512596) already exists. immich_postgres | 2025-06-24 22:28:00.579 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:28:08.582 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:28:08.582 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x2a5b213d16c1a4ea401ea12d9af7e80dd63a291c) already exists. immich_postgres | 2025-06-24 22:28:08.582 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:28:14.940 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:28:14.940 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x6106c043c77f9d0b0ee01f129c524bcdb3e7926c) already exists. immich_postgres | 2025-06-24 22:28:14.940 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:28:19.211 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:28:19.211 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x42e89774ce5bff180a6d883e7bb5af8deda30d50) already exists. immich_postgres | 2025-06-24 22:28:19.211 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:28:24.871 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:28:24.871 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x1ea19f0251d7313fba6b6d29e2dad66896d26f2a) already exists. immich_postgres | 2025-06-24 22:28:24.871 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:28:33.064 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:28:33.064 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x7c716cfd56a7f1e053d36dfa215784401283539a) already exists. immich_postgres | 2025-06-24 22:28:33.064 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:28:40.568 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:28:40.568 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x4e9c7b9085609ec828bd82f49eddca7cdad410cd) already exists. immich_postgres | 2025-06-24 22:28:40.568 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:28:45.247 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:28:45.247 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \xbfe1ea06cece80a0066c0288baaa3d19fb4ab113) already exists. immich_postgres | 2025-06-24 22:28:45.247 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:28:49.509 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:28:49.509 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x4849fba2e0f19e31a294b226e4ae60511b729819) already exists. immich_postgres | 2025-06-24 22:28:49.509 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:28:55.864 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:28:55.864 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x8f80648a9dff8b397ba48ab5bec03e41a14c7e62) already exists. immich_postgres | 2025-06-24 22:28:55.864 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:29:05.122 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:29:05.122 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x8da581d21f3d598031e91784aa11ea4701aa54d7) already exists. immich_postgres | 2025-06-24 22:29:05.122 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:29:16.751 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:29:16.751 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x3ca4e93c6fadea99c2abedcf6245a6dd27adc6ae) already exists. immich_postgres | 2025-06-24 22:29:16.751 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:29:26.962 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:29:26.962 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x4fce9df96af47321d80cb1d5797037bfd27baa59) already exists. immich_postgres | 2025-06-24 22:29:26.962 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:29:34.917 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:29:34.917 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x66ebb5a2571e502a4713449622227afe93876bcb) already exists. immich_postgres | 2025-06-24 22:29:34.917 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:29:42.973 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:29:42.973 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x5a182ec22da0b2fb4e52553df86e353f378bdbe0) already exists. immich_postgres | 2025-06-24 22:29:42.973 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:29:48.643 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:29:48.643 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x0ad2177ec9417b33ff3d91ff8bf9680bfaac49d3) already exists. immich_postgres | 2025-06-24 22:29:48.643 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:29:55.709 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:29:55.709 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x0a97f3c15bd7e916c14980c76e011b78ea7e8255) already exists. immich_postgres | 2025-06-24 22:29:55.709 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:30:01.514 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:30:01.514 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x7ac481b151e3008706bdd706f0eff9ba55d46edf) already exists. immich_postgres | 2025-06-24 22:30:01.514 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:30:05.619 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:30:05.619 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \xed0ffa397059f68b92e9f17a120085b1df55d48f) already exists. immich_postgres | 2025-06-24 22:30:05.619 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:30:10.464 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:30:10.464 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x01e44f6f4ebc5fb9940e6d628b4024e131ef3a54) already exists. immich_postgres | 2025-06-24 22:30:10.464 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:30:16.559 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:30:16.559 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \xbdc58dab74769497f565532cd4f13c16ad596324) already exists. immich_postgres | 2025-06-24 22:30:16.559 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:30:22.581 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:30:22.581 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \xde4134861162a6e720a88cae4fa460358c589276) already exists. immich_postgres | 2025-06-24 22:30:22.581 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:30:27.938 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:30:27.938 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \xe688c0b20b024355360b64c6091b3b99766ca956) already exists. immich_postgres | 2025-06-24 22:30:27.938 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:30:32.354 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:30:32.354 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \xd88b47b2705ee0df09881f8e61e2977938f5c117) already exists. immich_postgres | 2025-06-24 22:30:32.354 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:30:36.400 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:30:36.400 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \xb283c4cdf49164e76710904ef95258cf2e6b2be1) already exists. immich_postgres | 2025-06-24 22:30:36.400 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:30:41.006 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:30:41.006 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x4b3d185ddbc13b9cf3ddb8e36962445fa9175057) already exists. immich_postgres | 2025-06-24 22:30:41.006 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:30:46.022 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:30:46.022 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \xb204bf1c46dd792408c91126091c8fc4faa9026d) already exists. immich_postgres | 2025-06-24 22:30:46.022 UTC [4461] STATEMENT: insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning * immich_postgres | 2025-06-24 22:30:51.151 UTC [4461] ERROR: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_postgres | 2025-06-24 22:30:51.151 UTC [4461] DETAIL: Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \x0c005692e2e3c51b1cca7c0879a667ec4f135516) already exists. immich_server | Initializing Immich v1.135.3 immich_server | Detected CPU Cores: 2 immich_server | Starting api worker immich_server | Starting microservices worker immich_server | [Nest] 7 - 06/24/2025, 10:05:29 AM LOG [Microservices:EventRepository] Initialized websocket server immich_server | [Nest] 7 - 06/24/2025, 10:05:29 AM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 20179 rows immich_server | [Nest] 7 - 06/24/2025, 10:05:29 AM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 12351 rows immich_server | [Nest] 7 - 06/24/2025, 10:05:29 AM LOG [Microservices:DatabaseRepository] Running migrations, this may take a while immich_server | [Nest] 17 - 06/24/2025, 10:05:30 AM LOG [Api:EventRepository] Initialized websocket server immich_server | [Nest] 7 - 06/24/2025, 10:05:30 AM LOG [Microservices:DatabaseRepository] Migration "1750189909087-AddAlbumUserCreateFields" succeeded immich_server | [Nest] 7 - 06/24/2025, 10:05:30 AM LOG [Microservices:DatabaseRepository] Migration "1750323941566-UnsetPrewarmDimParameter" succeeded immich_server | [Nest] 7 - 06/24/2025, 10:05:30 AM LOG [Microservices:MetadataService] Bootstrapping metadata service immich_server | [Nest] 7 - 06/24/2025, 10:05:30 AM LOG [Microservices:MetadataService] Initializing metadata service immich_server | [Nest] 17 - 06/24/2025, 10:05:30 AM LOG [Api:DatabaseRepository] targetLists=1, current=1 for clip_index of 20179 rows immich_server | [Nest] 17 - 06/24/2025, 10:05:30 AM LOG [Api:DatabaseRepository] targetLists=1, current=1 for face_index of 12351 rows immich_server | [Nest] 17 - 06/24/2025, 10:05:30 AM LOG [Api:DatabaseRepository] Running migrations, this may take a while immich_server | [Nest] 7 - 06/24/2025, 10:05:30 AM LOG [Microservices:MapRepository] Initializing metadata repository immich_server | [Nest] 7 - 06/24/2025, 10:05:30 AM LOG [Microservices:MetadataService] Initialized local reverse geocoder immich_server | [Nest] 7 - 06/24/2025, 10:05:30 AM LOG [Microservices:ServerService] Feature Flags: { immich_server | "smartSearch": true, immich_server | "facialRecognition": true, immich_server | "duplicateDetection": true, immich_server | "map": true, immich_server | "reverseGeocoding": true, immich_server | "importFaces": true, immich_server | "sidecar": true, immich_server | "search": true, immich_server | "trash": true, immich_server | "oauth": false, immich_server | "oauthAutoLaunch": false, immich_server | "passwordLogin": true, immich_server | "configFile": false, immich_server | "email": true immich_server | } immich_server | [Nest] 7 - 06/24/2025, 10:05:30 AM LOG [Microservices:StorageService] Verifying system mount folder checks, current state: {"mountFiles":true,"mountChecks":{"thumbs":true,"upload":true,"backups":true,"library":true,"profile":true,"encoded-video":true}} immich_server | [Nest] 7 - 06/24/2025, 10:05:30 AM LOG [Microservices:StorageService] Successfully verified system mount folder checks immich_server | [Nest] 17 - 06/24/2025, 10:05:30 AM LOG [Api:ServerService] Feature Flags: { immich_server | "smartSearch": true, immich_server | "facialRecognition": true, immich_server | "duplicateDetection": true, immich_server | "map": true, immich_server | "reverseGeocoding": true, immich_server | "importFaces": true, immich_server | "sidecar": true, immich_server | "search": true, immich_server | "trash": true, immich_server | "oauth": false, immich_server | "oauthAutoLaunch": false, immich_server | "passwordLogin": true, immich_server | "configFile": false, immich_server | "email": true immich_server | } immich_server | [Nest] 17 - 06/24/2025, 10:05:30 AM LOG [Api:StorageService] Verifying system mount folder checks, current state: {"mountFiles":true,"mountChecks":{"thumbs":true,"upload":true,"backups":true,"library":true,"profile":true,"encoded-video":true}} immich_server | [Nest] 17 - 06/24/2025, 10:05:30 AM LOG [Api:StorageService] Successfully verified system mount folder checks immich_server | [Nest] 7 - 06/24/2025, 10:05:30 AM LOG [Microservices:VersionService] Adding 1.135.3 to upgrade history immich_server | Query failed : { immich_server | durationMs: 19.428427999839187, immich_server | error: PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_server | at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26) immich_server | at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6) immich_server | at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9) immich_server | at Socket.emit (node:events:518:28) immich_server | at addChunk (node:internal/streams/readable:561:12) immich_server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich_server | at Readable.push (node:internal/streams/readable:392:5) immich_server | at TCP.onStreamRead (node:internal/stream_base_commons:189:23) immich_server | at TCP.callbackTrampoline (node:internal/async_hooks:130:17) { immich_server | severity_local: 'ERROR', immich_server | severity: 'ERROR', immich_server | code: '23505', immich_server | detail: 'Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \\xe1fae3aa2c78e22211aef5e7a205267669ea2813) already exists.', immich_server | schema_name: 'public', immich_server | table_name: 'assets', immich_server | constraint_name: 'UQ_assets_owner_checksum', immich_server | file: 'nbtinsert.c', immich_server | line: '663', immich_server | routine: '_bt_check_unique' immich_server | }, immich_server | sql: 'insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *', immich_server | params: [ immich_server | '0e8b97b4-e566-47eb-a413-d359046c4d6a', immich_server | null, immich_server | , immich_server | 'upload/upload/0e8b97b4-e566-47eb-a413-d359046c4d6a/ac/4e/ac4ea7be-fb15-41f9-a14b-04a6bed3b51d.jpg', immich_server | '8333', immich_server | '740f51c8c3ad4433edf412a4e51568e2b40d04199f0cd73e8281d0276de65593', immich_server | 2025-06-24T01:53:09.000Z, immich_server | 2025-06-24T01:53:14.000Z, immich_server | 2025-06-24T01:53:09.000Z, immich_server | 'IMAGE', immich_server | false, immich_server | '0:00:00.000000', immich_server | 'timeline', immich_server | 'IMG_20250624_035309_418.jpg' immich_server | ] immich_server | } immich_server | Query failed : { immich_server | durationMs: 30.05102500319481, immich_server | error: PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_server | at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26) immich_server | at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6) immich_server | at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9) immich_server | at Socket.emit (node:events:518:28) immich_server | at addChunk (node:internal/streams/readable:561:12) immich_server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich_server | at Readable.push (node:internal/streams/readable:392:5) immich_server | at TCP.onStreamRead (node:internal/stream_base_commons:189:23) immich_server | at TCP.callbackTrampoline (node:internal/async_hooks:130:17) { immich_server | severity_local: 'ERROR', immich_server | severity: 'ERROR', immich_server | code: '23505', immich_server | detail: 'Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \\x52f74f9d6512ec17ea526e3e9724d86a38a77582) already exists.', immich_server | schema_name: 'public', immich_server | table_name: 'assets', immich_server | constraint_name: 'UQ_assets_owner_checksum', immich_server | file: 'nbtinsert.c', immich_server | line: '663', immich_server | routine: '_bt_check_unique' immich_server | }, immich_server | sql: 'insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *', immich_server | params: [ immich_server | '0e8b97b4-e566-47eb-a413-d359046c4d6a', immich_server | null, immich_server | , immich_server | 'upload/upload/0e8b97b4-e566-47eb-a413-d359046c4d6a/8e/74/8e747c34-e64c-4e93-8209-ac9714ff13f6.jpg', immich_server | '4853', immich_server | '740f51c8c3ad4433edf412a4e51568e2b40d04199f0cd73e8281d0276de65593', immich_server | 2025-01-10T13:51:43.000Z, immich_server | 2025-01-10T13:51:45.000Z, immich_server | 2025-01-10T13:51:43.000Z, immich_server | 'IMAGE', immich_server | false, immich_server | '0:00:00.000000', immich_server | 'timeline', immich_server | 'IMG_20250110_135143_922.jpg' immich_server | ] immich_server | } immich_server | Query failed : { immich_server | durationMs: 5.527565002441406, immich_server | error: PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_server | at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26) immich_server | at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6) immich_server | at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9) immich_server | at Socket.emit (node:events:518:28) immich_server | at addChunk (node:internal/streams/readable:561:12) immich_server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich_server | at Readable.push (node:internal/streams/readable:392:5) immich_server | at TCP.onStreamRead (node:internal/stream_base_commons:189:23) immich_server | at TCP.callbackTrampoline (node:internal/async_hooks:130:17) { immich_server | severity_local: 'ERROR', immich_server | severity: 'ERROR', immich_server | code: '23505', immich_server | detail: 'Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \\x1021055aee0bfb052ea780d192f0a3b758f93cca) already exists.', immich_server | schema_name: 'public', immich_server | table_name: 'assets', immich_server | constraint_name: 'UQ_assets_owner_checksum', immich_server | file: 'nbtinsert.c', immich_server | line: '663', immich_server | routine: '_bt_check_unique' immich_server | }, immich_server | sql: 'insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *', immich_server | params: [ immich_server | '0e8b97b4-e566-47eb-a413-d359046c4d6a', immich_server | null, immich_server | , immich_server | 'upload/upload/0e8b97b4-e566-47eb-a413-d359046c4d6a/47/57/4757264e-012d-4e01-b0e7-622e1656748d.jpg', immich_server | '4868', immich_server | '740f51c8c3ad4433edf412a4e51568e2b40d04199f0cd73e8281d0276de65593', immich_server | 2025-01-11T09:19:01.000Z, immich_server | 2025-01-11T09:19:03.000Z, immich_server | 2025-01-11T09:19:01.000Z, immich_server | 'IMAGE', immich_server | false, immich_server | '0:00:00.000000', immich_server | 'timeline', immich_server | 'IMG_20250111_091901_952.jpg' immich_server | ] immich_server | } immich_server | Query failed : { immich_server | durationMs: 6.462339997291565, immich_server | error: PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_server | at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26) immich_server | at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6) immich_server | at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9) immich_server | at Socket.emit (node:events:518:28) immich_server | at addChunk (node:internal/streams/readable:561:12) immich_server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich_server | at Readable.push (node:internal/streams/readable:392:5) immich_server | at TCP.onStreamRead (node:internal/stream_base_commons:189:23) immich_server | at TCP.callbackTrampoline (node:internal/async_hooks:130:17) { immich_server | severity_local: 'ERROR', immich_server | severity: 'ERROR', immich_server | code: '23505', immich_server | detail: 'Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \\xd0b558c90a537bfa2b004b6aa95410c1bf9f7a20) already exists.', immich_server | schema_name: 'public', immich_server | table_name: 'assets', immich_server | constraint_name: 'UQ_assets_owner_checksum', immich_server | file: 'nbtinsert.c', immich_server | line: '663', immich_server | routine: '_bt_check_unique' immich_server | }, immich_server | sql: 'insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *', immich_server | params: [ immich_server | '0e8b97b4-e566-47eb-a413-d359046c4d6a', immich_server | null, immich_server | , immich_server | 'upload/upload/0e8b97b4-e566-47eb-a413-d359046c4d6a/43/e6/43e66a32-2eb7-416c-a360-9940aae38ad6.jpg', immich_server | '4870', immich_server | '740f51c8c3ad4433edf412a4e51568e2b40d04199f0cd73e8281d0276de65593', immich_server | 2025-01-11T10:12:14.000Z, immich_server | 2025-01-11T10:12:14.000Z, immich_server | 2025-01-11T10:12:14.000Z, immich_server | 'IMAGE', immich_server | false, immich_server | '0:00:00.000000', immich_server | 'timeline', immich_server | 'IMG_20250111_101214_387.jpg' immich_server | ] immich_server | } immich_server | Query failed : { immich_server | durationMs: 4.315666005015373, immich_server | error: PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_server | at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26) immich_server | at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6) immich_server | at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9) immich_server | at Socket.emit (node:events:518:28) immich_server | at addChunk (node:internal/streams/readable:561:12) immich_server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich_server | at Readable.push (node:internal/streams/readable:392:5) immich_server | at TCP.onStreamRead (node:internal/stream_base_commons:189:23) immich_server | at TCP.callbackTrampoline (node:internal/async_hooks:130:17) { immich_server | severity_local: 'ERROR', immich_server | severity: 'ERROR', immich_server | code: '23505', immich_server | detail: 'Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \\x805c704c6629ea91e9a787aa0229e233a5e8bbd1) already exists.', immich_server | schema_name: 'public', immich_server | table_name: 'assets', immich_server | constraint_name: 'UQ_assets_owner_checksum', immich_server | file: 'nbtinsert.c', immich_server | line: '663', immich_server | routine: '_bt_check_unique' immich_server | }, immich_server | sql: 'insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *', immich_server | params: [ immich_server | '0e8b97b4-e566-47eb-a413-d359046c4d6a', immich_server | null, immich_server | , immich_server | 'upload/upload/0e8b97b4-e566-47eb-a413-d359046c4d6a/80/11/80114d4f-d9ff-4efe-bca0-65091d96f8d8.jpg', immich_server | '4871', immich_server | '740f51c8c3ad4433edf412a4e51568e2b40d04199f0cd73e8281d0276de65593', immich_server | 2025-01-11T10:13:49.000Z, immich_server | 2025-01-11T10:13:49.000Z, immich_server | 2025-01-11T10:13:49.000Z, immich_server | 'IMAGE', immich_server | false, immich_server | '0:00:00.000000', immich_server | 'timeline', immich_server | 'IMG_20250111_101349_744.jpg' immich_server | ] immich_server | } immich_server | Query failed : { immich_server | durationMs: 3.3106920048594475, immich_server | error: PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum" immich_server | at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26) immich_server | at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6) immich_server | at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9) immich_server | at Socket.emit (node:events:518:28) immich_server | at addChunk (node:internal/streams/readable:561:12) immich_server | at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) immich_server | at Readable.push (node:internal/streams/readable:392:5) immich_server | at TCP.onStreamRead (node:internal/stream_base_commons:189:23) immich_server | at TCP.callbackTrampoline (node:internal/async_hooks:130:17) { immich_server | severity_local: 'ERROR', immich_server | severity: 'ERROR', immich_server | code: '23505', immich_server | detail: 'Key ("ownerId", checksum)=(0e8b97b4-e566-47eb-a413-d359046c4d6a, \\xc62a1ad739f6bcb88eb6ecab77e1bbebd806fad9) already exists.', immich_server | schema_name: 'public', immich_server | table_name: 'assets', immich_server | constraint_name: 'UQ_assets_owner_checksum', immich_server | file: 'nbtinsert.c', immich_server | line: '663', immich_server | routine: '_bt_check_unique' immich_server | }, immich_server | sql: 'insert into "assets" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *', immich_server | params: [ immich_server | '0e8b97b4-e566-47eb-a413-d359046c4d6a', immich_server | null, immich_server | , immich_server | 'upload/upload/0e8b97b4-e566-47eb-a413-d359046c4d6a/1c/20/1c20e637-a0a9-4dc3-b535-c3c1d54866be.jpg', immich_server | '4872', immich_server | '740f51c8c3ad4433edf412a4e51568e2b40d04199f0cd73e8281d0276de65593', immich_server | 2025-01-11T10:19:38.000Z, immich_server | 2025-01-11T10:19:40.000Z, immich_server | 2025-01-11T10:19:38.000Z, immich_server | 'IMAGE', immich_server | false, immich_server | '0:00:00.000000', immich_server | 'timeline', immich_server | 'IMG_20250111_101938_989.jpg' immich_server | ] immich_server | } immich_server | Query failed : { immich_server | durationMs: 4.36030700057745, immich_redis | 1:M 22 May 2025 09:37:32.643 * oO0OoO0OoO0Oo Valkey is starting oO0OoO0OoO0Oo