You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@directory.apache.org by "John Peter (JIRA)" <ji...@apache.org> on 2016/08/08 12:46:20 UTC
[jira] [Comment Edited] (DIRSERVER-2162) Searcing for users using
ObjectClass=person takes long
[ https://issues.apache.org/jira/browse/DIRSERVER-2162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15411748#comment-15411748 ]
John Peter edited comment on DIRSERVER-2162 at 8/8/16 12:45 PM:
----------------------------------------------------------------
Hi,
thanks Emmannuel for getting back to me so quickly.
I'm not sure where can I see the full amount of entries.
Under the Search base: ou=users,dc=xxx,dc=fi we have # numEntries : 23506
The other parts combined have much fewer entries.
Searching for (objectClass=person) shows # numEntries : 21586
We are using Apache 2.0.0-M20.
I modified the C:\Program Files (x86)\ApacheDS\instances\default\conf\log4j.properties by adding:
log4j.logger.org.apache.directory.server.xdbm.search.impl.DefaultSearchEngine=DEBUG
Restarted apacheDS service.
Re did the query (&(cn=*PETEJO*)(objectClass=person))
and the wrapper.log shows the below:
INFO | jvm 1 | 2016/08/08 15:40:43 | [15:40:43] DEBUG [org.apache.directory.server.xdbm.search.impl.DefaultSearchEngine] - Nb results : 21586 for filter : (&:[21586](&:[21586](cn=*petejo*:[21627])(objectClass=person:[21586]))(#{SUBTREE_SCOPE (Estimated), 'ou=users,dc=hus,dc=fi', DEREF_ALWAYS}:[23506]))
Re did the query
(&(cn=*PETEJO*)(objectClass=*))
and the wrapper.log shows the below:
INFO | jvm 1 | 2016/08/08 15:41:50 | [15:41:50] DEBUG [org.apache.directory.server.xdbm.search.impl.DefaultSearchEngine] - Nb results : 1 for filter : (&:[21627](cn=*petejo*:[21627])(#{SUBTREE_SCOPE (Estimated), 'ou=users,dc=hus,dc=fi', DEREF_ALWAYS}:[23506]))
was (Author: jmrpet):
Hi,
thanks Emmannuel for getting back to me so quickly.
I'm not sure where can I see the full amount of entries.
Under the Search base: ou=users,dc=xxx,dc=fi we have # numEntries : 23506
The other parts combined have much fewer entries.
We are using Apache 2.0.0-M20.
I modified the C:\Program Files (x86)\ApacheDS\instances\default\conf\log4j.properties by adding:
log4j.logger.org.apache.directory.server.xdbm.search.impl.DefaultSearchEngine=DEBUG
Restarted apacheDS service.
Re did the query (&(cn=*PETEJO*)(objectClass=person))
and the wrapper.log shows the below:
INFO | jvm 1 | 2016/08/08 15:40:43 | [15:40:43] DEBUG [org.apache.directory.server.xdbm.search.impl.DefaultSearchEngine] - Nb results : 21586 for filter : (&:[21586](&:[21586](cn=*petejo*:[21627])(objectClass=person:[21586]))(#{SUBTREE_SCOPE (Estimated), 'ou=users,dc=hus,dc=fi', DEREF_ALWAYS}:[23506]))
Re did the query
(&(cn=*PETEJO*)(objectClass=*))
and the wrapper.log shows the below:
INFO | jvm 1 | 2016/08/08 15:41:50 | [15:41:50] DEBUG [org.apache.directory.server.xdbm.search.impl.DefaultSearchEngine] - Nb results : 1 for filter : (&:[21627](cn=*petejo*:[21627])(#{SUBTREE_SCOPE (Estimated), 'ou=users,dc=hus,dc=fi', DEREF_ALWAYS}:[23506]))
> Searcing for users using ObjectClass=person takes long
> ------------------------------------------------------
>
> Key: DIRSERVER-2162
> URL: https://issues.apache.org/jira/browse/DIRSERVER-2162
> Project: Directory ApacheDS
> Issue Type: Bug
> Affects Versions: 2.0.0-M20
> Reporter: John Peter
>
> When we do the below query the result takes long. Around 10-50 seconds.
> Search base: ou=users,dc=xxx,dc=fi
> Filter (&(cn=*USERNAME*)(objectClass=person))
> Scope: Subtree
> However the below query returns the result immediately
> Search base: ou=users,dc=xxx,dc=fi
> Filter (&(cn=*USERNAME*)(objectClass=*))
> Scope: Subtree
> Looking at the Partition settings it has Indexed attributes ObjectClass and cn.
> First both queries took long. Then we added cn to the index and rebooted apacheDS and the second query got fast.
> It seems like a bug that using ObjectClass in the query makes it slow all tough it is in the index.
> It seems something similar was reported before DIRSERVER-2048, but it says it's fixed in M20 which we are using.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)