Re: Cassandra FQL question-

[Akshith Mull]

And also we have Cassandra 4.0.5.

[cqlsh 6.0.0 | Cassandra 4.0.5 | CQL spec 3.4.5 | Native protocol v5]


Is this FQL & fqltool dump - will work on 4.0.x also right ?



> On Aug 9, 2023, at 9:18 AM, Akshith Mull  wrote:
> 
> 
> These are the class path settings , do we need to add anything here or is it 
> wrongly set?
> Any solution to fix this will be greatly appreciated,
> 
> cat /usr/bin/fqltool | grep CLASSPATH
> if [ -z "$CASSANDRA_CONF" -o -z "$CLASSPATH" ]; then
>echo "You must set the CASSANDRA_CONF and CLASSPATH vars" >&2
> "$JAVA" $JAVA_AGENT -ea -da:net.openhft... -cp "$CLASSPATH" $JVM_OPTS 
> -Xmx$MAX_HEAP_SIZE \
> 
> 
> 
> 
>> On Aug 8, 2023, at 12:57 PM, Miklosovic, Stefan 
>>  wrote:
>> 
>> Hey,
>> 
>> I did same steps from extracted tarball of 4.1.3 and it just works. It also 
>> works when I install Debian package.
>> 
>> The error you get seems like the class path is not set correctly so it can 
>> not load it.
>> 
>> You can probably debug this by wrapping last line in fqltool in "echo" to 
>> see what is on the class path.
>> 
>> Regards
>> 
>> 
>> From: Akshith Mull 
>> Sent: Tuesday, August 8, 2023 18:30
>> To: user@cassandra.apache.org
>> Subject: Cassandra FQL question-
>> 
>> You don't often get email from akshith.m...@gmail.com. Learn why this is 
>> important
>> NetApp Security WARNING: This is an external email. Do not click links or 
>> open attachments unless you recognize the sender and know the content is 
>> safe.
>> 
>> 
>> 
>> Hi All,
>> 
>> We have cassandra 4.x version,
>> 
>> I have enabled FQL as per the documentation-
>> 
>> 
>> Full Query Logging | Apache Cassandra 
>> Documentation
>> cassandra.apache.org
>> [favicon.ico]
>> 
>> 
>> nodetool enablefullquerylog --path /tmp/cassandrafullquerylog
>> 
>> 
>> 
>> Files generated.
>> 
>> 
>> -rw-r--r--   1131072 Aug  8 16:22 metadata.cq4t
>> 
>> -rw-r--r--   1 83886080 Aug  8 16:22 20230808-16.cq4
>> 
>> 
>> Its generated in binary .
>> 
>> 
>> As per the doc Im running dump command to convert human readable format.
>> 
>> 
>> fqltool dump /tmp/cassandrafullquerylog
>> 
>> 
>> But Im getting below error.
>> 
>> 
>> Error: Could not find or load main class 
>> org.apache.cassandra.fqltool.FullQueryLogTool
>> 
>> Caused by: java.lang.ClassNotFoundException: 
>> org.apache.cassandra.fqltool.FullQueryLogTool
>> 
>> 
>> Do we need to install anything to generate  the output ?
>> 
>> 
>> 
>> Gently appreciate the answers.
>> 
>> 
>> 
>> thanks
>> 
>> 
>> 
>> 
>> 
>> 
>> 
> 

Re: Cassandra FQL question-

[Akshith Mull]

These are the class path settings , do we need to add anything here or is it 
wrongly set?
Any solution to fix this will be greatly appreciated,

 cat /usr/bin/fqltool | grep CLASSPATH
if [ -z "$CASSANDRA_CONF" -o -z "$CLASSPATH" ]; then
echo "You must set the CASSANDRA_CONF and CLASSPATH vars" >&2
"$JAVA" $JAVA_AGENT -ea -da:net.openhft... -cp "$CLASSPATH" $JVM_OPTS 
-Xmx$MAX_HEAP_SIZE \




> On Aug 8, 2023, at 12:57 PM, Miklosovic, Stefan 
>  wrote:
> 
> Hey,
> 
> I did same steps from extracted tarball of 4.1.3 and it just works. It also 
> works when I install Debian package.
> 
> The error you get seems like the class path is not set correctly so it can 
> not load it.
> 
> You can probably debug this by wrapping last line in fqltool in "echo" to see 
> what is on the class path.
> 
> Regards
> 
> 
> From: Akshith Mull 
> Sent: Tuesday, August 8, 2023 18:30
> To: user@cassandra.apache.org
> Subject: Cassandra FQL question-
> 
> You don't often get email from akshith.m...@gmail.com. Learn why this is 
> important
> NetApp Security WARNING: This is an external email. Do not click links or 
> open attachments unless you recognize the sender and know the content is safe.
> 
> 
> 
> Hi All,
> 
> We have cassandra 4.x version,
> 
> I have enabled FQL as per the documentation-
> 
> 
> Full Query Logging | Apache Cassandra 
> Documentation
> cassandra.apache.org
> [favicon.ico]
> 
> 
> nodetool enablefullquerylog --path /tmp/cassandrafullquerylog
> 
> 
> 
> Files generated.
> 
> 
> -rw-r--r--   1131072 Aug  8 16:22 metadata.cq4t
> 
> -rw-r--r--   1 83886080 Aug  8 16:22 20230808-16.cq4
> 
> 
> Its generated in binary .
> 
> 
> As per the doc Im running dump command to convert human readable format.
> 
> 
> fqltool dump /tmp/cassandrafullquerylog
> 
> 
> But Im getting below error.
> 
> 
> Error: Could not find or load main class 
> org.apache.cassandra.fqltool.FullQueryLogTool
> 
> Caused by: java.lang.ClassNotFoundException: 
> org.apache.cassandra.fqltool.FullQueryLogTool
> 
> 
> Do we need to install anything to generate  the output ?
> 
> 
> 
> Gently appreciate the answers.
> 
> 
> 
> thanks
> 
> 
> 
> 
> 
> 
> 

