[Fedora-directory-users] big searches dont return anything

[Stéphane Konstantaropoulos]

Le mercredi 10 jan 2007 15:18, Richard Megginson a écrit :
> Stéphane Konstantaropoulos wrote:
> > Le mardi 09 jan 2007 18:50, David Boreham a écrit :
> >> Stéphane Konstantaropoulos wrote:
> >>> [09/Jan/2007:11:08:15 +0000] conn=914 op=7 SRCH base="o=sghms.ac.uk"
> >>> scope=2
> >>> filter="(|(&(objectClass=person)(cn=*smith*))(&(objectClass=person)
> >>> (uid=smith)))" attrs=ALL
> >>> [09/Jan/2007:11:08:15 +0000] conn=914 op=7 RESULT err=0 tag=101
> >>> nentries=0 etime=0
> >>>
> >>> seems to be no error at all.
> >>>
> >>> size limit is set to 10000, time limit to 3600 and lookthrough to 20000
> >>> (is that  right? it's on the LDBM plug-in settings).
> >>>
> >>> Does this make sense to anybody?
> >>
> >> Not yet. Can you post a successful search and an example of one of the
> >> entries returned ?
> >> The above log seems to indicate that there really are no target entries
> >> in the database,
> >> but there could be other explainations such as ACL preventing their
> >> access, database corrupt, etc.
> >
> > Here you go, I first search on "k", then "ko", then "kon", then "kons"
> > returns results.
> >
> > Yes, i think my db may be a bit funny, I just deleted all the indexes and
> > tried re-creating them, no change tho still. I set timelimit, sizelimit
> > and lookthrough limit to -1, so as to have no limit at all now.
> >
> > [10/Jan/2007:13:24:26 +0000] conn=24 op=62 SRCH
> > base="o=sghms.ac.uk,o=sghms.ac.uk" scope=2
> > filter="(|(&(objectClass=person)
> > (cn=*k*))(&(objectClass=person)(uid=k)))" attrs=ALL
> > [10/Jan/2007:13:24:26 +0000] conn=24 op=62 RESULT err=0 tag=101
> > nentries=0 etime=0
> > [10/Jan/2007:13:24:29 +0000] conn=24 op=64 SRCH base="" scope=0
> > filter="(| (objectClass=*)(objectClass=ldapsubentry))"
> > attrs="nsBackendSuffix" [10/Jan/2007:13:24:29 +0000] conn=24 op=64 RESULT
> > err=0 tag=101 nentries=1 etime=0
> > [10/Jan/2007:13:24:29 +0000] conn=24 op=65 SRCH base="cn=userRoot,cn=ldbm
> > database, cn=plugins, cn=config" scope=1 filter="(objectClass=vlvSearch)"
> > attrs=ALL
> > [10/Jan/2007:13:24:29 +0000] conn=24 op=65 RESULT err=0 tag=101
> > nentries=4 etime=0
> > [10/Jan/2007:13:24:29 +0000] conn=24 op=66 SRCH
> > base="o=sghms.ac.uk,o=sghms.ac.uk" scope=2
> > filter="(|(&(objectClass=person)
> > (cn=*kon*))(&(objectClass=person)(uid=kon)))" attrs=ALL
> > [10/Jan/2007:13:24:29 +0000] conn=24 op=66 RESULT err=0 tag=101
> > nentries=0 etime=0
>
> Hmm - no unindexed notes in the results.  Do you know how many entries
> match *kon*?  How many match *kons*?
>

"kons" matched 5 entries, "kon" not sure. Anyway, it was definitely a database 
corruption problem, I emptied the directory and re-populated it with a script 
I have and now it finds everybody and returns an ADMINLIMIT_EXCEEDED error 
when it reaches the limit, I set it to no limit now because I have a 40k 
entries.

It'd be nice if it noticed by itself that the db is corrupted. I also tried to 
delete all the indexes and then re-create them, which it did but that made no 
difference.

Anyway, thanks for helping,

-- 
Stéphane Konstantaropoulos <skonstant at sgul.ac.uk>
-- Web Developer - Computing Services
--- St George's University of London
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/fedora-directory-users/attachments/20070110/34df74a8/attachment.sig>