[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: Missing/dropped indices?



On Wednesday 10 May 2006 02:48, Mark Mcdonald wrote:
> Howdy,
>
> I've come across a similar problem to that below, where indices seem to
> have gone AWOL.
>
> We have recently deployed some new servers running Debian Sarge (OpenLDAP
> 2.2.23) while our older systems are running Debian Woody (OpenLDAP 2.1.30).
>  We have the uid and auth fields indexed (for equality) and are present in
> all the records I've tested with.
>
> On the new systems

How did you initialiase these systems?

> , searching on the 'uid' attribute returns immediately 
> with no results, while searching on the 'auth' attribute returns the entire
> record, including the uid attribute.
>
> There is no trailing whitespace and I am matching the uid field correctly. 
> We have millions of entries in our directory so I am assuming the immediate
> response means openldap is looking up the index, not finding the field, and
> return no result.

This sounds like the indexing on (at least) uid was added *after* the entries 
were imported. re-index, or just re-import (which may be quicker).

Regards,
Buchan

-- 
Buchan Milne
ISP Systems Specialist
B.Eng,RHCE(803004789010797),LPIC-2(LPI000074592)

Attachment: pgpXRLuU3AcX7.pgp
Description: PGP signature