DUMP LOCAL BLOCKER: initiate state dump for DEADLOCK
possible owner[782.2425506]
Submitting asynchronized dump request [28]
user session for deadlock lock 70000044269f2d0
pid=961 serial=64048 audsid=126283923 user: 61/HBNEW97
O/S info: user: , term: , ospid: 1234, machine: pfyy2
program:
Current SQL Statement:
update SERV_NWK set ADDR_SEQ=:1, USER_RS_ID=:2, STS=:3, STS_DATE=:4, LOCAL_NET_ID=:5 where SERV_ID=:6 and SERV_NWK_SEQ=:7 and SEQ=:8
user session for deadlock lock 7000004413ddaf0
pid=1239 serial=58184 audsid=126272724 user: 61/HBNEW97
O/S info: user: , term: , ospid: 1234, machine: pfyy1
program:
Current SQL Statement:
update EQPT_PAIR set EQPT_TYPE_ID=:1, EQPT_SUB_TYPE_ID=:2, LOCAL_NET_ID=:3, AREA_ID=:4, EXCH_ID=:5, TYPE=:6, PORT_TYPE=:7, STS=:8, STS_DATE=:9, CREATE_DATE=:10 where EQPT_ID=:11 and SIDE=:12 and PR_NBR=:13
Global blockers dump start:---------------------------------
DUMP LOCAL BLOCKER/HOLDER: block level 5 res [0x72004c][0x100df],[TX]
----------resource 0x700000313600f00----------------------
resname : [0x72004c][0x100df],[TX]
Local node : 0
dir_node : 0
master_node : 0
hv idx : 10
hv last r.inc : 4
current inc : 4
hv status : 0
hv master : 0
open options : dd
grant_bits : KJUSERNL KJUSEREX
grant mode : KJUSERNL KJUSERCR KJUSERCW KJUSERPR KJUSERPW KJUSEREX
count : 1 0 0 0 0 1
val_state : KJUSERVS_NOVALUE
valblk : 0x00000000000000000000000000000000 .
access_node : 0
vbreq_state : 0
state : x0
resp : 700000313600f00
On Scan_q? : N
Total accesses: 79151
Imm. accesses: 13891
Granted_locks : 1
Cvting_locks : 1
value_block: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
GRANTED_Q :
lp 70000044269f180 gl KJUSEREX rp 700000313600f00 [0x72004c][0x100df],[TX]
master 0 gl owner 700000430117030 possible pid 1769524 xid 104D-04D7-00171D68 bast 0 rseq 3299 mseq 0 history 0x14951495
open opt KJUSERDEADLOCK
CONVERT_Q:
lp 70000044269f2d0 gl KJUSERNL rl KJUSEREX rp 700000313600f00 [0x72004c][0x100df],[TX]
master 0 gl owner 700000446b6cc10 possible pid 2400650 xid 103C-03C1-00202B75 bast 0 rseq 3299 mseq 0 history 0x1495149a
convert opt KJUSERGETVALUE KJUSERTRCCANCEL
----------enqueue 0x70000044269f180------------------------
lock version : 9265349
Owner node : 0
grant_level : KJUSEREX
req_level : KJUSEREX
bast_level : KJUSERNL
notify_func : 0
resp : 700000313600f00
procp : 70000044bcdd638
pid : 2400650
proc version : 12460
oprocp : 0
opid : 0
group lock owner : 700000430117030
possible pid : 1769524
xid : 104D-04D7-00171D68
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 : 0x14951495
Msg_Seq : 0x0
res_seq : 3299
valblk : 0x00000000000000000000000000000000 .
possible owner[782.2425506]
Submitting asynchronized dump request [28]
user session for deadlock lock 70000044269f2d0
pid=961 serial=64048 audsid=126283923 user: 61/HBNEW97
O/S info: user: , term: , ospid: 1234, machine: pfyy2
program:
Current SQL Statement:
update SERV_NWK set ADDR_SEQ=:1, USER_RS_ID=:2, STS=:3, STS_DATE=:4, LOCAL_NET_ID=:5 where SERV_ID=:6 and SERV_NWK_SEQ=:7 and SEQ=:8
user session for deadlock lock 7000004413ddaf0
pid=1239 serial=58184 audsid=126272724 user: 61/HBNEW97
O/S info: user: , term: , ospid: 1234, machine: pfyy1
program:
Current SQL Statement:
update EQPT_PAIR set EQPT_TYPE_ID=:1, EQPT_SUB_TYPE_ID=:2, LOCAL_NET_ID=:3, AREA_ID=:4, EXCH_ID=:5, TYPE=:6, PORT_TYPE=:7, STS=:8, STS_DATE=:9, CREATE_DATE=:10 where EQPT_ID=:11 and SIDE=:12 and PR_NBR=:13
Global blockers dump start:---------------------------------
DUMP LOCAL BLOCKER/HOLDER: block level 5 res [0x72004c][0x100df],[TX]
----------resource 0x700000313600f00----------------------
resname : [0x72004c][0x100df],[TX]
Local node : 0
dir_node : 0
master_node : 0
hv idx : 10
hv last r.inc : 4
current inc : 4
hv status : 0
hv master : 0
open options : dd
grant_bits : KJUSERNL KJUSEREX
grant mode : KJUSERNL KJUSERCR KJUSERCW KJUSERPR KJUSERPW KJUSEREX
count : 1 0 0 0 0 1
val_state : KJUSERVS_NOVALUE
valblk : 0x00000000000000000000000000000000 .
access_node : 0
vbreq_state : 0
state : x0
resp : 700000313600f00
On Scan_q? : N
Total accesses: 79151
Imm. accesses: 13891
Granted_locks : 1
Cvting_locks : 1
value_block: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
GRANTED_Q :
lp 70000044269f180 gl KJUSEREX rp 700000313600f00 [0x72004c][0x100df],[TX]
master 0 gl owner 700000430117030 possible pid 1769524 xid 104D-04D7-00171D68 bast 0 rseq 3299 mseq 0 history 0x14951495
open opt KJUSERDEADLOCK
CONVERT_Q:
lp 70000044269f2d0 gl KJUSERNL rl KJUSEREX rp 700000313600f00 [0x72004c][0x100df],[TX]
master 0 gl owner 700000446b6cc10 possible pid 2400650 xid 103C-03C1-00202B75 bast 0 rseq 3299 mseq 0 history 0x1495149a
convert opt KJUSERGETVALUE KJUSERTRCCANCEL
----------enqueue 0x70000044269f180------------------------
lock version : 9265349
Owner node : 0
grant_level : KJUSEREX
req_level : KJUSEREX
bast_level : KJUSERNL
notify_func : 0
resp : 700000313600f00
procp : 70000044bcdd638
pid : 2400650
proc version : 12460
oprocp : 0
opid : 0
group lock owner : 700000430117030
possible pid : 1769524
xid : 104D-04D7-00171D68
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 : 0x14951495
Msg_Seq : 0x0
res_seq : 3299
valblk : 0x00000000000000000000000000000000 .