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!