Re: Cassandra FQL question-

[Akshith Mull]

Okay , thanks , let me try .
Seems like the tool is exists as root user , but not able to run it.

 :/usr/bin$ ls -ltra | grep fqltool
-rwxr-xr-x   1 root root  2388 May  6  2022 fqltool

/tmp/cassandrafullquerylog$ fqltool

Error: Could not find or load main class 
org.apache.cassandra.fqltool.FullQueryLogTool
Caused by: java.lang.ClassNotFoundException: 
org.apache.cassandra.fqltool.FullQueryLogTool
cassandra-tracking (efbfe41fcf)



> On Aug 8, 2023, at 12:57 PM, Miklosovic, Stefan 
>  wrote:
> 
> Hey,
> 
> I did same steps from extracted tarball of 4.1.3 and it just works. It also 
> works when I install Debian package.
> 
> The error you get seems like the class path is not set correctly so it can 
> not load it.
> 
> You can probably debug this by wrapping last line in fqltool in "echo" to see 
> what is on the class path.
> 
> Regards
> 
> 
> From: Akshith Mull 
> Sent: Tuesday, August 8, 2023 18:30
> To: user@cassandra.apache.org
> Subject: Cassandra FQL question-
> 
> You don't often get email from akshith.m...@gmail.com. Learn why this is 
> important
> NetApp Security WARNING: This is an external email. Do not click links or 
> open attachments unless you recognize the sender and know the content is safe.
> 
> 
> 
> Hi All,
> 
> We have cassandra 4.x version,
> 
> I have enabled FQL as per the documentation-
> 
> 
> Full Query Logging | Apache Cassandra 
> Documentation
> cassandra.apache.org
> [favicon.ico]
> 
> 
> nodetool enablefullquerylog --path /tmp/cassandrafullquerylog
> 
> 
> 
> Files generated.
> 
> 
> -rw-r--r--   1131072 Aug  8 16:22 metadata.cq4t
> 
> -rw-r--r--   1 83886080 Aug  8 16:22 20230808-16.cq4
> 
> 
> Its generated in binary .
> 
> 
> As per the doc Im running dump command to convert human readable format.
> 
> 
> fqltool dump /tmp/cassandrafullquerylog
> 
> 
> But Im getting below error.
> 
> 
> Error: Could not find or load main class 
> org.apache.cassandra.fqltool.FullQueryLogTool
> 
> Caused by: java.lang.ClassNotFoundException: 
> org.apache.cassandra.fqltool.FullQueryLogTool
> 
> 
> Do we need to install anything to generate  the output ?
> 
> 
> 
> Gently appreciate the answers.
> 
> 
> 
> thanks
> 
> 
> 
> 
> 
> 
> 

Re: Cassandra FQL question-

[Miklosovic, Stefan]

Hey,

I did same steps from extracted tarball of 4.1.3 and it just works. It also 
works when I install Debian package.

The error you get seems like the class path is not set correctly so it can not 
load it.

You can probably debug this by wrapping last line in fqltool in "echo" to see 
what is on the class path.

Regards


From: Akshith Mull 
Sent: Tuesday, August 8, 2023 18:30
To: user@cassandra.apache.org
Subject: Cassandra FQL question-

You don't often get email from akshith.m...@gmail.com. Learn why this is 
important
NetApp Security WARNING: This is an external email. Do not click links or open 
attachments unless you recognize the sender and know the content is safe.



Hi All,

We have cassandra 4.x version,

I have enabled FQL as per the documentation-


Full Query Logging | Apache Cassandra 
Documentation
cassandra.apache.org
[favicon.ico]


nodetool enablefullquerylog --path /tmp/cassandrafullquerylog



Files generated.


-rw-r--r--   1131072 Aug  8 16:22 metadata.cq4t

-rw-r--r--   1 83886080 Aug  8 16:22 20230808-16.cq4


Its generated in binary .


As per the doc Im running dump command to convert human readable format.


fqltool dump /tmp/cassandrafullquerylog


But Im getting below error.


Error: Could not find or load main class 
org.apache.cassandra.fqltool.FullQueryLogTool

Caused by: java.lang.ClassNotFoundException: 
org.apache.cassandra.fqltool.FullQueryLogTool


Do we need to install anything to generate  the output ?



Gently appreciate the answers.



thanks