Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Text error when synchronizing index

536238Sep 27 2006 — edited Oct 31 2006
I've had a database that's been humming along with an Oracle Text index for about a month now, doing daily synchronizes to keep it up to date. One day, it began giving me the following error, and has done so ever since:

ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drekmap (lob write)
ORA-00600: internal error code, arguments: [9999], [], [], [], [], [], [], []
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 539
ORA-06512: at line 1

The command I'm running in SQLPlus is:
exec ctx_ddl.sync_index ('us_ws_ctx_idx1', '256M');

I tried varying the memory and the parrellelism parameters, to no effect.

I tried synchronizing with the following to produce an output log:
exec ctx_output.start_log ('contextbuginfo.txt', false);
exec ctx_output.add_event (CTX_OUTPUT.EVENT_INDEX_PRINT_ROWID);
exec ctx_ddl.sync_index ('us_ws_ctx_idx1', '256M');

The output log didn't appear to have anything particularily interesting or obvious. Here is the tail end of it:
---
10-35-00 09/22/06 Errors reading documents: 0
10-35-00 09/22/06 Index data for 3155931 documents to be written to database
10-35-00 09/22/06 memory use: 268435504
10-35-00 09/22/06 Begin sorting the inverted list.
10-35-02 09/22/06 End sorting the inverted list.
10-35-02 09/22/06 Writing index data ($I) to database.
11-18-34 09/22/06 Wrote 776605 rows (28611 big rows) to $I.
11-18-34 09/22/06 Writing index data ($K) to database.
11-19-46 09/22/06 Wrote 3155931 rows to $K.
11-19-46 09/22/06 Writing index data ($R) to database.
---


Does anyone have any ideas on how to fix this problem?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 28 2006
Added on Sep 27 2006
8 comments
9,958 views