Uploaded image for project: 'Jackrabbit Oak'
  1. Jackrabbit Oak
  2. OAK-10325

potentially excessive query on CLUSTERNODES

    XMLWordPrintableJSON

Details

    • Documentation
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.50.0
    • None
    • jcr
    • None

    Description

      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"}

      Attachments

        Activity

          People

            Unassigned Unassigned
            wallace.howery Wallace Howery
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: