Traversal Warning : AEM 6.5.16 | Community
Skip to main content
P
Pandurang
Level 2
November 8, 2023
Solved

Traversal Warning : AEM 6.5.16

  • November 8, 2023
  • 2 replies
  • 891 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by aanchal-sikka

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-indexing.html?lang=en

https://experienceleague.adobe.com/docs/experience-manager-65/deploying/practices/best-practices-for-queries-and-indexing.html?lang=en

 

In general:

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

 

2 replies

aanchal-sikka
Community Advisor
aanchal-sikkaCommunity AdvisorAccepted solution
Community Advisor
November 8, 2023

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-indexing.html?lang=en

https://experienceleague.adobe.com/docs/experience-manager-65/deploying/practices/best-practices-for-queries-and-indexing.html?lang=en

 

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
    P
    PandurangAuthor
    Level 2
    December 13, 2023

    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
      Community Advisor
      Preetpal_BindraCommunity Advisor
      Community Advisor
      November 8, 2023

      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

       

        Terms & ConditionsAccessibility statement

        Loading footer...