You are viewing a plain text version of this content. The canonical link for it is here.
Posted to oak-issues@jackrabbit.apache.org by "Wallace Howery (Jira)" <ji...@apache.org> on 2023/06/22 19:40:00 UTC
[jira] [Created] (OAK-10325) potentially excessive query on CLUSTERNODES
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)