|
End DRM(2304) for pkey transfer request(s) from 1
*** 2014-10-23 11:33:38.061
user session for deadlock lock 0xa5567b8b0
pid=303 serial=45837 audsid=79868614 user: 58/QB_ZYK
O/S info: user: dsadm, term: , ospid: 11796718, machine: datastage1
program: [url=mailtosh@datastage1]osh@datastage1[/url] (TNS V1-V3)
application name: [url=mailtosh@datastage1]osh@datastage1[/url] (TNS V1-V3), hash value=522951622
Current SQL Statement:
INSERT INTO T_RYXX
(ID,
BARID,
JQMC,
KHNAME,
ZJLX,
ID_NUM,
FZDW,
ADDRESS,
COUNTRY,
ACTION_TIME,
OFFLINETIME,
CARDCLASS,
BARNAME,
DZQH,
MARK_SOURCE,
SRC_RKSJ,
RKSJ,
WTSJBS,
JLRKSJ,
ZHGXSJ)
VALUES
( :ID, :BARID, :JQMC, :KHNAME, :ZJLX, :ID_NUM, :FZDW, :ADDRESS, :COUNTRY, :ACTION_TIME, :OFFLINETIME, :CARDCLASS, :BARNAME, ZQH, :MARK_SOURCE, :SRC_RKSJ, :RKSJ, :WTSJBS,
SYSDATE,
SYSDATE)
user session for deadlock lock 0xa5567b760
pid=319 serial=30354 audsid=79868613 user: 58/QB_ZYK
O/S info: user: dsadm, term: , ospid: 17563694, machine: datastage1
program: [url=mailtosh@datastage1]osh@datastage1[/url] (TNS V1-V3)
application name: [url=mailtosh@datastage1]osh@datastage1[/url] (TNS V1-V3), hash value=522951622
Current SQL Statement:
INSERT INTO T_RYXX
(ID,
BARID,
JQMC,
KHNAME,
ZJLX,
ID_NUM,
FZDW,
ADDRESS,
COUNTRY,
ACTION_TIME,
OFFLINETIME,
CARDCLASS,
BARNAME,
DZQH,
MARK_SOURCE,
SRC_RKSJ,
RKSJ,
WTSJBS,
JLRKSJ,
ZHGXSJ)
VALUES
( :ID, :BARID, :JQMC, :KHNAME, :ZJLX, :ID_NUM, :FZDW, :ADDRESS, :COUNTRY, :ACTION_TIME, :OFFLINETIME, :CARDCLASS, :BARNAME, ZQH, :MARK_SOURCE, :SRC_RKSJ, :RKSJ, :WTSJBS,
SYSDATE,
SYSDATE)
user session for deadlock lock 0xa5f65e080
pid=319 serial=30354 audsid=79868613 user: 58/QB_ZYK
O/S info: user: dsadm, term: , ospid: 17563694, machine: datastage1
program: [url=mailtosh@datastage1]osh@datastage1[/url] (TNS V1-V3)
application name: [url=mailtosh@datastage1]osh@datastage1[/url] (TNS V1-V3), hash value=522951622
Current SQL Statement:
INSERT INTO T_RYXX
(ID,
BARID,
JQMC,
KHNAME,
ZJLX,
ID_NUM,
FZDW,
ADDRESS,
COUNTRY,
ACTION_TIME,
OFFLINETIME,
CARDCLASS,
BARNAME,
DZQH,
MARK_SOURCE,
SRC_RKSJ,
RKSJ,
WTSJBS,
JLRKSJ,
ZHGXSJ)
VALUES
( :ID, :BARID, :JQMC, :KHNAME, :ZJLX, :ID_NUM, :FZDW, :ADDRESS, :COUNTRY, :ACTION_TIME, :OFFLINETIME, :CARDCLASS, :BARNAME, ZQH, :MARK_SOURCE, :SRC_RKSJ, :RKSJ, :WTSJBS,
SYSDATE,
SYSDATE)
user session for deadlock lock 0xa5f65df30
pid=303 serial=45837 audsid=79868614 user: 58/QB_ZYK
O/S info: user: dsadm, term: , ospid: 11796718, machine: datastage1
program: [url=mailtosh@datastage1]osh@datastage1[/url] (TNS V1-V3)
application name: [url=mailtosh@datastage1]osh@datastage1[/url] (TNS V1-V3), hash value=522951622
Current SQL Statement:
INSERT INTO T_RYXX
(ID,
BARID,
JQMC,
KHNAME,
ZJLX,
ID_NUM,
FZDW,
ADDRESS,
COUNTRY,
ACTION_TIME,
OFFLINETIME,
CARDCLASS,
BARNAME,
DZQH,
MARK_SOURCE,
SRC_RKSJ,
RKSJ,
WTSJBS,
JLRKSJ,
ZHGXSJ)
VALUES
( :ID, :BARID, :JQMC, :KHNAME, :ZJLX, :ID_NUM, :FZDW, :ADDRESS, :COUNTRY, :ACTION_TIME, :OFFLINETIME, :CARDCLASS, :BARNAME, ZQH, :MARK_SOURCE, :SRC_RKSJ, :RKSJ, :WTSJBS,
SYSDATE,
SYSDATE)
Global blockers dump start:---------------------------------
DUMP LOCAL BLOCKER/HOLDER: block level 3 res [0x80020][0x19906],[TX]
----------resource 0x0x9b9d8ad08----------------------
resname : [0x80020][0x19906],[TX]
Local node : 0
dir_node : 0
master_node : 0
hv idx : 122
hv last r.inc : 8
current inc : 8
hv status : 0
hv master : 1
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 : 0x9b9d8ad08
On Scan_q? : N
Total accesses: 9271
Imm. accesses: 7421
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 0xa5567b760 gl KJUSEREX rp 0x9b9d8ad08 [0x80020][0x19906],[TX]
master 0 gl owner 0xa5f33e658 possible pid 27903 xid 13F000-0001-0000A998 bast 0 rseq 1462 mseq 0 history 0x14951495
open opt KJUSERDEADLOCK
CONVERT_Q:
lp 0xa5567b8b0 gl KJUSERNL rl KJUSERPR rp 0x9b9d8ad08 [0x80020][0x19906],[TX]
master 0 gl owner 0xa55366ec0 possible pid 27899 xid 12F000-0001-0000B75E bast 0 rseq 1462 mseq 0 history 0x1495149a
convert opt KJUSERGETVALUE
----------enqueue 0x0xa5567b760------------------------ |
|