My Oracle Support Banner

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 JULY 12, 2019

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=xx' filter='(|(mail=user@company.us)(mailAlternateAddress=user@company.us)(mailEquivalentAddress=user@company.us))' scope='sub'

Changes

 

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


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