Locations of visitors to this page

Friday, February 13, 2009

ora-7445 drexumcx

又一个BUG

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

Website Analytics

Followers