Creating Oracle Text index on a PDF file is spinning on CPU and does not complete (Doc ID 1636477.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Text - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Creating this index with

CREATE INDEX TESTCASE.IX_DOKUMENT_PRILOHA_TST ON
TESTCASE.DOKUMENT_PRILOHA_TST(SOUBOR)
 INDEXTYPE IS CTXSYS.CONTEXT
     FILTER BY
"DOKUMENT_PRILOHA_ID","DOKUMENT_ID","LANG_CODE","PLATNA_VERZE","STATUS","CSS_P
RILOHA_ID"
      PARAMETERS ('DATASTORE CTXSYS.DIRECT_DATASTORE
                   FILTER CTXSYS.AUTO_FILTER
                   LEXER TESTCASE.LEXER_NOSTEM
                   STOPLIST TESTCASE.CZECH_STOPLIST
                   STORAGE TESTCASE.IX_DOKUMENT_TELO_TEXT_STO
                   MEMORY 128M
                   SYNC (EVERY "SYSDATE + 1")');

with
'TESTCASE.LEXER_NOSTEM'= 'AUTO_LEXER'
'TESTCASE.LEXER_NOSTEM'='BASE_LETTER','YES'
'TESTCASE.IX_DOKUMENT_TELO_TEXT_STO'='BASIC_STORAGE'

spins up the CPU

top - 13:45:18 up 21 days, 17:44, 10 users,  load average: 1.11, 0.88, 0.55
Tasks: 529 total,   2 running, 527 sleeping,   0 stopped,   0 zombie
Cpu(s):  6.5%us,  0.2%sy,  0.0%ni, 93.3%id,  0.0%wa,  0.0%hi,  0.0%si,
0.0%st
Mem:  82441404k total, 81257696k used,  1183708k free,   696964k buffers
Swap: 33551744k total,   168276k used, 33383468k free, 75215336k cached

 PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
19253 bugmnt    25   0  706m 113m  83m R 99.9  0.1   6:07.77 oracle
18777 bugmnt    15   0  746m 141m  32m S  2.7  0.2   0:15.14 java
....

and seems it is never ending.


Errorstack shows:
Current SQL Statement:
select column_value from
table(cast(ctxsys.drvparx.ParallelPopuIndex(cursor(select /*+
DYNAMIC_SAMPLING(0) PARALLEL(base 6) FULL(base) NOCACHE(base) */ rowid, NULL,
NULL, NULL, NULL,
'N',base."CSS_PRILOHA_ID",base."DOKUMENT_ID",base."DOKUMENT_PRILOHA_ID",base."
LANG_CODE",base."PLATNA_VERZE",base."STATUS", base."SOUBOR"    from
"DOC"."DOKUMENT_PRILOHA" base), :idxownid, :idxid, :idxown, :idxname,
:ixpname,:popstate) as sys.odcivarchar2list))


Call Stack:
lxoMonoCmp lxoCmpStr drlibsltr drliblnorm druixputtkn inlxo2iatlx inlxo2iatlxs drlitoken drepprep dreb_populate drftpara drexpmain



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms