Sunday, May 2, 2010

SQL Mafia Death Threats

"Transaction (Process ID 107) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction."

It was the message he always dreaded, one he had only heard about in legend. He heard the rumors that the Mafia had infiltrated SQL, and that this sort of this was happening, but he never thought that the mafia would move from dead pigeons to deadlock sql messages on his computer. It was almost too much to handle.

Messages being lost, transactions disappearing. It was only a matter of time before such a thing happened to him as well.

Oh what to do, what to do. Not much to do but wait. Wait for the query window to appear. And then? No one knows. No one has returned o0nce they have entered the query window.

But enter he must, or else be lost as resources became deadlocked...

No comments: