Log in Sign up
PostgreSQL Critical 4 weeks ago

ERROR: deadlock detected (Process 1234 waits for ShareLock on transaction)

Varga Mark
70 0
Stack Trace / Error Log 
ERROR:  deadlock detected
DETAIL:  Process 1234 waits for ShareLock on transaction 9988; blocked by process 5678.
Process 5678 waits for ShareLock on transaction 9987; blocked by process 1234.
HINT:  See server log for query details.
CONTEXT:  while updating tuple (0,15) in relation "orders"

AI Suggested Fix

87% Confidence

Two transactions are trying to update the same rows in the orders table but in a different order.

Did this solution work?

Comments (0)

Join the discussion to help others fix this error.

Log in to comment

No comments yet. Be the first to share!

Issue Details

Status
Category General
Impact Score

Related Issues

Fixing npm ERR! code EBADENGINE Node.js • 1 hour ago
Segmentation fault (core dumped) C++ • 3 hours ago