告警日志:
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