SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Deadlocks
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

california6
Starting Member

USA
38 Posts

Posted - 04/06/2009 :  14:52:00  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7174 Posts

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

california6
Starting Member

USA
38 Posts

Posted - 04/06/2009 :  17:22:19  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000