Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have been seeing a lot of deadlocks occurring on a system with deadlock graphs similar to this one:

enter image description here

I have been advised that it is a multi-victim deadlock but I cannot re-create a deadlock graph such as this one. Also, why does it only show one victim?

Any help or advice would be most appreciated.

Andrew

share|improve this question
1  
The graph in the image has one victim. We would need to see the XML behind the graph to analyze the situation. –  Jon Seigel Apr 9 at 17:07
    
I cannot post the XML as it contains object names. Do you know of any reference material that would explain the above situation? Why does the victim only have one request? –  Andrew pruski Apr 10 at 15:53
    
I've been going through the XML and that only shows one deadlock victim so I am starting to think that the advice of it being a multi-victim deadlock was incorrect. However, it does not explain why the top process was selected as the victim. By killing that process it does not resolve the conflict, am I missing something? – –  Andrew pruski Apr 10 at 16:45
    
Hmmm... I'm not sure if the deadlock monitor will kill more than one process at a time, because it would have to re-evaulate the lock hierarchy after every kill. There may be a second deadlock detection and kill of the process on the left; check to see if that one was captured in a separate report (note that it may be several seconds after this one). –  Jon Seigel Apr 10 at 17:36
    
Hi Jon, thanks for coming back to me. I've had a look in the error log and there was another deadlock recorded just after the initial one. The victim from the initial deadlock is present in the second graph with more detail (i.e. an acquired and requested lock). Thank you, Andrew –  Andrew pruski Apr 11 at 10:03
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.