deadlock

/oraclerpt/app/oracle/product/10.2.0/admin/eprint/udump/eprint_ora_49351474.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oraclerpt/app/oracle/product/10.2.0
System name: AIX
Node name: mahkdb_b
Release: 1
Version: 6
Machine: 00F6D4EA4C00
Instance name: eprint
Redo thread mounted by this instance: 1
Oracle process number: 28
Unix process pid: 49351474, image: oracle@mahkdb_b

*** 2017-05-12 14:25:26.777
*** ACTION NAME:() 2017-05-12 14:25:26.776
*** MODULE NAME:(JDBC Thin Client) 2017-05-12 14:25:26.776
*** SERVICE NAME:(eprint) 2017-05-12 14:25:26.776
*** SESSION ID:(69.9380) 2017-05-12 14:25:26.776
DEADLOCK DETECTED ( ORA-00060 )
[Transaction Deadlock]
The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:
---------[color=red]Blocker[/color](s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-00050026-000013e7 28 69 X 26 142 X
TX-000a002b-0000e87c 26 142 X 28 69 X
[color=red]session 69: DID 0001-001C-000367E8 session 142: DID 0001-001A-0003931C
session 142: DID 0001-001A-0003931C session 69: DID 0001-001C-000367E8[/color]
Rows waited on:
Session 142: obj - rowid = 000135FE - AAATX+AAGAAAHefAAB
(dictionary objn - 79358, file - 6, block - 30623, slot - 1)
Session 69: obj - rowid = 000135FE - AAATX+AAGAAAHxmAAA
(dictionary objn - 79358, file - 6, block - 31846, slot - 0)
Information on the OTHER waiting sessions:
Session 142:
pid=26 serial=25081 audsid=130914 user: 58/PRINTSYS
O/S info: user: wlghkis, term: unknown, ospid: 1234, machine: EprintNew
program: JDBC Thin Client
application name: JDBC Thin Client, hash value=2546894660
Current SQL Statement:
update GaEndorTemp set id ='127680' , insuredname=:1 , endorsetext=:2 , clausetext=:3 , insurednameold=:4 , newendorsetext=:5 where id ='127680'
End of information on OTHER waiting sessions.
Current SQL statement for this session:
select insuredname,endorsetext,clausetext,insurednameold,newendorsetext from GaEndorTemp where id=127680 for update
===================================================
PROCESS STATE
-------------
Process global information:
process: 70000006f302128, call: 7000000695e92b8, xact: 70000006da37a48, curses: 70000006f3a32c8, usrses: 70000006f3a32c8
----------------------------------------
SO: 70000006f302128, type: 2, owner: 0, flag: INIT/-/-/0x00
(process) Oracle pid=28, calls cur/top: 7000000695e92b8/7000000695e92b8, flag: (0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 109 0 4
last post received-location: kslpsr
last process to post me: 70000006f2f7bc8 1 6
last post sent: 0 0 24
last post sent-location: ksasnd
last process posted by me: 70000006f2f7bc8 1 6
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 70000006f33f7d0
O/S info: user: oracle, term: UNKNOWN, ospid: 49351474
OSD pid info: Unix process pid: 49351474, image: oracle@mahkdb_b
Dump of memory from 0x070000006F2E4CD8 to 0x070000006F2E4EE0
70000006F2E4CD0 00000007 00000000 [........]
70000006F2E4CE0 07000000 694CA8B8 00000010 000313A7 [....iL..........]
70000006F2E4CF0 07000000 695E92B8 00000003 000313A7 [....i^..........]
70000006F2E4D00 07000000 6F5DE7B8 0000000B 000313A7 [....o]..........]
70000006F2E4D10 07000000 6F3A32C8 00000004 0003129B [....o:2.........]
70000006F2E4D20 07000000 6D7944C8 00000007 000313A7 [....myD.........]
70000006F2E4D30 07000000 6D794E68 00000007 000313A7 [....myNh........]
70000006F2E4D40 07000000 6D7954A0 00000007 000313A7 [....myT.........]
70000006F2E4D50 00000000 00000000 00000000 00000000 [................]
Repeat 24 times
(FOB) flags=2 fib=70000006d8f0730 incno=0 pending i/o cnt=0
fname=/oraclerpt/app/mahkrptdb/oradata/eprint/undotbs01.dbf
fno=2 lblksz=8192 fsiz=14720
(FOB) flags=2 fib=70000006d8f15c8 incno=0 pending i/o cnt=0
fname=/oraclerpt/app/mahkrptdb/oradata/eprint/tblspace_prp01.dbf
fno=6 lblksz=8192 fsiz=32000
(FOB) flags=2 fib=70000006d8f1d08 incno=0 pending i/o cnt=0
fname=/oraclerpt/app/mahkrptdb/oradata/eprint/tblspace_temp.dbf
fno=202 lblksz=8192 fsiz=4096
----------------------------------------
SO: 70000006f3a32c8, type: 4, owner: 70000006f302128, flag: INIT/-/-/0x00
(session) sid: 69 trans: 70000006da37a48, creator: 70000006f302128, flag: (100041) USR/- BSY/-/-/-/-/-
DID: 0001-001C-000367E8, short-term DID: 0000-0000-00000000
txn branch: 0
oct: 3, prv: 0, sql: 70000003ba64b38, psql: [color=red]70000005dbe65d8[/color], user: 58/PRINTSYS
service name: eprint
O/S info: user: wlghkis, term: unknown, ospid: 1234, machine: EprintNew
program: JDBC Thin Client
application name: JDBC Thin Client, hash value=2546894660
last wait for 'enq: TX - row lock contention' blocking sess=0x70000006f404d70 seq=39947 wait_time=2929752 seconds since wait started=2
name|mode=54580006, usn<<16 | slot=a002b, sequence=e87c
Dumping Session Wait History
for 'enq: TX - row lock contention' count=1 wait_time=2929752
name|mode=54580006, usn<<16 | slot=a002b, sequence=e87c
for 'SQL*Net message from client' count=1 wait_time=493
driver id=54435000, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=0
driver id=54435000, #bytes=1, =0
for 'log file sync' count=1 wait_time=277
buffer#=42a, =0, =0
for 'SQL*Net message from client' count=1 wait_time=365
driver id=54435000, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=3
driver id=54435000, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=27937
driver id=54435000, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=2
driver id=54435000, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=17846
driver id=54435000, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=2
driver id=54435000, #bytes=1, =0


==============================================================================
SO: 70000002f633b08, type: 53, owner: 70000006f3a32c8, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=70000002f633b08 handle=70000005dbe65d8 mode=N
call pin=0 session pin=0 hpc=0000 hlc=0000
htl=70000002f633b88[70000002f49c438,7000000694ffd20] htb=70000002f49c438 ssga=70000002f49b340
user=70000006f3a32c8 session=70000006f3a32c8 count=1 flags=[0000] savepoint=0x59155553
LIBRARY OBJECT HANDLE: handle=70000005dbe65d8 mtx=70000005dbe6708(4) cdp=4
name=
insert into GAENDORTEMP (AGREEMENTINFO, AGREEMENTNO, AGREESOLUTIONNO, APPLIADDRESS, APPLIADDRTYPE, APPLINAME, BILLACCEPTERCODE, BILLACCEPTERINFO, BILLACCEPTERTYPE, BLOCKCODE, CLAUSETEXT, COMPANYCODE, CONVEYANCENAME, EANO, ENDDATE, ENDDATEOLD, ENDORDATE, ENDORSEQNO, ENDORSETEXT, EXHAUSTSCALE, GROUPCODE, HELDMESS, INPUTDATE, INSUREDADDRESS, INSUREDCODE, INSUREDNAME, INSUREDNAMEOLD, INTERMEDIARYCODE, ISSUEDATE, ISSUEPLACE, LICENSENO, MAKE, MAKEDATE, NEWENDORSETEXT, OPERATORCODE, POLICYNO, PREMIUM, PRINTCODE, P
hash=fea113dd209423a567ab3f61b5411afe timestamp=04-26-2017 15:21:28
namespace=CRSR flags=RON/KGHP/TIM/PN0/KST/DBN/MTX/[100100d0]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch#=8 hpc=01c4 hlc=01c4
lwt=70000005dbe6680[70000005dbe6680,70000005dbe6680] ltm=70000005dbe6690[70000005dbe6690,70000005dbe6690]
pwt=70000005dbe6648[70000005dbe6648,70000005dbe6648] ptm=70000005dbe6658[70000005dbe6658,70000005dbe6658]
ref=70000005dbe66b0[70000005dbe66b0,70000005dbe66b0] lnd=70000005dbe66c8[70000005dbe66c8,70000005dbe66c8]
LIBRARY OBJECT: object=700000035448f28
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 700000046faa9d8 700000046faa648 7000000398fb248
1 700000046faa9d8 70000003875a028 700000049911e20
2 700000046faa9d8 70000003a86d3c0 70000003b9e5b40
3 700000046faa9d8 7000000387aa1c8 700000049a4ab40
4 700000046faa9d8 70000003ca3b4a0 7000000397934f8
5 700000046faa9d8 7000000597f8f10 700000039ffa960
6 700000046faa9d8 70000004614cc70 7000000444f3f70
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 7000000556b9d70 700000035449040 I/P/A/-/- 0 NONE 00
----------------------------------------


==============================================================================


----------------------------------------
Cursor#21(110441f30) state=BOUND curiob=1108b67c0
curflg=44 fl2=0 par=0 ses=70000006f3a32c8
sqltxt(70000005dbe65d8)=
insert into GAENDORTEMP (AGREEMENTINFO, AGREEMENTNO, AGREESOLUTIONNO, APPLIADDRESS, APPLIADDRTYPE, APPLINAME, BILLACCEPTERCODE, BILLACCEPTERINFO, BILLACCEPTERTYPE, BLOCKCODE, CLAUSETEXT, COMPANYCODE, CONVEYANCENAME, EANO, ENDDATE, ENDDATEOLD, ENDORDATE, ENDORSEQNO, ENDORSETEXT, EXHAUSTSCALE, GROUPCODE, HELDMESS, INPUTDATE, INSUREDADDRESS, INSUREDCODE, INSUREDNAME, INSUREDNAMEOLD, INTERMEDIARYCODE, ISSUEDATE, ISSUEPLACE, LICENSENO, MAKE, MAKEDATE, NEWENDORSETEXT, OPERATORCODE, POLICYNO, PREMIUM, PRINTCODE, PRINTDATE, PRINTINFO, RISKCLASS, RISKCNAME, RISKCODE, RISKENAME, RISKTNAME, SALESMANCODE, SEATCOUNT, SERAILNO, SITECODE, SOLUTIONCODE, SPECIALCLAUSES, SUMINSURED, SUMINSUREDOLD, SUMINSUREDOLDMESS, TASKID, TICCODE, UNDERWRITECODE, UNDERWRITEENDDATE, VALIDDATE, VESSNAME, VISASERIALNO, VISATYPE, VOYAGECARDNO, VOYAGEDESC, ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 )
hash=fea113dd209423a567ab3f61b5411afe
parent=700000035449040 maxchild=07 plk=70000002f633b08 ppn=n
cursor instantiation=1108b67c0 used=1494570323
child#6(7000000444f3f70) pcs=70000004614ca18
clk=7000000694ffca0 ci=7000000355ed008 pn=0 ctx=700000065164990
kgsccflg=1 llk[1108b67c8,1108b67c8] idx=ff
xscflg=80110436 fl2=5000008 fl3=2022008 fl4=0
Bind bytecodes
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf7e50 Offsi = 48, Offsi = 0
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf7e80 Offsi = 48, Offsi = 32
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf7eb0 Offsi = 48, Offsi = 64
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf7ee0 Offsi = 48, Offsi = 96
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf7f10 Offsi = 48, Offsi = 128
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf7f40 Offsi = 48, Offsi = 160
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf7f70 Offsi = 48, Offsi = 192
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf7fa0 Offsi = 48, Offsi = 224
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf7fd0 Offsi = 48, Offsi = 256
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8000 Offsi = 48, Offsi = 288
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8030 Offsi = 48, Offsi = 320
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8060 Offsi = 48, Offsi = 352
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8090 Offsi = 48, Offsi = 384
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf80c0 Offsi = 48, Offsi = 416
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf80f0 Offsi = 48, Offsi = 448
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8120 Offsi = 48, Offsi = 480
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8150 Offsi = 48, Offsi = 512
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8180 Offsi = 48, Offsi = 544
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf81b0 Offsi = 48, Offsi = 576
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf81e0 Offsi = 48, Offsi = 608
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8210 Offsi = 48, Offsi = 640
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8240 Offsi = 48, Offsi = 672
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8270 Offsi = 48, Offsi = 704
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf82a0 Offsi = 48, Offsi = 736
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf82d0 Offsi = 48, Offsi = 768
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8300 Offsi = 48, Offsi = 800
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8330 Offsi = 48, Offsi = 832
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8360 Offsi = 48, Offsi = 864
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8390 Offsi = 48, Offsi = 896
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf83c0 Offsi = 48, Offsi = 928
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf83f0 Offsi = 48, Offsi = 960
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8420 Offsi = 48, Offsi = 992
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8450 Offsi = 48, Offsi = 1024
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8480 Offsi = 48, Offsi = 1056
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf84b0 Offsi = 48, Offsi = 1088
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf84e0 Offsi = 48, Offsi = 1120
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8510 Offsi = 48, Offsi = 1152
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8540 Offsi = 48, Offsi = 1184
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8570 Offsi = 48, Offsi = 1216
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf85a0 Offsi = 48, Offsi = 1248
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf85d0 Offsi = 48, Offsi = 1280
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8600 Offsi = 48, Offsi = 1312
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8630 Offsi = 48, Offsi = 1344
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8660 Offsi = 48, Offsi = 1376
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8690 Offsi = 48, Offsi = 1408
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf86c0 Offsi = 48, Offsi = 1440
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf86f0 Offsi = 48, Offsi = 1472
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8720 Offsi = 48, Offsi = 1504
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8750 Offsi = 48, Offsi = 1536
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8780 Offsi = 48, Offsi = 1568
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf87b0 Offsi = 48, Offsi = 1600
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf87e0 Offsi = 48, Offsi = 1632
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8810 Offsi = 48, Offsi = 1664
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8840 Offsi = 48, Offsi = 1696
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8870 Offsi = 48, Offsi = 1728
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf88a0 Offsi = 48, Offsi = 1760
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf88d0 Offsi = 48, Offsi = 1792
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8900 Offsi = 48, Offsi = 1824
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8930 Offsi = 48, Offsi = 1856
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8960 Offsi = 48, Offsi = 1888
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8990 Offsi = 48, Offsi = 1920
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf89c0 Offsi = 48, Offsi = 1952
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf89f0 Offsi = 48, Offsi = 1984
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8a20 Offsi = 48, Offsi = 2016
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 700000063bf8a50 Offsi = 48, Offsi = 2048