bug(core): cnpg deadlock on device_updates #674

New issue

Closed

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

mfreeman451 commented

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

Owner

Imported from GitHub.

Original GitHub issue: #2087
Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/2087
Original created: 2025-12-08T19:26:35Z

Describe the bug

Log Details
Trace ID:

948a392bc899c28c77afdb3bdbd091de

Span ID:

37f45b8b64a9b2ed

Service Version:

1.0.0

Service Instance:

-

Scope:

core

Severity Number:

17

Attributes
trace_id: 948a392bc899c28c77afdb3bdbd091de
span_id: 37f45b8b64a9b2ed
error: failed to publish device updates: cnpg device_updates batch: ERROR: deadlock detected (SQLSTATE 40P01)
Raw Data
trace_id=948a392bc899c28c77afdb3bdbd091de,span_id=37f45b8b64a9b2ed,error=failed to publish device updates: cnpg device_updates batch: ERROR: deadlock detected (SQLSTATE 40P01)

To Reproduce
Steps to reproduce the behavior:

Go to '...'
Click on '....'
Scroll down to '....'
See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

OS: [e.g. iOS]
Browser [e.g. chrome, safari]
Version [e.g. 22]

Smartphone (please complete the following information):

Device: [e.g. iPhone6]
OS: [e.g. iOS8.1]
Browser [e.g. stock browser, safari]
Version [e.g. 22]

Additional context
Add any other context about the problem here.

Imported from GitHub. Original GitHub issue: #2087 Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/2087 Original created: 2025-12-08T19:26:35Z --- **Describe the bug** ``` Log Details Trace ID: 948a392bc899c28c77afdb3bdbd091de Span ID: 37f45b8b64a9b2ed Service Version: 1.0.0 Service Instance: - Scope: core Severity Number: 17 Attributes trace_id: 948a392bc899c28c77afdb3bdbd091de span_id: 37f45b8b64a9b2ed error: failed to publish device updates: cnpg device_updates batch: ERROR: deadlock detected (SQLSTATE 40P01) Raw Data trace_id=948a392bc899c28c77afdb3bdbd091de,span_id=37f45b8b64a9b2ed,error=failed to publish device updates: cnpg device_updates batch: ERROR: deadlock detected (SQLSTATE 40P01) ``` **To Reproduce** Steps to reproduce the behavior: 1. Go to '...' 2. Click on '....' 3. Scroll down to '....' 4. See error **Expected behavior** A clear and concise description of what you expected to happen. **Screenshots** If applicable, add screenshots to help explain your problem. **Desktop (please complete the following information):** - OS: [e.g. iOS] - Browser [e.g. chrome, safari] - Version [e.g. 22] **Smartphone (please complete the following information):** - Device: [e.g. iPhone6] - OS: [e.g. iOS8.1] - Browser [e.g. stock browser, safari] - Version [e.g. 22] **Additional context** Add any other context about the problem here.