Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Deadlocks

Author  Topic 

california6
Starting Member

38 Posts

Posted - 2009-04-06 : 14:52:00
I am having little hardtime reading and understanding this deadlock print out. I would appreciate, if someone please take a moment to take a look at it and answer: One more thing: The MS kb/832524 arcitle gives an eg of node 1 and Node 2 list. but in my output i see like Node 1-2 and 3. Dont know, how to interpet this and figure out, where the problem lies.

Any suggestions would be greatly apprecaited.

Output from SQL Server error logs after enabling 1204 and 2605 trace flags:
------------------------------------------------------------------------



Date,Source,Severity,Message
04/06/2009 11:38:14,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x0000000607EB3110 Mode: U SPID:198 BatchID:0 ECID:2 TaskProxy0x00000002D41DD1A0) Value:0x8130adc0 Cost0/0)
04/06/2009 11:38:14,spid10s,Unknown,Victim Resource Owner:
04/06/2009 11:38:14,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
04/06/2009 11:38:14,spid10s,Unknown,Producer: Xid Slot: 2 e_waitNone
04/06/2009 11:38:14,spid10s,Unknown,Producer List::
04/06/2009 11:38:14,spid10s,Unknown,Consumer: Xid Slot: 0 e_waitPipeGetRow
04/06/2009 11:38:14,spid10s,Unknown,Consumer List::
04/06/2009 11:38:14,spid10s,Unknown,Coordinator: Task = 0x000000000AF2FAC8 e_waitPipeGetRow
04/06/2009 11:38:14,spid10s,Unknown,Port: 0x000000008042F030 Xid Slot: 0 Exchange Wait Type :e_waitPipeGetRow

04/06/2009 11:38:14,spid10s,Unknown,Node:3
04/06/2009 11:38:14,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
04/06/2009 11:38:14,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x0000000290EC9270 Mode: IU SPID:169 BatchID:0 ECID:0 TaskProxy0x00000000E76C4598) Value:0x5a12c300 Cost0/1000)
04/06/2009 11:38:14,spid10s,Unknown,Requested By:
04/06/2009 11:38:14,spid10s,Unknown,Input Buf: Language Event: DELETE FROM [dbo].[sgDataOPERATIONS] WHERE [LCKNUMBER] = 236653 AND [CellVal] IN(1 4)
04/06/2009 11:38:14,spid10s,Unknown,SPID: 198 ECID: 0 Statement Type: DELETE Line #: 1
04/06/2009 11:38:14,spid10s,Unknown,Owner:0x000000038A44E140 Mode: U Flg:0x0 Ref:0 Life:00000001 SPID:198 ECID:0 XactLockInfo: 0x0000000151793A08
04/06/2009 11:38:14,spid10s,Unknown,Grant List 3:
04/06/2009 11:38:14,spid10s,Unknown,PAGE: 9:3:7338952 CleanCnt:2 Mode:U Flags: 0x2

04/06/2009 11:38:14,spid10s,Unknown,Node:2
04/06/2009 11:38:14,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
04/06/2009 11:38:14,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x0000000607EB3110 Mode: U SPID:198 BatchID:0 ECID:2 TaskProxy0x00000002D41DD1A0) Value:0x8130adc0 Cost0/0)
04/06/2009 11:38:14,spid10s,Unknown,Requested By:
04/06/2009 11:38:14,spid10s,Unknown,Input Buf: Language Event: DELETE [dbo].[sgDataOPERATIONS] WHERE [LCKNUMBER] IN (236649)
04/06/2009 11:38:14,spid10s,Unknown,SPID: 169 ECID: 0 Statement Type: DELETE Line #: 1
04/06/2009 11:38:14,spid10s,Unknown,Owner:0x000000065AA1DCC0 Mode: IX Flg:0x0 Ref:0 Life:02000000 SPID:169 ECID:0 XactLockInfo: 0x0000000290EC92A8
04/06/2009 11:38:14,spid10s,Unknown,Grant List 2:
04/06/2009 11:38:14,spid10s,Unknown,PAGE: 9:3:5504039 CleanCnt:3 Mode:IX Flags: 0x2

04/06/2009 11:38:14,spid10s,Unknown,Node:1
04/06/2009 11:38:14,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
04/06/2009 11:38:14,spid10s,Unknown,Wait-for graph
04/06/2009 11:38:14,spid10s,Unknown,Deadlock encountered .... Printing deadlock information
04/06/2009 11:35:14,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x00000002479E8B30 Mode: U SPID:289 BatchID:0 ECID:2 TaskProxy0x00000007088AF170) Value:0xa234380 Cost0/0)
04/06/2009 11:35:14,spid10s,Unknown,Victim Resource Owner:
04/06/2009 11:35:14,spid10s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
04/06/2009 11:35:14,spid10s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x00000002479E8B30 Mode: U SPID:289 BatchID:0 ECID:2 TaskProxy0x00000007088AF170) Value:0xa234380 Cost0/0)
04/06/2009 11:35:14,spid10s,Unknown,Requested By:
04/06/2009 11:35:14,spid10s,Unknown,Input Buf: Language Event: DELETE [dbo].[sgDataOPERATIONS] WHERE [LCKNUMBER] IN (236597)
04/06/2009 11:35:14,spid10s,Unknown,SPID: 366 ECID: 0 Statement Type: DELETE Line #: 1
04/06/2009 11:35:14,spid10s,Unknown,Owner:0x000000031A50E7C0 Mode: IX Flg:0x0 Ref:0 Life:02000000 SPID:366 ECID:0 XactLockInfo: 0x00000003ACA8C3A8
04/06/2009 11:35:14,spid10s,Unknown,Grant List 0:
04/06/2009 11:35:14,spid10s,Unknown,PAGE: 9:1:3239310 CleanCnt:2 Mode:IX Flags: 0x2



Cali

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-04-06 : 15:52:11
It will be more clear with 1222 Flag in SQL 2005.
Go to Top of Page

california6
Starting Member

38 Posts

Posted - 2009-04-06 : 17:22:19
thanks for the contribution. i have enabled 1222 flag. so far no deadlocks. if i do get it, will post here.

thanks again,

Cali
Go to Top of Page
   

- Advertisement -