I am getting the below errors on AEM 6.1 author instance,
30.01.2018 07:19:52.640 *WARN* [qtp2102344124-8253] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 100000 nodes with filter Filter(query=select h.[jcr:path] as [jcr:path], h.[jcr:score] as [jcr:score], h.* from [nt:base] as a inner join [nt:base] as b on ischildnode(b, a) inner join [nt:base] as c on ischildnode(c, b) inner join [nt:base] as d on ischildnode(d, c) inner join [nt:base] as e on ischildnode(e, d) inner join [nt:base] as f on ischildnode(f, e) inner join [nt:base] as g on ischildnode(g, f) inner join [nt:base] as h on ischildnode(h, g) where name(a) = 'content' and name(b) = 'mc' and name(c) = 'offer-exchange' and name(d) = 'platinum' and name(e) = 'ap' and name(f) = 'en' and name(g) = 'lifestyle' and name(h) = 'Paradisus-Los-Cabos.html' /* xpath: //content/mc/offer-exchange/platinum /ap/en/lifestyle/Paradisus-Los-Cabos.html */, path=*, property=[:localname=[content]]); consider creating an index or changing the query I have added the below lucene index but it is not being used as index when I run explain query <custom_offer_ntbase_search compatVersion="{Long}2" async="async" jcr:primaryType="oak:QueryIndexDefinition" type="lucene" reindex="{Boolean}true" excludedPaths="[/var,/etc,/jcr:system,/content/dam,/apps,/libs,/tmp,/conf,/bin]">
Can you advise if I need to and how I can create a property “:localname=[content]]”
