告警日志:
Thu Feb 12 22:24:04 2009 Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db1_ora_13380.trc: ORA-07445: exception encountered: core dump [drexumcx()+89] [SIGSEGV] [Address not mapped to object] [0x000000008] [] []
跟踪文件:
*** 2009-02-12 22:10:23.482 *** ACTION NAME:() 2009-02-12 22:10:23.482 *** MODULE NAME:(JDBC Thin Client) 2009-02-12 22:10:23.482 *** SERVICE NAME:(s3db) 2009-02-12 22:10:23.482 *** SESSION ID:(283.18668) 2009-02-12 22:10:23.482 KGL recovered in-flux handle for lock 0x6aa21360 ---------------------------------------- SO: 0x6aa21360, type: 53, owner: 0x6a8bf0b0, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: lock=6aa21360 handle=d1dea280 request=S call pin=(nil) session pin=(nil) hpc=0000 hlc=0000 htl=0x6aa213e0[0x6a816948,0x6a6fc2f0] htb=0x6a6fc2f0 ssga=0x6a6fbcb8 user=df7323b0 session=df7323b0 count=0 flags=[0000] savepoint=0x6fcf LIBRARY OBJECT HANDLE: handle=d1dea280 mtx=0xd1dea3b0(0) cdp=0 name=S3TEST.CONTENT_FULL_DESC DR$STATS$OBJ hash=d7ca3ccc9536b6e7493158d66d857752 timestamp=NULL namespace=CPOB flags=KGHP/TIM/FUP/XLR/[08000020] kkkk-dddd-llll=0000-0001-0001 lock=X pin=X latch#=3 hpc=be26 hlc=be0a lwt=0xd1dea328[0x6a788278,0x6a7c0550] ltm=0xd1dea338[0xd1dea338,0xd1dea338] pwt=0xd1dea2f0[0xd1dea2f0,0xd1dea2f0] ptm=0xd1dea300[0xd1dea300,0xd1dea300] ref=0xd1dea358[0xd1dea358,0xd1dea358] lnd=0xd1dea370[0xd1dea370,0xd1dea370] LOCK INSTANCE LOCK: id=LRd7ca3ccc9536b6e7 PIN INSTANCE LOCK: id=NRd7ca3ccc9536b6e7 mode=X release=F flags=[00] LIBRARY OBJECT: object=7fc2a810 type=CPOB flags=EXS/LOC/PRG[0085] pflags=[0000] status=VALD load=0 DATA BLOCKS: data# heap pointer status pins change whr ----- -------- -------- --------- ---- ------ --- 0 d1cf4248 7fc2a928 I/P/A/-/- 0 NONE 00 *** 2009-02-12 22:24:04.851 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x8, PC: [0x510baef, drexumcx()+89] *** 2009-02-12 22:24:04.865 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [drexumcx()+89] [SIGSEGV] [Address not mapped to object] [0x000000008] [] [] Current SQL statement for this session: declare cost sys.ODCICost := sys.ODCICost(NULL, NULL, NULL, NULL); arg0 VARCHAR2(1) := null; begin :1 := "CTXSYS"."TEXTOPTSTATS".ODCIStatsFunctionCost( sys.ODCIFuncInfo('CTXSYS', 'CTX_CONTAINS', 'TEXTCONTAINS', 2), cost, sys.ODCIARGDESCLIST(sys.ODCIARGDESC(2, 'PHYSICAL_CONTENT_REVISION', 'S3TEST', '"FULL_DESCRIPTION"', NULL, NULL, NULL), sys.ODCIARGDESC(1, NULL, NUL L, NULL, NULL, NULL, NULL)) , arg0, :5, sys.ODCIENV(:6,:7,:8,:9)); if cost.CPUCost IS NULL then :2 := -1.0; else :2 := cost.CPUCost; end if; if cost.IOCost IS NULL then :3 := -1.0; else :3 := cost.IOCost; end if; if cost.NetworkCost IS NULL then :4 := -1.0; else :4 := cost.NetworkCost; end if; exception when others then raise; end; ----- PL/SQL Call Stack ----- object line object handle number name 0xde9c8d08 79 CTXSYS.TEXTOPTSTATS 0xde7ebbc0 6 anonymous block 0xde9832a0 10 function S3TEST.SEARCHCONTENTFORKEYWORDS 0xde2f5fe8 1 anonymous block ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedst()+31 call ksedst1() 000000000 ? 000000001 ? 2B42B1E7CD50 ? 2B42B1E7CDB0 ? 2B42B1E7CCF0 ? 000000000 ? ksedmp()+610 call ksedst() 000000000 ? 000000001 ? 2B42B1E7CD50 ? 2B42B1E7CDB0 ? 2B42B1E7CCF0 ? 000000000 ? ssexhd()+629 call ksedmp() 000000003 ? 000000001 ? 2B42B1E7CD50 ? 2B42B1E7CDB0 ? 2B42B1E7CCF0 ? 000000000 ? _L_mutex_unlock_15( call ssexhd() 00000000B ? 2B42B1E7DD70 ? )+29 2B42B1E7DC40 ? 2B42B1E7CDB0 ? 2B42B1E7CCF0 ? 000000000 ? drexumcx()+89 signal _L_mutex_unlock_15( 2B42B1F19F18 ? 000000002 ? ) 2B42B23B9840 ? 000000003 ? 2B42B23B9640 ? 2B42B23BAA60 ? drexofcost()+143 call drexumcx() 7FFFFA9386D0 ? 000000002 ? 2B42B23B9840 ? 000000003 ? 2B42B23B9640 ? 2B42B23BAA60 ? spefcpfa()+867 call drexofcost() 7FFFFA939C30 ? 2B42B23B9918 ? 2B42B23B9840 ? 2B42B23B9718 ? 2B42B23B9640 ? 2B42B23BAA60 ? spefmccallstd()+993 call spefcpfa() FFFFFFFFFFFFFFFF ? 2B42B1F24990 ? 2B42B1F249D8 ? 7FFFFA938B70 ? 2B42B23B9640 ? 2B42B23BAA60 ? pextproc()+41 call spefmccallstd() 7FFFFA939C90 ? 7FFFFA939910 ? 7FFFFA9396B8 ? 7FFFFA939620 ? 000000000 ? 2B42B23BAA60 ? peftrusted()+158 call pextproc() 7FFFFA939C90 ? 7FFFFA939910 ? 7FFFFA9396B8 ? 7FFFFA939620 ? 000000000 ? 2B42B23BAA60 ? psdexsp()+248 call peftrusted() 7FFFFA939C90 ? 7FFFFA939910 ? 7FFFFA9396B8 ? 7FFFFA939620 ? 000000000 ? 2B42B23BAA60 ? rpiswu2()+420 call psdexsp() 7FFFFA9394A8 ? 7FFFFA939C90 ? 7FFFFA9396B8 ? 000020003 ? 0047B0976 ? 7FFFFA93A7C0 ? psdextp()+739 call rpiswu2() 0DF7323B0 ? 000000025 ? 7FFFFA939488 ? 000000002 ? 7FFFFA9394E0 ? 000000025 ? pefccal()+571 call psdextp() 7FFFFA93A7C0 ? 7FFFFA939910 ? 7FFFFA9396B8 ? 000000000 ? 7FFF00020003 ? 7FFFFA939C90 ? pefcal()+208 call pefccal() 004C6086E ? 7FFFFA939910 ? 7FFFFA9396B8 ? 0066876E0 ? 000798AE0 ? 7FFFFA939C90 ? pevm_FCAL()+173 call pefcal() 7FFFFA939C90 ? 006687860 ? 2B42B1F56BC8 ? 0066876E0 ? 000798AE0 ? 7FFFFA939C90 ? pfrinstr_FCAL()+79 call pevm_FCAL() 2B42B1F56BC8 ? 0A7832890 ? 2B42B1F56BC8 ? 0A7F07C88 ? 000798AE0 ? 7FFFFA939C90 ? pfrrun_no_tool()+65 call pfrinstr_FCAL() 2B42B1F56BC8 ? 0A764BD7E ? 2B42B1F56C30 ? 0A7F07C88 ? 000798AE0 ? 7FFFFA939C90 ? pfrrun()+906 call pfrrun_no_tool() 2B42B1F56BC8 ? 0A764BD7E ? 2B42B1F56C30 ? 0A7F07C88 ? 000798AE0 ? 7FFFFA939C90 ? plsql_run()+841 call pfrrun() 2B42B1F56BC8 ? 000000000 ? 2B42B1F56C30 ? 7FFFFA93A7C0 ? 000798AE0 ? 0C7A2D2C2 ? peicnt()+298 call plsql_run() 2B42B1F56BC8 ? 000000001 ? 000000000 ? 7FFFFA93A7C0 ? 000798AE0 ? 900000000 ? kkxexe()+503 call peicnt() 7FFFFA93A7C0 ? 2B42B1F56BC8 ? 2B42B1F282A8 ? 7FFFFA93A7C0 ? 2B42B1F24518 ? 900000000 ? opiexe()+4691 call kkxexe() 2B42B23D2830 ? 2B42B1F56BC8 ? 2B42B1F282A8 ? 0DFF46798 ? 0040C47BF ? 900000000 ? opiodr()+984 call opiexe() 000000004 ? 000000004 ? 7FFFFA93CB80 ? 00000001F ? 0040C47BF ? 900000000 ? rpidrus()+198 call opiodr() 000000004 ? 000000004 ? 7FFFFA93CB80 ? 00000001F ? 0059B04C0 ? 900000000 ? skgmstack()+158 call rpidrus() 7FFFFA93C3D8 ? 000000004 ? 7FFFFA93CB80 ? 00000001F ? 0059B04C0 ? 900000000 ? rpidru()+116 call skgmstack() 7FFFFA93C3B0 ? 0066872C0 ? 00000F618 ? 0022E9B48 ? 7FFFFA93C3D8 ? 900000000 ? rpiswu2()+420 call rpidru() 7FFFFA93CA70 ? 0066872C0 ? 00000F618 ? 0022E9B48 ? 7FFFFA93C3D8 ? 900000000 ? rpidrv()+1519 call rpiswu2() 0DF7323B0 ? 000000034 ? 0DF7323EC ? 000000002 ? 2B42B1F2FB10 ? 7FFF00000034 ? rpiexe()+65 call rpidrv() 00000001F ? 000000004 ? 7FFFFA93CB80 ? 00000000B ? 2B42B1F2FB10 ? 7FFF00000034 ? kkexfuncfEval()+195 call rpiexe() 00000001F ? 000000004 ? 2 7FFFFA93CB80 ? 00000000B ? 2B42B1F2FB10 ? 7FFF00000034 ? kkexfuncf()+4635 call kkexfuncfEval() 2B42B23BF0C0 ? 000000034 ? 00000A146 ? 000000005 ? 2B42B23BF7A0 ? 7FFFFA93F378 ? kkexFunc()+265 call kkexfuncf() 0C7A78660 ? 7FFFFA93F4B0 ? 7FFFFA93F4A8 ? 2B42B23BF0C0 ? 2B4200000000 ? 2B42B23BF090 ? kkeOperCost1()+164 call kkexFunc() 2B42B1F03F48 ? 2B42B1F65C50 ? 7FFFFA93F530 ? 7FFFFA93F538 ? 7FEFFFFFFFFFFFFF ? 0D2E799A0 ? kkeOperCost1()+1788 call kkeOperCost1() 2B42B1F03F48 ? 2B42B1F65C50 ? 7FFFFA93F740 ? 7FFFFA93F738 ? 7FFFFA93F8F0 ? 7FFFFA93F8F4 ? kkeOperCost()+326 call kkeOperCost1() 2B42B1F03D70 ? 2B42B1F65C50 ? 7FFFFA9403B0 ? 7FFFFA9403B8 ? 7FFFFA93F8F0 ? 7FFFFA93F8F4 ? kkepsl()+1942 call kkeOperCost() 2B42B1F03D70 ? 2B42B1F65C50 ? 7FFFFA9403B0 ? 7FFFFA9403B8 ? 7FFFFA93F8F0 ? 7FFFFA93F8F4 ? kkeosl()+1003 call kkepsl() 2B42B1F03D70 ? 7FFFFA940358 ? 000000000 ? 2B42B1F65C50 ? 7FFFFA93F8F0 ? 7FFFFA93F8F4 ? kkecdn()+8503 call kkeosl() 2B42B1F041C8 ? 7FFFFA941CE0 ? 000000000 ? 000000001 ? 7FFF00000000 ? 2B42B1F65C50 ? kkotap()+16656 call kkecdn() 2B42B1F6F490 ? 000000002 ? 2B42B1F0CC80 ? 2B42B1F0E1A8 ? 2B42B1F0DC68 ? 2B42B1F65C50 ? kkoiqb()+11059 call kkotap() 2B42B1F0DC68 ? 2B42B1F0E4A0 ? 000000011 ? 000000000 ? 000000000 ? 2B42B1F65C50 ? kkooqb()+986 call kkoiqb() 2B42B1F0E1A8 ? 000000000 ? 000000000 ? 000000000 ? 000000000 ? 2B42B1F65C50 ? kkoqbc()+2083 call kkooqb() 2B42B1F06DD8 ? 000000000 ? 000000000 ? 000000004 ? 000000000 ? 000000008 ? apakkoqb()+170 call kkoqbc() 7FFFFA945150 ? 2B42B1F06DD8 ? 000000000 ? 000000001 ? 000000000 ? 000000000 ? apaqbdDescendents() call apakkoqb() 7FFFFA945150 ? 2B42B1F06DD8 ? +399 0C7A788D8 ? 000000001 ? 000000000 ? 000000000 ? apaqbdListReverse() call apaqbdDescendents() 7FFFFA945150 ? 2B42B1F06DD8 ? +68 0C7A788D8 ? 000000001 ? 000000000 ? 000000000 ? apadrv()+586 call apaqbdListReverse() 7FFFFA945150 ? 2B42B1F06DD8 ? 0C7A788D8 ? 000000001 ? 000000000 ? 000000000 ? opitca()+1512 call apadrv() 0C7A788D8 ? 2B42B1F06DD8 ? 0C7A788D8 ? 000000001 ? 000000000 ? 000000000 ? kksFullTypeCheck()+ call opitca() 2B42B1F41D90 ? 0C7A788D8 ? 30 0C7A788D8 ? 000000001 ? 000000000 ? 000000000 ? rpiswu2()+420 call kksFullTypeCheck() 7FFFFA9466F8 ? 0C7A788D8 ? 0C7A788D8 ? 000000001 ? 000000000 ? 000000000 ? kksLoadChild()+9500 call rpiswu2() 0DF7323B0 ? 000000034 ? 0B9347F9C ? 000000002 ? 0B9347C00 ? 100000034 ? kxsGetRuntimeLock() call kksLoadChild() 0066876E0 ? 0D1A9AB30 ? +1353 7FFFFA947B90 ? 000000000 ? 0B9347E38 ? 2B42B1F41D90 ? kksfbc()+15084 call kxsGetRuntimeLock() 0066876E0 ? 2B42B1F41D90 ? 7FFFFA947B90 ? 000000000 ? 0B9347E38 ? 2B42B1F41D90 ? opiexe()+1884 call kksfbc() 2B42B1F41D90 ? 000000003 ? 000000102 ? 000000000 ? 000000000 ? 7FFFFA948890 ? opipls()+2025 call opiexe() 000000004 ? 000000005 ? 7FFFFA94910C ? 000000016 ? 000000000 ? 7FFFFA948890 ? opiodr()+984 call opipls() 000000066 ? 000000006 ? 7FFFFA94A800 ? 000000000 ? 2B42B1F41D90 ? 000000000 ? rpidrus()+198 call opiodr() 000000066 ? 000000006 ? 7FFFFA94A800 ? 000000016 ? 0059B1410 ? 000000000 ? skgmstack()+158 call rpidrus() 7FFFFA949E48 ? 000000006 ? 7FFFFA94A800 ? 000000016 ? 0059B1410 ? 000000000 ? rpidru()+116 call skgmstack() 7FFFFA949E20 ? 0066872C0 ? 00000F618 ? 0022E9B48 ? 7FFFFA949E48 ? 000000000 ? rpiswu2()+420 call rpidru() 7FFFFA94A4E0 ? 0066872C0 ? 00000F618 ? 0022E9B48 ? 7FFFFA949E48 ? 000000000 ? rpidrv()+1519 call rpiswu2() 0DF7323B0 ? 000000034 ? 7FFFFA94A4C0 ? 000000002 ? 7FFFFA94A528 ? 000000034 ? psddr0()+438 call rpidrv() 000000016 ? 000000066 ? 7FFFFA94A800 ? 000000078 ? 7FFFFA94A528 ? 000000034 ? psdnal()+386 call psddr0() 000000016 ? 000000066 ? 7FFFFA94A800 ? 000000070 ? 7FFFFA94A528 ? 000000034 ? pevm_EXECC()+376 call psdnal() 7FFFFA94B340 ? 7FFFFA94B530 ? 7FFFFA94A800 ? 2B42B1F0FE88 ? 00000000B ? 000000034 ? pfrinstr_EXECC()+80 call pevm_EXECC() 2B42B2406228 ? 7FFFFA94B530 ? 000000020 ? 2B42B1F0FE88 ? 00000000B ? 000000034 ? pfrrun_no_tool()+65 call pfrinstr_EXECC() 2B42B2406228 ? 0C73CFDC2 ? 2B42B2406290 ? 2B42B1F0FE88 ? 00000000B ? 7FFF00000020 ? pfrrun()+906 call pfrrun_no_tool() 2B42B2406228 ? 0C73CFDC2 ? 2B42B2406290 ? 2B42B1F0FE88 ? 00000000B ? 7FFF00000020 ? plsql_run()+841 call pfrrun() 2B42B2406228 ? 000000000 ? 2B42B2406290 ? 7FFFFA94B340 ? 00000000B ? 0C7648946 ? peicnt()+298 call plsql_run() 2B42B2406228 ? 000000001 ? 000000000 ? 7FFFFA94B340 ? 00000000B ? 900000000 ? kkxexe()+503 call peicnt() 7FFFFA94B340 ? 2B42B2406228 ? 2B42B1F26DC8 ? 7FFFFA94B340 ? 2B42B1F24518 ? 900000000 ? opiexe()+4691 call kkxexe() 2B42B1F5F8E0 ? 2B42B2406228 ? 2B42B1F26DC8 ? 0DFF46798 ? 0040C47BF ? 900000000 ? kpoal8()+2273 call opiexe() 000000049 ? 000000003 ? 7FFFFA94C590 ? 000000011 ? 0040C47BF ? 900000000 ? opiodr()+984 call kpoal8() 00000005E ? 000000017 ? 7FFFFA94F470 ? 000000011 ? 000000001 ? 900000000 ? ttcpip()+1012 call opiodr() 00000005E ? 000000017 ? 7FFFFA94F470 ? 000000000 ? 0059B12D0 ? 900000000 ? opitsk()+1322 call ttcpip() 00668F3B0 ? 7FFFFA94D400 ? 7FFFFA94F470 ? 000000000 ? 7FFFFA94EF68 ? 7FFFFA94F5D8 ? opiino()+1026 call opitsk() 000000003 ? 000000000 ? 7FFFFA94F470 ? 000000001 ? 000000000 ? 4E526F400000001 ? opiodr()+984 call opiino() 00000003C ? 000000004 ? 7FFFFA950638 ? 000000000 ? 000000000 ? 4E526F400000001 ? opidrv()+547 call opiodr() 00000003C ? 000000004 ? 7FFFFA950638 ? 000000000 ? 0059B0D80 ? 4E526F400000001 ? sou2o()+114 call opidrv() 00000003C ? 000000004 ? 7FFFFA950638 ? 000000000 ? 0059B0D80 ? 4E526F400000001 ? opimai_real()+163 call sou2o() 7FFFFA950610 ? 00000003C ? 000000004 ? 7FFFFA950638 ? 0059B0D80 ? 4E526F400000001 ? main()+116 call opimai_real() 000000002 ? 7FFFFA9506A0 ? 000000004 ? 7FFFFA950638 ? 0059B0D80 ? 4E526F400000001 ? __libc_start_main() call main() 000000002 ? 7FFFFA9506A0 ? +244 000000004 ? 7FFFFA950638 ? 0059B0D80 ? 4E526F400000001 ? _start()+41 call __libc_start_main() 000713938 ? 000000002 ? 7FFFFA9507F8 ? 000000000 ? 0059B0D80 ? 000000002 ? --------------------- Binary Stack Dump --------------------- ...
文档:
ORA-7445 (drexumcx)
Bug 5905736 - Dump (drexumcx) from Text query
补丁:
XF11.1OREDEF - TRC - DREXUMCX
-fin-
No comments:
Post a Comment