Not a member yet? Why not Sign up today
Create an account  

Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
2022-04-06 Server SQL Deadlock

#2
(04-06-2022, 06:49 PM)Haxus Wrote: Servers started reporting deadlocks a lot when making SQL updates. I've seen the occasional deadlock happen in the past without knowing the cause. The frequency of deadlocks seemed to increase a lot recently.

When a deadlock happens during an SQL transaction, the entire transaction fails.

The negative consequences of this event are many. One negative consequence is leaving players in limbo when they travel from one server to another, like when going through a wormhole.

A little research revealed the root cause of deadlocks during SQL UPDATE operations in PostgreSQL. The solution was trivial. It simply required a consistency of order when updating records by multiple processes. Updates are now performed in atom id order.

This requires a little time monitoring the server logs to be sure the problem is gone. So far so good. Logs are blissfully quiet.

Nice! That sounds like it would resolve quite a bit.
Avatars: - LimboWarrior

[Image: ezgif-com-resize.gif]
Reply



Messages In This Thread
2022-04-06 Server SQL Deadlock - by Haxus - 04-06-2022, 06:49 PM
RE: 2022-04-06 Server SQL Deadlock - by Rockinsince87 - 04-06-2022, 07:02 PM
RE: 2022-04-06 Server SQL Deadlock - by Deantwo - 04-06-2022, 07:15 PM
RE: 2022-04-06 Server SQL Deadlock - by Greydog - 04-06-2022, 07:46 PM

Forum Jump:


Users browsing this thread:
1 Guest(s)