----------enqueue 0x0x15c7e4f50------------------------ lock version : 108947 Owner node : 0 grant_level : KJUSERNL req_level : KJUSEREX bast_level : KJUSERNL notify_func : (nil) resp : 0xcd735138 procp : 0x15dc874e0 pid : 25201 proc version : 314 oprocp : (nil) opid : 0 group lock owner : 0x15d3a7890 possible pid : 25201 xid : 26000-0001-000004A0 dd_time : -20.0 secs dd_count : 0 timeout : 0.0 secs On_timer_q? : N On_dd_q? : Y lock_state : OPENING CONVERTING Open Options : KJUSERDEADLOCK Convert options : KJUSERGETVALUE History : 0x1495149a Msg_Seq : 0x0 res_seq : 599 valblk : 0x00000000000000000000000000000000 . DUMP LOCAL BLOCKER: initiate state dump for DEADLOCK possible owner[38.25201] Submitting asynchronized dump request [28] Global blockers dump end:----------------------------------- Global Wait-For-Graph(WFG) at ddTS[0.353] : BLOCKED 0x15c7e4e00 5 [0x420002][0x38c3c],[TX] [1C000-0001-0000025E] 0 BLOCKER 0x15c7e38d0 5 [0x420002][0x38c3c],[TX] [29000-0001-00000498] 0 BLOCKED 0x15c7e38d0 5 [0x420002][0x38c3c],[TX] [29000-0001-00000498] 0 BLOCKER 0x15c474ed0 5 [0x420002][0x38c3c],[TX] [10000-0001-000008B2] 0 BLOCKED 0x15c7e1d10 5 [0x690009][0x30583],[TX] [10000-0001-000008B2] 0 BLOCKER 0x15c7e1ba8 5 [0x690009][0x30583],[TX] [1C000-0001-0000025E] 0 *** 2009-01-20 21:30:34.006 kjddopr: skip converting lock 0x15c7e40c8 dd_cnt 3 *** 2009-01-20 21:30:54.020 kjddopr: skip converting lock 0x15c7e38d0 dd_cnt 4 *** 2009-01-20 21:31:24.050 user session for deadlock lock 0x15c7e1ba8 pid=38 serial=16709 audsid=574175938 user: 46/XM O/S info: user: xm2_w1, term: , ospid: 1234, machine: czcholsint075.prg-dc.dhl.com program: Current SQL Statement: DELETE FROM CT WHERE MBD = :1 AND EV_ID = :2 user session for deadlock lock 0x15c7e38d0 pid=41 serial=1809 audsid=574175941 user: 46/XM O/S info: user: xm2_w1, term: , ospid: 1234, machine: czcholsint075.prg-dc.dhl.com program: Current SQL Statement: DELETE FROM CT WHERE MBD = :1 AND EV_ID = :2 user session for deadlock lock 0x15c7e4368 pid=16 serial=16756 audsid=574175922 user: 46/XM O/S info: user: xm22_w1, term: , ospid: 1234, machine: czcholsint076.prg-dc.dhl.com program: Current SQL Statement: UPDATE CT SET M_FLG = 'N' WHERE MBD = 1232472639245372242 AND EV_ID = 170 Global blockers dump start:--------------------------------- DUMP LOCAL BLOCKER/HOLDER: block level 5 res [0x420002][0x38c3c],[TX]