Help in analysing this 2604 Deadlock Trace

Question

Post reply

Help in analysing this 2604 Deadlock Trace

Pargat

Old Hand

Points: 337
More actions
October 29, 2004 at 4:22 am

#86783

Hi am experiancing alot of deadlock against a specific table.
I ran 1204 trace which gave details of processes involved in the deadlock. I've including the deadlock trace information for one of the deadlocks. I've read the article by s kumar, which discussed analysing deadlock traces. But really need more information on the trace below. For what I can see, both nodes are inserting to the same table, and this is causing the deadlock. There is a composite clustered index on the customernumber and customerversionnumber columns.   Could it be due to this. Any help would be grateful.
2004-10-28 13:07:52.36 spid1     Wait-for graph
2004-10-28 13:07:52.36 spid1
2004-10-28 13:07:52.36 spid1     Node:1
2004-10-28 13:07:52.36 spid1     KEY: 9:98099390:1 (cf000061655d) CleanCnt:2 Mode: Range-S-S Flags: 0x0
2004-10-28 13:07:52.36 spid1      Grant List 0::
2004-10-28 13:07:52.36 spid1      Grant List 2::
2004-10-28 13:07:52.36 spid1        Owner:0x511bd920 Mode: Range-S-S Flg:0x0 Ref:3 Life:02000000 SPID:305 ECID:0
2004-10-28 13:07:52.36 spid1        SPID: 305 ECID: 0 Statement Type: INSERT Line #: 1
2004-10-28 13:07:52.36 spid1        Input Buf: Language Event: INSERT INTO INCOMESUMMARY (CUSTOMERNUMBER, CUSTOMERVERSIONNUMBER, ALLOWABLEANNUALINCOME, NETALLOWABLEANNUALINCOME, ALLOWABLEMONTHLYINCOME) values ( '20457362', 1, 45000, 43860, 3750)
2004-10-28 13:07:52.36 spid1      Requested By:
2004-10-28 13:07:52.36 spid1        ResType:LockOwner Stype:'OR' Mode: Range-Insert-Null SPID:299 ECID:0 Ec0x254E7568) Value:0x4e0a1780 Cost0/44)
2004-10-28 13:07:52.36 spid1
2004-10-28 13:07:52.36 spid1     Node:2
2004-10-28 13:07:52.36 spid1     KEY: 9:98099390:1 (cf000061655d) CleanCnt:2 Mode: Range-S-S Flags: 0x0
2004-10-28 13:07:52.36 spid1      Grant List 0::
2004-10-28 13:07:52.36 spid1        Owner:0x2730b3e0 Mode: Range-S-S Flg:0x0 Ref:2 Life:02000000 SPID:299 ECID:0
2004-10-28 13:07:52.36 spid1        SPID: 299 ECID: 0 Statement Type: INSERT Line #: 1
2004-10-28 13:07:52.36 spid1        Input Buf: Language Event: INSERT INTO INCOMESUMMARY (CUSTOMERNUMBER, CUSTOMERVERSIONNUMBER, ALLOWABLEANNUALINCOME, NETALLOWABLEANNUALINCOME, ALLOWABLEMONTHLYINCOME) values ( '20457364', 1, 17182, 17180.8, 1431.83333333333)
2004-10-28 13:07:52.36 spid1      Grant List 2::
2004-10-28 13:07:52.36 spid1      Requested By:
2004-10-28 13:07:52.36 spid1        ResType:LockOwner Stype:'OR' Mode: Range-Insert-Null SPID:305 ECID:0 Ec0x6A3FD568) Value:0x61c91b20 Cost0/44)
2004-10-28 13:07:52.36 spid1     Victim Resource Owner:
2004-10-28 13:07:52.36 spid1      ResType:LockOwner Stype:'OR' Mode: Range-Insert-Null SPID:305 ECID:0 Ec0x6A3FD568) Value:0x61c91b20 Cost0/44)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Pargat Old Hand Points: 337 More actions · Answer 1

Apologies All the heading should be Help in analysing this 1204 Deadlock Trace