Hi,
when we call the ctx_doc.gist procedure the second or more number of times we get End-of-communication error and instance hangs.
Contents:
1) Code used to create the URL_Datastore Index.
2) PL/SQL block used to invoke ctx_doc.Gist proc.
3) Trace file generated by Oracle in user_dump_dest.
----------------------------------------------------
1) Below is the code that we used to create the index :
CREATE TABLE DOCSVIB (
IDDOC NUMBER NOT NULL,
TEXTDOCURL VARCHAR2 (80),
PRIMARY KEY ( IDDOC ));
INSERT INTO DOCSVIB ( IDDOC, TEXTDOCURL ) VALUES (111, '
DECLARE
BEGIN
ctx_ddl.drop_preference('URL_PREFvib');
ctx_ddl.create_preference('URL_PREFvib','URL_DATASTORE');
ctx_ddl.set_attribute('URL_PREFvib','NO_PROXY','localhost');
ctx_ddl.set_attribute('URL_PREFvib','Timeout','300');
END;
CREATE INDEX datastores_textvib ON DOCSVIB ( TEXTDOCURL )
indextype IS ctxsys.context
parameters ( 'Datastore URL_PREFvib');
--------
2) Below is the PL/SQL block to invoke the GIST proc. This block, when executed consecutively in the same session for the 4th time, the connection to the server is lost. GTEMP_GIST is the result table.
DECLARE
BEGIN
ctx_doc.Gist('datastores_textvib',TO_CHAR (111),'GTEMP_GIST',2004,'S','GENERIC',1,80);
END;
-------
3) Trace file dump.
Dump file E:\Oracle\admin\IPA\udump\ORA01080.TRC
Wed Mar 19 11:43:36 2003
ORACLE V8.1.7.3.0 - Production vsnsta=0
vsnsql=f vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production
With the Partitioning option
JServer Release 8.1.7.3.0 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Instance name: ipa
Redo thread mounted by this instance: 1
Oracle process number: 12
Windows thread id: 1080, image: ORACLE.EXE
*** 2003-03-19 11:43:36.963
*** SESSION ID10.6) 2003-03-19 11:43:36.923
FATAL ERROR IN TWO-TASK SERVER: error = 12571
*** 2003-03-19 11:43:36.963
ksedmp: internal or fatal error
Current SQL statement for this session:
DECLARE
BEGIN
ctx_doc.Gist('datastores_textvib',TO_CHAR(111),'GTEMP_GIST',2004,'S','GENERIC',1,80);
END;
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedmp+a8 CALLrel _ksedst+0
66E470
_opitsk+f4a CALLrel _ksedmp+0 2
_opiino+50c CALLrel _opitsk+0 0
_opiodr+507 CALLreg 00000000 3C 4
B66FBF8
_opidrv+384 CALLrel _opiodr+0 3C 4
B66FBF8
0
_sou2o+19 CALLrel _opidrv+0
_opimai+10c CALLrel _sou2o+0
_OracleThreadStart@4+4b8 CALLrel _opimai+0 2
B66FE74
77E87587 CALLreg 00000000
----- Argument/Register Address Dump -----
Argument/Register addr=b66e470.
Dump of memory from 0xB66E430 to 0xB66E570
B66E430 00000003 00000000 65522100 00000033 [.........!Re3...]
when we call the ctx_doc.gist procedure the second or more number of times we get End-of-communication error and instance hangs.
Contents:
1) Code used to create the URL_Datastore Index.
2) PL/SQL block used to invoke ctx_doc.Gist proc.
3) Trace file generated by Oracle in user_dump_dest.
----------------------------------------------------
1) Below is the code that we used to create the index :
CREATE TABLE DOCSVIB (
IDDOC NUMBER NOT NULL,
TEXTDOCURL VARCHAR2 (80),
PRIMARY KEY ( IDDOC ));
INSERT INTO DOCSVIB ( IDDOC, TEXTDOCURL ) VALUES (111, '
DECLARE
BEGIN
ctx_ddl.drop_preference('URL_PREFvib');
ctx_ddl.create_preference('URL_PREFvib','URL_DATASTORE');
ctx_ddl.set_attribute('URL_PREFvib','NO_PROXY','localhost');
ctx_ddl.set_attribute('URL_PREFvib','Timeout','300');
END;
CREATE INDEX datastores_textvib ON DOCSVIB ( TEXTDOCURL )
indextype IS ctxsys.context
parameters ( 'Datastore URL_PREFvib');
--------
2) Below is the PL/SQL block to invoke the GIST proc. This block, when executed consecutively in the same session for the 4th time, the connection to the server is lost. GTEMP_GIST is the result table.
DECLARE
BEGIN
ctx_doc.Gist('datastores_textvib',TO_CHAR (111),'GTEMP_GIST',2004,'S','GENERIC',1,80);
END;
-------
3) Trace file dump.
Dump file E:\Oracle\admin\IPA\udump\ORA01080.TRC
Wed Mar 19 11:43:36 2003
ORACLE V8.1.7.3.0 - Production vsnsta=0
vsnsql=f vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production
With the Partitioning option
JServer Release 8.1.7.3.0 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Instance name: ipa
Redo thread mounted by this instance: 1
Oracle process number: 12
Windows thread id: 1080, image: ORACLE.EXE
*** 2003-03-19 11:43:36.963
*** SESSION ID10.6) 2003-03-19 11:43:36.923
FATAL ERROR IN TWO-TASK SERVER: error = 12571
*** 2003-03-19 11:43:36.963
ksedmp: internal or fatal error
Current SQL statement for this session:
DECLARE
BEGIN
ctx_doc.Gist('datastores_textvib',TO_CHAR(111),'GTEMP_GIST',2004,'S','GENERIC',1,80);
END;
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedmp+a8 CALLrel _ksedst+0
66E470
_opitsk+f4a CALLrel _ksedmp+0 2
_opiino+50c CALLrel _opitsk+0 0
_opiodr+507 CALLreg 00000000 3C 4
B66FBF8
_opidrv+384 CALLrel _opiodr+0 3C 4
B66FBF8
0
_sou2o+19 CALLrel _opidrv+0
_opimai+10c CALLrel _sou2o+0
_OracleThreadStart@4+4b8 CALLrel _opimai+0 2
B66FE74
77E87587 CALLreg 00000000
----- Argument/Register Address Dump -----
Argument/Register addr=b66e470.
Dump of memory from 0xB66E430 to 0xB66E570
B66E430 00000003 00000000 65522100 00000033 [.........!Re3...]