SQL Server Performance

Deadlock Info

Discussion in 'General DBA Questions' started by chetanjain04, Jun 30, 2006.

  1. chetanjain04 Member

    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
  2. Luis Martin Moderator

Share This Page