question

tatsean avatar image
tatsean asked

Deadlock's Log Analysis in Sql Server

The following deadlock's log just confuses me.

1. What is the difference between the "mode" in [keylock] and the "mode" in owner-list?
2. Why owner has a requestType=wait, typically it is only seen in waiter. So, if requestType=wait exists in owner, what does it actually mean?

keylock hobtid=72057594049658880 dbid=9 objectname=XXXXX.dbo.Partner indexname=PK_Partner id=lock16f21977480 mode=X associatedObjectId=72057594049658880
owner-list
owner id=process16e35c9dc28 mode=S requestType=wait
waiter-list
waiter id=process17184a64108 mode=S requestType=wait

Thanks in advance!
deadlockdeadlock-graph
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.