Deadlock info: How to intepret ?

Trying to do a shrinkfile and it always seems to deadlock. Can someone help
me intepret this and maybe suggest a way on how i can get the shrinkfile to
succeed?
Deadlock encountered ... Printing deadlock information
2003-09-09 16:37:34.10 spid4
2003-09-09 16:37:34.10 spid4 Wait-for graph
2003-09-09 16:37:34.10 spid4
2003-09-09 16:37:34.10 spid4 Node:1
2003-09-09 16:37:34.10 spid4 TAB: 9:1993058136 [] CleanCnt:1
Mode: IX Flags: 0x0
2003-09-09 16:37:34.10 spid4 Grant List::
2003-09-09 16:37:34.10 spid4 Owner:0x56c315e0 Mode: IS Flg:0x0
Ref:1 Life:00000000 SPID:87 ECID:0
2003-09-09 16:37:34.10 spid4 SPID: 87 ECID: 0 Statement Type: EXECUTE
Line #: 1
2003-09-09 16:37:34.10 spid4 Input Buf: RPC Event: sp_cursoropen;1
2003-09-09 16:37:34.10 spid4 Requested By:
2003-09-09 16:37:34.10 spid4 ResType:LockOwner Stype:'OR' Mode: X
SPID:81 ECID:0 Ec:(0x1a1c1530) Value:0x5bbdf800 Cost:(1/0)
2003-09-09 16:37:34.10 spid4
2003-09-09 16:37:34.10 spid4 Node:2
2003-09-09 16:37:34.10 spid4 PAG: 9:1:2875975 CleanCnt:1
Mode: X Flags: 0x0
2003-09-09 16:37:34.10 spid4 Grant List::
2003-09-09 16:37:34.10 spid4 Owner:0x59e235e0 Mode: X Flg:0x0
Ref:1 Life:00000000 SPID:81 ECID:0
2003-09-09 16:37:34.10 spid4 SPID: 81 ECID: 0 Statement Type: BACKUP
LOG Line #: 1
2003-09-09 16:37:34.10 spid4 Input Buf: Language Event: dbcc
shrinkfile(Northwind_Data ,20000)
2003-09-09 16:37:34.10 spid4 Requested By:
2003-09-09 16:37:34.10 spid4 ResType:LockOwner Stype:'OR' Mode: IS
SPID:87 ECID:0 Ec:(0x4b189558) Value:0x56c31a40 Cost:(0/0)
2003-09-09 16:37:34.10 spid4 Victim Resource Owner:
2003-09-09 16:37:34.10 spid4 ResType:LockOwner Stype:'OR' Mode: X
SPID:81 ECID:0 Ec:(0x1a1c1530) Value:0x5bbdf800 Cost:(1/0)I shrink file every night, it has three steps;
1 Set databasae into simple recovery mode
2 Shrink log
3 Set database into full recovery mode
alter database proclaim set recovery simple
dbcc shrinkfile (trainingproclaimlog,1000)
alter database proclaim set recovery full
I hope it helps
>--Original Message--
>Trying to do a shrinkfile and it always seems to
deadlock. Can someone help
>me intepret this and maybe suggest a way on how i can get
the shrinkfile to
>succeed?
>Deadlock encountered ... Printing deadlock information
>2003-09-09 16:37:34.10 spid4
>2003-09-09 16:37:34.10 spid4 Wait-for graph
>2003-09-09 16:37:34.10 spid4
>2003-09-09 16:37:34.10 spid4 Node:1
>2003-09-09 16:37:34.10 spid4 TAB: 9:1993058136
[] CleanCnt:1
>Mode: IX Flags: 0x0
>2003-09-09 16:37:34.10 spid4 Grant List::
>2003-09-09 16:37:34.10 spid4 Owner:0x56c315e0
Mode: IS Flg:0x0
>Ref:1 Life:00000000 SPID:87 ECID:0
>2003-09-09 16:37:34.10 spid4 SPID: 87 ECID: 0
Statement Type: EXECUTE
>Line #: 1
>2003-09-09 16:37:34.10 spid4 Input Buf: RPC Event:
sp_cursoropen;1
>2003-09-09 16:37:34.10 spid4 Requested By:
>2003-09-09 16:37:34.10 spid4 ResType:LockOwner
Stype:'OR' Mode: X
>SPID:81 ECID:0 Ec:(0x1a1c1530) Value:0x5bbdf800 Cost:(1/0)
>2003-09-09 16:37:34.10 spid4
>2003-09-09 16:37:34.10 spid4 Node:2
>2003-09-09 16:37:34.10 spid4 PAG:
9:1:2875975 CleanCnt:1
>Mode: X Flags: 0x0
>2003-09-09 16:37:34.10 spid4 Grant List::
>2003-09-09 16:37:34.10 spid4 Owner:0x59e235e0
Mode: X Flg:0x0
>Ref:1 Life:00000000 SPID:81 ECID:0
>2003-09-09 16:37:34.10 spid4 SPID: 81 ECID: 0
Statement Type: BACKUP
>LOG Line #: 1
>2003-09-09 16:37:34.10 spid4 Input Buf: Language
Event: dbcc
>shrinkfile(Northwind_Data ,20000)
>2003-09-09 16:37:34.10 spid4 Requested By:
>2003-09-09 16:37:34.10 spid4 ResType:LockOwner
Stype:'OR' Mode: IS
>SPID:87 ECID:0 Ec:(0x4b189558) Value:0x56c31a40 Cost:(0/0)
>2003-09-09 16:37:34.10 spid4 Victim Resource Owner:
>2003-09-09 16:37:34.10 spid4 ResType:LockOwner
Stype:'OR' Mode: X
>SPID:81 ECID:0 Ec:(0x1a1c1530) Value:0x5bbdf800 Cost:(1/0)
>
>.
>|||Amar,
Why do you shrink the files everynight? If you have to keep shrinking it
then that means it wasn't big enough to begin with. I suggest you leave it
at that size so it doesn't have to keep growing and shrinking.
--
Andrew J. Kelly
SQL Server MVP
"Amar" <amar.pabla@.wanneroo.gov.au> wrote in message
news:036f01c3773f$3ecd1ae0$a601280a@.phx.gbl...
> I shrink file every night, it has three steps;
> 1 Set databasae into simple recovery mode
> 2 Shrink log
> 3 Set database into full recovery mode
> alter database proclaim set recovery simple
> dbcc shrinkfile (trainingproclaimlog,1000)
> alter database proclaim set recovery full
> I hope it helps
> >--Original Message--
> >Trying to do a shrinkfile and it always seems to
> deadlock. Can someone help
> >me intepret this and maybe suggest a way on how i can get
> the shrinkfile to
> >succeed?
> >
> >Deadlock encountered ... Printing deadlock information
> >2003-09-09 16:37:34.10 spid4
> >2003-09-09 16:37:34.10 spid4 Wait-for graph
> >2003-09-09 16:37:34.10 spid4
> >2003-09-09 16:37:34.10 spid4 Node:1
> >2003-09-09 16:37:34.10 spid4 TAB: 9:1993058136
> [] CleanCnt:1
> >Mode: IX Flags: 0x0
> >2003-09-09 16:37:34.10 spid4 Grant List::
> >2003-09-09 16:37:34.10 spid4 Owner:0x56c315e0
> Mode: IS Flg:0x0
> >Ref:1 Life:00000000 SPID:87 ECID:0
> >2003-09-09 16:37:34.10 spid4 SPID: 87 ECID: 0
> Statement Type: EXECUTE
> >Line #: 1
> >2003-09-09 16:37:34.10 spid4 Input Buf: RPC Event:
> sp_cursoropen;1
> >2003-09-09 16:37:34.10 spid4 Requested By:
> >2003-09-09 16:37:34.10 spid4 ResType:LockOwner
> Stype:'OR' Mode: X
> >SPID:81 ECID:0 Ec:(0x1a1c1530) Value:0x5bbdf800 Cost:(1/0)
> >2003-09-09 16:37:34.10 spid4
> >2003-09-09 16:37:34.10 spid4 Node:2
> >2003-09-09 16:37:34.10 spid4 PAG:
> 9:1:2875975 CleanCnt:1
> >Mode: X Flags: 0x0
> >2003-09-09 16:37:34.10 spid4 Grant List::
> >2003-09-09 16:37:34.10 spid4 Owner:0x59e235e0
> Mode: X Flg:0x0
> >Ref:1 Life:00000000 SPID:81 ECID:0
> >2003-09-09 16:37:34.10 spid4 SPID: 81 ECID: 0
> Statement Type: BACKUP
> >LOG Line #: 1
> >2003-09-09 16:37:34.10 spid4 Input Buf: Language
> Event: dbcc
> >shrinkfile(Northwind_Data ,20000)
> >
> >2003-09-09 16:37:34.10 spid4 Requested By:
> >2003-09-09 16:37:34.10 spid4 ResType:LockOwner
> Stype:'OR' Mode: IS
> >SPID:87 ECID:0 Ec:(0x4b189558) Value:0x56c31a40 Cost:(0/0)
> >2003-09-09 16:37:34.10 spid4 Victim Resource Owner:
> >2003-09-09 16:37:34.10 spid4 ResType:LockOwner
> Stype:'OR' Mode: X
> >SPID:81 ECID:0 Ec:(0x1a1c1530) Value:0x5bbdf800 Cost:(1/0)
> >
> >
> >.
> >|||In addition to turning off backup jobs (thanks for the tip, Andrew), you
might want to see what else is going on (any other scheduled jobs?) while
the shrinkfile is trying to execute. I noticed spid87 and spid81 in the log.
which came to life before your statement was actually executed. As Andrew
pointed out, the backup might be running while you're trying to shrink the
file.
HTH,
-Morgan
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:e7IHeR0dDHA.1752@.TK2MSFTNGP11.phx.gbl...
> Make sure you turn off your backup jobs while this is shrinking.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:OyJEy%23ydDHA.3428@.tk2msftngp13.phx.gbl...
> > Trying to do a shrinkfile and it always seems to deadlock. Can someone
> help
> > me intepret this and maybe suggest a way on how i can get the shrinkfile
> to
> > succeed?
> >
> > Deadlock encountered ... Printing deadlock information
> > 2003-09-09 16:37:34.10 spid4
> > 2003-09-09 16:37:34.10 spid4 Wait-for graph
> > 2003-09-09 16:37:34.10 spid4
> > 2003-09-09 16:37:34.10 spid4 Node:1
> > 2003-09-09 16:37:34.10 spid4 TAB: 9:1993058136 []
CleanCnt:1
> > Mode: IX Flags: 0x0
> > 2003-09-09 16:37:34.10 spid4 Grant List::
> > 2003-09-09 16:37:34.10 spid4 Owner:0x56c315e0 Mode: IS
> Flg:0x0
> > Ref:1 Life:00000000 SPID:87 ECID:0
> > 2003-09-09 16:37:34.10 spid4 SPID: 87 ECID: 0 Statement Type:
> EXECUTE
> > Line #: 1
> > 2003-09-09 16:37:34.10 spid4 Input Buf: RPC Event:
sp_cursoropen;1
> > 2003-09-09 16:37:34.10 spid4 Requested By:
> > 2003-09-09 16:37:34.10 spid4 ResType:LockOwner Stype:'OR' Mode: X
> > SPID:81 ECID:0 Ec:(0x1a1c1530) Value:0x5bbdf800 Cost:(1/0)
> > 2003-09-09 16:37:34.10 spid4
> > 2003-09-09 16:37:34.10 spid4 Node:2
> > 2003-09-09 16:37:34.10 spid4 PAG: 9:1:2875975
CleanCnt:1
> > Mode: X Flags: 0x0
> > 2003-09-09 16:37:34.10 spid4 Grant List::
> > 2003-09-09 16:37:34.10 spid4 Owner:0x59e235e0 Mode: X
> Flg:0x0
> > Ref:1 Life:00000000 SPID:81 ECID:0
> > 2003-09-09 16:37:34.10 spid4 SPID: 81 ECID: 0 Statement Type:
> BACKUP
> > LOG Line #: 1
> > 2003-09-09 16:37:34.10 spid4 Input Buf: Language Event: dbcc
> > shrinkfile(Northwind_Data ,20000)
> >
> > 2003-09-09 16:37:34.10 spid4 Requested By:
> > 2003-09-09 16:37:34.10 spid4 ResType:LockOwner Stype:'OR' Mode:
IS
> > SPID:87 ECID:0 Ec:(0x4b189558) Value:0x56c31a40 Cost:(0/0)
> > 2003-09-09 16:37:34.10 spid4 Victim Resource Owner:
> > 2003-09-09 16:37:34.10 spid4 ResType:LockOwner Stype:'OR' Mode: X
> > SPID:81 ECID:0 Ec:(0x1a1c1530) Value:0x5bbdf800 Cost:(1/0)
> >
> >
>

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
>