Wie debugge ich ORA-08177?Java

Java-Forum
Anonymous
 Wie debugge ich ORA-08177?

Post by Anonymous »

Wir haben eine Frühlingsanwendung auf Java, die mit Oracle 19.14 funktioniert.

Code: Select all

@Transactional(isolation = Isolation.SERIALIZABLE, propagation = NESTED)
public importCollection() {
// some select and insert statements here
}
Wenn wir diese Funktion aufrufen (wenn wir importcollection () keine parallelen Threads aufrufen, erhalten wir ORA-08177 (kann den Zugriff nicht serialisieren) Fehlermeldung. Ohne Fehler und danach kommt dieser Fehler nicht wieder vor. (Wenn wir unsere Anwendung auf der neuen virtuellen Maschine mit der neuen Oracle -Instanz bereitstellen, wird die Usecase erneut aufgetreten.) Isolierungsstufe Es ist wichtig, initran> = 3 < /code>. class = "Lang-none hübschprint-override">

Code: Select all

=====================
PARSING IN CURSOR #140495296748256 len=216 dep=0 uid=109 oct=2 lid=109 tim=14479044068 hv=772606070 ad='760a5048' sqlid='541sxycr0u23q'
INSERT ALL   INTO SAM_COLLECTION_ACTION(COLLECTION_ID, ACTION_ID, TRANSITIVE)  VALUES ( :1 ,  :2 , :3 )   INTO SAM_COLLECTION_ACTION(COLLECTION_ID, ACTION_ID, TRANSITIVE)  VALUES ( :4 ,  :5 , :6 )  SELECT * FROM dual
END OF STMT
PARSE #140495296748256:c=161,e=161,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=0,tim=14479044068
EXEC #140495297789296:c=14,e=14,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=866645418,tim=14479044240
FETCH #140495297789296:c=11,e=11,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=866645418,tim=14479044266
CLOSE #140495297789296:c=0,e=0,dep=1,type=3,tim=14479044278
EXEC #140495297789296:c=7,e=7,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=866645418,tim=14479044312
FETCH #140495297789296:c=4,e=4,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=866645418,tim=14479044323
CLOSE #140495297789296:c=0,e=0,dep=1,type=3,tim=14479044331
EXEC #140495297789296:c=5,e=5,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=866645418,tim=14479044361
FETCH #140495297789296:c=4,e=4,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=866645418,tim=14479044372
CLOSE #140495297789296:c=0,e=0,dep=1,type=3,tim=14479044379
EXEC #140495297789296:c=4,e=4,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=866645418,tim=14479044392
FETCH #140495297789296:c=4,e=4,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=866645418,tim=14479044410
CLOSE #140495297789296:c=0,e=0,dep=1,type=3,tim=14479044418
EXEC #140495297789296:c=14,e=14,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=866645418,tim=14479045382
FETCH #140495297789296:c=9,e=9,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=866645418,tim=14479045413
CLOSE #140495297789296:c=0,e=0,dep=1,type=3,tim=14479045424
=====================
PARSING IN CURSOR #140495293613264 len=41 dep=1 uid=0 oct=7 lid=0 tim=14479045703 hv=766663521 ad='8231d2c8' sqlid='9rzjf5cqv4qv1'
delete from deferred_stg$ where obj# = :1
END OF STMT
EXEC #140495293613264:c=266,e=266,p=0,cr=2,cu=4,mis=0,r=1,dep=1,og=4,plh=2714355898,tim=14479045703
CLOSE #140495293613264:c=0,e=0,dep=1,type=3,tim=14479045733
=====================
PARSING IN CURSOR #140495297059344 len=226 dep=1 uid=0 oct=3 lid=0 tim=14479045975 hv=1011610568 ad='885d2010' sqlid='9tgj4g8y4rwy8'
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),NVL(scanhint,0),NVL(bitmapranges,0) from seg$ where ts#=:1 and file#=:2 and block#=:3
END OF STMT
EXEC #140495297059344:c=16,e=16,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=3755742892,tim=14479045975
FETCH #140495297059344:c=5,e=5,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,plh=3755742892,tim=14479046023
CLOSE #140495297059344:c=0,e=0,dep=1,type=3,tim=14479046037
=====================
PARSING IN CURSOR #140495297050960 len=259 dep=1 uid=0 oct=2 lid=0 tim=14479046414 hv=1814305607 ad='824a4ba0' sqlid='g7mt7ptq286u7'
insert into seg$ (file#,block#,type#,ts#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,lists,groups,cachehint,hwmincr, spare1, scanhint,  bitmapranges)  v a l u e s   ( : 1 , : 2 , : 3 , : 4 , : 5 , : 6 , : 7 , : 8 , : 9 , : 1 0 , : 1 1 , : 1 2 , : 1 3 , : 1 4 , : 1 5 , : 1 6 , D E C O D E ( : 1 7 , 0 , N U L L , : 1 7 ) , : 1 8 , : 1 9 ) < b r   / > E N D   O F   S T M T < b r   / > E X E C   # 1 4 0 4 9 5 2 9 7 0 5 0 9 6 0 : c = 1 2 8 , e = 2 5 5 , p = 0 , c r = 3 , c u = 7 , m i s = 0 , r = 1 , d e p = 1 , o g = 4 , p l h = 0 , t i m = 1 4 4 7 9 0 4 6 4 1 2 < b r   / > C L O S E   # 1 4 0 4 9 5 2 9 7 0 5 0 9 6 0 : c = 0 , e = 1 , d e p = 1 , t y p e = 3 , t i m = 1 4 4 7 9 0 4 6 4 5 0 < b r   / > = = = = = = = = = = = = = = = = = = = = = < b r   / > P A R S I N G   I N   C U R S O R   # 1 4 0 4 9 5 2 9 7 3 6 1 0 5 6   l e n = 4 1   d e p = 1   u i d = 0   o c t = 3   l i d = 0   t i m = 1 4 4 7 9 0 4 6 6 2 7   h v = 4 1 3 8 8 1 8 8 3 5   a d = ' 8 2 3 1 7 d 6 8 '   s q l i d = ' 9 5 n x 0 k v v b 2 r 8 m ' < b r   / > s e l e c t   i n d m e t h o d #   f r o m   i n d $   w h e r e   o b j # = : 1 < b r   / > E N D   O F   S T M T < b r   / > P A R S E   # 1 4 0 4 9 5 2 9 7 3 6 1 0 5 6 : c = 2 6 , e = 2 6 , p = 0 , c r = 0 , c u = 0 , m i s = 0 , r = 0 , d e p = 1 , o g = 4 , p l h = 3 3 1 2 8 6 0 2 7 2 , t i m = 1 4 4 7 9 0 4 6 6 2 7 < b r   / > E X E C   # 1 4 0 4 9 5 2 9 7 3 6 1 0 5 6 : c = 2 0 , e = 2 0 , p = 0 , c r = 0 , c u = 0 , m i s = 0 , r = 0 , d e p = 1 , o g = 4 , p l h = 3 3 1 2 8 6 0 2 7 2 , t i m = 1 4 4 7 9 0 4 6 6 7 6 < b r   / > F E T C H   # 1 4 0 4 9 5 2 9 7 3 6 1 0 5 6 : c = 2 1 , e = 2 1 , p = 0 , c r = 3 , c u = 0 , m i s = 0 , r = 1 , d e p = 1 , o g = 4 , p l h = 3 3 1 2 8 6 0 2 7 2 , t i m = 1 4 4 7 9 0 4 6 7 0 4 < b r   / > S T A T   # 1 4 0 4 9 5 2 9 7 361056 id=1 cnt=1 pid=0 pos=1 obj=19 op='TABLE ACCESS BY INDEX ROWID IND$ (cr=3 pr=0 pw=0 str=1 time=22 us cost=2 size=7 card=1)'
STAT #140495297361056 id=2 cnt=1 pid=1 pos=1 obj=41 op='INDEX UNIQUE SCAN I_IND1 (cr=2 pr=0 pw=0 str=1 time=6 us cost=1 size=0 card=1)'
CLOSE #140495297361056:c=8,e=8,dep=1,type=1,tim=14479046760
EXEC #140495297789296:c=8,e=8,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=866645418,tim=14479046796
FETCH #140495297789296:c=8,e=8,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=866645418,tim=14479046811
CLOSE #140495297789296:c=0,e=0,dep=1,type=3,tim=14479046819
EXEC #140495293613264:c=79,e=79,p=0,cr=2,cu=3,mis=0,r=1,dep=1,og=4,plh=2714355898,tim=14479046905
CLOSE #140495293613264:c=0,e=0,dep=1,type=3,tim=14479046916
EXEC #140495297059344:c=24,e=24,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=3755742892,tim=14479047020
FETCH #140495297059344:c=3,e=3,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,plh=3755742892,tim=14479047037
CLOSE #140495297059344:c=0,e=0,dep=1,type=3,tim=14479047046
EXEC #140495297050960:c=131,e=131,p=0,cr=3,cu=6,mis=0,r=1,dep=1,og=4,plh=0,tim=14479049162
CLOSE #140495297050960:c=1,e=1,dep=1,type=3,tim=14479049189
=====================
PARSING IN CURSOR #140495297362384 len=40 dep=1 uid=0 oct=7 lid=0 tim=14479049542 hv=2579434614 ad='82318dc0' sqlid='gsfnqdfcvy33q'
delete from superobj$ where subobj# = :1
END OF STMT
PARSE #140495297362384:c=44,e=45,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2453887050,tim=14479049542
EXEC #140495297362384:c=24,e=24,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,plh=2453887050,tim=14479049599
STAT #140495297362384 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  SUPEROBJ$ (cr=1 pr=0 pw=0 str=1 time=5 us)'
STAT #140495297362384 id=2 cnt=0 pid=1 pos=1 obj=98 op='INDEX UNIQUE SCAN I_SUPEROBJ1 (cr=1 pr=0 pw=0 str=1 time=3 us cost=0 size=26 card=1)'
CLOSE #140495297362384:c=1,e=1,dep=1,type=0,tim=14479049659
=====================
PARSING IN CURSOR #140495297362384 len=36 dep=1 uid=0 oct=7 lid=0 tim=14479049698 hv=1175925690 ad='822fc1d8' sqlid='3kywng531fcxu'
delete from tab_stats$ where obj#=:1
END OF STMT
PARSE #140495297362384:c=15,e=15,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2667651180,tim=14479049698
EXEC #140495297362384:c=18,e=17,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,plh=2667651180,tim=14479049738
STAT #140495297362384 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  TAB_STATS$ (cr=1 pr=0 pw=0 str=1 time=4 us)'
STAT #140495297362384 id=2 cnt=0 pid=1 pos=1 obj=74 op='INDEX UNIQUE SCAN I_TAB_STATS$_OBJ# (cr=1 pr=0 pw=0 str=1 time=3 us cost=0 size=13 card=1)'
CLOSE #140495297362384:c=1,e=1,dep=1,type=0,tim=14479049778
=====================
PARSING IN CURSOR #140495297035352 len=651 dep=1 uid=0 oct=6 lid=0 tim=14479049960 hv=1254766863 ad='822f7f30' sqlid='9g9a7195cnf8g'
update tab$ set ts#=:2,file#=:3,block#=:4,bobj#=decode(:5,0,null,:5),tab#=decode(:6,0,null,:6),intcols=:7,kernelcols=:8,clucols=decode(:9,0,null,:9),audit$=:10,flags=:11,pctfree$=:12,pctused$=:13,initrans=:14,maxtrans=:15,rowcnt=:16,blkcnt=:17,empcnt=:18,avgspc=:19,chncnt=:20,avgrln=:21,analyzetime=:22,samplesize=:23,cols=:24,property=:25,degree=decode(:26,1,null,:26),instances=decode(:27,1,null,:27),dataobj#=:28,avgspc_flb=:29,flbcnt=:30,trigflag=:31,spare1=:32,spare2=decode(:33,0,null,:33),spare4=:34,spare6=:35,acdrflags=decode(:36,0,null,:36),acdrtsobj#=decode(:37,0,null,:37),acdrdefaulttime=:38,acdrrowtsintcol#=:39,spare7=:40 where obj#=:1
END OF STMT
EXEC #140495297035352:c=152,e=152,p=0,cr=4,cu=3,mis=0,r=1,dep=1,og=4,plh=2918346288,tim=14479049960
CLOSE #140495297035352:c=0,e=0,dep=1,type=3,tim=14479049994
=====================
PARSING IN CURSOR #140495297362384 len=36 dep=1 uid=0 oct=7 lid=0 tim=14479050078 hv=1784203153 ad='822f1e88' sqlid='3axxxnjp5jjwj'
delete from ind_stats$ where obj#=:1
END OF STMT
PARSE #140495297362384:c=21,e=21,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1596536394,tim=14479050077
EXEC #140495297362384:c=22,e=22,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,plh=1596536394,tim=14479050127
STAT #140495297362384 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE  IND_STATS$ (cr=1 pr=0 pw=0 str=1 time=4 us)'
STAT #140495297362384 id=2 cnt=0 pid=1 pos=1 obj=76 op='INDEX UNIQUE SCAN I_IND_STATS$_OBJ# (cr=1 pr=0 pw=0 str=1 time=3 us cost=0 size=13 card=1)'
CLOSE #140495297362384:c=5,e=5,dep=1,type=1,tim=14479050173
=====================
PARSING IN CURSOR #140495293558184 len=533 dep=1 uid=0 oct=6 lid=0 tim=14479050271 hv=625199886 ad='822edbe0' sqlid='gg8cpx0kn7ksf'
update ind$ set ts#=:2,file#=:3,block#=:4,intcols=:5,type#=:6,flags=:7,property=:8,pctfree$=:9,initrans=:10,maxtrans=:11,blevel=:12,leafcnt=:13,distkey=:14,lblkkey=:15,dblkkey=:16,clufac=:17,cols=:18,analyzetime=:19,samplesize=:20,dataobj#=:21,degree=decode(:22,1,null,:22),instances=decode(:23,1,null,:23),rowcnt=:24,pctthres$=:31*256+:25,  indmethod#=:26, trunccnt=:27,evaledition#=decode(:33,1,null,:33),unusablebefore#=decode(:34,0,null,:34),unusablebeginning#=decode(:35,0,null,:35),spare4=:29,spare2=:30,spare6=:32 where obj#=:1
END OF STMT
EXEC #140495293558184:c=77,e=77,p=0,cr=2,cu=1,mis=0,r=1,dep=1,og=4,plh=2580332476,tim=14479050271
CLOSE #140495293558184:c=1,e=1,dep=1,type=3,tim=14479050307
=====================
PARSING IN CURSOR #140495297025144 len=314 dep=1 uid=0 oct=6 lid=0 tim=14479050406 hv=3096556448 ad='8245a2a0' sqlid='0kkhhb2w93cx0'
update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9,extpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,:17),scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3
END OF STMT
EXEC #140495297025144:c=70,e=70,p=0,cr=3,cu=1,mis=0,r=1,dep=1,og=4,plh=2170058777,tim=14479050406
CLOSE #140495297025144:c=0,e=0,dep=1,type=3,tim=14479050441
EXEC #140495297025144:c=35,e=35,p=0,cr=3,cu=1,mis=0,r=1,dep=1,og=4,plh=2170058777,tim=14479050488
CLOSE #140495297025144:c=0,e=0,dep=1,type=3,tim=14479050498
EXEC #140495296748256:c=7217,e=7911,p=0,cr=58,cu=126,mis=1,r=0,dep=0,og=1,plh=2939908344,tim=14479052017
ERROR #140495296748256:err=8177 tim=14479052040
STAT #140495296748256 id=1 cnt=0 pid=0 pos=1 obj=0 op='MULTI-TABLE INSERT  (cr=0 pr=0 pw=0 str=1 time=3 us)'
STAT #140495296748256 id=2 cnt=1 pid=1 pos=1 obj=0 op='FAST DUAL  (cr=0 pr=0 pw=0 str=1 time=1 us cost=2 size=0 card=1)'
STAT #140495296748256 id=3 cnt=0 pid=1 pos=2 obj=76144 op='INTO  SAM_COLLECTION_ACTION (cr=0 pr=0 pw=0 str=0 time=0 us)'
STAT #140495296748256 id=4 cnt=0 pid=1 pos=3 obj=76144 op='INTO  SAM_COLLECTION_ACTION (cr=0 pr=0 pw=0 str=0 time=0 us)'
WAIT #140495296748256: nam='SQL*Net break/reset to client' ela= 7 driver id=1413697536 break?=1 p3=0 obj#=-1 tim=14479052122
WAIT #140495296748256: nam='SQL*Net break/reset to client' ela= 338 driver id=1413697536 break?=0 p3=0 obj#=-1 tim=14479052468
WAIT #140495296748256: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=14479052541
WAIT #140495296748256: nam='SQL*Net message from client' ela= 2210 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=14479054802
CLOSE #140495296748256:c=6,e=6,dep=0,type=0,tim=14479054841
XCTEND rlbk=1, rd_only=0, tim=14479054875
WAIT #0: nam='log file sync' ela= 3529 buffer#=4257 sync scn=2413495 p3=0 obj#=-1 tim=14479058850
WAIT #0: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=14479058893
WAIT #0: nam='SQL*Net message from client' ela= 508 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=14479059410
PARSE #140495297001416:c=4,e=4,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=0,tim=14479059444
EXEC #140495297001416:c=7,e=8,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=0,tim=14479059462
XCTEND rlbk=0, rd_only=1, tim=14479059470
WAIT #140495297001416: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=14479059478

Quick Reply

Change Text Case: 
   
  • Similar Topics
    Replies
    Views
    Last post