Why Random Database Errors For Various Collection During Crawl Job?

(Doc ID 2121726.1)

Last updated on DECEMBER 08, 2017

Applies to:

Oracle Knowledge - Version 8.4.2.2 and later
Information in this document applies to any platform.

Symptoms

There are different types of errors that can happen on the database.  These errors generally mean there is a corruption in the index data.  They can happen for various reasons.

1. Stopping the indexing process / instance from weblogic or command line when a job is running. Also killing the process would be even worse.
2. Updating (commit to central repository) the dictionary when the job is running. The workbench user can enable disable and create rules or concepts WITHOUT committing to the working vcroot and that can cause a corruption.
3. The database connection dropping or going offline or the file system running out of space.

4. There are random intermittent CONCURRENT_COLLECTION_UPDATE failure with illegal collection status in various collections during crawl job like below.  this comes from running two indexers against the same database.

...

[82695 Local Workclient-default-taskrun(2266)] Event(Code=CONCURRENT_COLLECTION_UPDATE, id=#148B2I2266P2265) with Error occurred at 3/23/16 9:00 AM: Operation updateContent cannot be performed on collection COMMUNICATIONS due to illegal collection status CRAWL.
[82699 Local Workclient-default-taskrun(2267)] Event(Code=COLLECTION_UPDATE_FAILED, id=#148B2I2267P2265) with Error occurred at 3/23/16 9:00 AM: Unable to crawl collection COMMUNICATIONS, cause: com.inquira.content.ConcurrentUpdateException: Event (cc9b417b-4f42-4bd9-b239-b77bf832af53#148B2I2266P2265): [Local Workclient-default-taskrun @ Wed Mar 23 09:00:16 EDT 2016 - ContentUpdate] (CONCURRENT_COLLECTION_UPDATE updateContent COMMUNICATIONS CRAWL null)
com.inquira.content.ConcurrentUpdateException: Event (cc9b417b-4f42-4bd9-b239-b77bf832af53#148B2I2266P2265): [Local Workclient-default-taskrun @ Wed Mar 23 09:00:16 EDT 2016 - ContentUpdate] (CONCURRENT_COLLECTION_UPDATE updateContent COMMUNICATIONS CRAWL null)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
....
[179347 Local Workclient-default-taskrun(4528)] Event(Code=CONCURRENT_COLLECTION_UPDATE, id=#293B2I4528P4527) with Error occurred at 3/22/16 6:00 PM: Operation updateContent cannot be performed on collection POLICY_AND_PROCEDURES due to illegal collection status CRAWL.
[179351 Local Workclient-default-taskrun(4529)] Event(Code=COLLECTION_UPDATE_FAILED, id=#293B2I4529P4527) with Error occurred at 3/22/16 6:00 PM: Unable to crawl collection POLICY_AND_PROCEDURES, cause: com.inquira.content.ConcurrentUpdateException: Event (bcb086ec-6942-4665-8963-840ca5cea0bd#293B2I4528P4527): [Local Workclient-default-taskrun @ Tue Mar 22 18:00:37 EDT 2016 - ContentUpdate] (CONCURRENT_COLLECTION_UPDATE updateContent POLICY_AND_PROCEDURES CRAWL null)
com.inquira.content.ConcurrentUpdateException: Event (bcb086ec-6942-4665-8963-840ca5cea0bd#293B2I4528P4527): [Local Workclient-default-taskrun @ Tue Mar 22 18:00:37 EDT 2016 - ContentUpdate] (CONCURRENT_COLLECTION_UPDATE updateContent POLICY_AND_PROCEDURES CRAWL null)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
...

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