Key Lock Hashed Resource Text Value not unique?

[Jake]

I have a deadlock situation, part of the problem looks like this;

spid ecid dbid ObjId IndId Type Resource Mode
Status
------ ------ ------ ----------- ------ ---- ---------------- -------
------
404 0 9 792389892 1 KEY (010086470766) SIU
WAIT
72 0 9 792389892 1 KEY (010086470766) SIU
WAIT
115 0 9 792389892 1 KEY (010086470766) SIU
WAIT
61 0 9 792389892 1 KEY (010086470766) IS
WAIT
318 0 9 792389892 1 KEY (010086470766) SIU
WAIT
430 0 9 1112391032 1 KEY (010086470766) X
GRANT

They are key locks I am used to the resource value generally being
unique by table. I am wondering if the other 'WAIT's are indeed
waiting based on the 'unique' resource value. Note that the exclusive
grant is on a different table but, the resource rsc_text value is the
same. Looking it up I get for a key lock that it's a hashed value, my
referance tells me what is is for a non-clustered index but, does not
explain what it would be for a clustered index.

Does it protect this resource based exclusively on resource rsc_text or
is it unique by ObjID/Rsc_text, has anyone seen this before?
Suggestions?

SQL Server 2000/SP3

-Chris

[Jake]

Nevermind, the hash as far as I can tell is rowid/key value in this
case 1,1 and 1,1. I reproduced and was able to get exclusive lock on
two tables with same rsc_text value, so lock is unique by
ObjId/Resource (at least). I went thru the lock table again and found a
NULL lock MODE that I had missed that had a GRANT status, expanding the
script to display the expanded modes.

Thanks anyways..

Jake wrote:

I have a deadlock situation, part of the problem looks like this;

spid ecid dbid ObjId IndId Type Resource Mode
Status
------ ------ ------ ----------- ------ ---- ---------------- ------- ------
404 0 9 792389892 1 KEY (010086470766) SIU
WAIT
72 0 9 792389892 1 KEY (010086470766) SIU
WAIT
115 0 9 792389892 1 KEY (010086470766) SIU
WAIT
61 0 9 792389892 1 KEY (010086470766) IS
WAIT
318 0 9 792389892 1 KEY (010086470766) SIU
WAIT
430 0 9 1112391032 1 KEY (010086470766) X
GRANT

They are key locks I am used to the resource value generally being
unique by table. I am wondering if the other 'WAIT's are indeed
waiting based on the 'unique' resource value. Note that the exclusive grant is on a different table but, the resource rsc_text value is the
same. Looking it up I get for a key lock that it's a hashed value, my referance tells me what is is for a non-clustered index but, does not
explain what it would be for a clustered index.

Does it protect this resource based exclusively on resource rsc_text or is it unique by ObjID/Rsc_text, has anyone seen this before?
Suggestions?

SQL Server 2000/SP3

-Chris