Wallace Howery created OAK-10325:
------------------------------------
Summary: potentially excessive query on CLUSTERNODES
Key: OAK-10325
URL: https://issues.apache.org/jira/browse/OAK-10325
Project: Jackrabbit Oak
Issue Type: Documentation
Components: jcr
Affects Versions: 1.50.0
Reporter: Wallace Howery
Getting an error: Potentially excessive query on CLUSTERNODES with 6912 hits
(configured QUERYHITSLIMIT 4096). I can't find any documentation on setting
QUERYHITSLIMIT configuration, or how to fix this issue. Help greatly
appreciated.
{"@timestamp":"2023-06-22T15:03:18.898-04:00","@version":"1","message":"Potentially
excessive query on CLUSTERNODES with 6912 hits (limited to 2147483647,
configured QUERYHITSLIMIT 4096), elapsed time 28ms, params minid '0' maxid 'a'
excludeKeyPatterns [] conditions [] limit 2147483647. Result range:
'1'...'999'. Read 6990270 chars from DATA and 0 bytes from BDATA. Check calling
method.","logger_name":"org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStoreJDBC","thread_name":"DocumentNodeStore
cluster update thread
(1)","level":"INFO","level_value":20000,"stack_trace":"java.lang.Exception:
call stack\n\tat
org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStoreJDBC.query(RDBDocumentStoreJDBC.java:515)\n\tat
org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.internalQuery(RDBDocumentStore.java:1784)\n\tat
org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.query(RDBDocumentStore.java:298)\n\tat
org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.query(RDBDocumentStore.java:287)\n\tat
org.apache.jackrabbit.oak.plugins.document.ClusterNodeInfoDocument.all(ClusterNodeInfoDocument.java:154)\n\tat
org.apache.jackrabbit.oak.plugins.document.DocumentNodeStore.updateClusterState(DocumentNodeStore.java:2403)\n\tat
org.apache.jackrabbit.oak.plugins.document.DocumentNodeStore$BackgroundClusterUpdate.execute(DocumentNodeStore.java:3848)\n\tat
org.apache.jackrabbit.oak.plugins.document.DocumentNodeStore$NodeStoreTask.run(DocumentNodeStore.java:3651)\n\tat
java.base/java.lang.Thread.run(Thread.java:833)\n"}
{"@timestamp":"2023-06-22T15:03:20.075-04:00","@version":"1","message":"Potentially
excessive query on CLUSTERNODES with 6912 hits (limited to 2147483647,
configured QUERYHITSLIMIT 4096), elapsed time 119ms, params minid '0' maxid 'a'
excludeKeyPatterns [] conditions [] limit 2147483647. Result range:
'1'...'999'. Read 6990303 chars from DATA and 0 bytes from BDATA. Check calling
method.","logger_name":"org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStoreJDBC","thread_name":"DocumentNodeStore
cluster update thread
(1)","level":"INFO","level_value":20000,"stack_trace":"java.lang.Exception:
call stack\n\tat
org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStoreJDBC.query(RDBDocumentStoreJDBC.java:515)\n\tat
org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.internalQuery(RDBDocumentStore.java:1784)\n\tat
org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.query(RDBDocumentStore.java:298)\n\tat
org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentStore.query(RDBDocumentStore.java:287)\n\tat
org.apache.jackrabbit.oak.plugins.document.ClusterNodeInfoDocument.all(ClusterNodeInfoDocument.java:154)\n\tat
org.apache.jackrabbit.oak.plugins.document.DocumentNodeStore.updateClusterState(DocumentNodeStore.java:2403)\n\tat
org.apache.jackrabbit.oak.plugins.document.DocumentNodeStore$BackgroundClusterUpdate.execute(DocumentNodeStore.java:3848)\n\tat
org.apache.jackrabbit.oak.plugins.document.DocumentNodeStore$NodeStoreTask.run(DocumentNodeStore.java:3651)\n\tat
java.base/java.lang.Thread.run(Thread.java:833)\n"}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
