On 01/05/2011 09:16 AM, Orion Poplawski wrote: > On 01/05/2011 09:06 AM, Rich Megginson wrote: >> Try doing the ldapsearch you used to test, but add numSubordinates to >> the list >> of attributes to return: >> >> ldapsearch .... "big filter with (numSubordinates>=1) clause removed" \* >> numSubordinates > > Okay, something is wrong here. These results appear correct: Looks like a problem with the numSubordinates index - it looks like it is only indexed for presence - try adding an equality index for numSubordinates and reindex. I don't know when or why this changed - looks like a regression. > > [root at earth slapd-cora]# ldapsearch -Z -x -b "dc=cora,dc=nwra,dc=com" > -s one numSubordinates > # extended LDIF > # > # LDAPv3 > # base <dc=cora,dc=nwra,dc=com> with scope oneLevel > # filter: (objectclass=*) > # requesting: numSubordinates > # > > # nis, cora.nwra.com > dn: ou=nis,dc=cora,dc=nwra,dc=com > numSubordinates: 0 > > # auto.master, cora.nwra.com > dn: ou=auto.master,dc=cora,dc=nwra,dc=com > numSubordinates: 4 > > # auto.home, cora.nwra.com > dn: ou=auto.home,dc=cora,dc=nwra,dc=com > numSubordinates: 88 > > # auto.data, cora.nwra.com > dn: ou=auto.data,dc=cora,dc=nwra,dc=com > numSubordinates: 21 > > # auto.nfs, cora.nwra.com > dn: ou=auto.nfs,dc=cora,dc=nwra,dc=com > numSubordinates: 3 > > # auto.datag, cora.nwra.com > dn: ou=auto.datag,dc=cora,dc=nwra,dc=com > numSubordinates: 21 > > # auto.data4, cora.nwra.com > dn: ou=auto.data4,dc=cora,dc=nwra,dc=com > numSubordinates: 21 > > # auto.data4g, cora.nwra.com > dn: ou=auto.data4g,dc=cora,dc=nwra,dc=com > numSubordinates: 21 > > # search result > search: 3 > result: 0 Success > > # numResponses: 9 > # numEntries: 8 > > > But this is wrong: > > [root at earth slapd-cora]# ldapsearch -Z -x -b "dc=cora,dc=nwra,dc=com" > -s one 'numSubordinates>=1' numSubordinates > # extended LDIF > # > # LDAPv3 > # base <dc=cora,dc=nwra,dc=com> with scope oneLevel > # filter: numSubordinates>=1 > # requesting: numSubordinates > # > > # auto.home, cora.nwra.com > dn: ou=auto.home,dc=cora,dc=nwra,dc=com > numSubordinates: 88 > > # auto.data, cora.nwra.com > dn: ou=auto.data,dc=cora,dc=nwra,dc=com > numSubordinates: 21 > > # auto.datag, cora.nwra.com > dn: ou=auto.datag,dc=cora,dc=nwra,dc=com > numSubordinates: 21 > > # auto.data4, cora.nwra.com > dn: ou=auto.data4,dc=cora,dc=nwra,dc=com > numSubordinates: 21 > > # auto.data4g, cora.nwra.com > dn: ou=auto.data4g,dc=cora,dc=nwra,dc=com > numSubordinates: 21 > > # search result > search: 3 > result: 0 Success > > # numResponses: 6 > # numEntries: 5 > > > This works: > ldapsearch -Z -x -b "dc=cora,dc=nwra,dc=com" -s one > 'numSubordinates>0' numSubordinates > # numResponses: 9 > # numEntries: 8 > > I also tried >=2 through >=4 but none returned auto.master. >=22 > successfully eliminated the auto.data* entries. > >
