Stacking does not work during deduplication process

[HearthisAt]

Now we have another issue:

Stacking does not work. Deletion works. Sorry to be a pain.

[Nest] 17  - 01/27/2025, 10:02:41 PM VERBOSE [Api:LoggingInterceptor~5at1ahau] {"assetIds":["a10c3f6d-eb43-4f20-8b08-2089e08197c7","f1abe158-61e2-4fb1-a59c-b70d59fa1bc8","e0763d65-5bbb-470c-803e-46e16668fdd5","5a9fe812-0786-406e-8cd2-4f981ffbe783","245feb08-08fe-439e-ae1f-8042e1bd72d8","516d98bf-fb85-47f1-8a30-1404bb30641d","52cb1404-22d7-4c7c-97b8-d217ed811fd5","7466170d-0da3-4620-944c-0a7bca215930","401349a0-b4e5-43e1-a039-c2610a329566","b89ccb57-1b37-4cb2-b37c-72296c948cd7","87023927-cd45-4f15-98a1-8526637fd640","c4213455-0ef3-4c34-8e50-5df3b39ba39a","3bd8cd36-2db3-4ec3-9eb0-38883a69ed62","9d961f65-b6b0-4da5-81b8-3e626bc470a9","a37ca4db-68cd-45cb-bd01-ef571cd6a2b7","003dbb80-2841-45a9-be21-ea73e348557f","f7e1a406-3f16-43ac-97d9-c80caa2fcb8c","f7a8494e-eecf-48df-acd1-a4a0a2cc55ee","f6b25d86-4bd4-4a9e-99e2-a3caab1a50a3","f6230dd4-a3ce-4df3-b47e-a67f6de57bae","ecc0b5b6-abce-412a-aded-33625ff4371a","ec915cff-b150-46a9-b46d-0655d36b6e4f","eb572281-983c-478f-9c9b-e60f16c2bc4f","dd4ad414-583d-4e14-97ba-7acb53dd5376","da527cbb-9426-4653-b360-0a4c724b99fe","d5cd5b9d-ac74-4dc1-a3ef-964837a83718","c749966b-6738-4829-b044-69e269947d7d","c536164c-330e-4254-8db3-c38232c249e4","c127f3f9-8e99-4f52-80d5-e1dc8d6ea5b0","4da14250-11ed-47f7-b715-cec59a1546a5","bac257e5-9781-47e7-810e-8c49cfbcab72","b6db2a2e-72a9-4b03-aa61-e02565502465","b6d410a4-6a74-431b-9d24-8f3f7d88ebd1","b507ef74-f420-4d45-b20f-1e12f76c09ea","b4416d1e-5dcd-4d19-aba4-2aa5f01c38d5","46175c99-5231-458e-9531-28ff496a7b6e","5cc4b0b5-5dab-4e87-bea7-d023b8937c0b","69caef03-a425-4a4e-af74-1c5eb3c5c5da","aa651882-428a-40f3-879d-c12fbaada70d","a76b5636-a528-4ca7-b2d9-5200654a2288","9d20e1e9-e057-410a-a3c5-193922f699fc","9c20e7d3-c696-4b6b-ace2-0ec2c91b6f10","842b76d7-a484-4112-addc-2d7af3fbc3fc","812f2e10-4a52-4b0f-8116-35544e0382cc","80d0b8ca-9902-4352-9dec-3bd65b0efead","9f2a2121-0de7-4f89-97b5-d82909ba5659","7cb6da54-b8f5-4429-ac8d-c2b0bebfbe57","79fd4738-7fa6-4157-a1ef-8fc26a09453d","73d231fe-cc88-4712-af0b-834be878156a","af77a765-9396-4f7f-8a9e-57c1d7e56887","72c82f5a-8e74-4633-88b6-233b760373a8","3569d685-8ea1-4d42-a280-e782099a3564","3140a539-9c60-412b-827c-7378c5dc83ff","308494ac-8bf7-40ab-9f18-a7701f208db7","2a3b9264-806e-4251-bbd2-8807f94a8c0d","273251da-e16c-446b-8052-a33a135026c9","18e64af9-9c19-4aed-b766-d8c2932733d8","22f9b94d-bf8b-4110-ba54-7557ea361794","1f9fd638-db77-47b2-a998-61c862bb512a","d20f0625-27c9-47d8-9368-3bf6a45537d6","1ea9c603-5b26-41fc-b98b-cab289801861","1a6d43f1-9385-4e8d-902d-87d9455720b4","1b8cc405-69b2-43f0-a7e2-2a03371ba258","2dfa08a1-be20-46d5-a3b5-9855dedf7298","41669318-7d85-4675-8488-d67df94eca54","fc434329-a467-458b-8b76-bd4b7161f1b2","fd9e47e2-a688-440c-af86-6d14e495090d","24a3f9cd-e1b1-42cb-b880-72efa8d32c15","6ae7c631-6b84-4f4a-8d5d-27fcd6be6260","62ee6016-01b1-4cb0-9f34-f2a8e97b792d","51a012bd-ff3e-422e-993d-856d6297a464","57fc515e-7019-4d82-b337-6aa81dbdb019","fab9cf28-f531-4a41-928c-c07456384e1e","2c0894de-7926-4fe2-a863-3452a54b4f0a","4ddc88db-7814-40d4-a7f7-6fd6175fb576","4d935592-afa2-4dec-ba75-9328722d91af","4d00edd1-4cf4-4e03-9bfa-f17076a0e27c","45099022-ba6b-455d-9b95-05ac0b5ba48f","3f973759-89c3-4d8e-9d3d-a943d58b74b9","8f16f6c0-484e-47c9-a84c-38890d831aa4","3e9b0e62-893d-4adb-8d7a-50e9b0e6184e","3ae1834c-a265-4eb0-85d8-dda2c29514cf","a5297528-41d2-4077-9080-ffdb16fb56e7","3ac11233-8860-4c90-8c27-5a35f82e7187","3a944977-7f6d-4d56-9cbc-46c5b5a615f4","09850ef1-001d-4f19-9e6a-be223d762bba","39c3fd70-5d8d-4bd5-be67-3b937e5f592f","0e31bbf9-0731-4e5c-8233-eda829680a48","1018cf35-c07e-49b3-a9fe-e7a3883a33fb","1652c3e9-cc69-4745-8f97-3f252090b853","35beb2cc-ff84-48d7-9f5f-f8ff730602fa","e0ea2c59-62df-41e7-a498-8670cb3ed458","ddced032-4324-4dea-b534-ca888819610d"]}
> 
> [Nest] 17  - 01/27/2025, 10:02:42 PM   DEBUG [Api:LoggingInterceptor~l57ou7sh] PUT /api/assets 204 7.79ms ::ffff:172.20.0.1
> 
> [Nest] 17  - 01/27/2025, 10:02:42 PM VERBOSE [Api:LoggingInterceptor~l57ou7sh] {"ids":["a10c3f6d-eb43-4f20-8b08-2089e08197c7","f1abe158-61e2-4fb1-a59c-b70d59fa1bc8","e0763d65-5bbb-470c-803e-46e16668fdd5","5a9fe812-0786-406e-8cd2-4f981ffbe783","245feb08-08fe-439e-ae1f-8042e1bd72d8","516d98bf-fb85-47f1-8a30-1404bb30641d","52cb1404-22d7-4c7c-97b8-d217ed811fd5","7466170d-0da3-4620-944c-0a7bca215930","401349a0-b4e5-43e1-a039-c2610a329566","b89ccb57-1b37-4cb2-b37c-72296c948cd7","87023927-cd45-4f15-98a1-8526637fd640","c4213455-0ef3-4c34-8e50-5df3b39ba39a","3bd8cd36-2db3-4ec3-9eb0-38883a69ed62","9d961f65-b6b0-4da5-81b8-3e626bc470a9","a37ca4db-68cd-45cb-bd01-ef571cd6a2b7","003dbb80-2841-45a9-be21-ea73e348557f","f7e1a406-3f16-43ac-97d9-c80caa2fcb8c","f7a8494e-eecf-48df-acd1-a4a0a2cc55ee","f6b25d86-4bd4-4a9e-99e2-a3caab1a50a3","f6230dd4-a3ce-4df3-b47e-a67f6de57bae","ecc0b5b6-abce-412a-aded-33625ff4371a","ec915cff-b150-46a9-b46d-0655d36b6e4f","eb572281-983c-478f-9c9b-e60f16c2bc4f","dd4ad414-583d-4e14-97ba-7acb53dd5376","da527cbb-9426-4653-b360-0a4c724b99fe","d5cd5b9d-ac74-4dc1-a3ef-964837a83718","c749966b-6738-4829-b044-69e269947d7d","c536164c-330e-4254-8db3-c38232c249e4","c127f3f9-8e99-4f52-80d5-e1dc8d6ea5b0","4da14250-11ed-47f7-b715-cec59a1546a5","bac257e5-9781-47e7-810e-8c49cfbcab72","b6db2a2e-72a9-4b03-aa61-e02565502465","b6d410a4-6a74-431b-9d24-8f3f7d88ebd1","b507ef74-f420-4d45-b20f-1e12f76c09ea","b4416d1e-5dcd-4d19-aba4-2aa5f01c38d5","46175c99-5231-458e-9531-28ff496a7b6e","5cc4b0b5-5dab-4e87-bea7-d023b8937c0b","69caef03-a425-4a4e-af74-1c5eb3c5c5da","aa651882-428a-40f3-879d-c12fbaada70d","a76b5636-a528-4ca7-b2d9-5200654a2288","9d20e1e9-e057-410a-a3c5-193922f699fc","9c20e7d3-c696-4b6b-ace2-0ec2c91b6f10","842b76d7-a484-4112-addc-2d7af3fbc3fc","812f2e10-4a52-4b0f-8116-35544e0382cc","80d0b8ca-9902-4352-9dec-3bd65b0efead","9f2a2121-0de7-4f89-97b5-d82909ba5659","7cb6da54-b8f5-4429-ac8d-c2b0bebfbe57","79fd4738-7fa6-4157-a1ef-8fc26a09453d","73d231fe-cc88-4712-af0b-834be878156a","af77a765-9396-4f7f-8a9e-57c1d7e56887","72c82f5a-8e74-4633-88b6-233b760373a8","3569d685-8ea1-4d42-a280-e782099a3564","3140a539-9c60-412b-827c-7378c5dc83ff","308494ac-8bf7-40ab-9f18-a7701f208db7","2a3b9264-806e-4251-bbd2-8807f94a8c0d","273251da-e16c-446b-8052-a33a135026c9","18e64af9-9c19-4aed-b766-d8c2932733d8","22f9b94d-bf8b-4110-ba54-7557ea361794","1f9fd638-db77-47b2-a998-61c862bb512a","d20f0625-27c9-47d8-9368-3bf6a45537d6","1ea9c603-5b26-41fc-b98b-cab289801861","1a6d43f1-9385-4e8d-902d-87d9455720b4","1b8cc405-69b2-43f0-a7e2-2a03371ba258","2dfa08a1-be20-46d5-a3b5-9855dedf7298","41669318-7d85-4675-8488-d67df94eca54","fc434329-a467-458b-8b76-bd4b7161f1b2","fd9e47e2-a688-440c-af86-6d14e495090d","24a3f9cd-e1b1-42cb-b880-72efa8d32c15","6ae7c631-6b84-4f4a-8d5d-27fcd6be6260","62ee6016-01b1-4cb0-9f34-f2a8e97b792d","51a012bd-ff3e-422e-993d-856d6297a464","57fc515e-7019-4d82-b337-6aa81dbdb019","fab9cf28-f531-4a41-928c-c07456384e1e","2c0894de-7926-4fe2-a863-3452a54b4f0a","4ddc88db-7814-40d4-a7f7-6fd6175fb576","4d935592-afa2-4dec-ba75-9328722d91af","4d00edd1-4cf4-4e03-9bfa-f17076a0e27c","45099022-ba6b-455d-9b95-05ac0b5ba48f","3f973759-89c3-4d8e-9d3d-a943d58b74b9","8f16f6c0-484e-47c9-a84c-38890d831aa4","3e9b0e62-893d-4adb-8d7a-50e9b0e6184e","3ae1834c-a265-4eb0-85d8-dda2c29514cf","a5297528-41d2-4077-9080-ffdb16fb56e7","3ac11233-8860-4c90-8c27-5a35f82e7187","3a944977-7f6d-4d56-9cbc-46c5b5a615f4","09850ef1-001d-4f19-9e6a-be223d762bba","39c3fd70-5d8d-4bd5-be67-3b937e5f592f","0e31bbf9-0731-4e5c-8233-eda829680a48","1018cf35-c07e-49b3-a9fe-e7a3883a33fb","1652c3e9-cc69-4745-8f97-3f252090b853","35beb2cc-ff84-48d7-9f5f-f8ff730602fa","e0ea2c59-62df-41e7-a498-8670cb3ed458","ddced032-4324-4dea-b534-ca888819610d"],"duplicateId":null}

