Highlighted

Query Index Missing Warning when accessing Assets Folder in AEM 6.3

Avatar

Avatar

gauravs23

Avatar

gauravs23

gauravs23

22-05-2018

We have an images folder for our project in ASSETS section, which has more than 1000 images in it. Whenever the authors access that images folder through Assets section (http://localhost:4502/assets.html/content/dam/abc/content-images), the following warning is printed in the logs, which warns about the missing index for the query that is fired when that images folder is accessed.

    *WARN* GET /assets.html/content/dam/abc/content-images HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 1000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [nt:base] as a where ischildnode(a, '/content/dam/abc/content-images') and [hidden] = 'false' union select [jcr:path], [jcr:score], * from [nt:base] as a where ischildnode(a, '/content/dam/abc/content-images') and [hidden] is null order by [jcr:created] desc /* xpath: /jcr:root/content/dam/abc/content-images/*[((@hidden = 'false' or not(@hidden)))] order by @jcr:created descending */, path=/content/dam/abc/content-images/*, property=[hidden=[false]]); consider creating an index or changing the query

We have not yet created any custom index for damAssets, as the above query is automatically fired by AEM when navigating through the Assets section and as there is no custom implementation done by us, we didn't create any index.

For analysis, I tried to run the above query and a simplified version of the above query - select [jcr:path], [jcr:score] from [nt:base] as a where ischildnode(a, '/content/dam/abc/content-images') through Explain Query tool and it mentions that no indexes were used in the query and it is a traversal query. The results are still returned with this query as well and it prints the same warning.

Has anyone else has found such warnings when navigating through assets? Looking for some help from the community here.

Replies

Highlighted

Avatar

Avatar

kautuk_sahni

Community Manager

Total Posts

5.5K

Likes

955

Correct Answer

1.1K

Avatar

kautuk_sahni

Community Manager

Total Posts

5.5K

Likes

955

Correct Answer

1.1K
kautuk_sahni
Community Manager

24-05-2018

Checking this with the team!!

Highlighted

Avatar

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Answer

2.3K

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Answer

2.3K
smacdonald2008

24-05-2018

It certainly appears that the warning is because there is no Index here.

Highlighted

Avatar

Avatar

gauravs23

Avatar

gauravs23

gauravs23

24-05-2018

smacdonald2008 Yes, the warning clearly says consider creating an index. But this warning is appearing only in Author instance when accessing a particular folder in Assets and the query being printed in the warning seems to be internally fired by AEM. Ideally damAssetLucene index should take of all these index requirements where no custom development/customization has been done. What do you think?

Highlighted

Avatar

Avatar

abera

Avatar

abera

abera

05-05-2020

Hi @gauravs23 , I am having the same issue. Can you please tell how you fixed this.