bug(core): duplicate key for sync #671

New issue

Closed

opened 2026-03-28 04:27:15 +00:00 by mfreeman451 · 0 comments

mfreeman451 commented

2026-03-28 04:27:15 +00:00

Owner

Imported from GitHub.

Original GitHub issue: #2067
Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/2067
Original created: 2025-12-05T16:46:53Z

{"level":"error","trace_id":"ca235bda423552dd17f528b1bda05201","span_id":"bdfb355a8994b57a","component":"core","error":"process sync chunk (size=16384): failed to publis
h device updates: cnpg device_updates batch: ERROR: duplicate key value violates unique constraint \"idx_unified_devices_ip_unique_active\" (SQLSTATE 23505)","poller_id":"k8s-poller","time":"2025-12-05T16:45:44Z","message":"Error processing sync discovery sightings"}                                                                       {"level":"error","trace_id":"ca235bda423552dd17f528b1bda05201","span_id":"bdfb355a8994b57a","component":"core","error":"process sync chunk (size=16384): failed to publish device updates: cnpg device_updates batch: ERROR: duplicate key value violates unique constraint \"idx_unified_devices_ip_unique_active\" (SQLSTATE 23505)","service_name":"sync","poller_id":"k8s-poller","time":"2025-12-05T16:45:44Z","message":"Error processing metrics for service"}                                                      {"level":"error","trace_id":"ca235bda423552dd17f528b1bda05201","span_id":"bdfb355a8994b57a","component":"core","error":"process sync chunk (size=16384): failed to publish device updates: cnpg device_updates batch: ERROR: duplicate key value violates unique constraint \"idx_unified_devices_ip_unique_active\" (SQLSTATE 23505)","service_name":"sync","poller_id":"k8s-poller","time":"2025-12-05T16:45:44Z","message":"Error processing details for service"}

Imported from GitHub. Original GitHub issue: #2067 Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/2067 Original created: 2025-12-05T16:46:53Z --- ``` {"level":"error","trace_id":"ca235bda423552dd17f528b1bda05201","span_id":"bdfb355a8994b57a","component":"core","error":"process sync chunk (size=16384): failed to publis h device updates: cnpg device_updates batch: ERROR: duplicate key value violates unique constraint \"idx_unified_devices_ip_unique_active\" (SQLSTATE 23505)","poller_id":"k8s-poller","time":"2025-12-05T16:45:44Z","message":"Error processing sync discovery sightings"} {"level":"error","trace_id":"ca235bda423552dd17f528b1bda05201","span_id":"bdfb355a8994b57a","component":"core","error":"process sync chunk (size=16384): failed to publish device updates: cnpg device_updates batch: ERROR: duplicate key value violates unique constraint \"idx_unified_devices_ip_unique_active\" (SQLSTATE 23505)","service_name":"sync","poller_id":"k8s-poller","time":"2025-12-05T16:45:44Z","message":"Error processing metrics for service"} {"level":"error","trace_id":"ca235bda423552dd17f528b1bda05201","span_id":"bdfb355a8994b57a","component":"core","error":"process sync chunk (size=16384): failed to publish device updates: cnpg device_updates batch: ERROR: duplicate key value violates unique constraint \"idx_unified_devices_ip_unique_active\" (SQLSTATE 23505)","service_name":"sync","poller_id":"k8s-poller","time":"2025-12-05T16:45:44Z","message":"Error processing details for service"} ```

Rows
Columns