Expand my Community achievements bar.

SOLVED

Traversal Warning : AEM 6.5.16

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

 


Aanchal Sikka

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

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

 


Aanchal Sikka

Avatar

Level 2

Hi @aanchal-sikka ,

 

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

 

Really apricate your time on it. 

 

Regards,

Pandurang Jadhav 

Avatar

Community Advisor

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