Deadlock encountered .... Printing deadlock information

Hi
Below is the info about deadlock occured, can you suggest the needful.
ST_SP_UpdateFLCLAttrMeasureQ_Act is the procedure
========================================
====================================
===
Deadlock encountered ... Printing deadlock information
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Wait-for graph
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:1
0
2005-12-08 11:14:17.37 spid3 PAG: 10:1:84715
CleanCnt:4 Mode: SIX Flags: 0x2
0
2005-12-08 11:14:17.37 spid3 Grant List 0::
0
2005-12-08 11:14:17.37 spid3 Owner:0x1d311a40 Mode: SIX
Flg:0x0 Ref:1 Life:02000000 SPID:536 ECID:0
0
2005-12-08 11:14:17.37 spid3 SPID: 536 ECID: 0 Statement Type:
SELECT Line #: 462
0
2005-12-08 11:14:17.37 spid3 Input Buf: RPC Event:
ST_SP_UpdateFLCLAttrMeasureQ_Act;1
0
2005-12-08 11:14:17.37 spid3 Requested By:
0
2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
S SPID:532 ECID:3 Ec0x5E2F60C0) Value:0x62879ec0 Cost0/0)
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:2
0
2005-12-08 11:14:17.37 spid3 Port: 0x42c30380 Xid Slot: 0, EC:
0x574ff578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
0
2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x574ff578, SPID:
536, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Consumer List::
0
2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
0x574ff578, SPID: 536, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Producer List::
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
0x20bf60c0, SPID: 536, ECID: 2, Blocking
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
0x1f15e0c0, SPID: 536, ECID: 1, Blocking
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:3
0
2005-12-08 11:14:17.37 spid3 PAG: 10:1:80523
CleanCnt:3 Mode: IX Flags: 0x2
0
2005-12-08 11:14:17.37 spid3 Grant List 1::
0
2005-12-08 11:14:17.37 spid3 Owner:0x1d364fa0 Mode: IX
Flg:0x0 Ref:1 Life:02000000 SPID:538 ECID:0
0
2005-12-08 11:14:17.37 spid3 SPID: 538 ECID: 0 Statement Type:
SELECT Line #: 384
0
2005-12-08 11:14:17.37 spid3 Input Buf: RPC Event:
ST_SP_UpdateFLCLAttrMeasureQ_Act;1
0
2005-12-08 11:14:17.37 spid3 Requested By:
0
2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
S SPID:536 ECID:2 Ec0x20BF60C0) Value:0x1d33b440 Cost0/EC)
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:4
0
2005-12-08 11:14:17.37 spid3 Port: 0x42c30200 Xid Slot: 0, EC:
0x20efb578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
0
2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x20efb578, SPID:
538, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Consumer List::
0
2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
0x20efb578, SPID: 538, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Producer List::
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
0x214c40c0, SPID: 538, ECID: 1, Blocking
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
0x590260c0, SPID: 538, ECID: 2, Blocking
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:5
0
2005-12-08 11:14:17.37 spid3 PAG: 10:1:84715
CleanCnt:4 Mode: SIX Flags: 0x2
0
2005-12-08 11:14:17.37 spid3 Wait List:
0
2005-12-08 11:14:17.37 spid3 Owner:0x62879ec0 Mode: S
Flg:0x0 Ref:1 Life:00000000 SPID:532 ECID:3
0
2005-12-08 11:14:17.37 spid3 SPID: 532 ECID: 3 Statement Type:
SELECT Line #: 80
0
2005-12-08 11:14:17.37 spid3 Input Buf: RPC Event:
ST_SP_GetFLCLAttrMeasureQ_Tar;1
0
2005-12-08 11:14:17.37 spid3 Requested By:
0
2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
S SPID:538 ECID:1 Ec0x214C40C0) Value:0x1d2b70a0 Cost0/DC)
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 -- next branch --
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:4
0
2005-12-08 11:14:17.37 spid3 Port: 0x42c30200 Xid Slot: 0, EC:
0x20efb578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
0
2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x20efb578, SPID:
538, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Consumer List::
0
2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
0x20efb578, SPID: 538, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Producer List::
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
0x214c40c0, SPID: 538, ECID: 1, Blocking
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
0x590260c0, SPID: 538, ECID: 2, Blocking
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:8
0
2005-12-08 11:14:17.37 spid3 PAG: 10:1:84715
CleanCnt:4 Mode: SIX Flags: 0x2
0
2005-12-08 11:14:17.37 spid3 Wait List:
0
2005-12-08 11:14:17.37 spid3 Owner:0x62879ec0 Mode: S
Flg:0x0 Ref:1 Life:00000000 SPID:532 ECID:3
0
2005-12-08 11:14:17.37 spid3 Requested By:
0
2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
S SPID:538 ECID:2 Ec0x590260C0) Value:0x1d3daa60 Cost0/DC)
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 -- next branch --
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:4
0
2005-12-08 11:14:17.37 spid3 Port: 0x42c30200 Xid Slot: 0, EC:
0x20efb578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
0
2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x20efb578, SPID:
538, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Consumer List::
0
2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
0x20efb578, SPID: 538, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Producer List::
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
0x214c40c0, SPID: 538, ECID: 1, Blocking
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
0x590260c0, SPID: 538, ECID: 2, Blocking
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 -- next branch --
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:2
0
2005-12-08 11:14:17.37 spid3 Port: 0x42c30380 Xid Slot: 0, EC:
0x574ff578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
0
2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x574ff578, SPID:
536, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Consumer List::
0
2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
0x574ff578, SPID: 536, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Producer List::
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
0x20bf60c0, SPID: 536, ECID: 2, Blocking
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
0x1f15e0c0, SPID: 536, ECID: 1, Blocking
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:12
0
2005-12-08 11:14:17.37 spid3 PAG: 10:1:80523
CleanCnt:3 Mode: IX Flags: 0x2
0
2005-12-08 11:14:17.37 spid3 Wait List:
0
2005-12-08 11:14:17.37 spid3 Owner:0x1d33b440 Mode: S
Flg:0x0 Ref:1 Life:00000000 SPID:536 ECID:2
0
2005-12-08 11:14:17.37 spid3 Requested By:
0
2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
S SPID:536 ECID:1 Ec0x1F15E0C0) Value:0x5306c360 Cost0/EC)
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 -- next branch --
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:2
0
2005-12-08 11:14:17.37 spid3 Port: 0x42c30380 Xid Slot: 0, EC:
0x574ff578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
0
2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x574ff578, SPID:
536, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Consumer List::
0
2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
0x574ff578, SPID: 536, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Producer List::
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
0x20bf60c0, SPID: 536, ECID: 2, Blocking
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
0x1f15e0c0, SPID: 536, ECID: 1, Blocking
0
2005-12-08 11:14:17.37 spid3 Victim Resource Owner:
0
2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode: S
SPID:532 ECID:3 Ec0x5E2F60C0) Value:0x62879ec0 Cost0/0)
0
2005-12-08 11:14:17.37 spid3
0
Deadlock encountered ... Printing deadlock information
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Wait-for graph
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:1
0
2005-12-08 11:14:17.37 spid3 PAG: 10:1:80523
CleanCnt:3 Mode: IX Flags: 0x2
0
2005-12-08 11:14:17.37 spid3 Grant List 1::
0
2005-12-08 11:14:17.37 spid3 Owner:0x1d364fa0 Mode: IX
Flg:0x0 Ref:1 Life:02000000 SPID:538 ECID:0
0
2005-12-08 11:14:17.37 spid3 SPID: 538 ECID: 0 Statement Type:
SELECT Line #: 384
0
2005-12-08 11:14:17.37 spid3 Input Buf: RPC Event:
ST_SP_UpdateFLCLAttrMeasureQ_Act;1
0
2005-12-08 11:14:17.37 spid3 Requested By:
0
2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
S SPID:536 ECID:2 Ec0x20BF60C0) Value:0x1d33b440 Cost0/EC)
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:2
0
2005-12-08 11:14:17.37 spid3 Port: 0x42c30200 Xid Slot: 0, EC:
0x20efb578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
0
2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x20efb578, SPID:
538, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Consumer List::
0
2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
0x20efb578, SPID: 538, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Producer List::
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
0x214c40c0, SPID: 538, ECID: 1, Blocking
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
0x590260c0, SPID: 538, ECID: 2, Blocking
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:3
0
2005-12-08 11:14:17.37 spid3 PAG: 10:1:84715
CleanCnt:4 Mode: SIX Flags: 0x3
0
2005-12-08 11:14:17.37 spid3 Grant List 0::
0
2005-12-08 11:14:17.37 spid3 Requested By:
0
2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
S SPID:538 ECID:1 Ec0x214C40C0) Value:0x1d2b70a0 Cost0/DC)
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:4
0
2005-12-08 11:14:17.37 spid3 PAG: 10:1:84715
CleanCnt:4 Mode: SIX Flags: 0x3
0
2005-12-08 11:14:17.37 spid3 Grant List 0::
0
2005-12-08 11:14:17.37 spid3 Owner:0x1d311a40 Mode: SIX
Flg:0x0 Ref:1 Life:02000000 SPID:536 ECID:0
0
2005-12-08 11:14:17.37 spid3 SPID: 536 ECID: 0 Statement Type:
SELECT Line #: 462
0
2005-12-08 11:14:17.37 spid3 Input Buf: RPC Event:
ST_SP_UpdateFLCLAttrMeasureQ_Act;1
0
2005-12-08 11:14:17.37 spid3 Requested By:
0
2005-12-08 11:14:17.37 spid3 2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:5
0
2005-12-08 11:14:17.37 spid3 Port: 0x42c30380 Xid Slot: 0, EC:
0x574ff578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
0
2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x574ff578, SPID:
536, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Consumer List::
0
2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
0x574ff578, SPID: 536, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Producer List::
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
0x20bf60c0, SPID: 536, ECID: 2, Blocking
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
0x1f15e0c0, SPID: 536, ECID: 1, Blocking
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 -- next branch --
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:5
0
2005-12-08 11:14:17.37 spid3 Port: 0x42c30380 Xid Slot: 0, EC:
0x574ff578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
0
2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x574ff578, SPID:
536, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Consumer List::
0
2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
0x574ff578, SPID: 536, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Producer List::
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
0x20bf60c0, SPID: 536, ECID: 2, Blocking
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
0x1f15e0c0, SPID: 536, ECID: 1, Blocking
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:8
0
2005-12-08 11:14:17.37 spid3 PAG: 10:1:80523
CleanCnt:3 Mode: IX Flags: 0x2
0
2005-12-08 11:14:17.37 spid3 Wait List:
0
2005-12-08 11:14:17.37 spid3 Owner:0x1d33b440 Mode: S
Flg:0x0 Ref:1 Life:00000000 SPID:536 ECID:2
0
2005-12-08 11:14:17.37 spid3 Requested By:
0
2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
S SPID:536 ECID:1 Ec0x1F15E0C0) Value:0x5306c360 Cost0/EC)
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 -- next branch --
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:5
0
2005-12-08 11:14:17.37 spid3 Port: 0x42c30380 Xid Slot: 0, EC:
0x574ff578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
0
2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x574ff578, SPID:
536, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Consumer List::
0
2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
0x574ff578, SPID: 536, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Producer List::
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
0x20bf60c0, SPID: 536, ECID: 2, Blocking
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
0x1f15e0c0, SPID: 536, ECID: 1, Blocking
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 -- next branch --
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:2
0
2005-12-08 11:14:17.37 spid3 Port: 0x42c30200 Xid Slot: 0, EC:
0x20efb578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
0
2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x20efb578, SPID:
538, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Consumer List::
0
2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
0x20efb578, SPID: 538, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Producer List::
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
0x214c40c0, SPID: 538, ECID: 1, Blocking
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
0x590260c0, SPID: 538, ECID: 2, Blocking
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:12
0
2005-12-08 11:14:17.37 spid3 PAG: 10:1:84715
CleanCnt:4 Mode: SIX Flags: 0x3
0
2005-12-08 11:14:17.37 spid3 Grant List 0::
0
2005-12-08 11:14:17.37 spid3 Requested By:
0
2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
S SPID:538 ECID:2 Ec0x590260C0) Value:0x1d3daa60 Cost0/DC)
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 -- next branch --
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:2
0
2005-12-08 11:14:17.37 spid3 Port: 0x42c30200 Xid Slot: 0, EC:
0x20efb578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
0
2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x20efb578, SPID:
538, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Consumer List::
0
2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
0x20efb578, SPID: 538, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Producer List::
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
0x214c40c0, SPID: 538, ECID: 1, Blocking
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
0x590260c0, SPID: 538, ECID: 2, Blocking
0
2005-12-08 11:14:17.37 spid3 Victim Resource Owner:
0
2005-12-08 11:14:17.37 spid3 :2
0
2005-12-08 11:14:17.37 spid3
0
Deadlock encountered ... Printing deadlock information
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Wait-for graph
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:1
0
2005-12-08 11:14:17.37 spid3 PAG: 10:1:80523
CleanCnt:3 Mode: IX Flags: 0x2
0
2005-12-08 11:14:17.37 spid3 Wait List:
0
2005-12-08 11:14:17.37 spid3 Owner:0x1d33b440 Mode: S
Flg:0x0 Ref:1 Life:00000000 SPID:536 ECID:2
0
2005-12-08 11:14:17.37 spid3 SPID: 536 ECID: 2 Statement Type:
SELECT Line #: 462
0
2005-12-08 11:14:17.37 spid3 Input Buf: RPC Event:
ST_SP_UpdateFLCLAttrMeasureQ_Act;1
0
2005-12-08 11:14:17.37 spid3 Requested By:
0
2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
S SPID:536 ECID:1 Ec0x1F15E0C0) Value:0x5306c360 Cost0/EC)
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:2
0
2005-12-08 11:14:17.37 spid3 PAG: 10:1:80523
CleanCnt:3 Mode: IX Flags: 0x2
0
2005-12-08 11:14:17.37 spid3 Grant List 1::
0
2005-12-08 11:14:17.37 spid3 Owner:0x1d364fa0 Mode: IX
Flg:0x0 Ref:1 Life:02000000 SPID:538 ECID:0
0
2005-12-08 11:14:17.37 spid3 SPID: 538 ECID: 0 Statement Type:
SELECT Line #: 384
0
2005-12-08 11:14:17.37 spid3 Input Buf: RPC Event:
ST_SP_UpdateFLCLAttrMeasureQ_Act;1
0
2005-12-08 11:14:17.37 spid3 Requested By:
0
2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
S SPID:536 ECID:2 Ec0x20BF60C0) Value:0x1d33b440 Cost0/EC)
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:3
0
2005-12-08 11:14:17.37 spid3 Port: 0x42c30200 Xid Slot: 0, EC:
0x20efb578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
0
2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x20efb578, SPID:
538, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Consumer List::
0
2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
0x20efb578, SPID: 538, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Producer List::
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
0x214c40c0, SPID: 538, ECID: 1, Blocking
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
0x590260c0, SPID: 538, ECID: 2, Blocking
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:4
0
2005-12-08 11:14:17.37 spid3 PAG: 10:1:84715
CleanCnt:3 Mode: SIX Flags: 0x2
0
2005-12-08 11:14:17.37 spid3 Grant List 0::
0
2005-12-08 11:14:17.37 spid3 Owner:0x1d311a40 Mode: SIX
Flg:0x0 Ref:1 Life:02000000 SPID:536 ECID:0
0
2005-12-08 11:14:17.37 spid3 Requested By:
0
2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
S SPID:538 ECID:1 Ec0x214C40C0) Value:0x1d2b70a0 Cost0/DC)
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:5
0
2005-12-08 11:14:17.37 spid3 Port: 0x42c30380 Xid Slot: 0, EC:
0x574ff578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
0
2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x574ff578, SPID:
536, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Consumer List::
0
2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
0x574ff578, SPID: 536, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Producer List::
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
0x20bf60c0, SPID: 536, ECID: 2, Blocking
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
0x1f15e0c0, SPID: 536, ECID: 1, Blocking
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 -- next branch --
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:5
0
2005-12-08 11:14:17.37 spid3 Port: 0x42c30380 Xid Slot: 0, EC:
0x574ff578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
0
2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x574ff578, SPID:
536, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Consumer List::
0
2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
0x574ff578, SPID: 536, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Producer List::
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
0x20bf60c0, SPID: 536, ECID: 2, Blocking
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
0x1f15e0c0, SPID: 536, ECID: 1, Blocking
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 -- next branch --
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:5
0
2005-12-08 11:14:17.37 spid3 Port: 0x42c30380 Xid Slot: 0, EC:
0x574ff578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
0
2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x574ff578, SPID:
536, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Consumer List::
0
2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
0x574ff578, SPID: 536, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Producer List::
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
0x20bf60c0, SPID: 536, ECID: 2, Blocking
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
0x1f15e0c0, SPID: 536, ECID: 1, Blocking
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 -- next branch --
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:3
0
2005-12-08 11:14:17.37 spid3 Port: 0x42c30200 Xid Slot: 0, EC:
0x20efb578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
0
2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x20efb578, SPID:
538, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Consumer List::
0
2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
0x20efb578, SPID: 538, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Producer List::
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
0x214c40c0, SPID: 538, ECID: 1, Blocking
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
0x590260c0, SPID: 538, ECID: 2, Blocking
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:11
0
2005-12-08 11:14:17.37 spid3 PAG: 10:1:84715
CleanCnt:3 Mode: SIX Flags: 0x2
0
2005-12-08 11:14:17.37 spid3 Wait List:
0
2005-12-08 11:14:17.37 spid3 Owner:0x1d2b70a0 Mode: S
Flg:0x0 Ref:1 Life:00000000 SPID:538 ECID:1
0
2005-12-08 11:14:17.37 spid3 Requested By:
0
2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
S SPID:538 ECID:2 Ec0x590260C0) Value:0x1d3daa60 Cost0/DC)
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 -- next branch --
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3
0
2005-12-08 11:14:17.37 spid3 Node:3
0
2005-12-08 11:14:17.37 spid3 Port: 0x42c30200 Xid Slot: 0, EC:
0x20efb578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
0
2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x20efb578, SPID:
538, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Consumer List::
0
2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
0x20efb578, SPID: 538, ECID: 0, Not Blocking
0
2005-12-08 11:14:17.37 spid3 Producer List::
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
0x214c40c0, SPID: 538, ECID: 1, Blocking
0
2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
0x590260c0, SPID: 538, ECID: 2, Blocking
0
2005-12-08 11:14:17.37 spid3 Victim Resource Owner:
0
2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode: S
SPID:538 ECID:1 Ec0x214C40C0) Value:0x1d2b70a0 Cost0/DC)
0
2005-12-08 11:32:39.76 spid3
0
Deadlock encountered ... Printing deadlock information
0
2005-12-08 11:32:39.76 spid3
0
2005-12-08 11:32:39.76 spid3 Wait-for graph
0
2005-12-08 11:32:39.76 spid3
0
2005-12-08 11:32:39.76 spid3 Node:1
0
2005-12-08 11:32:39.76 spid3 PAG: 10:1:85048
CleanCnt:2 Mode: SIU Flags: 0x2
0
2005-12-08 11:32:39.76 spid3 Grant List 1::
0
2005-12-08 11:32:39.76 spid3 Owner:0x1d3db960 Mode: S
Flg:0x0 Ref:1 Life:00000000 SPID:538 ECID:2
0
2005-12-08 11:32:39.76 spid3 SPID: 538 ECID: 2 Statement Type:
CONDITIONAL Line #: 392
0
2005-12-08 11:32:39.76 spid3 Input Buf: RPC Event:
ST_SP_UpdateFLCLAttrMeasureQ_Act;1
0
2005-12-08 11:32:39.76 spid3 Requested By:
0
2005-12-08 11:32:39.76 spid3 ResType:LockOwner Stype:'OR' Mode:
IX SPID:537 ECID:0 Ec0x69591578) Value:0x1d371720 Cost0/394)
0
2005-12-08 11:32:39.76 spid3
0
2005-12-08 11:32:39.76 spid3 Node:2
0
2005-12-08 11:32:39.76 spid3 PAG: 10:1:85049
CleanCnt:2 Mode: SIX Flags: 0x2
0
2005-12-08 11:32:39.76 spid3 Grant List 1::
0
2005-12-08 11:32:39.76 spid3 Owner:0x42c28c20 Mode: IX
Flg:0x0 Ref:3 Life:02000000 SPID:537 ECID:0
0
2005-12-08 11:32:39.76 spid3 SPID: 537 ECID: 0 Statement Type:
UPDATE Line #: 416
0
2005-12-08 11:32:39.76 spid3 Input Buf: RPC Event:
ST_SP_UpdateFLCLAttrMeasureQ_Tar;1
0
2005-12-08 11:32:39.76 spid3 Requested By:
0
2005-12-08 11:32:39.76 spid3 ResType:LockOwner Stype:'OR' Mode:
S SPID:538 ECID:2 Ec0x76D740C0) Value:0x5316ff60 Cost0/0)
0
2005-12-08 11:32:39.76 spid3 Victim Resource Owner:
0
2005-12-08 11:32:39.76 spid3 ResType:LockOwner Stype:'OR' Mode: S
SPID:538 ECID:2 Ec0x76D740C0) Value:0x5316ff60 Cost0/0)
0
2005-12-08 12:49:22.28 spid3
KaranPls read this article
http://www.sql-server-performance.com/deadlocks.asp
"Karan Lobana" <karan_lobana2001@.yahoo.com> wrote in message
news:1134029405.081946.40170@.g44g2000cwa.googlegroups.com...
> Hi
> Below is the info about deadlock occured, can you suggest the needful.
> ST_SP_UpdateFLCLAttrMeasureQ_Act is the procedure
>
> ========================================
==================================
=====
> Deadlock encountered ... Printing deadlock information
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Wait-for graph
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:1
>
> 0
> 2005-12-08 11:14:17.37 spid3 PAG: 10:1:84715
> CleanCnt:4 Mode: SIX Flags: 0x2
> 0
> 2005-12-08 11:14:17.37 spid3 Grant List 0::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Owner:0x1d311a40 Mode: SIX
> Flg:0x0 Ref:1 Life:02000000 SPID:536 ECID:0
> 0
> 2005-12-08 11:14:17.37 spid3 SPID: 536 ECID: 0 Statement Type:
> SELECT Line #: 462
> 0
> 2005-12-08 11:14:17.37 spid3 Input Buf: RPC Event:
> ST_SP_UpdateFLCLAttrMeasureQ_Act;1
> 0
> 2005-12-08 11:14:17.37 spid3 Requested By:
>
> 0
> 2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
> S SPID:532 ECID:3 Ec0x5E2F60C0) Value:0x62879ec0 Cost0/0)
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:2
>
> 0
> 2005-12-08 11:14:17.37 spid3 Port: 0x42c30380 Xid Slot: 0, EC:
> 0x574ff578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
> 0
> 2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x574ff578, SPID:
> 536, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
> 0x574ff578, SPID: 536, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
> 0x20bf60c0, SPID: 536, ECID: 2, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
> 0x1f15e0c0, SPID: 536, ECID: 1, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:3
>
> 0
> 2005-12-08 11:14:17.37 spid3 PAG: 10:1:80523
> CleanCnt:3 Mode: IX Flags: 0x2
> 0
> 2005-12-08 11:14:17.37 spid3 Grant List 1::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Owner:0x1d364fa0 Mode: IX
> Flg:0x0 Ref:1 Life:02000000 SPID:538 ECID:0
> 0
> 2005-12-08 11:14:17.37 spid3 SPID: 538 ECID: 0 Statement Type:
> SELECT Line #: 384
> 0
> 2005-12-08 11:14:17.37 spid3 Input Buf: RPC Event:
> ST_SP_UpdateFLCLAttrMeasureQ_Act;1
> 0
> 2005-12-08 11:14:17.37 spid3 Requested By:
>
> 0
> 2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
> S SPID:536 ECID:2 Ec0x20BF60C0) Value:0x1d33b440 Cost0/EC)
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:4
>
> 0
> 2005-12-08 11:14:17.37 spid3 Port: 0x42c30200 Xid Slot: 0, EC:
> 0x20efb578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
> 0
> 2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x20efb578, SPID:
> 538, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
> 0x20efb578, SPID: 538, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
> 0x214c40c0, SPID: 538, ECID: 1, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
> 0x590260c0, SPID: 538, ECID: 2, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:5
>
> 0
> 2005-12-08 11:14:17.37 spid3 PAG: 10:1:84715
> CleanCnt:4 Mode: SIX Flags: 0x2
> 0
> 2005-12-08 11:14:17.37 spid3 Wait List:
>
> 0
> 2005-12-08 11:14:17.37 spid3 Owner:0x62879ec0 Mode: S
> Flg:0x0 Ref:1 Life:00000000 SPID:532 ECID:3
> 0
> 2005-12-08 11:14:17.37 spid3 SPID: 532 ECID: 3 Statement Type:
> SELECT Line #: 80
> 0
> 2005-12-08 11:14:17.37 spid3 Input Buf: RPC Event:
> ST_SP_GetFLCLAttrMeasureQ_Tar;1
> 0
> 2005-12-08 11:14:17.37 spid3 Requested By:
>
> 0
> 2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
> S SPID:538 ECID:1 Ec0x214C40C0) Value:0x1d2b70a0 Cost0/DC)
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 -- next branch --
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:4
>
> 0
> 2005-12-08 11:14:17.37 spid3 Port: 0x42c30200 Xid Slot: 0, EC:
> 0x20efb578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
> 0
> 2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x20efb578, SPID:
> 538, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
> 0x20efb578, SPID: 538, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
> 0x214c40c0, SPID: 538, ECID: 1, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
> 0x590260c0, SPID: 538, ECID: 2, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:8
>
> 0
> 2005-12-08 11:14:17.37 spid3 PAG: 10:1:84715
> CleanCnt:4 Mode: SIX Flags: 0x2
> 0
> 2005-12-08 11:14:17.37 spid3 Wait List:
>
> 0
> 2005-12-08 11:14:17.37 spid3 Owner:0x62879ec0 Mode: S
> Flg:0x0 Ref:1 Life:00000000 SPID:532 ECID:3
> 0
> 2005-12-08 11:14:17.37 spid3 Requested By:
>
> 0
> 2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
> S SPID:538 ECID:2 Ec0x590260C0) Value:0x1d3daa60 Cost0/DC)
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 -- next branch --
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:4
>
> 0
> 2005-12-08 11:14:17.37 spid3 Port: 0x42c30200 Xid Slot: 0, EC:
> 0x20efb578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
> 0
> 2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x20efb578, SPID:
> 538, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
> 0x20efb578, SPID: 538, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
> 0x214c40c0, SPID: 538, ECID: 1, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
> 0x590260c0, SPID: 538, ECID: 2, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 -- next branch --
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:2
>
> 0
> 2005-12-08 11:14:17.37 spid3 Port: 0x42c30380 Xid Slot: 0, EC:
> 0x574ff578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
> 0
> 2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x574ff578, SPID:
> 536, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
> 0x574ff578, SPID: 536, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
> 0x20bf60c0, SPID: 536, ECID: 2, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
> 0x1f15e0c0, SPID: 536, ECID: 1, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:12
>
> 0
> 2005-12-08 11:14:17.37 spid3 PAG: 10:1:80523
> CleanCnt:3 Mode: IX Flags: 0x2
> 0
> 2005-12-08 11:14:17.37 spid3 Wait List:
>
> 0
> 2005-12-08 11:14:17.37 spid3 Owner:0x1d33b440 Mode: S
> Flg:0x0 Ref:1 Life:00000000 SPID:536 ECID:2
> 0
> 2005-12-08 11:14:17.37 spid3 Requested By:
>
> 0
> 2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
> S SPID:536 ECID:1 Ec0x1F15E0C0) Value:0x5306c360 Cost0/EC)
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 -- next branch --
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:2
>
> 0
> 2005-12-08 11:14:17.37 spid3 Port: 0x42c30380 Xid Slot: 0, EC:
> 0x574ff578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
> 0
> 2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x574ff578, SPID:
> 536, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
> 0x574ff578, SPID: 536, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
> 0x20bf60c0, SPID: 536, ECID: 2, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
> 0x1f15e0c0, SPID: 536, ECID: 1, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Victim Resource Owner:
>
> 0
> 2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode: S
> SPID:532 ECID:3 Ec0x5E2F60C0) Value:0x62879ec0 Cost0/0)
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> Deadlock encountered ... Printing deadlock information
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Wait-for graph
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:1
>
> 0
> 2005-12-08 11:14:17.37 spid3 PAG: 10:1:80523
> CleanCnt:3 Mode: IX Flags: 0x2
> 0
> 2005-12-08 11:14:17.37 spid3 Grant List 1::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Owner:0x1d364fa0 Mode: IX
> Flg:0x0 Ref:1 Life:02000000 SPID:538 ECID:0
> 0
> 2005-12-08 11:14:17.37 spid3 SPID: 538 ECID: 0 Statement Type:
> SELECT Line #: 384
> 0
> 2005-12-08 11:14:17.37 spid3 Input Buf: RPC Event:
> ST_SP_UpdateFLCLAttrMeasureQ_Act;1
> 0
> 2005-12-08 11:14:17.37 spid3 Requested By:
>
> 0
> 2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
> S SPID:536 ECID:2 Ec0x20BF60C0) Value:0x1d33b440 Cost0/EC)
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:2
>
> 0
> 2005-12-08 11:14:17.37 spid3 Port: 0x42c30200 Xid Slot: 0, EC:
> 0x20efb578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
> 0
> 2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x20efb578, SPID:
> 538, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
> 0x20efb578, SPID: 538, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
> 0x214c40c0, SPID: 538, ECID: 1, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
> 0x590260c0, SPID: 538, ECID: 2, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:3
>
> 0
> 2005-12-08 11:14:17.37 spid3 PAG: 10:1:84715
> CleanCnt:4 Mode: SIX Flags: 0x3
> 0
> 2005-12-08 11:14:17.37 spid3 Grant List 0::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Requested By:
>
> 0
> 2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
> S SPID:538 ECID:1 Ec0x214C40C0) Value:0x1d2b70a0 Cost0/DC)
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:4
>
> 0
> 2005-12-08 11:14:17.37 spid3 PAG: 10:1:84715
> CleanCnt:4 Mode: SIX Flags: 0x3
> 0
> 2005-12-08 11:14:17.37 spid3 Grant List 0::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Owner:0x1d311a40 Mode: SIX
> Flg:0x0 Ref:1 Life:02000000 SPID:536 ECID:0
> 0
> 2005-12-08 11:14:17.37 spid3 SPID: 536 ECID: 0 Statement Type:
> SELECT Line #: 462
> 0
> 2005-12-08 11:14:17.37 spid3 Input Buf: RPC Event:
> ST_SP_UpdateFLCLAttrMeasureQ_Act;1
> 0
> 2005-12-08 11:14:17.37 spid3 Requested By:
>
> 0
> 2005-12-08 11:14:17.37 spid3 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:5
>
> 0
> 2005-12-08 11:14:17.37 spid3 Port: 0x42c30380 Xid Slot: 0, EC:
> 0x574ff578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
> 0
> 2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x574ff578, SPID:
> 536, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
> 0x574ff578, SPID: 536, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
> 0x20bf60c0, SPID: 536, ECID: 2, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
> 0x1f15e0c0, SPID: 536, ECID: 1, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 -- next branch --
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:5
>
> 0
> 2005-12-08 11:14:17.37 spid3 Port: 0x42c30380 Xid Slot: 0, EC:
> 0x574ff578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
> 0
> 2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x574ff578, SPID:
> 536, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
> 0x574ff578, SPID: 536, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
> 0x20bf60c0, SPID: 536, ECID: 2, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
> 0x1f15e0c0, SPID: 536, ECID: 1, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:8
>
> 0
> 2005-12-08 11:14:17.37 spid3 PAG: 10:1:80523
> CleanCnt:3 Mode: IX Flags: 0x2
> 0
> 2005-12-08 11:14:17.37 spid3 Wait List:
>
> 0
> 2005-12-08 11:14:17.37 spid3 Owner:0x1d33b440 Mode: S
> Flg:0x0 Ref:1 Life:00000000 SPID:536 ECID:2
> 0
> 2005-12-08 11:14:17.37 spid3 Requested By:
>
> 0
> 2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
> S SPID:536 ECID:1 Ec0x1F15E0C0) Value:0x5306c360 Cost0/EC)
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 -- next branch --
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:5
>
> 0
> 2005-12-08 11:14:17.37 spid3 Port: 0x42c30380 Xid Slot: 0, EC:
> 0x574ff578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
> 0
> 2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x574ff578, SPID:
> 536, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
> 0x574ff578, SPID: 536, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
> 0x20bf60c0, SPID: 536, ECID: 2, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
> 0x1f15e0c0, SPID: 536, ECID: 1, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 -- next branch --
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:2
>
> 0
> 2005-12-08 11:14:17.37 spid3 Port: 0x42c30200 Xid Slot: 0, EC:
> 0x20efb578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
> 0
> 2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x20efb578, SPID:
> 538, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
> 0x20efb578, SPID: 538, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
> 0x214c40c0, SPID: 538, ECID: 1, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
> 0x590260c0, SPID: 538, ECID: 2, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
>2005-12-08 11:14:17.37 spid3 Node:12
>
> 0
> 2005-12-08 11:14:17.37 spid3 PAG: 10:1:84715
> CleanCnt:4 Mode: SIX Flags: 0x3
> 0
> 2005-12-08 11:14:17.37 spid3 Grant List 0::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Requested By:
>
> 0
> 2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
> S SPID:538 ECID:2 Ec0x590260C0) Value:0x1d3daa60 Cost0/DC)
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 -- next branch --
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:2
>
> 0
> 2005-12-08 11:14:17.37 spid3 Port: 0x42c30200 Xid Slot: 0, EC:
> 0x20efb578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
> 0
> 2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x20efb578, SPID:
> 538, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
> 0x20efb578, SPID: 538, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
> 0x214c40c0, SPID: 538, ECID: 1, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
> 0x590260c0, SPID: 538, ECID: 2, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Victim Resource Owner:
>
> 0
> 2005-12-08 11:14:17.37 spid3 :2
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> Deadlock encountered ... Printing deadlock information
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Wait-for graph
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:1
>
> 0
> 2005-12-08 11:14:17.37 spid3 PAG: 10:1:80523
> CleanCnt:3 Mode: IX Flags: 0x2
> 0
> 2005-12-08 11:14:17.37 spid3 Wait List:
>
> 0
> 2005-12-08 11:14:17.37 spid3 Owner:0x1d33b440 Mode: S
> Flg:0x0 Ref:1 Life:00000000 SPID:536 ECID:2
> 0
> 2005-12-08 11:14:17.37 spid3 SPID: 536 ECID: 2 Statement Type:
> SELECT Line #: 462
> 0
> 2005-12-08 11:14:17.37 spid3 Input Buf: RPC Event:
> ST_SP_UpdateFLCLAttrMeasureQ_Act;1
> 0
> 2005-12-08 11:14:17.37 spid3 Requested By:
>
> 0
> 2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
> S SPID:536 ECID:1 Ec0x1F15E0C0) Value:0x5306c360 Cost0/EC)
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:2
>
> 0
> 2005-12-08 11:14:17.37 spid3 PAG: 10:1:80523
> CleanCnt:3 Mode: IX Flags: 0x2
> 0
> 2005-12-08 11:14:17.37 spid3 Grant List 1::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Owner:0x1d364fa0 Mode: IX
> Flg:0x0 Ref:1 Life:02000000 SPID:538 ECID:0
> 0
> 2005-12-08 11:14:17.37 spid3 SPID: 538 ECID: 0 Statement Type:
> SELECT Line #: 384
> 0
> 2005-12-08 11:14:17.37 spid3 Input Buf: RPC Event:
> ST_SP_UpdateFLCLAttrMeasureQ_Act;1
> 0
> 2005-12-08 11:14:17.37 spid3 Requested By:
>
> 0
> 2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
> S SPID:536 ECID:2 Ec0x20BF60C0) Value:0x1d33b440 Cost0/EC)
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Port: 0x42c30200 Xid Slot: 0, EC:
> 0x20efb578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
> 0
> 2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x20efb578, SPID:
> 538, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
> 0x20efb578, SPID: 538, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
> 0x214c40c0, SPID: 538, ECID: 1, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
> 0x590260c0, SPID: 538, ECID: 2, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:4
>
> 0
> 2005-12-08 11:14:17.37 spid3 PAG: 10:1:84715
> CleanCnt:3 Mode: SIX Flags: 0x2
> 0
> 2005-12-08 11:14:17.37 spid3 Grant List 0::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Owner:0x1d311a40 Mode: SIX
> Flg:0x0 Ref:1 Life:02000000 SPID:536 ECID:0
> 0
> 2005-12-08 11:14:17.37 spid3 Requested By:
>
> 0
> 2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
> S SPID:538 ECID:1 Ec0x214C40C0) Value:0x1d2b70a0 Cost0/DC)
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:5
>
> 0
> 2005-12-08 11:14:17.37 spid3 Port: 0x42c30380 Xid Slot: 0, EC:
> 0x574ff578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
> 0
> 2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x574ff578, SPID:
> 536, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
> 0x574ff578, SPID: 536, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
> 0x20bf60c0, SPID: 536, ECID: 2, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
> 0x1f15e0c0, SPID: 536, ECID: 1, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 -- next branch --
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:5
>
> 0
> 2005-12-08 11:14:17.37 spid3 Port: 0x42c30380 Xid Slot: 0, EC:
> 0x574ff578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
> 0
> 2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x574ff578, SPID:
> 536, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
> 0x574ff578, SPID: 536, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
> 0x20bf60c0, SPID: 536, ECID: 2, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
> 0x1f15e0c0, SPID: 536, ECID: 1, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 -- next branch --
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:5
>
> 0
> 2005-12-08 11:14:17.37 spid3 Port: 0x42c30380 Xid Slot: 0, EC:
> 0x574ff578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
> 0
> 2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x574ff578, SPID:
> 536, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
> 0x574ff578, SPID: 536, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
> 0x20bf60c0, SPID: 536, ECID: 2, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
> 0x1f15e0c0, SPID: 536, ECID: 1, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 -- next branch --
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Port: 0x42c30200 Xid Slot: 0, EC:
> 0x20efb578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
> 0
> 2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x20efb578, SPID:
> 538, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
> 0x20efb578, SPID: 538, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
> 0x214c40c0, SPID: 538, ECID: 1, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
> 0x590260c0, SPID: 538, ECID: 2, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:11
>
> 0
> 2005-12-08 11:14:17.37 spid3 PAG: 10:1:84715
> CleanCnt:3 Mode: SIX Flags: 0x2
> 0
> 2005-12-08 11:14:17.37 spid3 Wait List:
>
> 0
> 2005-12-08 11:14:17.37 spid3 Owner:0x1d2b70a0 Mode: S
> Flg:0x0 Ref:1 Life:00000000 SPID:538 ECID:1
> 0
> 2005-12-08 11:14:17.37 spid3 Requested By:
>
> 0
> 2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode:
> S SPID:538 ECID:2 Ec0x590260C0) Value:0x1d3daa60 Cost0/DC)
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 -- next branch --
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Node:3
>
> 0
> 2005-12-08 11:14:17.37 spid3 Port: 0x42c30200 Xid Slot: 0, EC:
> 0x20efb578, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
> 0
> 2005-12-08 11:14:17.37 spid3 Coordinator: EC = 0x20efb578, SPID:
> 538, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Consumer: Xid Slot: 0, EC =
> 0x20efb578, SPID: 538, ECID: 0, Not Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer List::
>
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 1, EC =
> 0x214c40c0, SPID: 538, ECID: 1, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Producer: Xid Slot: 2, EC =
> 0x590260c0, SPID: 538, ECID: 2, Blocking
> 0
> 2005-12-08 11:14:17.37 spid3 Victim Resource Owner:
>
> 0
> 2005-12-08 11:14:17.37 spid3 ResType:LockOwner Stype:'OR' Mode: S
> SPID:538 ECID:1 Ec0x214C40C0) Value:0x1d2b70a0 Cost0/DC)
> 0
> 2005-12-08 11:32:39.76 spid3
>
> 0
> Deadlock encountered ... Printing deadlock information
>
> 0
> 2005-12-08 11:32:39.76 spid3
>
> 0
> 2005-12-08 11:32:39.76 spid3 Wait-for graph
>
> 0
> 2005-12-08 11:32:39.76 spid3
>
> 0
> 2005-12-08 11:32:39.76 spid3 Node:1
>
> 0
> 2005-12-08 11:32:39.76 spid3 PAG: 10:1:85048
> CleanCnt:2 Mode: SIU Flags: 0x2
> 0
> 2005-12-08 11:32:39.76 spid3 Grant List 1::
>
> 0
> 2005-12-08 11:32:39.76 spid3 Owner:0x1d3db960 Mode: S
> Flg:0x0 Ref:1 Life:00000000 SPID:538 ECID:2
> 0
> 2005-12-08 11:32:39.76 spid3 SPID: 538 ECID: 2 Statement Type:
> CONDITIONAL Line #: 392
> 0
> 2005-12-08 11:32:39.76 spid3 Input Buf: RPC Event:
> ST_SP_UpdateFLCLAttrMeasureQ_Act;1
> 0
> 2005-12-08 11:32:39.76 spid3 Requested By:
>
> 0
> 2005-12-08 11:32:39.76 spid3 ResType:LockOwner Stype:'OR' Mode:
> IX SPID:537 ECID:0 Ec0x69591578) Value:0x1d371720 Cost0/394)
> 0
> 2005-12-08 11:32:39.76 spid3
>
> 0
> 2005-12-08 11:32:39.76 spid3 Node:2
>
> 0
> 2005-12-08 11:32:39.76 spid3 PAG: 10:1:85049
> CleanCnt:2 Mode: SIX Flags: 0x2
> 0
> 2005-12-08 11:32:39.76 spid3 Grant List 1::
>
> 0
> 2005-12-08 11:32:39.76 spid3 Owner:0x42c28c20 Mode: IX
> Flg:0x0 Ref:3 Life:02000000 SPID:537 ECID:0
> 0
> 2005-12-08 11:32:39.76 spid3 SPID: 537 ECID: 0 Statement Type:
> UPDATE Line #: 416
> 0
> 2005-12-08 11:32:39.76 spid3 Input Buf: RPC Event:
> ST_SP_UpdateFLCLAttrMeasureQ_Tar;1
> 0
> 2005-12-08 11:32:39.76 spid3 Requested By:
>
> 0
> 2005-12-08 11:32:39.76 spid3 ResType:LockOwner Stype:'OR' Mode:
> S SPID:538 ECID:2 Ec0x76D740C0) Value:0x5316ff60 Cost0/0)
> 0
> 2005-12-08 11:32:39.76 spid3 Victim Resource Owner:
>
> 0
> 2005-12-08 11:32:39.76 spid3 ResType:LockOwner Stype:'OR' Mode: S
> SPID:538 ECID:2 Ec0x76D740C0) Value:0x5316ff60 Cost0/0)
> 0
> 2005-12-08 12:49:22.28 spid3
>
> Karan
>