Originally posted by @HearthisAt in #15693

[alextran1502]

Can you please run the Duplication Detection job again before trying to stack them?

[HearthisAt]

Started the job for all assets. Details tomorrow.

[HearthisAt]

Sorry, nothing changed after a complete deduplication check of all assets:

{"ids":["8f16f6c0-484e-47c9-a84c-38890d831aa4","bac257e5-9781-47e7-810e-8c49cfbcab72","f7a8494e-eecf-48df-acd1-a4a0a2cc55ee","5a9fe812-0786-406e-8cd2-4f981ffbe783","401349a0-b4e5-43e1-a039-c2610a329566","a10c3f6d-eb43-4f20-8b08-2089e08197c7","87023927-cd45-4f15-98a1-8526637fd640","1f9fd638-db77-47b2-a998-61c862bb512a","4da14250-11ed-47f7-b715-cec59a1546a5","52cb1404-22d7-4c7c-97b8-d217ed811fd5","273251da-e16c-446b-8052-a33a135026c9","22f9b94d-bf8b-4110-ba54-7557ea361794","b6d410a4-6a74-431b-9d24-8f3f7d88ebd1","4d00edd1-4cf4-4e03-9bfa-f17076a0e27c","245feb08-08fe-439e-ae1f-8042e1bd72d8","3ac11233-8860-4c90-8c27-5a35f82e7187","51a012bd-ff3e-422e-993d-856d6297a464","3e9b0e62-893d-4adb-8d7a-50e9b0e6184e","da527cbb-9426-4653-b360-0a4c724b99fe","f1abe158-61e2-4fb1-a59c-b70d59fa1bc8","3bd8cd36-2db3-4ec3-9eb0-38883a69ed62","c4213455-0ef3-4c34-8e50-5df3b39ba39a","b89ccb57-1b37-4cb2-b37c-72296c948cd7","7466170d-0da3-4620-944c-0a7bca215930","73d231fe-cc88-4712-af0b-834be878156a","516d98bf-fb85-47f1-8a30-1404bb30641d","e0763d65-5bbb-470c-803e-46e16668fdd5","45099022-ba6b-455d-9b95-05ac0b5ba48f","24a3f9cd-e1b1-42cb-b880-72efa8d32c15","62ee6016-01b1-4cb0-9f34-f2a8e97b792d","80d0b8ca-9902-4352-9dec-3bd65b0efead","6ae7c631-6b84-4f4a-8d5d-27fcd6be6260","4d935592-afa2-4dec-ba75-9328722d91af","09850ef1-001d-4f19-9e6a-be223d762bba","0e31bbf9-0731-4e5c-8233-eda829680a48","9d20e1e9-e057-410a-a3c5-193922f699fc","308494ac-8bf7-40ab-9f18-a7701f208db7","1018cf35-c07e-49b3-a9fe-e7a3883a33fb","1652c3e9-cc69-4745-8f97-3f252090b853","2a3b9264-806e-4251-bbd2-8807f94a8c0d","18e64af9-9c19-4aed-b766-d8c2932733d8","d20f0625-27c9-47d8-9368-3bf6a45537d6","39c3fd70-5d8d-4bd5-be67-3b937e5f592f","c749966b-6738-4829-b044-69e269947d7d","c127f3f9-8e99-4f52-80d5-e1dc8d6ea5b0","57fc515e-7019-4d82-b337-6aa81dbdb019","2c0894de-7926-4fe2-a863-3452a54b4f0a","3a944977-7f6d-4d56-9cbc-46c5b5a615f4","46175c99-5231-458e-9531-28ff496a7b6e","2dfa08a1-be20-46d5-a3b5-9855dedf7298","1a6d43f1-9385-4e8d-902d-87d9455720b4","72c82f5a-8e74-4633-88b6-233b760373a8","a76b5636-a528-4ca7-b2d9-5200654a2288","9d961f65-b6b0-4da5-81b8-3e626bc470a9","a37ca4db-68cd-45cb-bd01-ef571cd6a2b7","f7e1a406-3f16-43ac-97d9-c80caa2fcb8c","fab9cf28-f531-4a41-928c-c07456384e1e","fd9e47e2-a688-440c-af86-6d14e495090d","fc434329-a467-458b-8b76-bd4b7161f1b2","3569d685-8ea1-4d42-a280-e782099a3564","5cc4b0b5-5dab-4e87-bea7-d023b8937c0b","1b8cc405-69b2-43f0-a7e2-2a03371ba258","003dbb80-2841-45a9-be21-ea73e348557f","a5297528-41d2-4077-9080-ffdb16fb56e7","69caef03-a425-4a4e-af74-1c5eb3c5c5da","1ea9c603-5b26-41fc-b98b-cab289801861","aa651882-428a-40f3-879d-c12fbaada70d","79fd4738-7fa6-4157-a1ef-8fc26a09453d","dd4ad414-583d-4e14-97ba-7acb53dd5376","c536164c-330e-4254-8db3-c38232c249e4","ddced032-4324-4dea-b534-ca888819610d","b507ef74-f420-4d45-b20f-1e12f76c09ea","b4416d1e-5dcd-4d19-aba4-2aa5f01c38d5","e0ea2c59-62df-41e7-a498-8670cb3ed458","eb572281-983c-478f-9c9b-e60f16c2bc4f","ec915cff-b150-46a9-b46d-0655d36b6e4f","d5cd5b9d-ac74-4dc1-a3ef-964837a83718","3ae1834c-a265-4eb0-85d8-dda2c29514cf","3f973759-89c3-4d8e-9d3d-a943d58b74b9","ecc0b5b6-abce-412a-aded-33625ff4371a","842b76d7-a484-4112-addc-2d7af3fbc3fc","9c20e7d3-c696-4b6b-ace2-0ec2c91b6f10","f6230dd4-a3ce-4df3-b47e-a67f6de57bae","f6b25d86-4bd4-4a9e-99e2-a3caab1a50a3","b6db2a2e-72a9-4b03-aa61-e02565502465","af77a765-9396-4f7f-8a9e-57c1d7e56887","812f2e10-4a52-4b0f-8116-35544e0382cc","9f2a2121-0de7-4f89-97b5-d82909ba5659","3140a539-9c60-412b-827c-7378c5dc83ff","35beb2cc-ff84-48d7-9f5f-f8ff730602fa","41669318-7d85-4675-8488-d67df94eca54","7cb6da54-b8f5-4429-ac8d-c2b0bebfbe57","4ddc88db-7814-40d4-a7f7-6fd6175fb576"],"duplicateId":null}

