Casandra 2.1 is a NoSQL database sponsored by Apache. Use this tag for question specifically for version 2.1.
Questions tagged [cassandra-2.1]
396 questions
4
votes
1 answer
If auto_snapshot is enabled in cassandra.yaml, when these snapshots will be deleted
If we set auto_snapshot: true in the cassandra.yaml, and we delete some table the snapshots for that particular table will be created right? So when will these snapshots be deleted? Do we need to delete them manually by running scripts? Or is there…
user6288321
- 365
- 4
- 14
4
votes
0 answers
Finding duplicate rows in Cassandra
I have a table as follows:
CREATE TABLE xyz (
id text,
profile_name text,
cret_dt timestamp,
cret_id text,
PRIMARY KEY(id, profile));
It also has some data.
Now, when I run this query:
select id from xyz ;
It returns 165…
TheRedDevils
- 41
- 1
- 4
4
votes
2 answers
Cassandra: For a single node cluster, will keyspace replication factor >1 increase disk space usage?
I have a keyspace with replication factor set to 3 but I have only a single node. Will then the disk space be used 3 times the data size? As the replicas are not yet assigned to any other nodes, will cassandra stop creating replicas unless new nodes…
Masum
- 1,678
- 15
- 19
4
votes
2 answers
Using secondary indexes to update rows in Cassandra 2.1
I'm using Cassandra 2.1 and have a model that roughly looks as follows:
CREATE TABLE events (
client_id bigint,
bucket int,
timestamp timeuuid,
...
ticket_id bigint,
PRIMARY KEY ((client_id, bucket), timestamp)
);
CREATE INDEX…
hvtilborg
- 1,397
- 11
- 21
4
votes
1 answer
Consistency level ALL used while statement has consistency level TWO defined
We use java datastax cassandra driver 2.1.2. Cassandra version we use is 2.0.9.
We have statement which we build with QueryBuilder and we are setting consistency level to statement on TWO explicitly.
Select selectStatement = …
Nenad Bozic
- 3,724
- 19
- 45
3
votes
1 answer
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:NumberOfGCLogFiles=10"
-XX:GCLogFileSize=10M
However, now…
MeanwhileInHell
- 6,780
- 17
- 57
- 106
3
votes
2 answers
How do I properly set up the Cassandra client in Javascript?
Right now, I'm running a docker with Cassandra on it. I have a javascript file that sits outside the docker that needs to connect to Cassandra. I've found a node package that interfaces w/ JS, called cassandra-driver. However, with the following…
Jerry
- 93
- 1
- 7
3
votes
2 answers
How to find large partition in cassandra except system.log?
How can we find large partitions on our cassandra cluster before came into system.log? we are facing some performance issue due to this. Can anyone help me. We have cassandra version 2.0.11 and 2.1.16.
LetsNoSQL
- 1,478
- 1
- 11
- 23
3
votes
1 answer
Can I run nodetool cleanup while nodetool repair is running?
I have couple of questions.
Can I run nodetool cleanup while nodetool repair is running? Our scheduled crons are running "nodetool repair -pr" command on servers. These repair takes days to finish. I have just finished adding up new server. And I…
Atul Atri
- 53
- 5
3
votes
1 answer
Cassandra Commit log ideal size and default size clarification
From the docs it is given
commitlog_total_space_in_mb
(Default: 32MB for 32-bit JVMs, 8192MB for 64-bit JVMs)note Total space used for commitlogs. If the used space goes above this value, Cassandra rounds up to the next nearest segment multiple and…
Hiteshdua1
- 2,126
- 18
- 29
3
votes
1 answer
Cancelling ongoing compaction jobs in Cassandra
I have 3 node cluster. 2 out of 3 nodes show 100% CPU usage.
Seems We didn't not call repair and cleanup after changing consistency level (or we called it too late or it didn't complete)
Now we have 100k plus compaction tasks pending. And they eat…
Jigar Shah
- 2,576
- 6
- 31
- 53
3
votes
2 answers
Does Cassandra read have inconsistency?
I am new to Cassandra and am trying to understand how it works. Say if a write to a number of nodes. My understanding is that depending on the hash value of the key, its decided which node owns the data and then the replication happens. While…
user3276247
- 1,046
- 2
- 9
- 24
3
votes
2 answers
caching options with deprecated syntax
We're seing such warnings:
WARN [SharedPool-Worker-3] 2017-03-23 11:57:06,054 CFPropDefs.java:172 - Setting caching options with deprecated syntax.
when creating CFs like this:
CREATE TABLE "CF_ConversationIndex" (
key blob,
column1 blob,
…
Steffen Winther Sørensen
- 343
- 1
- 11
3
votes
1 answer
is 'nodetool repair -pr -par' a full repair?
We do run repair -pr on every DSC 2.1.15 node within gc_grace like this:
nodetool -h localhost repair -pr -par mykeyspc
But in the log it says full=true:
[2017-02-12 00:00:01,683] Starting repair command #11, repairing 256 ranges for
keyspace…
Steffen Winther Sørensen
- 343
- 1
- 11
3
votes
1 answer
JVM state determined to be unstable. Exiting forcefully. what is Java Stability Inspector ?? why it is stopping DSE?
From last few days i am seeing on some of the nodes in cassandra cluster DSE is getting shutdown due to the error below and i need to kill Java process and restart DSE service.
I have cross checked reads and writes and compactions nothing looks…
user6288321
- 365
- 4
- 14