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

Traversal Warning : AEM 6.5.16

  • November 8, 2023
  • 2 replies
  • 888 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

Preetpal_Bindra
Preetpal_Bindra
New Participant
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

 

    aanchal-sikka
    aanchal-sikkaAccepted solution
    New Participant
    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
      New Participant
      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 

        Terms & ConditionsAccessibility statement

        Loading footer...