How to solve query indexing issue? | Community
Skip to main content
N
NandanGo1
Level 2
May 5, 2023

How to solve query indexing issue?

  • May 5, 2023
  • 3 replies
  • 2024 views

I have workflow "torrid-pdp-top-sheet" which does not have any process steps which contains query, but I am getting below error:

 

04.05.2023 05:54:34.559 *INFO* [JobHandler: /var/workflow/instances/server2/2023-05-03/torrid-pdp-top-sheet_414:/content/dam/torrid/pdp-assets/197/314/19731487] org.apache.jackrabbit.oak.plugins.index.lucene.LucenePropertyIndex Change in index version detected. Query would be performed without offset
04.05.2023 05:55:11.175 *WARN* [JobHandler: /var/workflow/instances/server2/2023-05-03/torrid-pdp-top-sheet_414:/content/dam/torrid/pdp-assets/197/314/19731487] org.apache.jackrabbit.oak.plugins.index.search.spi.query.FulltextIndex$FulltextPathCursor Index-Traversed 10000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [cq:Workflow] as a where [status] = 'RUNNING' and isdescendantnode(a, '/') order by [startTime] desc /* xpath: /jcr:root//element(*,cq:Workflow)[@status='RUNNING'] order by @startTime descending */, path=//*, property=[status=[RUNNING]])

 

Any assistance in solving the issue is much appreciated.

 

Thanks,

Nandan

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

MayurSatav
Community Advisor and Adobe Champion
MayurSatavCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
May 5, 2023

hi @nandango1 ,

 

Could you please check if the index is up-to-date, you can check the status of the index by going to the AEM console and navigating to Tools > Operations > Lucene Indexes. If the index is not up-to-date, try rebuilding it by clicking on the "Rebuild" button in the AEM console. 

Mayur Satav | www.mayursatav.in
    Saravanan_Dharmaraj
    Community Advisor
    Saravanan_DharmarajCommunity Advisor
    Community Advisor
    May 5, 2023

    @nandango1 you can check the oak index generator to create simple indexes. But i assume you haven't added this query in the workflow. You can run below query in explain query tool and see the cost. 

     

    https://oakutils.appspot.com/generate/index

     

    Explain query tool

    http://localhost:4502/libs/granite/operations/content/diagnosistools/queryPerformance.html 

     

    query:

    select [jcr:path], [jcr:score], * from [cq:Workflow] as a where [status] = 'RUNNING' and isdescendantnode(a, '/') order by [startTime] desc

     

     

    index

    { "compatVersion": 2, "async": "async", "jcr:primaryType": "oak:QueryIndexDefinition", "evaluatePathRestrictions": true, "type": "lucene", "indexRules": { "jcr:primaryType": "nt:unstructured", "cq:Workflow": { "jcr:primaryType": "nt:unstructured", "properties": { "jcr:primaryType": "nt:unstructured", "startTime": { "name": "startTime", "ordered": true, "jcr:primaryType": "nt:unstructured" }, "status": { "name": "status", "propertyIndex": true, "jcr:primaryType": "nt:unstructured" } } } } }

     

    https://www.linkedin.com/pulse/aem-struggling-decide-how-add-oak-index-veena-vikraman/ 

     

     

      N
      NandanGo1Author
      Level 2
      May 8, 2023

      Thank you @saravanan_dharmaraj for your response.

       

      I have already defined the index for this query and still getting the same warning.

      The response from query performance:

       

      Parsing JCR-SQL2 statement: explain select [jcr:path], [jcr:score], * from [cq:Workflow] as a where [status] = 'RUNNING' and isdescendantnode(a, '/') order by [startTime] desc
      cost using filter Filter(query=explain select [jcr:path], [jcr:score], * from [cq:Workflow] as a where [status] = 'RUNNING' and isdescendantnode(a, '/') order by [startTime] desc, path=//*, property=[status=[RUNNING]])
      cost for reference is Infinity
      cost for property is Infinity
      cost for nodeType is Infinity
      Applicable IndexingRule found IndexRule: nt:base
      Applicable IndexingRule found IndexRule: cq:Workflow
      Applicable IndexingRule found IndexRule: nt:base
      Applicable IndexingRule found IndexRule: nt:base
      Applicable IndexingRule found IndexRule: nt:base
      Applicable IndexingRule found IndexRule: nt:base
      cost for [/oak:index/workflowDataLucene] of type (lucene-property) with plan [lucene:workflowDataLucene(/oak:index/workflowDataLucene) status:RUNNING ordering:[{ propertyName : startTime, propertyType : UNDEFINED, order : DESCENDING }]] is 402.00
      cost for [/oak:index/ntBaseLucene] of type (lucene-property) with plan [lucene:ntBaseLucene(/oak:index/ntBaseLucene) status:RUNNING sync:(status RUNNING)] is 1408.00
      cost for lucene-property is Infinity
      cost for aggregate lucene is Infinity
      looking for plans for paths : []
      cost for aggregate solr is Infinity
      cost for traverse is 1063012.0

        Terms & ConditionsAccessibility statement

        Loading footer...