My Oracle Support Banner

On 11.2.0.4 Indexing a Zipped File Hangs (Doc ID 1682027.1)

Last updated on JUNE 20, 2017

Applies to:

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

Symptoms

Since upgrading to 11.2.0.4, ctx_ddl.sync_index or CREATE INDEX ... INDEXTYPE IS CTXSYS.CONTEXT hangs and spins on CPU when index'ing a zipped file:

SQL> select count(*) from FILEBLOBTAB_ONE_RECORD;

  COUNT(*)
----------
         1

SQL> select ROOTID, BLB_CONTENTTYPE, BLB_FILEEXTENSION from FILEBLOBTAB_ONE_RECORD;

ROOTID     BLB_CONTENTTYPE                BLB_FILEE
---------- ------------------------------ ---------
1jd6m.ac   application/x-zip-compressed   zip

SQL> begin
  2    ctx_ddl.create_preference('"FILEBLOBTAB_IDX_DST"','DIRECT_DATASTORE');
  3  end;
  4  /

PL/SQL procedure successfully completed.

SQL>
SQL> begin
  2    ctx_ddl.create_preference('"FILEBLOBTAB_IDX_FIL"','AUTO_FILTER');
  3  end;
  4  /

PL/SQL procedure successfully completed.

17:09:10 SQL> create index FILEBLOBTAB_IDX
17:09:10   2  on FILEBLOBTAB_ONE_RECORD ("BLB_BLOBFIELD")
17:09:10   3  indextype is ctxsys.context
17:09:10   4  parameters('datastore "FILEBLOBTAB_IDX_DST" filter "FILEBLOBTAB_IDX_FIL"')
17:09:10   5  /

Checking the process list shows ctxhx is hanging and using up most of the cpu.

UID        PID  PPID   C   STIME   TTY   TIME   CMD
oracle   29866     1  78   Aug 20    ? 1981:19  /app/oracle/product/11.2.0.4/ctx/bin/ctxhx /tmp//drgib_Pbvya /tmp//drgit_Tbvyb ASCII8 utf8 H NOMETA 120 HEURISTIC FORMAT NOPDFROTATE /tmp//drgitmp_Tbvyc ENCRYPTED

The same issue occurs with or without Patch 17762528.

A report from hanganalyze or hangfg may show that the index'ing is hanging on:

select column_value from table(cast(ctxsys.drvparx.ParallelPopuIndex(cursor(select /*+ DYNAMIC_SAMPLING(0) PARALLEL(base 4) FULL(base) NOCACHE(base) */ rowid, NULL, NULL, NULL, NULL, 'N', base."DATA"
from "<INDEX_OWNER>"."<INDEX_NAME>" base), :idxownid, :idxid, :idxown, :idxname, :ixpname,:popstate) as sys.odcivarchar2list))

Changes

Upgraded to 11.2.0.4.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.