Continued index_param failed for indexed attributes (ITS#2381)

[quanah@stanford.edu]

Full_Name: Quanah Gibson-Mount
Version: 2.1.16
OS: Solaris 8
URL: ftp://ftp.openldap.org/incoming/
Submission from: (NULL) (171.66.182.82)


With 2.1.16, I have:

exported my db
removed the BDB attributes (entryCSN, entryUUID)
re-imported my db

started doing searches.

It now takes 20+ seconds to do a filter with uid searching for attribute
sumaildrop, where in the past it took less than 1.

Note that a filter of suseassunetid searching on attribute sumaildrop takes less
than 1 second (log follows indices).

Indexing from conf file:
# Indices to maintain
index   default         eq
index   cn              eq,sub,approx
index   sn              eq,sub
index   suAffiliation   pres,eq,sub
index   suSunetID       pres,eq,sub
index   suDisplayAffiliation    pres,eq,sub
index   uid             pres,eq,sub
index   dc
index   description
index   displayName
index   gidNumber
index   gecos
index   givenName
index   krb5PrincipalName
index   labeledURI
index   loginShell
index   mail
index   mobile
index   o
index   objectClass
index   ou
index   pager
index   suDisplayNameLF
index   suRegisteredName
index   suRegisteredNameLF
index   suMaildrop
index   suRegID
index   suPrivilegeGroup
index   suSeasSunetID
index   suUniqueIdentifier
index   suSeasUriRouteTo
index   telephoneNumber
index   title
index   uidNumber

Mar 16 01:31:16 ldap-test2.Stanford.EDU slapd[19215]: [ID 848112 local4.debug]
c
onn=3 fd=10 ACCEPT from IP=172.24.14.250:51007 (IP=0.0.0.0:389)
Mar 16 01:31:16 ldap-test2.Stanford.EDU slapd[19215]: [ID 902418 local4.debug]
c
onn=3 op=0 SRCH base="" scope=0 filter="(objectClass=*)"
Mar 16 01:31:16 ldap-test2.Stanford.EDU slapd[19215]: [ID 706578 local4.debug]
c
onn=3 op=0 SRCH attr=supportedSASLMechanisms
Mar 16 01:31:16 ldap-test2.Stanford.EDU slapd[19215]: [ID 217296 local4.debug]
c
onn=3 op=0 RESULT tag=101 err=0 text=
Mar 16 01:31:16 ldap-test2.Stanford.EDU slapd[19215]: [ID 347666 local4.debug]
c
onn=3 op=1 BIND dn="" method=163
Mar 16 01:31:16 ldap-test2.Stanford.EDU slapd[19215]: [ID 951063 local4.debug]
c
onn=3 op=3 BIND authcid="quanah@stanford.edu"
Mar 16 01:31:16 ldap-test2.Stanford.EDU slapd[19215]: [ID 996101 local4.debug]
c
onn=3 op=3 BIND dn="uid=quanah,cn=accounts,dc=stanford,dc=edu" mech=GSSAPI
ssf=5
6
Mar 16 01:31:16 ldap-test2.Stanford.EDU slapd[19215]: [ID 902418 local4.debug]
c
onn=3 op=4 SRCH base="cn=accounts,dc=stanford,dc=edu" scope=2
filter="(uid=quana
h)"
Mar 16 01:31:16 ldap-test2.Stanford.EDU slapd[19215]: [ID 706578 local4.debug]
c
onn=3 op=4 SRCH attr=sumaildrop
Mar 16 01:31:38 ldap-test2.Stanford.EDU slapd[19215]: [ID 362707 local4.debug]
c
onn=3 op=4 SEARCH RESULT tag=101 err=0 nentries=1 text=
Mar 16 01:31:38 ldap-test2.Stanford.EDU slapd[19215]: [ID 338319 local4.debug]
c
onn=3 op=5 UNBIND
Mar 16 01:31:38 ldap-test2.Stanford.EDU slapd[19215]: [ID 850449 local4.debug]
c
onn=3 fd=10 closed