Hi, The query engine is using the nodetype index on "nen:resource" instead of the property index on "nen:type". I guess there are many nodes with type / mixin "nen:resource".
Which version of Oak are you using? This should be fixed in Oak 1.0.2. (I can find the Oak issue number if you need it.) Regards, Thomas On 15/07/14 00:21, "Torgeir Veimo" <[email protected]> wrote: >I' seeing logs like > >00:11:55,702 DEBUG jackrabbit.JackrabbitQuery.getQueryString() - line >242 [127.0.0.1] - queryString: >/jcr:root/nen:content/pages-en//element(*,nen:resource)[@nen:type = >'0'] > >00:11:55,706 WARN >strategy.ContentMirrorStoreStrategy$PathIterator.fetchNextPossiblyDuplicat >e() >- line 278 [127.0.0.1] - Traversed 1000 nodes using index >jcr:mixinTypes with filter Filter(query=select [jcr:path], >[jcr:score], * from [nen:resource] as a where [nen:type] = '0' and >isdescendantnode(a, '/nen:content/pages-en') /* xpath: >/jcr:root/nen:content/pages-en//element(*,nen:resource)[@nen:type = >'0'] */, path=/nen:content/pages-en//*, property=[nen:type=0]) >[...] > >which I guess indicates that I need an index here (on jcr:path)? > >I've currently set up indexes in an RepositoryInitializer class with > >IndexUtils.createIndexDefinition(index, "nen:resourceid", true, false, >org.elasticsearch.common.collect.ImmutableList.of("nen:resourceid"), >null); >IndexUtils.createIndexDefinition(index, "nen:type", true, false, >org.elasticsearch.common.collect.ImmutableList.of("nen:type"), null); >IndexUtils.createIndexDefinition(index, "nen:name", true, false, >org.elasticsearch.common.collect.ImmutableList.of("nen:name"), null); > > >My /oak:index node contains index definitions for > >nen:type, acPrincipalName, uuid, nen:resourceid,nen:name, nodetype, >reference, principalName, lucene, authorizableId. > >-- >-Tor
