Deadlocks

Can anyone help me with my questions about the following deadlock.
Deadlock encountered ... Printing deadlock information
2006-08-14 15:45:55.04 spid4
2006-08-14 15:45:55.04 spid4 Wait-for graph
2006-08-14 15:45:55.04 spid4
2006-08-14 15:45:55.04 spid4 Node:1
2006-08-14 15:45:55.04 spid4 KEY: 9:363864363:1 (2002aa6e06a0)
CleanCnt:1 Mode: X Flags: 0x0
2006-08-14 15:45:55.04 spid4 Grant List 1::
2006-08-14 15:45:55.04 spid4 Owner:0x3f81b5c0 Mode: X Flg:0x0
Ref:0 Life:02000000 SPID:60 ECID:0
2006-08-14 15:45:55.04 spid4 SPID: 60 ECID: 0 Statement Type: SELECT
Line #: 40
2006-08-14 15:45:55.04 spid4 Input Buf: RPC Event: spManagePVOrder;1
2006-08-14 15:45:55.04 spid4 Requested By:
2006-08-14 15:45:55.04 spid4 ResType:LockOwner Stype:'OR' Mode: U
SPID:59 ECID:0 Ec0x3B241530) Value:0x77a971a0 Cost0/0)
2006-08-14 15:45:55.04 spid4
2006-08-14 15:45:55.04 spid4 Node:2
2006-08-14 15:45:55.04 spid4 PAG: 12:1:144496 CleanCnt:1
Mode: SIX Flags: 0x0
2006-08-14 15:45:55.04 spid4 Grant List 1::
2006-08-14 15:45:55.04 spid4 Owner:0x3f81bce0 Mode: SIX Flg:0x0
Ref:0 Life:02000000 SPID:59 ECID:0
2006-08-14 15:45:55.04 spid4 SPID: 59 ECID: 0 Statement Type: DELETE
Line #: 136
2006-08-14 15:45:55.04 spid4 Input Buf: RPC Event: sp_executesql;1
2006-08-14 15:45:55.04 spid4 Requested By:
2006-08-14 15:45:55.04 spid4 ResType:LockOwner Stype:'OR' Mode: S
SPID:60 ECID:0 Ec0x6D8454E8) Value:0x77a97a00 Cost0/0)
2006-08-14 15:45:55.04 spid4 Victim Resource Owner:
2006-08-14 15:45:55.04 spid4 ResType:LockOwner Stype:'OR' Mode: S
SPID:60 ECID:0 Ec0x6D8454E8) Value:0x77a97a00 Cost0/0)
I know what this means Node 1 was blocked by Process 60, and requested by
process 59, and Node 1 was blocked by Process 59, but requested by process
60 (which created the deadlock). The victim was process 60.
But I need some help for the following:
1.- How can I know what is Node 2 (PAG: 12:1:144496 ) I have tried DBCC PAGE
(12,14496,3) but all I got is "DBCC execution completed. If DBCC printed
error messages, contact your system administrator."
2.- How can I know what application called sp_executesql in process 60 ?..
3.- How can I fix the problem, since probably I only have control over
sp_managePVorders ?.
Regards,
Pablo.Silva@.Aspentech.com
Inline ...
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Pablo Silva" <PabloSilva@.discussions.microsoft.com> wrote in message
news:F92D8349-F9CF-4A5F-AE4B-73BA48F2C881@.microsoft.com...
> Can anyone help me with my questions about the following deadlock.
>
> Deadlock encountered ... Printing deadlock information
> 2006-08-14 15:45:55.04 spid4
> 2006-08-14 15:45:55.04 spid4 Wait-for graph
> 2006-08-14 15:45:55.04 spid4
> 2006-08-14 15:45:55.04 spid4 Node:1
> 2006-08-14 15:45:55.04 spid4 KEY: 9:363864363:1 (2002aa6e06a0)
> CleanCnt:1 Mode: X Flags: 0x0
> 2006-08-14 15:45:55.04 spid4 Grant List 1::
> 2006-08-14 15:45:55.04 spid4 Owner:0x3f81b5c0 Mode: X
> Flg:0x0
> Ref:0 Life:02000000 SPID:60 ECID:0
> 2006-08-14 15:45:55.04 spid4 SPID: 60 ECID: 0 Statement Type:
> SELECT
> Line #: 40
> 2006-08-14 15:45:55.04 spid4 Input Buf: RPC Event:
> spManagePVOrder;1
> 2006-08-14 15:45:55.04 spid4 Requested By:
> 2006-08-14 15:45:55.04 spid4 ResType:LockOwner Stype:'OR' Mode: U
> SPID:59 ECID:0 Ec0x3B241530) Value:0x77a971a0 Cost0/0)
> 2006-08-14 15:45:55.04 spid4
> 2006-08-14 15:45:55.04 spid4 Node:2
> 2006-08-14 15:45:55.04 spid4 PAG: 12:1:144496 CleanCnt:1
> Mode: SIX Flags: 0x0
> 2006-08-14 15:45:55.04 spid4 Grant List 1::
> 2006-08-14 15:45:55.04 spid4 Owner:0x3f81bce0 Mode: SIX
> Flg:0x0
> Ref:0 Life:02000000 SPID:59 ECID:0
> 2006-08-14 15:45:55.04 spid4 SPID: 59 ECID: 0 Statement Type:
> DELETE
> Line #: 136
> 2006-08-14 15:45:55.04 spid4 Input Buf: RPC Event: sp_executesql;1
> 2006-08-14 15:45:55.04 spid4 Requested By:
> 2006-08-14 15:45:55.04 spid4 ResType:LockOwner Stype:'OR' Mode: S
> SPID:60 ECID:0 Ec0x6D8454E8) Value:0x77a97a00 Cost0/0)
> 2006-08-14 15:45:55.04 spid4 Victim Resource Owner:
> 2006-08-14 15:45:55.04 spid4 ResType:LockOwner Stype:'OR' Mode: S
> SPID:60 ECID:0 Ec0x6D8454E8) Value:0x77a97a00 Cost0/0)
> I know what this means Node 1 was blocked by Process 60, and requested by
> process 59, and Node 1 was blocked by Process 59, but requested by
> process
> 60 (which created the deadlock). The victim was process 60.
Node 1 was granted to Process 60 and requested by process 59
Node 2 was granted to Process 59 and requested by process 60
> But I need some help for the following:
> 1.- How can I know what is Node 2 (PAG: 12:1:144496 ) I have tried DBCC
> PAGE
> (12,14496,3) but all I got is "DBCC execution completed. If DBCC printed
> error messages, contact your system administrator."
You have to turn on trace flag 3604 to get results from DBCC PAGE:
DBCC TRACEON (3604)
DBCC PAGE (12,14496,3)

> 2.- How can I know what application called sp_executesql in process 60 ?..
The trace does not contain this information. If you are running a trace when
the deadlock occurs, that is the best way to get the info.

> 3.- How can I fix the problem, since probably I only have control over
> sp_managePVorders ?.
Did this just happen once? If so, it is not a problem as long as your
application detects it and resubmits the query. If it happens often, you can
start a trace to capture deadlock, deadlock chains, batches, stored
procedures statements, which will give you more details as to the exact
series of events that led to the deadlock.

> Regards,
> Pablo.Silva@.Aspentech.com
sql

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
Karan
Pls 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.googlegro ups.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
>