Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Logs getting filled with Indexing warnings

Avatar

Avatar
Validate 10
Level 3
ranadyutis95334
Level 3

Likes

10 likes

Total Posts

57 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
ranadyutis95334
Level 3

Likes

10 likes

Total Posts

57 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
ranadyutis95334
Level 3

19-09-2016

Hi,

In the log files I am getting the below warnings related to indexing. How to prevent it or what action is required?

 

19.09.2016 13:50:56.565 *WARN* [10.148.117.100 [1474291853171] GET /bin/security/authorizables.json HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 409000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [nt:base] as a where [rep:principalName] is not null and isdescendantnode(a, '/home') /* xpath: /jcr:root/home//element(*)[@rep:principalName] */, path=/home//*, property=[rep:principalName=[is not null]]); consider creating an index or changing the query
19.09.2016 13:51:00.035 *WARN* [10.148.117.100 [1474291853171] GET /bin/security/authorizables.json HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 410000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [nt:base] as a where [rep:principalName] is not null and isdescendantnode(a, '/home') /* xpath: /jcr:root/home//element(*)[@rep:principalName] */, path=/home//*, property=[rep:principalName=[is not null]]); consider creating an index or changing the query
19.09.2016 13:51:05.281 *WARN* [10.148.117.100 [1474291853171] GET /bin/security/authorizables.json HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 411000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [nt:base] as a where [rep:principalName] is not null and isdescendantnode(a, '/home') /* xpath: /jcr:root/home//element(*)[@rep:principalName] */, path=/home//*, property=[rep:principalName=[is not null]]); consider creating an index or changing the query
19.09.2016 13:51:08.999 *WARN* [10.148.117.100 [1474291853171] GET /bin/security/authorizables.json HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 412000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [nt:base] as a where [rep:principalName] is not null and isdescendantnode(a, '/home') /* xpath: /jcr:root/home//element(*)[@rep:principalName] */, path=/home//*, property=[rep:principalName=[is not null]]); consider creating an index or changing the query

Replies

Avatar

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,406 likes

Total Posts

12,671 posts

Correct Reply

2,278 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give back 900
Give back 600
View profile

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,406 likes

Total Posts

12,671 posts

Correct Reply

2,278 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give back 900
Give back 600
View profile
smacdonald2008
Level 10

19-09-2016

Looks like Indexing is not configured properly. Watch this GEMS session on Indexing: 

https://docs.adobe.com/ddc/en/gems/oak-lucene-indexes.html

Hope this helps... 

Avatar

Avatar
Give Back 50
Employee
Feike_Visser1
Employee

Likes

247 likes

Total Posts

970 posts

Correct Reply

221 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Give Back 50
Employee
Feike_Visser1
Employee

Likes

247 likes

Total Posts

970 posts

Correct Reply

221 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
Feike_Visser1
Employee

19-09-2016

What version of AEM is this?

Avatar

Avatar
Validate 10
Level 3
ranadyutis95334
Level 3

Likes

10 likes

Total Posts

57 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
ranadyutis95334
Level 3

Likes

10 likes

Total Posts

57 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
ranadyutis95334
Level 3

19-09-2016

6.1

Avatar

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,406 likes

Total Posts

12,671 posts

Correct Reply

2,278 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give back 900
Give back 600
View profile

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,406 likes

Total Posts

12,671 posts

Correct Reply

2,278 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give back 900
Give back 600
View profile
smacdonald2008
Level 10

19-09-2016

Did you configure Indexing as explained in the GEMs session that i referened?

Avatar

Avatar
Boost 5
Employee
vmehrotr
Employee

Likes

19 likes

Total Posts

43 posts

Correct Reply

5 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Employee
vmehrotr
Employee

Likes

19 likes

Total Posts

43 posts

Correct Reply

5 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
vmehrotr
Employee

19-09-2016

Disable the ootb property index 'authorizables' by changing type to disabled.

Apply the lucene based index.

<authorizables jcr:primaryType="oak:QueryIndexDefinition" async="async" compatVersion="{Long}2" name="authorizables" reindex="{Boolean}true" indexPath="/oak:index/authorizables" excludedPaths="[/var,/etc/replication,/etc/workflow/instances,/jcr:system]" type="lucene"> <aggregates jcr:primaryType="nt:unstructured"> <rep:Authorizable jcr:primaryType="nt:unstructured"> <include0 jcr:primaryType="nt:unstructured" path="profile" relativeNode="{Boolean}false"/> </rep:Authorizable> </aggregates> <indexRules jcr:primaryType="nt:unstructured"> <rep:Authorizable jcr:primaryType="nt:unstructured"> <properties jcr:primaryType="nt:unstructured"> <repPrincipalName jcr:primaryType="nt:unstructured" analyzed="{Boolean}true" name="rep:principalName" ordered="{Boolean}true" propertyIndex="{Boolean}true" type="String"/> <repAuthorizableId jcr:primaryType="nt:unstructured" analyzed="{Boolean}true" name="rep:authorizableId" ordered="{Boolean}true" propertyIndex="{Boolean}true" type="String"/> <profileEmail jcr:primaryType="nt:unstructured" analyzed="{Boolean}true" name="profile/email" ordered="{Boolean}false" propertyIndex="{Boolean}true" type="String"/> <profileGivenName jcr:primaryType="nt:unstructured" analyzed="{Boolean}true" name="profile/givenName" ordered="{Boolean}false" propertyIndex="{Boolean}true" type="String"/> <profileFamilyName jcr:primaryType="nt:unstructured" analyzed="{Boolean}true" name="profile/familyName" ordered="{Boolean}false" propertyIndex="{Boolean}true" type="String"/> <profileGender jcr:primaryType="nt:unstructured" analyzed="{Boolean}true" name="profile/gender" ordered="{Boolean}false" propertyIndex="{Boolean}true" type="String"/> </properties> </rep:Authorizable> </indexRules> </authorizables>

Avatar

Avatar
Validate 1
Level 1
mayankm1988
Level 1

Like

1 like

Total Posts

7 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
mayankm1988
Level 1

Like

1 like

Total Posts

7 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
mayankm1988
Level 1

19-06-2017

Hi All,

We facing same issue in AEM 6.1.

Is this resolved issue by creating index.

vmehrotr​ the query mentioned is on nt:base and index is on rep:Authorizable will this be picked up by the query engine or do we need to create index on nt:base.

Avatar

Avatar
Level 1
somasreeb857955
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
somasreeb857955
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
somasreeb857955
Level 1

02-08-2019

Looks like we had the same query traversal on our 6.2 AEM few days earlier,

30.07.2019 15:36:32.032 *WARN* [130.208.54.25 [1564500088801] GET /bin/security/authorizables.json HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 2035000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [nt:base] as a where [rep:principalName] is not null and isdescendantnode(a, '/home') /* xpath: /jcr:root/home//element(*)[@rep:principalName] */, path=/home//*, property=[rep:principalName=[is not null]]); consider creating an index or changing the query

Is there any particular source for such queries like being system generated, or been particularly when run by someone against the home path?