On 7/19/07, Srilakshmanan, Kumuthiny Kumuthiny.Srilakshmanan@auspost.com.au wrote:
Hi
I have a OpenLDAP version 2.2 on ldbm database under unix with 2500 users. I'm aware upgrading is an option but it is not clear whether it would resolve my issue as stated below.
A search query returns a subset of the expected results.
I reindexed the data and there was no change in the results returned.
An update action to a user id not visible in the initial query becomes visible in subsequent queries.
After an export of the data(slapcat) and import (slapadd) to an empty data store,the same query as above returns the expected results.
After a period of time further queries return only a subset of the expected result set.
Please find below the slapd.conf and data base size
# Caches cachesize 100000 dbcachesize 10000000
index objectClass eq index cn eq index uid eq,sub index sn eq index groups eq
#user limitations -1 no limit sizelimit 10000 timelimit 60
Well, if your searches are taking longer than sixty seconds, or you expect them to return more than ten thousand records, then things are okay. However, you're probably asking for help because that is not the case. :)
Please try to reproduce this problem with some level of debugging to see if, possibly, you're running into an err=80 (this will show up even in 256 logging), a bug where your database slows way down after some set number of queries (I had this problem with ldbm), or something a little less obvious.
It might be easier for you to ugprade to 2.3.x + bdb and see if that just works. With such a small database, migrating the data is going to be very, very easy.