Re: Understanding TRACE logging

2019-09-26 Thread Jeff Jirsa
The EXECUTE lines are a prepared statement with the specified number of parameters. On Wed, Sep 25, 2019 at 11:38 PM shalom sagges wrote: > 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.cassand

Re: Understanding TRACE logging

2019-09-26 Thread shalom sagges
Thanks for the quick response Jeff! The EXECUTE lines are a prepared statement with the specified number of parameters. Is it possible to find out on which keyspace/table these prepared statements run? Can I get additional information from the prepared statement's ID? e.g. EXECUTE *d67e6a07c24b675

Re: Understanding TRACE logging

2019-09-26 Thread Laxmikant Upadhyay
One of the way to figure out what queries have run is to use audit logging plugin supported in 3.x, 2.2 https://github.com/Ericsson/ecaudit On Thu, Sep 26, 2019 at 2:19 PM shalom sagges wrote: > Thanks for the quick response Jeff! > > The EXECUTE lines are a prepared statement with the specifi

How to verify hint file checksum

2019-09-26 Thread Shishir Kumar
Hi, Is there any CLI or API which I can use to validate hint files checksum is correct? Reason to ask for such utility/CLI - We are doing rolling upgrade for Cassandra in Google cloud. As approach we bring down nodes, take snapshot backup, upgrade and bring node up. During this process hint file

Re: How to verify hint file checksum

2019-09-26 Thread Jeff Jirsa
No mechanism exists. You could potentially do multiple rsyncs instead of trying to grab a live file one time, but it’s also worth a JIRA to build a utility that tries to validate the checksum (it won’t be difficult) > On Sep 26, 2019, at 6:37 AM, Shishir Kumar wrote: > >  > Hi, > > Is ther

Re: How to verify hint file checksum

2019-09-26 Thread Shishir Kumar
Since we take backup and upgrade so multiple rsync do not seem option. Where to file JIRA to get this util build? I can attempt building tool myself but need pointer for Checksum generator class reference which read hints file and generate/update crc file hint digest. Regards Shishir On Thu, 26

Re: Understanding TRACE logging

2019-09-26 Thread Paul Chandler
Hi Shalom, When tracking down specific queries I have used ngrep and fed the results into Wireshark, this will allow you to find out everything about the requests coming into the node from the client, as long as the connection is not encrypted. I wrote this up here a few months ago: http://www