[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
RE: Continued index_param failed for indexed attributes (ITS#2381)
Howard,
Sorry about that. I did a grep on the connection, forgetting that the
index_param failed message doesn't show up as being part of the connection.
Here is the complete log at loglevel 256:
Mar 16 01:31:16 ldap-test2.Stanford.EDU slapd[19215]: [ID 848112
local4.debug] conn=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] conn=3 op=0 SRCH base="" scope=0 filter="(objectClass=*)"
Mar 16 01:31:16 ldap-test2.Stanford.EDU slapd[19215]: [ID 706578
local4.debug] conn=3 op=0 SRCH attr=supportedSASLMechanisms
Mar 16 01:31:16 ldap-test2.Stanford.EDU slapd[19215]: [ID 217296
local4.debug] conn=3 op=0 RESULT tag=101 err=0 text=
Mar 16 01:31:16 ldap-test2.Stanford.EDU slapd[19215]: [ID 347666
local4.debug] conn=3 op=1 BIND dn="" method=163
Mar 16 01:31:16 ldap-test2.Stanford.EDU slapd[19215]: [ID 951063
local4.debug] conn=3 op=3 BIND authcid="quanah@stanford.edu"
Mar 16 01:31:16 ldap-test2.Stanford.EDU slapd[19215]: [ID 996101
local4.debug] conn=3 op=3 BIND
dn="uid=quanah,cn=accounts,dc=stanford,dc=edu" mech=GSSAPI ssf=56
Mar 16 01:31:16 ldap-test2.Stanford.EDU slapd[19215]: [ID 902418
local4.debug] conn=3 op=4 SRCH base="cn=accounts,dc=stanford,dc=edu"
scope=2 filter="(uid=quanah)"
Mar 16 01:31:16 ldap-test2.Stanford.EDU slapd[19215]: [ID 706578
local4.debug] conn=3 op=4 SRCH attr=sumaildrop
Mar 16 01:31:16 ldap-test2.Stanford.EDU slapd[19215]: [ID 925615
local4.debug] <= bdb_equality_candidates: (uid) index_param failed (18)
Mar 16 01:31:38 ldap-test2.Stanford.EDU slapd[19215]: [ID 362707
local4.debug] conn=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] conn=3 op=5 UNBIND
--On Sunday, March 16, 2003 2:56 AM -0800 Howard Chu <hyc@highlandsun.com>
wrote:
> 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
>>
>>
>>
>>
>
--
Quanah Gibson-Mount
Senior Systems Administrator
ITSS/TSS/Computing Systems
Stanford University
GnuPG Public Key: http://www.stanford.edu/~quanah/pgp.html