[mertalev]

Are any of the assets in this duplicate group already stacked? I think it might not be handling that well.

[HearthisAt]

Yes. Some of the assets are part of stack and some aren't.

[HearthisAt]

But stacking also does not work with two assets that are not in a stack.
Checked with 4 other examples of detected assets.

[HearthisAt]

The post request is:

[Nest] 17  - 01/27/2025, 10:53:38 PM DEBUG [Api:LoggingInterceptor~6joyvbmp] POST /api/stacks 201 12.94ms ::ffff:172.20.0.1
[Nest] 17  - 01/27/2025, 10:53:38 PM VERBOSE [Api:LoggingInterceptor~6joyvbmp] {"assetIds":["a8ab7d8a-cdcb-46ba-9bb9-38879e7c83a1","b39f06cc-64e1-46be-a625-3e7abd4c4573"]}

[Nest] 17  - 01/27/2025, 10:54:53 PM   DEBUG [Api:LoggingInterceptor~167lrlgk] POST /api/stacks 201 18.28ms ::ffff:172.20.0.1
[Nest] 17  - 01/27/2025, 10:54:53 PM VERBOSE [Api:LoggingInterceptor~167lrlgk] {"assetIds":["b0a943ea-5447-4e19-adae-992277c706b2","02e83583-b54f-45cd-b797-d4513c67207e"]}

