Home » Server Options » Text & interMedia » ORA-03113 error while creating text index
ORA-03113 error while creating text index [message #76065] Thu, 02 October 2003 03:43 Go to next message
Juan Salvador
Messages: 4
Registered: July 2003
Junior Member
Hi,
I'm trying to create an intermedia index over a table with 60000 rows. To get a better performance, I increased MAX_INDEX_MEMORY parameter up to 128M and issued the create index command with the 'memory 128M' parameter. The creation operation fails with an "ORA-03113: end-of-file on communication channel" error. An here is an excerpt of the trace file:

Unix process pid: 19476, image: oracle@curvaton (TNS V1-V3)

*** 2003-09-29 19:39:37.262
*** SESSION ID:(22.49001) 2003-09-29 19:39:37.262
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x2f2f3a70, PC: [[0x2f2f3a70, 2F2F3A70]]
Registers:
%eax: 0x00002d5f %ebx: 0x7474682f %ecx: 0xbffdaf58
%edx: 0x4044c500 %edi: 0x2f2f3a70 %esi: 0x2f3a7074
%esp: 0xbffdaf58 %ebp: 0x7474682f %eip: 0x2f2f3a70
%efl: 0x00010286
*** 2003-09-29 19:39:37.265
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [[2F2F3A70]] [[SIGSEGV]] [[Address not mapped to object]] [[0x2F2F3A70]] [[]] [[]]
Current SQL statement for this session:
create index indice_url on url_busqueda ( url )
indextype is ctxsys.context
parameters ( 'Datastore URL_PREF
filter USER_FILTER_PREF
lexer spanish_lexer
stoplist spanish_stoplist
wordlist spanish_wordlist
memory 32M')
----- PL/SQL Call Stack -----
object line object
handle number name
0x67d02d38 244 package body CTXSYS.DRIDISP
0x67d02d38 412 package body CTXSYS.DRIDISP
0x67d02d38 369 package body CTXSYS.DRIDISP
0x67cd4cc0 750 package body CTXSYS.DRIDDL
0x679d8210 170 CTXSYS.TEXTINDEXMETHODS
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp()+269 call ksedst()+0 1 ? 0 ? 0 ? 1 ? 4059DA70 ?
46327830 ?

I've tried to gradually lower the memory parameter until reach its default value and the error still remains. I even restored MAX_INDEX_MEMORY to its default value without any result. Prior creation operations were succesfull, but after changing the MAX_INDEX_MEMORY parameter the creation process always fails.

Any ideas?

Thank you in advance
Re: ORA-03113 error while creating text index [message #76066 is a reply to message #76065] Mon, 06 October 2003 05:58 Go to previous messageGo to next message
Vincenzo D'Amore
Messages: 2
Registered: October 2003
Junior Member
I have the same problem but I'm tryng to build an index on a LONG field.

create index PIU_CNT_EDI_INDEX_XML on PIU_CNT_EDITORIALE(XML) indextype is ctxsys.context;

Now I suppose there is a problem with my version of Oracle, what is your current version/patch status?

This is the head of my trc file:

/oracle/app/oracle/817/admin/PIUENDB/udump/piuendb_ora_2190.trc
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
ORACLE_HOME = /oracle/app/oracle/817
System name: SunOS
Node name: elpep01s
Release: 5.8
Version: Generic_108528-10
Machine: sun4u
Instance name: PIUENDB
Redo thread mounted by this instance: 1
Oracle process number: 21
Unix process pid: 2190, image: oracle@elpep01s (TNS V1-V3)

*** 2003-10-02 16:48:03.829
*** SESSION ID:(20.49627) 2003-10-02 16:48:03.819
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x
1d2243c, PC: memcpy()+140
*** 2003-10-02 16:48:04.456
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [[memcpy()+140]] [[SIGSEGV]] [[Address no
t mapped to object]] [[30549052]] [[]] [[]]
Current SQL statement for this session:
select base."XML" from "BVUSERTMP"."PIU_CNT_EDITORIALE" base where rowid = :RID
----- PL/SQL Call Stack -----
object line object
handle number name
8ad24538 245 package body CTXSYS.DRIDISP
8ad24538 372 package body CTXSYS.DRIDISP
8ad24538 330 package body CTXSYS.DRIDISP
8b979d24 580 package body CTXSYS.DRIDDL
8af319fc 55 CTXSYS.TEXTINDEXMETHODS
1a3f0bc 1 anonymous block
Re: ORA-03113 error while creating text index [message #76067 is a reply to message #76066] Mon, 06 October 2003 06:37 Go to previous messageGo to next message
Juan Salvador
Messages: 4
Registered: July 2003
Junior Member
My current version is 9.2.0.4. For your trace I can see you are using 8.1.7. I know that there is a patch for your version that it's supossed to solve similar problems. You can find it at Metalink. However, I haven`t found anything similar for 9.2.0.4
Re: ORA-03113 error while creating text index [message #76068 is a reply to message #76067] Mon, 06 October 2003 07:56 Go to previous message
Vincenzo D'Amore
Messages: 2
Registered: October 2003
Junior Member
Thanks you very much, so I'll try to install the latest patches available.

Best regards and good luck for your problem.
Vincenzo
Previous Topic: InterMedia - File DataStore
Next Topic: index problem in oracle text
Goto Forum:
  


Current Time: Fri Mar 29 10:34:48 CDT 2024