I do not understand what does statement type UNKNOWN TOKEN mean in the Node 2 of the following deadlock information. Any ideas please?<br /><br /><br />Deadlock encountered .... Printing deadlock information0<br />2006-06-10 18:42:49.68 spid4 0<br />2006-06-10 18:42:49.68 spid4 Wait-for graph0<br />2006-06-10 18:42:49.68 spid4 0<br />2006-06-10 18:42:49.68 spid4 Node:10<br />2006-06-10 18:42:49.68 spid4 KEY: 1:30:1 (1a013bd4b69f) CleanCnt:2 Mode: U Flags: 0x00<br />2006-06-10 18:42:49.68 spid4 Grant List 1::0<br />2006-06-10 18:42:49.68 spid4 Grant List 3::0<br />2006-06-10 18:42:49.68 spid4 Owner:0x42e1d360 Mode: S Flg:0x0 Ref:1 Life:00000000 SPID:51 ECID:00<br />2006-06-10 18:42:49.68 spid4 SPID: 51 ECID: 0 Statement Type: SELECT Line #: 1220<br />2006-06-10 18:42:49.68 spid4 Input Buf: Language Event: exec sp_helpreplicationdboption 0<br />2006-06-10 18:42:49.68 spid4 Requested By: 0<br />2006-06-10 18:42:49.68 spid4 ResType:LockOwner Stype:'OR' Mode: X SPID:17 ECID:0 Ec<img src='/community/emoticons/emotion-6.gif' alt='' />0x431A03F0) Value:0x42e18f20 Cost<img src='/community/emoticons/emotion-6.gif' alt='' />0/44)0<br />2006-06-10 18:42:49.68 spid4 0<br />2006-06-10 18:42:49.68 spid4 Node:20<br />2006-06-10 18:42:49.68 spid4 DB: 14 CleanCnt:2 Mode: X Flags: 0x00<br />2006-06-10 18:42:49.68 spid4 Grant List 0::0<br />2006-06-10 18:42:49.68 spid4 Owner:0x42e1d400 Mode: X Flg:0x0 Ref:1 Life:00000000 SPID:17 ECID:00<br />2006-06-10 18:42:49.68 spid4 SPID: 17 ECID: 0 <b>Statement Type: UNKNOWN TOKEN </b> Line #: 00<br />2006-06-10 18:42:49.68 spid4 Requested By: 0<br />2006-06-10 18:42:49.68 spid4 ResType:LockOwner Stype:'OR' Mode: S SPID:51 ECID:0 Ec<img src='/community/emoticons/emotion-6.gif' alt='' />0x42E6555<img src='/community/emoticons/emotion-11.gif' alt='8)' /> Value:0x42e1d380 Cost<img src='/community/emoticons/emotion-6.gif' alt='' />1/2710)0<br />2006-06-10 18:42:49.68 spid4 Victim Resource Owner:0<br />2006-06-10 18:42:49.68 spid4 ResType:LockOwner Stype:'OR' Mode: S SPID:51 ECID:0 Ec<img src='/community/emoticons/emotion-6.gif' alt='' />0x42E6555<img src='/community/emoticons/emotion-11.gif' alt='8)' /> Value:0x42e1d380 Cost<img src='/community/emoticons/emotion-6.gif' alt='' />1/2710<br /><br /><br /><br />Regards,<br /><br />Chetan
Check: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=441442&SiteID=1 http://support.microsoft.com/default.aspx?scid=kb;en-us;308547 Luis Martin Moderator SQL-Server-Performance.com All in Love is Fair Stevie Wonder All postings are provided “AS IS†with no warranties for accuracy.
