AEM 6.0 query issue on cq:tags | Community
Skip to main content
Level 5
June 8, 2022

AEM 6.0 query issue on cq:tags

  • June 8, 2022
  • 1 reply
  • 832 views

Hi All,

 

We started seeing a weird issue about query optimization a few months ago. When we issue a query as:

/jcr:root/content/site//element(*,cq:PageContent)[@sling:resourceType='site/components/page/news-detail' and (@cq:tags = 'department:drama')] order by @date descending

We will see a warning message about traversing too many nodes, 

org.apache.jackrabbit.oak.plugins.index.property.strategy.ContentMirrorStoreStrategy Traversed 60000 nodes (212558 index entries) using index cq:tags with filter Filter

 

There is a node "cqTags" under oak:index, as

 

 

The weird thing is that if we modify the query a bit, /jcr:root/content/site//element(*,cq:PageContent)[@sling:resourceType='site/components/page/news-detail' and (@cq:tags = 'articles:drama')] order by @date descending. Changing the tag value from "department:drama" to "articles:drama" will not issue any warning, given that both tags are valid in the /etc/tags. Also, the issue only takes place in the publisher, not the author. 

 

The "department:drama" tag property is as:

 

 

Any idea where I should troubleshoot this?

 

Thanks!

 

-k

 

 

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

1 reply

Fanindra_Surat
Community Advisor
Community Advisor
June 9, 2022

Hi @kevin_gta  - Have you verified if the tag 'articles:drama' is published and/or is available in the publisher?

 

 

Kevin_GTaAuthor
Level 5
June 9, 2022

Tags are the same on both author and publisher.