RE: Continued index_param failed for indexed attributes (ITS#2381)

[hyc@highlandsun.com]

There's not enough detail in your log to indicate any problem. In particular,
there is no "index_param failed" message to indicate that there is any
trouble with your indices, so I don't understand why you've listed that in
the subject of this report.  Do you actually have a log that shows this
message, or any more details? Level 5 would probably be enough.

  -- Howard Chu
  Chief Architect, Symas Corp.       Director, Highland Sun
  http://www.symas.com               http://highlandsun.com/hyc
  Symas: Premier OpenSource Development and Support

> -----Original Message-----
> From: owner-openldap-bugs@OpenLDAP.org
> [mailto:owner-openldap-bugs@OpenLDAP.org]On Behalf Of
> quanah@stanford.edu
> Sent: Sunday, March 16, 2003 1:39 AM
> To: openldap-its@OpenLDAP.org
> Subject: Continued index_param failed for indexed attributes
> (ITS#2381)
>
>
> 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
>
>
>
>