I'm sorry I'm new here, I'm struggling to interpret this trace of Deadlock, I would get the query and object
causing the deadlock. Could someone help me
DUMP LOCAL BLOCKER: initiate state dump for DEADLOCK
possible owner[904.19054] on resource TX-004E0002-00372ED3
Submitting asynchronized dump request [28]
----------enqueue 0x14898e57c8------------------------
lock version : 9939
Owner node : 0
grant_level : KJUSERNL
req_level : KJUSEREX
bast_level : KJUSERNL
notify_func : 0
resp : 3e94eddb8
procp : 49479b9a8
pid : 11621
proc version : 3133
oprocp : 0
opid : 0
group lock owner : 14886c3230
possible pid : 11621
xid : 100B-00B6-0026AA25
dd_time : 13.0 secs
dd_count : 1
timeout : 193.0 secs
On_timer_q? : Y
On_dd_q? : Y
lock_state : OPENING CONVERTING
Open Options : KJUSERDEADLOCK
Convert options : KJUSERGETVALUE KJUSERTRCCANCEL
History : 0x49a5149a
Msg_Seq : 0x0
res_seq : 340
valblk : 0x00000000000000000000000000000000 .
DUMP LOCAL BLOCKER: initiate state dump for DEADLOCK
possible owner[182.11621] on resource TX-004E0002-00372ED3
Submitting asynchronized dump request [28]
Global blockers dump end:-----------------------------------
Global Wait-For-Graph(WFG) at ddTS[0.5e18] :
BLOCKED 14894c0800 5 wq 2 cvtops x1001 [0x40009][0xa3cb40],[TX] [1038-0388-00344A1B] 0
BLOCKER 14898e5930 5 wq 2 cvtops x1001 [0x40009][0xa3cb40],[TX] [1011-0112-00283CED] 0
BLOCKED 14898e5930 5 wq 2 cvtops x1001 [0x40009][0xa3cb40],[TX] [1011-0112-00283CED] 0
BLOCKER 14898e2438 5 wq 1 cvtops x8 [0x40009][0xa3cb40],[TX] [103D-03DA-004273DE] 0
BLOCKED 14891c8b58 5 wq 2 cvtops x1001 [0x4e0002][0x372ed3],[TX] [103D-03DA-004273DE] 0
BLOCKER 1488d74ab0 5 wq 1 cvtops x8 [0x4e0002][0x372ed3],[TX] [1038-0388-00344A1B] 0
DUMP LOCAL BLOCKER/HOLDER: block level 5 res [0x40009][0xa3cb40],[TX]
----------resource 0x3ccd643d0----------------------
resname : [0x40009][0xa3cb40],[TX]
Local node : 0
dir_node : 0
master_node : 0
hv idx : 40
hv last r.inc : 48
current inc : 48
hv status : 0
hv master : 3
open options : dd
grant_bits : KJUSERNL KJUSEREX
grant mode : KJUSERNL KJUSERCR KJUSERCW KJUSERPR KJUSERPW KJUSEREX
count : 8 0 0 0 0 1
val_state : KJUSERVS_NOVALUE
valblk : 0x00000000000000000000000000000000 .
access_node : 0
vbreq_state : 0
state : x0
resp : 3ccd643d0
On Scan_q? : N
Total accesses: 5818
Imm. accesses: 3049
Granted_locks : 1
Cvting_locks : 8
value_block: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
GRANTED_Q :
lp 14898e2438 gl KJUSEREX rp 3ccd643d0 [0x40009][0xa3cb40],[TX]
master 0 gl owner 14952fd1b8 possible pid 19547 xid 103D-03DA-004273DE bast 0 rseq 539 mseq 0 history 0x49a51495
open opt KJUSERDEADLOCK
CONVERT_Q:
lp 14898e5930 gl KJUSERNL rl KJUSEREX rp 3ccd643d0 [0x40009][0xa3cb40],[TX]
master 0 gl owner 1488571fd0 possible pid 16165 xid 1011-0112-00283CED bast 0 rseq 539 mseq 0 history 0x4495149a
convert opt KJUSERGETVALUE KJUSERTRCCANCEL
lp 14894c0800 gl KJUSERNL rl KJUSEREX rp 3ccd643d0 [0x40009][0xa3cb40],[TX]
master 0 gl owner 14885407c8 possible pid 19054 xid 1038-0388-00344A1B bast 0 rseq 539 mseq 0 history 0x49a5149a
convert opt KJUSERGETVALUE KJUSERTRCCANCEL
lp 1488badf80 gl KJUSERNL rl KJUSEREX rp 3ccd643d0 [0x40009][0xa3cb40],[TX]
master 0 gl owner 14886581b0 possible pid 19647 xid 103F-03F4-00300B84 bast 0 rseq 539 mseq 0 history 0x49a5149a
convert opt KJUSERGETVALUE KJUSERTRCCANCEL
lp 1489260388 gl KJUSERNL rl KJUSEREX rp 3ccd643d0 [0x40009][0xa3cb40],[TX]
master 0 gl owner 1488577570 possible pid 18402 xid 103A-03AE-003D8AEF bast 0 rseq 539 mseq 0 history 0x1495149a
convert opt KJUSERGETVALUE KJUSERTRCCANCEL
lp 1489428e80 gl KJUSERNL rl KJUSEREX rp 3ccd643d0 [0x40009][0xa3cb40],[TX]
master 0 gl owner 148860bd88 possible pid 28543 xid 100A-00A6-002E7610 bast 0 rseq 539 mseq 0 history 0x1495149a
convert opt KJUSERGETVALUE KJUSERTRCCANCEL
lp 1488d76670 gl KJUSERNL rl KJUSEREX rp 3ccd643d0 [0x40009][0xa3cb40],[TX]
master 0 gl owner 14886f8a70 possible pid 19052 xid 1030-0306-00254B77 bast 0 rseq 539 mseq 0 history 0x4955149a
convert opt KJUSERGETVALUE KJUSERTRCCANCEL
lp c892ac438 gl KJUSERNL rl KJUSEREX rp 3ccd643d0 [0x40009][0xa3cb40],[TX]
master 0 gl owner c88839bf0 possible pid 22239 xid 1029-029B-000E2038 bast 0 rseq 539 mseq 0 history 0x1495149a
convert opt KJUSERGETVALUE KJUSERTRCCANCEL
lp 1489132c48 gl KJUSERNL rl KJUSEREX rp 3ccd643d0 [0x40009][0xa3cb40],[TX]
master 0 gl owner 14885ed130 possible pid 18988 xid 1037-037C-00B80278 bast 0 rseq 539 mseq 0 history 0x1495149a
convert opt KJUSERGETVALUE KJUSERTRCCANCEL
----------enqueue 0x14898e2438------------------------
lock version : 2905343
Owner node : 0
grant_level : KJUSEREX
req_level : KJUSEREX
bast_level : KJUSERNL
notify_func : 0
resp : 3ccd643d0
procp : 494702810
pid : 16165
proc version : 3066
oprocp : 0
opid : 0
group lock owner : 14952fd1b8
possible pid : 19547
xid : 103D-03DA-004273DE
dd_time : 0.0 secs
dd_count : 0
timeout : 0.0 secs
On_timer_q? : N
On_dd_q? : N
lock_state : GRANTED
Open Options : KJUSERDEADLOCK
Convert options : KJUSERNOQUEUE
History : 0x49a51495
Msg_Seq : 0x0
res_seq : 539
valblk : 0x00000000000000000000000000000000 .
DUMP LOCAL BLOCKER: initiate state dump for DEADLOCK
possible owner[986.19547] on resource TX-00040009-00A3CB40
Submitting asynchronized dump request [28]
----------enqueue 0x14898e5930------------------------
lock version : 9075
Owner node : 0
grant_level : KJUSERNL
req_level : KJUSEREX
bast_level : KJUSERNL
notify_func : 0
resp : 3ccd643d0
procp : 494702810
pid : 16165
proc version : 3066
oprocp : 0
opid : 0
group lock owner : 1488571fd0
possible pid : 16165
xid : 1011-0112-00283CED
dd_time : 60.0 secs
dd_count : 1
timeout : 240.0 secs
On_timer_q? : Y
On_dd_q? : Y
lock_state : OPENING CONVERTING
Open Options : KJUSERDEADLOCK
Convert options : KJUSERGETVALUE KJUSERTRCCANCEL
History : 0x4495149a
Msg_Seq : 0x0
res_seq : 539
valblk : 0x00000000000000000000000000000000 .
DUMP LOCAL BLOCKER: initiate state dump for DEADLOCK
possible owner[274.16165] on resource TX-00040009-00A3CB40
Submitting asynchronized dump request [28]
* Cancel deadlock victim lockp x894c0800
kjxocdr: drop duplicate open [0x42000b][0x5213ba],[TX].796 0xc955e2500 [held 0][req 3]
*** 2015-05-09 20:14:34.140
kjddopr: skip converting lock 1489260388 dd_cnt 1
kjddopr: skip converting lock 1489260388 dd_cnt 1
kjddopr: skip converting lock 1489260388 dd_cnt 1
kjddopr: skip converting lock 1489260388 dd_cnt 1
kjddopr: skip converting lock 1489428e80 dd_cnt 1
kjddopr: skip converting lock 1489428e80 dd_cnt 1
kjddopr: skip converting lock 1489428e80 dd_cnt 1
kjxocdr: drop duplicate open [0x4b0000][0x36d54d],[TX].488 0xc957ef008 [held 0][req 3]
*** 2015-05-09 20:15:02.104
kjddopr: skip converting lock 1489428fd0 dd_cnt 1
kjddopr: skip converting lock 1489428fd0 dd_cnt 1
kjddopr: skip converting lock 1489428fd0 dd_cnt 1
kjddopr: skip converting lock 1489428fd0 dd_cnt 1
kjddopr: skip converting lock 1489428fd0 dd_cnt 1
kjddopr: skip converting lock 1489428fd0 dd_cnt 1
kjddopr: skip converting lock 14891311d8 dd_cnt 1
kjddopr: skip converting lock 14891311d8 dd_cnt 1
kjddopr: skip converting lock 14891311d8 dd_cnt 1
kjddopr: skip converting lock 14891311d8 dd_cnt 1
kjddopr: skip converting lock 14891311d8 dd_cnt 1
kjddopr: skip converting lock 1488d74d50 dd_cnt 1
kjddopr: skip converting lock 1488d74d50 dd_cnt 1
kjddopr: skip converting lock 1488d74d50 dd_cnt 1
kjddopr: skip converting lock 1488d74d50 dd_cnt 1
kjddopr: skip converting lock 14894bed78 dd_cnt 1
kjddopr: skip converting lock 14894bed78 dd_cnt 1
kjddopr: skip converting lock 14894bed78 dd_cnt 1
kjddopr: skip converting lock 14896859f8 dd_cnt 1
kjddopr: skip converting lock 14896859f8 dd_cnt 1
kjddopr: skip converting lock 14896859f8 dd_cnt 1
kjxocdr: drop duplicate open [0x16001b][0x73c41e],[TX].404 0xc955b59f8 [held 3][req 3]
kjxocdr: drop duplicate open [0x1f0003][0x4f2d86],[TX].367 0xc88b7f4a8 [held 0][req 3]
kjxocdr: drop duplicate open [0x1f001f][0x4f2d5e],[TX].209 0xc955e2500 [held 0][req 3]
kjxocdr: drop duplicate open [0x40019][0xa3c19c],[TX].349 0xc955b59f8 [held 0][req 3]
*** 2015-05-09 20:15:19.344
kjxocdr: drop duplicate open [0x4001c][0xa3cb91],[TX].388 0xc95651270 [held 0][req 3]
kjxocdr: drop duplicate open [0x4001c][0xa3cb91],[TX].388 0xc95651270 [held 0][req 3]
kjxocdr: drop duplicate open [0x4001c][0xa3cb91],[TX].388 0xc95651270 [held 0][req 3]
kjxocdr: drop duplicate open [0x4001c][0xa3cb91],[TX].388 0xc95651270 [held 0][req 3]
kjddopr: skip converting lock 14894c2270 dd_cnt 1
kjddopr: skip converting lock 14894c2270 dd_cnt 1