Delphi / Object Pascal · Database exception

BDE Error 10255 ($280F) - A Deadlock Was Detected

What does BDE Error 10255 ($280F) - A Deadlock Was Detected mean in Delphi / Object Pascal?

Raised when the BDE detects that two or more sessions are each waiting on a lock held by the other, and it breaks the deadlock by failing one of the operations.

BDE Error 10255 ($280F) - A Deadlock Was DetectedDelphi (VCL) · Delphi (BDE)

Condition

Raised when the BDE detects that two or more sessions are each waiting on a lock held by the other, and it breaks the deadlock by failing one of the operations.

Fix

Keep transactions short and acquire locks in a consistent order across the application to reduce circular waits, and retry the failed operation after the deadlock is broken since the underlying data isn't corrupted.

Pending source verification. Not yet checked against official documentation.

Related database exception