dbTalk Databases Forums  

TRACE 3604 on errorlog sqlserver 2000

microsoft.public.sqlserver.server microsoft.public.sqlserver.server


Discuss TRACE 3604 on errorlog sqlserver 2000 in the microsoft.public.sqlserver.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
freewarefw
 
Posts: n/a

Default TRACE 3604 on errorlog sqlserver 2000 - 10-17-2003 , 03:38 AM






I need help regarding a deadlock. I setup in sql2000 a
trace (-T3604 -T1204 -T1205).
I have something in the errorlog in sql.
Could someone give me explanation regarding my example or
where can I find explanation regarding how read this
trace ?

short example of a deadlock trace :
Deadlock encountered .... Printing deadlock information
2003-10-07 15:07:38.94 spid2
2003-10-07 15:07:38.94 spid2 Wait-for graph
2003-10-07 15:07:38.94 spid2
2003-10-07 15:07:38.94 spid2 Node:1
2003-10-07 15:07:38.94 spid2 Port: 0x42be8300 Xid Slot: 0,
EC: 0x27bd39a0, ECID: 0 (Coordinator), Exchange Wait
Type :e_etypeCXPacket
2003-10-07 15:07:38.94 spid2 SPID: 131 ECID: 0 Statement
Type: UPDATE Line #: 186
2003-10-07 15:07:38.94 spid2 Input Buf: Language Event:
INSERT INTO lfdeals ( lfd_code, lfd_number, lfd_seq,
lfd_orderid, lfd_orderseq, lfd_frontofficeid, lfd_status,
lfd_iuser, lfd_idate, lfd_vuser, lfd_vdate, lfd_customer,
lfd_pfolio, lfd_acttype, lfd_transcode, lfd_ccy,
lfd_ccyrate, lfd_1set_method, lfd_1an
2003-10-07 15:07:38.94 spid2 Coordinator: EC = 0x27bd39a0,
SPID: 131, ECID: 0, Not Blocking
2003-10-07 15:07:38.94 spid2 Consumer List::
2003-10-07 15:07:38.94 spid2 Consumer: Xid Slot: 0, EC =
0x27bd39a0, SPID: 131, ECID: 0, Not Blocking
2003-10-07 15:07:38.94 spid2 Producer List::
2003-10-07 15:07:38.94 spid2 Producer: Xid Slot: 1, EC =
0x2a426098, SPID: 131, ECID: 2, Blocking
2003-10-07 15:07:38.94 spid2 Producer: Xid Slot: 2, EC =
0x3a9f2098, SPID: 131, ECID: 1, Blocking
2003-10-07 15:07:38.94 spid2
2003-10-07 15:07:38.94 spid2 Node:2
2003-10-07 15:07:38.94 spid2 PAG: 6:1:56182 CleanCnt:3
Mode: IX Flags: 0x0
2003-10-07 15:07:38.94 spid2 Wait List:
2003-10-07 15:07:38.94 spid2 Owner:0x55332e60 Mode: S
Flg:0x0 Ref:1 Life:00000001 SPID:57 ECID:1
2003-10-07 15:07:38.94 spid2 SPID: 57 ECID: 1 Statement
Type: UPDATE Line #: 208
2003-10-07 15:07:38.94 spid2 Input Buf: Language Event:
INSERT INTO lfdeals ( lfd_code, lfd_number, lfd_seq,
lfd_orderid, lfd_orderseq, lfd_frontofficeid, lfd_status,
lfd_iuser, lfd_idate, lfd_vuser, lfd_vdate, lfd_customer,
lfd_pfolio, lfd_acttype, lfd_transcode, lfd_ccy,
lfd_ccyrate, lfd_1set_method, lfd_1an
2003-10-07 15:07:38.94 spid2 Requested By:
2003-10-07 15:07:38.94 spid2 ResType:LockOwner Stype:'OR'
Mode: S SPID:131 ECID:2 Ec0x2A426098) Value:0x55408680
Cost0/4AC)
2003-10-07 15:07:38.94 spid2
2003-10-07 15:07:38.94 spid2 Node:3
2003-10-07 15:07:38.94 spid2 PAG: 6:1:56182 CleanCnt:3
Mode: IX Flags: 0x0
2003-10-07 15:07:38.94 spid2 Grant List 0::
2003-10-07 15:07:38.94 spid2 Grant List 1::
2003-10-07 15:07:38.94 spid2 Owner:0x553b52e0 Mode: IX
Flg:0x0 Ref:0 Life:02000000 SPID:131 ECID:0
2003-10-07 15:07:38.94 spid2 Requested By:
2003-10-07 15:07:38.94 spid2 ResType:LockOwner Stype:'OR'
Mode: S SPID:57 ECID:1 Ec0x3AF90098) Value:0x55332e60
Cost0/45C)
2003-10-07 15:07:38.94 spid2
2003-10-07 15:07:38.95 spid2 -- next branch --
2003-10-07 15:07:38.95 spid2
2003-10-07 15:07:38.95 spid2
2003-10-07 15:07:38.95 spid2 Node:1
2003-10-07 15:07:38.95 spid2 Port: 0x42be8300 Xid Slot: 0,
EC: 0x27bd39a0, ECID: 0 (Coordinator), Exchange Wait
Type :e_etypeCXPacket
2003-10-07 15:07:38.95 spid2 Coordinator: EC = 0x27bd39a0,
SPID: 131, ECID: 0, Not Blocking
2003-10-07 15:07:38.95 spid2 Consumer List::
2003-10-07 15:07:38.95 spid2 Consumer: Xid Slot: 0, EC =
0x27bd39a0, SPID: 131, ECID: 0, Not Blocking
2003-10-07 15:07:38.95 spid2 Producer List::
2003-10-07 15:07:38.95 spid2 Producer: Xid Slot: 1, EC =
0x2a426098, SPID: 131, ECID: 2, Blocking
2003-10-07 15:07:38.95 spid2 Producer: Xid Slot: 2, EC =
0x3a9f2098, SPID: 131, ECID: 1, Blocking
2003-10-07 15:07:38.95 spid2
2003-10-07 15:07:38.95 spid2 Node:6
2003-10-07 15:07:38.95 spid2 PAG: 6:1:56182 CleanCnt:3
Mode: IX Flags: 0x0
2003-10-07 15:07:38.95 spid2 Wait List:
2003-10-07 15:07:38.95 spid2 Owner:0x55332e60 Mode: S
Flg:0x0 Ref:1 Life:00000001 SPID:57 ECID:1
2003-10-07 15:07:38.95 spid2 Requested By:
2003-10-07 15:07:38.95 spid2 ResType:LockOwner Stype:'OR'
Mode: S SPID:131 ECID:1 Ec0x3A9F2098) Value:0x5536a500
Cost0/4AC)
2003-10-07 15:07:38.95 spid2
2003-10-07 15:07:38.95 spid2 -- next branch --

Thanks you in advance



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.