398 questions
0 votes
1 answer
120 views
cqlsh cannot connect to some nodes in the cluster
cqlsh connection shows below error for couple of machine, but it is successful in other machines in cluster. Bad nodes were removed out of cluster, system_auth replication is 5 for both dc's with ...
1 vote
1 answer
121 views
am unable to to the database using cqlsh
I have a cassandra db 1.21 installed on windows 2019, am unable to to the database using cqlsh enter image description here Able to start the cassandra db enter image description here when i run cqslh ...
1 vote
1 answer
128 views
Read timeout error after Cassandra upgraded from 2.2.19 to 3.11.13
I have two dc cluster, where one dc was upgraded from Cassandra 2.2.19 to 3.11.13. Currently I notice cql timeout reported after the upgrade on the Cassandra 3.x DC. The other dc which is on version 2....
1 vote
1 answer
348 views
NoSuchMethodError: org.apache.cassandra.db.ColumnFamilyStore.getOverlappingSSTables
I have upgraded one of cluster node from 2.2.19 to 3.11.13, but I'm continuously getting the below error in system logs. I'm using TimeWindowCompactionStrategy-3.7.jar Please let me know how can I fix ...
0 votes
1 answer
155 views
Cassandra : map map<text, text> datatype of UDT to SortedDictionary in .Net
I am using cassandra DB for .Net. I have created a datatype dictionary_type_property map<text,text> inside user defined datatype, but facing problem while converting this datatype value to .Net ...
0 votes
0 answers
25 views
How do I enable DML logging in Cassandra 2.1?
How to enable logging DML(inserts, updates), DDL (alter, create) operations in cassandra version 2.1? nodetool getlogginglevels Logger Name Log Level ROOT ...
1 vote
2 answers
187 views
Hints during cassandra version upgrade from 2.1.17 to 3.0.15
I was trying to upgrade 4 nodes in a Cluster. DC1 had nodes N1 and N2 DC2 had nodes N3 and N4 App server is connected to N1 and N2 nodes. RF = {DC1: 2, DC: 2} DC2 nodes where upgraded to 3.0.15 first. ...
0 votes
1 answer
616 views
Running Cassandra 2.1.17 on Java 11
I am trying to get Cassandra v2.1.17 running using Java 11 (Oracle), but cannot get it to startup. I have updated all the JVM args in cassandra-env.sh to the Java 11 equivalents, but I now get the ...
3 votes
1 answer
5k views
JVM 11 GC log rotation : Initialization of output 'file=/var/log/cassandra/gc.log' using options '(null)' failed
I am trying to update some older JVM GC log rotation options to be compatible with Java 11. Previously, using Java 8 I had: -Xloggc:/var/log/cassandra/gc.log" -XX:+UseGCLogFileRotation" -XX:...
0 votes
1 answer
399 views
Can i do logical Query inside Blob column field in cassandra Query?
Can i do logical Query inside Blob column field in cassandra Query ? like i have a file inside Blob field called purchase amount : 500$ i want to do search and fetch results purchase amount which is ...
0 votes
2 answers
871 views
How do you nest a UDT inside another UDT in Cassandra?
I have created the following user defined types (UDT) in cassandra : CREATE TYPE keyspace.location ( latitude text, longitude text, accuracy text, address text ); CREATE TYPE keyspace....
1 vote
1 answer
445 views
Querying on cassandra consumes CPU
Connecting to Cassandra from application code and querying consumes Cassandra's CPU. My query is like :: select fields from table where partition_key = "PARTITION_KEY" and clustering_key_1 = "KEY1" ...
1 vote
1 answer
154 views
Cassandra read consistency is one, but node connects to another node
3 node cluster and RF of 3 means every node has all the data. Consistency is ONE. So when queried for some data on node-1, ideally as node-1 has all the data it should be able to complete my query. ...
0 votes
1 answer
245 views
How to migrate existing columns data to new column in Cassandra database?
I need to save user's quiz completion status to a Cassandra's table, previously table was designed only to hold one quiz status so I can't save if the user takes another quiz(User id is primary key). ...
1 vote
1 answer
657 views
Cassandra nodes are continuously throwing this error
I have 6 nodes Cassandra cluster where 3 are data nodes and 3 are seed nodes they all are using Cassandra version 3.7 below are the exceptions which I am getting on data nodes : java.lang....