Reindexing Hangs with Errors : "ERROR<20995> - ... - database failed to get entry from id2entry file (id=39589), err=12" and "ERROR<20775> - Backend Database - ... - database error 12". (Doc ID 1390673.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Directory Server Enterprise Edition - Version 11.1.1.3.0 and later
Information in this document applies to any platform.
***Checked for relevance on 08-Nov-2013***

Symptoms

Original issue: Using ldapdelete, DELETE operations result in err=1:
ldap_delete: Operations error
or, for example:
[09/Nov/2011:15:59:24 +0530] conn=21140 op=1 msgId=2 - DEL dn="uid=user,ou=people,o=users,o=Support,o=org,dc=domain,dc=component"
[09/Nov/2011:15:59:24 +0530] conn=21140 op=1 msgId=2 - RESULT err=1 tag=107 nentries=0 etime=0 csn=4ebb6478001200050000
Entries can be modified by ldapmodify.
When entries modified using ldapmodify, the entry can be deleted.
Issue can not be reproduced when exporting and then importing to a new instance.
Issue occurs when backup created and then restored to a new instance.
Since modifying any attribute in the entry allows the entry to be deleted, reindexing was advised as the next step to remove any index corruption issues.

During reindex of database, reindexing does not complete and hangs at 99%:
[19/Dec/2011:18:35:04 +0530] - nic: Processing 340000 entries (99%).

Errors logged:
[19/Dec/2011:18:35:12 +0530] - DEBUG - conn=-1 op=-1 msgId=-1 - libdb: Lock table is out of available lock entries
[19/Dec/2011:18:35:12 +0530] - DEBUG - conn=-1 op=-1 msgId=-1 - libdb: Lock table is out of available lock entries
[19/Dec/2011:18:35:12 +0530] - ERROR<20995> - conn=-1 op=-1 msgId=-1 - database failed to get entry from id2entry file (id=39589), err=12
[19/Dec/2011:18:35:12 +0530] - ERROR<20775> - Backend Database - conn=4128 op=116 msgId=117 - database error 12

For specific ERROR<20775> logged (above), operation traced back in errors log shows that the operation resulted in an unindexed search:
[19/Dec/2011:18:34:51 +0530] - WARNING<20805> - Backend Database - conn=4128 op=116 msgId=117 - search is not indexed base='dc=nic,dc=us' filter='(|(mail=user@company.us)(mailAlternateAddress=user@company.us)(mailEquivalentAddress=user@company.us))' scope='sub'

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