Traversal Warning : AEM 6.5.16

[Pandurang]

Hi,

Below are warnings coming continuously from AEM Production Publishers. Kindly help us with the same. Due to this, CPU utilization and load average are becoming very high, and Publihsers are going to be unresponsive some times.

Please check and do the needful for us.

08.11.2023 15:38:34.097 *WARN* [3.224.220.101 [1699438036101] GET /content/crisil/en/home/newsroom/press-releases/2022/02/for-housing-finance-cos-gnpas-rose-70-bps-on-tighter-norms-even-as-portfolio-quality-improved.html HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.Cursors$TraversingCursor Traversed 16000 nodes with filter Filter(query=SELECT([s].[personalizeTags] = 'crisil:Ratings/affordable-housing-financiers') and (isdescendantnode([s], [/content/crisil/en/home/our-analysis/reports])) ORDER BY ['customCreationDate'] desc, path=/content/crisil/en/home/our-analysis/reports//*, property=[personalizeTags=[crisil:Ratings/affordable-housing-financiers]]); consider creating an index or changing the query
08.11.2023 15:38:34.128 *WARN* [3.224.220.101 [1699438036101] GET /content/crisil/en/home/newsroom/press-releases/2022/02/for-housing-finance-cos-gnpas-rose-70-bps-on-tighter-norms-even-as-portfolio-quality-improved.html HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.Cursors$TraversingCursor Traversed 17000 nodes with filter Filter(query=SELECT([s].[personalizeTags] = 'crisil:Ratings/affordable-housing-financiers') and (isdescendantnode([s], [/content/crisil/en/home/our-analysis/reports])) ORDER BY ['customCreationDate'] desc, path=/content/crisil/en/home/our-analysis/reports//*, property=[personalizeTags=[crisil:Ratings/affordable-housing-financiers]]); consider creating an index or changing the query
08.11.2023 15:38:34.160 *WARN* [3.224.220.101 [1699438036101] GET /content/crisil/en/home/newsroom/press-releases/2022/02/for-housing-finance-cos-gnpas-rose-70-bps-on-tighter-norms-even-as-portfolio-quality-improved.html HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.Cursors$TraversingCursor Traversed 18000 nodes with filter Filter(query=SELECT([s].[personalizeTags] = 'crisil:Ratings/affordable-housing-financiers') and (isdescendantnode([s], [/content/crisil/en/home/our-analysis/reports])) ORDER BY ['customCreationDate'] desc, path=/content/crisil/en/home/our-analysis/reports//*, property=[personalizeTags=[crisil:Ratings/affordable-housing-financiers]]); consider creating an index or changing the query
08.11.2023 15:38:34.191 *WARN* [3.224.220.101 [1699438036101] GET /content/crisil/en/home/newsroom/press-releases/2022/02/for-housing-finance-cos-gnpas-rose-70-bps-on-tighter-norms-even-as-portfolio-quality-improved.html HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.Cursors$TraversingCursor Traversed 19000 nodes with filter Filter(query=SELECT([s].[personalizeTags] = 'crisil:Ratings/affordable-housing-financiers') and (isdescendantnode([s], [/content/crisil/en/home/our-analysis/reports])) ORDER BY ['customCreationDate'] desc, path=/content/crisil/en/home/our-analysis/reports//*, property=[personalizeTags=[crisil:Ratings/affordable-housing-financiers]]); consider creating an index or changing the query
08.11.2023 15:38:34.223 *WARN* [3.224.220.101 [1699438036101] GET /content/crisil/en/home/newsroom/press-releases/2022/02/for-housing-finance-cos-gnpas-rose-70-bps-on-tighter-norms-even-as-portfolio-quality-improved.html HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.Cursors$TraversingCursor Traversed 20000 nodes with filter Filter(query=SELECT([s].[personalizeTags] = 'crisil:Ratings/affordable-housing-financiers') and (isdescendantnode([s], [/content/crisil/en/home/our-analysis/reports])) ORDER BY ['customCreationDate'] desc, path=/content/crisil/en/home/our-analysis/reports//*, property=[personalizeTags=[crisil:Ratings/affordable-housing-financiers]]); consider creating an index or changing the query
08.11.2023 15:38:34.256 *WARN* [3.224.220.101 [1699438036101] GET /content/crisil/en/home/newsroom/press-releases/2022/02/for-housing-finance-cos-gnpas-rose-70-bps-on-tighter-norms-even-as-portfolio-quality-improved.html HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.Cursors$TraversingCursor Traversed 21000 nodes with filter Filter(query=SELECT([s].[personalizeTags] = 'crisil:Ratings/affordable-housing-financiers') and (isdescendantnode([s], [/content/crisil/en/home/our-analysis/reports])) ORDER BY ['customCreationDate'] desc, path=/content/crisil/en/home/our-analysis/reports//*, property=[personalizeTags=[crisil:Rati

[aanchal-sikka · Accepted solution]

Hello @Pandurang 

You need to optimize your indexes.

Please refer to following documentation:

https://experienceleague.adobe.com/docs/experience-manager-65/deploying/deploying/queries-and-indexi...

https://experienceleague.adobe.com/docs/experience-manager-65/deploying/practices/best-practices-for...

In general:

• Assure that you are using a 'type' of node 
• Execute queries over relevant sub-tree of content
• Assure custom properties are indexed

[Pandurang]

Hi @aanchal-sikka ,

Thanks for responding on query. it got resolved sorry for late update. 

Really apricate your time on it. 

Regards,

Pandurang Jadhav 

[Preetpal_Bindra]

This article may help you in the troubleshooting process,

https://wttech.blog/blog/2020/jcr-query-performance/

Use the query that the logs are complaining about in this tool and it will tell you which index is being used or no index is used.

With that information, you can either create a new or update an existing index in AEM and test it against this tool, until you get satisfying results.

regards,

Preetpal