I have a deadlock. And when I lokked into it, the error log, said that on the same resource, 2 processes owned an X lock. I thought that was impossible. How can 2 processes have an "exclusive" lock on the same resource?
Here is the errorlog showing 2 processes have an exclusive lock on the same object and are both waiting for a U lock on the same object.
keylock hobtid=72057608971812864 dbid=5 objectname=Qa.dbo.Docket indexname=ClaimID id=lock2323ba00 mode=X associatedObjectId=72057608971812864
owner id=process3a601390 mode=X
waiter id=process3968c70 mode=U requestType=wait
keylock hobtid=72057608971812864 dbid=5 objectname=Qa.dbo.Docket indexname=ClaimID id=lock23423900 mode=X associatedObjectId=72057608971812864
owner id=process3968c70 mode=X
waiter id=process3a601390 mode=U requestType=wait