Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-15057

Log the query when warning about aggregate on multiple partition keys

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Fix Version/s: 4.x
    • Component/s: CQL/Interpreter
    • Labels:
      None
    • Change Category:
      Operability
    • Complexity:
      Normal

      Description

      We  have 05  node  single  DC Apache Cassandra cluster with  version  2.2.5 running on Ubuntu (4.15.0-1013-azure #13~16.04.2-Ubuntu SMP Wed May 30 01:39:27 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux).

       

      If we look at system.log file always we see WARNING of Aggregation query used on multiple partition keys (IN restriction) on all nodes .

      How to enable tracing/debugging and capture the full CQL Select Statement  which is flooding the system.log file .

      I donot have Opscenter , or  dev center  or any other monitoring tool   except  nodetool .

       

      Are  there any direct ways to find out  what are the CQL running at a given current point in time on any Cassandra node 

       

      WARN  [SharedPool-Worker-2] 2019-03-19 08:16:06,935 SelectStatement.java:258 - Aggregation query used on multiple partition keys (IN restriction)

      WARN  [SharedPool-Worker-1] 2019-03-19 08:16:32,715 SelectStatement.java:258 - Aggregation query used on multiple partition keys (IN restriction)

      WARN  [SharedPool-Worker-2] 2019-03-19 08:16:47,666 SelectStatement.java:258 - Aggregation query used on multiple partition keys (IN restriction)

      WARN  [SharedPool-Worker-2] 2019-03-19 08:17:06,022 SelectStatement.java:258 - Aggregation query used on multiple partition keys (IN restriction)

      WARN  [SharedPool-Worker-1] 2019-03-19 08:17:36,642 SelectStatement.java:258 - Aggregation query used on multiple partition keys (IN restriction)

      WARN  [SharedPool-Worker-6] 2019-03-19 08:18:20,990 SelectStatement.java:258 - Aggregation query used on multiple partition keys (IN restriction)

      WARN  [SharedPool-Worker-2] 2019-03-19 08:20:44,853 SelectStatement.java:258 - Aggregation query used on multiple partition keys (IN restriction)

      WARN  [SharedPool-Worker-2] 2019-03-19 08:21:29,083 SelectStatement.java:258 - Aggregation query used on multiple partition keys (IN restriction)

      WARN  [SharedPool-Worker-1] 2019-03-19 08:21:46,911 SelectStatement.java:258 - Aggregation query used on multiple partition keys (IN restriction)

      WARN  [SharedPool-Worker-3] 2019-03-19 08:21:59,935 SelectStatement.java:258 - Aggregation query used on multiple partition keys (IN restriction)

      WARN  [SharedPool-Worker-2] 2019-03-19 08:22:13,693 SelectStatement.java:258 - Aggregation query used on multiple partition keys (IN restriction)

      WARN  [SharedPool-Worker-1] 2019-03-19 08:22:48,263 SelectStatement.java:258 - Aggregation query used on multiple partition keys (IN restriction)

      WARN  [SharedPool-Worker-13] 2019-03-19 08:46:11,379 SelectStatement.java:258 - Aggregation query used on multiple partition keys (IN restriction)

      WARN  [SharedPool-Worker-1] 2019-03-19 08:47:38,160 SelectStatement.java:258 - Aggregation query used on multiple partition keys (IN restriction)

       

       

      Thanks

      Gangadhara

       

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              GANGA GANGADHARA
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: