This discussion is archived
3 Replies Latest reply: Feb 19, 2013 10:13 AM by 991721 RSS

DRG-11225: Third-party filter timed out

991721 Newbie
Currently Being Moderated
Hello,

I am facing the following problem when indexing a column:

DRG-11207: user filter command exited with status 2
DRG-11225: Third-party filter timed out.

I am using Ubuntu 10.04.2 LTS and Oracle Database 11g Enterprise Edition Release 11.2.0.1.0

I have a column named URL in a table named DOCUMENTO_CONSULTA
This column contains file URLs (2 rows involved in the test)
I am confident that the paths that appear in the two rows of the URL column are correct (because if I change
them to something different another error appear that says, as expected, that files could not be found). I am sure
that access to the files is granted. FILE_ACCESS_ROLE is set to CTXAPP and role is granted to the user. File
and path permission are set to 777.
The two rows contains paths to simple DOC and PDF content, with just one paragraph each.

I am using the following configuration:

ctx_ddl.create_preference ('ajn_doc_cons_datastore', 'URL_DATASTORE');
ctx_ddl.set_attribute ('ajn_doc_cons_datastore', 'urlsize', 1024);

ctx_ddl.create_preference ('ajn_doc_cons_filter', 'AUTO_FILTER');
ctx_ddl.set_attribute ('ajn_doc_cons_filter', 'timeout', 0);

ctx_ddl.create_preference ('ajn_spanish_lexer', 'BASIC_LEXER');
ctx_ddl.set_attribute ('ajn_spanish_lexer', 'base_letter', 'YES');
ctx_ddl.set_attribute ('ajn_spanish_lexer', 'index_themes', 'NO');
ctx_ddl.set_attribute ('ajn_spanish_lexer', 'index_stems', 7);
ctx_ddl.set_attribute ('ajn_spanish_lexer', 'index_text', 'YES');

ctx_ddl.create_preference ('ajn_spanish_wordlist', 'BASIC_WORDLIST');
ctx_ddl.set_attribute ('ajn_spanish_wordlist', 'stemmer', 'SPANISH');
ctx_ddl.set_attribute ('ajn_spanish_wordlist', 'fuzzy_match', 'SPANISH');

The sentence to create the index is:

create index ajn_doc_cons_idx on documento_consulta(URL)
indextype is ctxsys.context
parameters ('LEXER ajn_spanish_lexer DATASTORE ajn_doc_cons_datastore FILTER ajn_doc_cons_filter WORDLIST ajn_spanish_wordlist ')

I've tried changing URL_DATASTORE to FILE_DATASTORE (with no attributes) but the result is the same

Here's the configuration I've set in /etv/environment:

PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/mnt/oracle/app/oracle/product/11.2.0/dbhome_1/bin:/mnt/oracle/app/oracle/product/11.2.0/dbhome_1/ctx/bin"
TMPDIR=/tmp
ORACLE_HOSTNAME=--------- (my host name)
ORACLE_BASE=/mnt/oracle/app/oracle
ORACLE_HOME=/mnt/oracle/app/oracle/product/11.2.0/dbhome_1
ORACLE_SID=orcl
ORACLE_TERM=xterm
LD_LIBRARY_PATH=/mnt/oracle/app/oracle/product/11.2.0/dbhome_1/ctx/lib:/mnt/oracle/app/oracle/product/11.2.0/dbhome_1/lib

If I try to use ctxhx from the console everything works OK and twoHTML files corresponding to the two rows are generated with no errors at all.

I haven't found any relevant information in forums and docs. I don't have any more ideas, so any answer would be appreciated.

Thanks in advance

Edited by: 988718 on 18-feb-2013 7:16
  • 1. Re: DRG-11225: Third-party filter timed out
    991721 Newbie
    Currently Being Moderated
    I've simplified the creation of the index to this:


    create index ajn_doc_cons_idx on documento_consulta(URL) indextype is ctxsys.context parameters ('DATASTORE ctxsys.file_datastore FILTER ctxsys.auto_filter')


    And of course I've change the URL of the columns to paths in the filesystem. Paths are ok.

    Problem keeps happening.
  • 2. Re: DRG-11225: Third-party filter timed out
    Roger Ford Expert
    Currently Being Moderated
    Ubuntu is not a supported platform for Oracle, so it's hard to answer this.

    However, if you want to try to debug it, replace the "ctxhx" executable with a shell script which dumps its arguments and the current environment to a file.

    You can then use that output to create a shell with the same environment, and see if command line ctxhx still works. If not, you'll have to figure out what the differences are between the two environments.
  • 3. Re: DRG-11225: Third-party filter timed out
    991721 Newbie
    Currently Being Moderated
    I don't know how to do that, I'm a newbie, but I understand that help about this topic is beyond the scope of this thread.
    Anyway, I tried the same scenario (Oracle version, database, parameters, index...) in Fedora 17 and it worked,
    so I guess that the settings are ok and the problem is located in the link between Ubuntu and Oracle (or maybe I did a
    bad Oracle installation).

    Thank you very much.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points