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.
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.