Hope this helps.

[mackid1993]

I'm also seeing this issue. Nothing is able to be stacked.

[alextran1502]

Any error from the server?

[mackid1993]

@alextran1502 I just started using Immich literally yesterday using the aio container on Unraid, so I'm a very new user. Can you let me know where I can go to see the errors?

[alextran1502]

I don't use unraid so I am not sure

[mackid1993]

I don't use unraid so I am not sure

Seems like it's just the regular container logs. I see this when I reproduce:

Query failed : {
  durationMs: 1.9035639995709062,
  error: PostgresError: duplicate key value violates unique constraint "REL_91704e101438fd0653f582426d"
      at ErrorResponse (/app/immich/server/node_modules/postgres/cjs/src/connection.js:788:26)
      at handle (/app/immich/server/node_modules/postgres/cjs/src/connection.js:474:6)
      at Socket.data (/app/immich/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:191:23)
      at TCP.callbackTrampoline (node:internal/async_hooks:130:17) {
    severity_local: 'ERROR',
    severity: 'ERROR',
    code: '23505',
    detail: 'Key ("primaryAssetId")=(cc2f9815-129d-4963-b28c-e57e7762be46) already exists.',
    schema_name: 'public',
    table_name: 'asset_stack',
    constraint_name: 'REL_91704e101438fd0653f582426d',
    file: 'nbtinsert.c',
    line: '666',
    routine: '_bt_check_unique'
  },
  sql: 'insert into "asset_stack" ("ownerId", "primaryAssetId") values ($1, $2) returning "id"',
  params: [
    '606f4ad5-1079-4c55-9ec0-3ea82f38eebb',
    'cc2f9815-129d-4963-b28c-e57e7762be46'
  ]
}
[Nest] 1129  - 01/28/2025, 10:47:09 AM   ERROR [Api:ErrorInterceptor~icdh9okt] Unknown error: PostgresError: duplicate key value violates unique constraint "REL_91704e101438fd0653f582426d"
PostgresError: duplicate key value violates unique constraint "REL_91704e101438fd0653f582426d"
    at ErrorResponse (/app/immich/server/node_modules/postgres/cjs/src/connection.js:788:26)
    at handle (/app/immich/server/node_modules/postgres/cjs/src/connection.js:474:6)
    at Socket.data (/app/immich/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:191:23)
    at TCP.callbackTrampoline (node:internal/async_hooks:130:17)

