[CASSANDRA-15057] Log the query when warning about aggregate on multiple partition keys

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Duplicate
• Fix Version/s: 5.x
• Component/s: CQL/Interpreter
• Change Category: Operability
• Complexity: Normal
• Assignee: Unassigned
• Reporter: GANGADHARA
• Created: 19/Mar/19 15:26
• Updated: 10/Apr/24 19:35
• Resolved: 10/Apr/24 19:35

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

 

 

Issue Links

• duplicates: CASSANDRA-18219 Warning message on aggregation queries doesn't specify table name or aggregate type