Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Custom index for DAM expiry job to not exceed memory limit

bobkranson
Level 4
Level 4

We are operating on a large repository.  I see this warning message re-occurring and am concerned the expired assets are not fully listed to the authors.  Is there an index which can be used or created to solve this?

com.day.cq.dam.core.impl.ExpiryNotificationJobImpl] org.apache.jackrabbit.oak.query.FilterIterators The query read more than 500000 nodes in memory.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution
Vijayalakshmi_S
Correct answer by
Community Advisor
Community Advisor

Hi @bobkranson,

Can you share the query that is getting executed from the existing logs. 

If it is not available, add a Log entry (for below in DEBUG mode) and reproduce the scenario.

http://localhost:4502/system/console/slinglog

org.apache.jackrabbit.oak.query.QueryEngineImpl
org.apache.jackrabbit.oak.query.SQL2Parser
org.apache.jackrabbit.oak.query.QueryImpl
org.apache.jackrabbit.oak.query

Based on the query executed, we can decide on the index definition.

 

View solution in original post

3 Replies
Vijayalakshmi_S
Correct answer by
Community Advisor
Community Advisor

Hi @bobkranson,

Can you share the query that is getting executed from the existing logs. 

If it is not available, add a Log entry (for below in DEBUG mode) and reproduce the scenario.

http://localhost:4502/system/console/slinglog

org.apache.jackrabbit.oak.query.QueryEngineImpl
org.apache.jackrabbit.oak.query.SQL2Parser
org.apache.jackrabbit.oak.query.QueryImpl
org.apache.jackrabbit.oak.query

Based on the query executed, we can decide on the index definition.

 

View solution in original post

bobkranson
Level 4
Level 4
Give me a day or two and I'll post back my results. Thanks!
vanegi
Employee
Employee

Hi @bobkranson,

Have you enabled debug logs for all the below classes, if not yet can you please do that. DEBUG logging configuration can be added for the following packages, write a separate log file. Also let me know what specific queries you are running.

 

org.apache.jackrabbit.oak.plugins.index

org.apache.jackrabbit.oak.query

com.day.cq.search

 

Once you have the query, you can post the query in Explain Query http://host:port/libs/granite/operations/content/diagnosistools/queryPerformance.html and see if it is traversal or utilizing any OOTB index?

 

If it is traversal, a custom index can be created using https://oakutils.appspot.com/generate/index.

 

Thanks!!