Re: Seemingly broken database

[Quanah Gibson-Mount <quanah@zimbra.com>]

--On Friday, December 09, 2011 1:14 PM +0100 Peter Mogensen <apm@one.com> 
wrote:

> Hi,
>
> I have a large database with several million entries, which for a few
> specific entries takes very long (several minutes) to search.
>
> Looking at the debug output the search suddenly goes into a mode where it
> tests a lot of completely irrelevant entries and outputs a lot of
> "bdb_search: <number> scope not okay" messages - which takes very long
> time before the query ends.
>
> I've tried deleting all indexes and re-indexing with slapdindex, but the
> problem persists - also with 2.4.28.
> It's BDB 4.8.26 with back_bdb.

4.8.26 was pulled by Oracle.  The only version available for download is 
4.8.30.  I would advise updating BDB as a first step.

Also, confirming you are using back-bdb not back-hdb as your backend?

--Quanah


--

Quanah Gibson-Mount
Sr. Member of Technical Staff
Zimbra, Inc
A Division of VMware, Inc.
--------------------
Zimbra ::  the leader in open source messaging and collaboration