[alextran1502]

Thanks, this is helpful

[masx200]

 },

  sql: 'insert into "albums_assets_assets" ("albumsId", "assetsId") values ($1, $2)',

  params: [

    'f276a638-20aa-4c33-9fce-905480638631',

    'e95e6bbb-3eef-470b-8ad0-80cef16cd4ff'

  ]

}

[Nest] 25  - 02/04/2025, 12:29:57 PM   ERROR [Api:ErrorInterceptor~4b93tb8q] Unknown error: PostgresError: duplicate key value violates unique constraint "PK_c67bc36fa845fb7b18e0e398180"

PostgresError: duplicate key value violates unique constraint "PK_c67bc36fa845fb7b18e0e398180"

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

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

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

    at Socket.emit (node:events:524: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)

Query failed : {

  durationMs: 4.616383999993559,

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

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

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

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

      at Socket.emit (node:events:524: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 ("albumsId", "assetsId")=(24336e12-f64f-4f08-b7fc-b41666453749, 26a4a5b5-8913-4735-8d18-4f646d88e1ca) already exists.',

    schema_name: 'public',

    table_name: 'albums_assets_assets',

    constraint_name: 'PK_c67bc36fa845fb7b18e0e398180',

    file: 'nbtinsert.c',

    line: '663',

    routine: '_bt_check_unique'

  },

  sql: 'insert into "albums_assets_assets" ("albumsId", "assetsId") values ($1, $2)',

  params: [

    '24336e12-f64f-4f08-b7fc-b41666453749',

    '26a4a5b5-8913-4735-8d18-4f646d88e1ca'

  ]

}

