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,Message04/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_waitNone04/06/2009 11:38:14,spid10s,Unknown,Producer List::04/06/2009 11:38:14,spid10s,Unknown,Consumer: Xid Slot: 0 e_waitPipeGetRow04/06/2009 11:38:14,spid10s,Unknown,Consumer List::04/06/2009 11:38:14,spid10s,Unknown,Coordinator: Task = 0x000000000AF2FAC8 e_waitPipeGetRow04/06/2009 11:38:14,spid10s,Unknown,Port: 0x000000008042F030 Xid Slot: 0 Exchange Wait Type :e_waitPipeGetRow04/06/2009 11:38:14,spid10s,Unknown,Node:304/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 #: 104/06/2009 11:38:14,spid10s,Unknown,Owner:0x000000038A44E140 Mode: U Flg:0x0 Ref:0 Life:00000001 SPID:198 ECID:0 XactLockInfo: 0x0000000151793A0804/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: 0x204/06/2009 11:38:14,spid10s,Unknown,Node:204/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 #: 104/06/2009 11:38:14,spid10s,Unknown,Owner:0x000000065AA1DCC0 Mode: IX Flg:0x0 Ref:0 Life:02000000 SPID:169 ECID:0 XactLockInfo: 0x0000000290EC92A804/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: 0x204/06/2009 11:38:14,spid10s,Unknown,Node:104/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 graph04/06/2009 11:38:14,spid10s,Unknown,Deadlock encountered .... Printing deadlock information04/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 #: 104/06/2009 11:35:14,spid10s,Unknown,Owner:0x000000031A50E7C0 Mode: IX Flg:0x0 Ref:0 Life:02000000 SPID:366 ECID:0 XactLockInfo: 0x00000003ACA8C3A804/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 |
|