[Nest] 7  - 08/21/2025, 12:19:12 AM   ERROR [Microservices:{"libraryId":"81e85acf-dad3-4af2-a085-36187e127091","paths":["/mnt/media/photos/kim/iPhone Photo Backup/2025/07/IMG_1788.JPG","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1794.JPG","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1795.JPG","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1796.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1798.JPG","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1799.JPG","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1807.JPG","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1809.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1810.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1811.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1812.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1814.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1815.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1816.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1818.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1819.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1820.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1821.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1822.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1823.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1833.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1834.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1835.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1836.MOV","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1837.JPG","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1838.JPG","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1839_slowmo.MOV","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1840_slowmo.MOV","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1841_slowmo.MOV","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1842.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1843.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1844.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1853.JPG","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1860.JPG","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1867.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1869.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1870.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1874.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1877.JPG","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1890.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1891.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1892.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1893.HEIC","/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1894.HEIC"],"progressCounter":30000}] Unable to run job handler (LibrarySyncFiles): PostgresError: duplicate key value violates unique constraint "asset_ownerId_libraryId_checksum_idx"
PostgresError: duplicate key value violates unique constraint "asset_ownerId_libraryId_checksum_idx"
    at ErrorResponse (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:794:26)
    at handle (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:480:6)
    at Socket.data (/usr/src/app/server/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)