[Nest] 25  - 02/04/2025, 12:29:57 PM   ERROR [Api:ErrorInterceptor~ogqtsdvl] Unknown error: PostgresError: duplicate key value violates unique constraint "PK_c67bc36fa845fb7b18e0e398180"

PostgresError: duplicate key value violates unique constraint "PK_c67bc36fa845fb7b18e0e398180"

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

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

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

    at Socket.emit (node:events:524: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)

[Nest] 7  - 02/04/2025, 12:29:57 PM    WARN [Microservices:MetadataService] Asset 68fa776c-8a5e-4602-b703-413a1c1a7779 has no time zone information

[Nest] 7  - 02/04/2025, 12:29:57 PM    WARN [Microservices:MetadataService] Asset 83768993-3663-497e-b6d8-25f5415e30d7 has no time zone information

Query failed : {

  durationMs: 12.662618000002112,

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

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

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

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

      at Socket.emit (node:events:524: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 ("albumsId", "assetsId")=(24336e12-f64f-4f08-b7fc-b41666453749, 73588ff1-45fe-4fde-a2cb-a38186937c03) already exists.',

    schema_name: 'public',

    table_name: 'albums_assets_assets',

    constraint_name: 'PK_c67bc36fa845fb7b18e0e398180',

    file: 'nbtinsert.c',

    line: '663',

    routine: '_bt_check_unique'

  },

  sql: 'insert into "albums_assets_assets" ("albumsId", "assetsId") values ($1, $2)',

  params: [

    '24336e12-f64f-4f08-b7fc-b41666453749',

    '73588ff1-45fe-4fde-a2cb-a38186937c03'

  ]

}

[Nest] 25  - 02/04/2025, 12:29:57 PM   ERROR [Api:ErrorInterceptor~e5wi7k7w] Unknown error: PostgresError: duplicate key value violates unique constraint "PK_c67bc36fa845fb7b18e0e398180"

PostgresError: duplicate key value violates unique constraint "PK_c67bc36fa845fb7b18e0e398180"

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

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

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

    at Socket.emit (node:events:524: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)