Hi All, I've been trying to find which queries are run on a Cassandra node. I've enabled DEBUG and ran *nodetool setlogginglevel org.apache.cassandra.transport TRACE*
I did get some queries, but it's definitely not all the queries that are run on this database. I've also found a lot of DEBUG [SharedPool-Worker-72] 2019-09-25 06:29:16,674 Message.java:437 - Received: EXECUTE 2a6022010ffaf55229262de917657d0f with 6 values at consistency LOCAL_QUORUM, v=3 but I don't understand what information I can gain from that and why it appears many times (a lot more then the queries I wish to track). Can someone help me understand this type of logging? Thanks! DEBUG [SharedPool-Worker-88] 2019-09-25 06:29:16,793 Message.java:437 - Received: EXECUTE 2a6022010ffaf55229262de917657d0f with 6 values at consistency LOCAL_QUORUM, v=3 DEBUG [SharedPool-Worker-87] 2019-09-25 06:29:16,780 Message.java:437 - Received: EXECUTE 447fdb9c8dfae53fafd78c7583aeb0f1 with 3 values at consistency LOCAL_QUORUM, v=3 DEBUG [SharedPool-Worker-86] 2019-09-25 06:29:16,770 Message.java:437 - Received: EXECUTE db812ac40b66c326f728452350eb0ab2 with 3 values at consistency LOCAL_QUORUM, v=3 DEBUG [SharedPool-Worker-84] 2019-09-25 06:29:16,761 Message.java:437 - Received: EXECUTE 7119db57e0a2041206f62c6d48fb4329 with 3 values at consistency LOCAL_QUORUM, v=3 DEBUG [SharedPool-Worker-82] 2019-09-25 06:29:16,759 Message.java:437 - Received: QUERY UPDATE tbl1 SET col6=?,col7=?,col8=?,col9=? WHERE col1=? AND col2=? AND col3=? AND col4=? AND col5=?;, v=3 DEBUG [SharedPool-Worker-85] 2019-09-25 06:29:16,751 Message.java:437 - Received: EXECUTE 2cddc1f6af3c6efbeaf435f9b7ec1c8a with 4 values at consistency LOCAL_ONE, v=3 DEBUG [SharedPool-Worker-83] 2019-09-25 06:29:16,745 Message.java:437 - Received: EXECUTE db812ac40b66c326f728452350eb0ab2 with 3 values at consistency LOCAL_QUORUM, v=3 DEBUG [SharedPool-Worker-81] 2019-09-25 06:29:16,734 Message.java:437 - Received: EXECUTE 7119db57e0a2041206f62c6d48fb4329 with 3 values at consistency LOCAL_QUORUM, v=3 DEBUG [SharedPool-Worker-79] 2019-09-25 06:29:16,732 Message.java:437 - Received: EXECUTE e779e97bc0de5e5e121db71c5cb2b727 with 11 values at consistency LOCAL_QUORUM, v=3 DEBUG [SharedPool-Worker-80] 2019-09-25 06:29:16,731 Message.java:437 - Received: EXECUTE 91af551f94a4394b96ef9afff71dfcc1 with 2 values at consistency LOCAL_QUORUM, v=3 DEBUG [SharedPool-Worker-78] 2019-09-25 06:29:16,731 Message.java:437 - Received: EXECUTE 2a6022010ffaf55229262de917657d0f with 6 values at consistency LOCAL_QUORUM, v=3 DEBUG [SharedPool-Worker-75] 2019-09-25 06:29:16,720 Message.java:437 - Received: EXECUTE b665e5f576dfe70845269d63b485c8ee with 2 values at consistency LOCAL_QUORUM, v=3 DEBUG [SharedPool-Worker-77] 2019-09-25 06:29:16,715 Message.java:437 - Received: EXECUTE ce545d85a7ee7c8ad58875afa72d9cf6 with 3 values at consistency LOCAL_QUORUM, v=3 DEBUG [SharedPool-Worker-74] 2019-09-25 06:29:16,703 Message.java:437 - Received: EXECUTE 7119db57e0a2041206f62c6d48fb4329 with 3 values at consistency LOCAL_QUORUM, v=3 DEBUG [SharedPool-Worker-76] 2019-09-25 06:29:16,686 Message.java:437 - Received: EXECUTE b665e5f576dfe70845269d63b485c8ee with 2 values at consistency LOCAL_QUORUM, v=3 DEBUG [SharedPool-Worker-71] 2019-09-25 06:29:16,682 Message.java:437 - Received: EXECUTE 2a6022010ffaf55229262de917657d0f with 6 values at consistency LOCAL_QUORUM, v=3 DEBUG [SharedPool-Worker-73] 2019-09-25 06:29:16,675 Message.java:437 - Received: EXECUTE b665e5f576dfe70845269d63b485c8ee with 2 values at consistency LOCAL_QUORUM, v=3 DEBUG [SharedPool-Worker-72] 2019-09-25 06:29:16,674 Message.java:437 - Received: EXECUTE 2a6022010ffaf55229262de917657d0f with 6 values at consistency LOCAL_QUORUM, v=3 DEBUG [SharedPool-Worker-69] 2019-09-25 06:29:16,644 Message.java:437 - Received: EXECUTE 2cddc1f6af3c6efbeaf435f9b7ec1c8a with 4 values at consistency LOCAL_ONE, v=3 DEBUG [SharedPool-Worker-68] 2019-09-25 06:29:16,635 Message.java:437 - Received: EXECUTE b665e5f576dfe70845269d63b485c8ee with 2 values at consistency LOCAL_QUORUM, v=3 DEBUG [SharedPool-Worker-53] 2019-09-25 06:29:16,635 Message.java:437 - Received: EXECUTE e779e97bc0de5e5e121db71c5cb2b727 with 11 values at consistency LOCAL_QUORUM, v=3 DEBUG [SharedPool-Worker-66] 2019-09-25 06:29:16,635 Message.java:437 - Received: EXECUTE 447fdb9c8dfae53fafd78c7583aeb0f1 with 3 values at consistency LOCAL_QUORUM, v=3 DEBUG [SharedPool-Worker-65] 2019-09-25 06:29:16,623 Message.java:437 - Received: EXECUTE d67e6a07c24b675f492686078b46c997 with 3 values at consistency LOCAL_ONE, v=3 DEBUG [SharedPool-Worker-61] 2019-09-25 06:29:16,621 Message.java:437 - Received: QUERY SELECT column4 FROM ks2.tbl2 WHERE column1='xxxx' AND column2='yyyy' AND ts1>1569358692193;, v=3 DEBUG [SharedPool-Worker-62] 2019-09-25 06:29:16,618 Message.java:437 - Received: EXECUTE d67e6a07c24b675f492686078b46c997 with 3 values at consistency LOCAL_ONE, v=3