Query failed : {
  durationMs: 311.46232299999974,
  error: PostgresError: duplicate key value violates unique constraint "asset_ownerId_libraryId_checksum_idx"
      at ErrorResponse (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:794:26)
      at handle (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:480:6)
      at Socket.data (/usr/src/app/server/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) {
    severity_local: 'ERROR',
    severity: 'ERROR',
    code: '23505',
    detail: 'Key ("ownerId", "libraryId", checksum)=(382c0351-70a8-4055-b9fd-a4439e740e09, 81e85acf-dad3-4af2-a085-36187e127091, \\x7f73e60a1a25deb149ab8c226c7587871d2438cb) already exists.',
    schema_name: 'public',
    table_name: 'asset',
    constraint_name: 'asset_ownerId_libraryId_checksum_idx',
    file: 'nbtinsert.c',
    line: '663',
    routine: '_bt_check_unique'
  },
  sql: 'insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "fileCreatedAt", "fileModifiedAt", "localDateTime", "deviceAssetId", "deviceId", "type", "originalFileName", "isExternal", "livePhotoVideoId") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13), ($14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26), ($27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39), ($40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52), ($53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65), ($66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78), ($79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91), ($92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104), ($105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117), ($118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130), ($131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143), ($144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156), ($157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169), ($170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182), ($183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195), ($196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208), ($209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221), ($222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234), ($235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247), ($248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260), ($261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273), ($274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286), ($287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299), ($300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312), ($313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325), ($326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338), ($339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350, $351), ($352, $353, $354, $355, $356, $357, $358, $359, $360, $361, $362, $363, $364), ($365, $366, $367, $368, $369, $370, $371, $372, $373, $374, $375, $376, $377), ($378, $379, $380, $381, $382, $383, $384, $385, $386, $387, $388, $389, $390), ($391, $392, $393, $394, $395, $396, $397, $398, $399, $400, $401, $402, $403), ($404, $405, $406, $407, $408, $409, $410, $411, $412, $413, $414, $415, $416), ($417, $418, $419, $420, $421, $422, $423, $424, $425, $426, $427, $428, $429), ($430, $431, $432, $433, $434, $435, $436, $437, $438, $439, $440, $441, $442), ($443, $444, $445, $446, $447, $448, $449, $450, $451, $452, $453, $454, $455), ($456, $457, $458, $459, $460, $461, $462, $463, $464, $465, $466, $467, $468), ($469, $470, $471, $472, $473, $474, $475, $476, $477, $478, $479, $480, $481), ($482, $483, $484, $485, $486, $487, $488, $489, $490, $491, $492, $493, $494), ($495, $496, $497, $498, $499, $500, $501, $502, $503, $504, $505, $506, $507), ($508, $509, $510, $511, $512, $513, $514, $515, $516, $517, $518, $519, $520), ($521, $522, $523, $524, $525, $526, $527, $528, $529, $530, $531, $532, $533), ($534, $535, $536, $537, $538, $539, $540, $541, $542, $543, $544, $545, $546), ($547, $548, $549, $550, $551, $552, $553, $554, $555, $556, $557, $558, $559), ($560, $561, $562, $563, $564, $565, $566, $567, $568, $569, $570, $571, $572) returning *',
  params: [
    '382c0351-70a8-4055-b9fd-a4439e740e09',
    '81e85acf-dad3-4af2-a085-36187e127091',
    <Buffer 7f 73 e6 0a 1a 25 de b1 49 ab 8c 22 6c 75 87 87 1d 24 38 cb>,
    '/mnt/media/photos/kim/iPhone Photo Backup/2025/07/IMG_1788.JPG',
    2025-07-29T00:24:54.000Z,
    2025-07-29T00:24:54.000Z,
    2025-07-29T00:24:54.000Z,
    'IMG_1788.JPG',
    'Library Import',
    'IMAGE',
    'IMG_1788.JPG',
    true,
    null,
    '382c0351-70a8-4055-b9fd-a4439e740e09',
    '81e85acf-dad3-4af2-a085-36187e127091',
    <Buffer 7a 7b f7 e5 ae 0a ba 22 fe d3 fe 8b be ff ec 2f 4a e9 04 ff>,
    '/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1794.JPG',
    2025-08-01T13:39:13.000Z,
    2025-08-01T13:39:13.000Z,
    2025-08-01T13:39:13.000Z,
    'IMG_1794.JPG',
    'Library Import',
    'IMAGE',
    'IMG_1794.JPG',
    true,
    null,
    '382c0351-70a8-4055-b9fd-a4439e740e09',
    '81e85acf-dad3-4af2-a085-36187e127091',
    <Buffer 69 1d ba 81 a7 4c 9b 7b 94 ef 63 d8 85 a6 dd 80 5f c3 f7 7c>,
    '/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1795.JPG',
    2025-08-01T20:53:16.000Z,
    2025-08-01T20:53:16.000Z,
    2025-08-01T20:53:16.000Z,
    'IMG_1795.JPG',
    'Library Import',
    'IMAGE',
    'IMG_1795.JPG',
    true,
    null,
    '382c0351-70a8-4055-b9fd-a4439e740e09',
    '81e85acf-dad3-4af2-a085-36187e127091',
    <Buffer f7 29 fd 09 78 df 00 f2 01 04 20 4e c5 34 9b d8 39 da ac f6>,
    '/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1798.JPG',
    2025-08-02T14:25:04.000Z,
    2025-08-02T14:25:04.000Z,
    2025-08-02T14:25:04.000Z,
    'IMG_1798.JPG',
    'Library Import',
    'IMAGE',
    'IMG_1798.JPG',
    true,
    null,
    '382c0351-70a8-4055-b9fd-a4439e740e09',
    '81e85acf-dad3-4af2-a085-36187e127091',
    <Buffer 17 86 6d 62 92 bd 6f d3 da d2 1a 6a 76 36 2c 07 24 d1 b1 c1>,
    '/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1796.HEIC',
    2025-08-02T16:20:42.000Z,
    2025-08-02T16:20:42.000Z,
    2025-08-02T16:20:42.000Z,
    'IMG_1796.HEIC',
    'Library Import',
    'IMAGE',
    'IMG_1796.HEIC',
    true,
    null,
    '382c0351-70a8-4055-b9fd-a4439e740e09',
    '81e85acf-dad3-4af2-a085-36187e127091',
    <Buffer a6 88 e8 a1 f5 71 20 d8 5b ed d6 9b aa b0 9f ef b3 c3 85 38>,
    '/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1799.JPG',
    2025-08-02T23:07:44.000Z,
    2025-08-02T23:07:44.000Z,
    2025-08-02T23:07:44.000Z,
    'IMG_1799.JPG',
    'Library Import',
    'IMAGE',
    'IMG_1799.JPG',
    true,
    null,
    '382c0351-70a8-4055-b9fd-a4439e740e09',
    '81e85acf-dad3-4af2-a085-36187e127091',
    <Buffer c7 fd 3a eb 03 33 ae 73 9b 0f 95 80 e2 3a 2b ff 5d 33 34 e0>,
    '/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1807.JPG',
    2025-08-01T21:03:10.000Z,
    2025-08-01T21:03:10.000Z,
    2025-08-01T21:03:10.000Z,
    'IMG_1807.JPG',
    'Library Import',
    'IMAGE',
    'IMG_1807.JPG',
    true,
    null,
    '382c0351-70a8-4055-b9fd-a4439e740e09',
    '81e85acf-dad3-4af2-a085-36187e127091',
    <Buffer 3e 8b 16 68 f5 fb 0d c2 17 0d 1e 8a ec 23 1e ee ce 7d 97 21>,
    '/mnt/media/photos/kim/iPhone Photo Backup/2025/08/IMG_1809.HEIC',
    2025-08-04T23:49:23.000Z,
    2025-08-04T23:49:23.000Z,
    2025-08-04T23:49:23.000Z,
    'IMG_1809.HEIC',
    'Library Import',
    ... 472 more items
  ]
}