ORA-20000 DRG-50610 DRG-10607 since upgrading to 11.2.0.2 when updating a table with Text index (Doc ID 1321570.1)

Last updated on JUNE 22, 2015

Applies to:

Oracle Text - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 11-Sep-2013***

Symptoms

Since upgrading to 11.2.0.2, updating a column with a Text index fails with errors:

SQL> CREATE INDEX TS_TEXT_IDX
  on TEST ( TS_TEXT_SYNC )
INDEXTYPE IS CTXSYS.CONTEXT;

Index created.

SQL> SELECT TS_TEXT_SYNC FROM TEST
 WHERE CONTAINS ( TS_TEXT_SYNC,'sat on the mat' ) > 0;

TS_TEXT_SYNC
----------------------------------------------------
The cat sat on the mat

SQL> update test
 set TS_TEXT_SYNC = 'Updating the indexed column'
  where test_id = 1;

1 row updated.

SQL> commit;
commit
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-20000: Oracle Text error:
DRG-50610: internal error: drexdsync
DRG-10607: index meta data is not ready yet for queuing DML
ORA-06512: at "CTXSYS.SYNCRN", line 1
ORA-06512: at line 1

Changes

The database was upgraded to 11.2.0.2.

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