Questions tagged [cassandra]

Apache Cassandra is an open source distributed database management system. It is designed to handle very large amounts of data spread out across many commodity servers while providing a highly available service with no single point of failure. It is a NoSQL solution.

Filter by
Sorted by
Tagged with
0 votes
0 answers
19 views

How does Cassandra achieve strong consistency with failed writes if there is no rollback and no two phase commit?

Looking for concrete evidence (documentation or source code) on the behavior of cassandra 3.0+ on the following situation Write of key1, value1 is requested with consistency level of QUORUM but only N ...
olaf's user avatar
  • 123
0 votes
1 answer
13 views

How to migrate 2 different Cassandra databases into one cluster

We have two separate Cassandra clusters, each with six nodes: Cluster A and Cluster B. Our requirement is to merge these two clusters to save costs. Because this is a critical application, we need to ...
Sai's user avatar
  • 35
1 vote
1 answer
23 views

Does Docker stop take of care of stopping gossip and drain?

We have a setup where we have 3 cassandra nodes running as a cluster. We are using cassandra docker container with cassandra version 4.1.3. So, in this scenario what happens when one of the node ...
Manju K B's user avatar
1 vote
1 answer
24 views

Cassandra Read-Write Latency

INFO [HintsDispatcher:416] 2024-02-12 01:42:41,180 NoSpamLogger.java:91 - Maximum memory usage reached (536870912), cannot allocate chunk of 1048576 We are getting the above INFO in logs. Also, we ...
Cassandra Thrift's user avatar
1 vote
2 answers
78 views

Cassandra Login - AuthenticationFailed ... Unable to perform authentication: Cannot achieve consistency level LOCAL_QUORUM

Summary: I have a 2 node cluster and if one of the nodes is down I am unable to login. I receive the error. Connection error: ('Unable to connect to any servers', {'192.168.1.104:9042': ...
adinas's user avatar
  • 113
0 votes
1 answer
107 views

When will Cassandra 5.0 be a stable release?

as I'am considering migrating from 3.x with a wish to have the longest "support" as possible, I was wondering, when will release 5.0 become stable version, suitable for commercial use? Is ...
Vrabec's user avatar
  • 1
-1 votes
2 answers
26 views

JNA Link failure and JMX unable to receive remote Connections and Out of memory error after running cassandra command on Windows

WARNING! Powershell script execution unavailable. Please use 'powershell Set-ExecutionPolicy Unrestricted' on this user-account to run cassandra with fully featured functionality on this ...
prem's user avatar
  • 1
0 votes
1 answer
27 views

What is the difference between GA and stable version?

What is the difference between Apache Cassandra Stable version and General availability version. Is that mean General availability version may have more bugs than stable version ? Or it is something ...
Cassandra Thrift's user avatar
0 votes
2 answers
51 views

Unable to start Cassandra, getting Java error "Invalid decorator", "Invalid -Xlog option"

I'm getting below error while trying to start cassandra services on the ubuntu platform. $ /u01/cassandra/apache-cassandra-4.0.11_dlpx_apache_stg_n_0/bin/cassandra OpenJDK 64-Bit Server VM warning: ...
CassandraNovice's user avatar
1 vote
1 answer
25 views

Apache Cassandra node restarts randomly

I have a cluster of 11 nodes, Apache Cassandra version 3.11.4, where certain nodes are restarted at random times. Nodes characteristics: CPU(s): 32 Model name: Intel(R) Xeon(R) Silver 4110 CPU @ 2....
Midas Salimgali's user avatar
-1 votes
2 answers
51 views

How can we do point-in-time recovery in Cassandra?

How we can do Point in time recovery in Cassandra. Can anyone please provide the step by step process.
Balu's user avatar
  • 1
0 votes
2 answers
28 views

How do I design a table which has limited key diversity?

I'm in the process of designing a Cassandra database expected to handle messages on several clusters. The data model is primarily structured with a partitioning strategy based on a key locationId ...
Chillax's user avatar
  • 131
2 votes
3 answers
53 views

Is it possible to reattach the data volume of a node to a replacement node for migrating to a new OS?

I have a Cassandra cluster consisted of 21 nodes (each node has 4 TB Cassandra data volume) and I need to replace the nodes (migration from Ubuntu 18.04 to 22.04) I wonder if it's possible to re-...
Player's user avatar
  • 23
1 vote
2 answers
29 views

If a snapshot is cloned to a new node, will the data be replicated to the rest of the nodes in the cluster?

I have restored cassandra snapshot in one node in a new cluster which consists of 6 nodes. Will it replicate to the remaining nodes? Or do we need to copy the snapshot to remaining nodes (as done in ...
Prasad's user avatar
  • 31
0 votes
0 answers
61 views

Cassandra cluster upgrade 3.x -> 4.x fails with internode encryption = none

I have a Docker swarm cluster with 3 distinct Cassandra services (named cassandra7, cassandra8, cassandra9) running on 3 different servers. The 3 services are running the version 3.11.16, using the ...
Aldo's user avatar
  • 101
0 votes
1 answer
65 views

sstableloader fails with NoHostAvailableException, "All host(s) tried for query failed"

sstableloader run on a v4.1.3 host using sstablefiles from a v3.11.6 host: sstableloader -v --nodes oneofthehosts --username whatever --password whatever --truststore /etc/cassandra/conf/truststore....
Frank Limstrand's user avatar
0 votes
2 answers
49 views

Decommissioning a node from cluster is stuck and no clue from logs what went wrong

We have initiated decommissioning a node from 18 node cluster and I see there is no progress and still showing the status as LEAVING. The same activity earlier used to be completed in a day and now ...
Pokuri's user avatar
  • 123
1 vote
2 answers
26 views

How do I migrate from a JBOD configuration to a single-volume setup?

Need some help with something I couldn't find a solution online. I have CassandraDB running on a server. This server has 3 mounted volumes /data1, /data2 and /data3. In my scylla.yaml file, I've ...
Mujeer Ahmed's user avatar
1 vote
2 answers
70 views

Safe upgrade routine for Cassandra

I've been tasked with upgrading an Ubuntu based Cassandra cluster - having no prior experience with Cassandra. I've tried digging through the docs but have been unable to find any instructions on how ...
azzid's user avatar
  • 113
0 votes
0 answers
70 views

Performance issues after Cassandra upgrade

I would like to ask for your help in the following issue. We have upgraded our Cassandra 3.11.4 to 4.1.2 in production environment and since that we're facing with many performance issues: The ...
DezsofiM's user avatar
0 votes
1 answer
62 views

spark-cassandra-connector read throughput unpredictable

A user reports that the range query throughput is far higher than expected when setting spark.cassandra.input.readsPerSec in the spark-cassandra-connector. Job dependencies. The Java driver version is ...
Paul's user avatar
  • 381
0 votes
1 answer
63 views

Cassandra dsbulk loading data with null values doesnt implement it

I have table with 2 fields: id (primary key) fld_1 text, i have 1 row in target table, for example 1 'hello world', and i have source tsv file with 1 row: 1\t. After loading in target table i expect ...
Andrey's user avatar
  • 3
0 votes
1 answer
29 views

LOCAL_ONE and QUORUM produce different results

I'm connecting to Cassandra DB via IntelliJ Data Source and run an ad-hoc query. We have this DB in multiple data centers. My connection string includes just a single node IP. With the same query and ...
PM 77-1's user avatar
  • 123
0 votes
0 answers
23 views

Cassandra's medusa backup not working. Backup job created, but status missing and medusa container logs not updated(stuck)

I am trying to create medusa backup by running below command, but it doesn't work, it only creates the medusabackup job in MedusaBackupJobs folder, but I never get the status in the medusabackup job ...
Shivi Bhatt's user avatar
1 vote
1 answer
40 views

TWCS SSTABLE drop issue

We have encountered with an issue that 3 of our 5 nodes cluster is not dropping expired sstables automatically.Other 2 nodes its being dropped successfully. We moved from STCS to TWCS compaction ...
Cassandra Thrift's user avatar
1 vote
1 answer
121 views

Not a able to decommission the old datacenter

I am using cassandra 4.1 with Java 11. I have added the new data center and modified all my keyspaces including system_auth, system_traces, and system_distributed to replicate to new data center. Now ...
Vijayraj M's user avatar
0 votes
0 answers
38 views

Cassandra compact executor exception

When I try to load the SStable in through sstableloader, I am getting this following error: ERROR [CompactionExecutor:28] 2023-09-26 10:48:37,680 JVMStabilityInspector.java:68 - Exception in thread ...
prasanna's user avatar
0 votes
0 answers
94 views

Cassandra performance issues with GC

We are currently having minor timeouts in the Cassandra and I came across longer "stop-the-world" times in the GC log on 5 of 8 nodes while searching for the problem: Total time for which ...
DisjunkteMenge's user avatar
0 votes
1 answer
54 views

How can I perform a sanity check to confirm data is consistent after a repair?

How can i check for data sanity after performing nodetool repair on cassandra to validate that data is consistent.
Anurag M A's user avatar
0 votes
2 answers
131 views

Cassandra 3.11.16 cannot be installed due to dependencies

[Question] How can we resolve dependencies? [Requirements] I want to install cassandra 3.11 series. I want to use AmazonLinux2023 as my operating system. I want to install Cassandra using dnf ...
Shohei Okubo's user avatar
0 votes
0 answers
18 views

Cassandra repeated Error

We have 48 Nodes Cassandra Cluster and we are getting a repeated error in only one node.Any idea what may be the reason. Error is as below : ERROR [BatchlogTasks:1] 2023-08-29 09:12:55,524 ...
Cassandra Thrift's user avatar
0 votes
0 answers
9 views

Cassandra error: ERROR 16:27:50 java.lang.IllegalStateException: Attempting gossip state mutation from illegal thread: GossipTasks:1

After cloning Cassandra database from one cluster to another cluster using nodetool refresh we are seeing below errors often. This might not be related to migration but not sure. What causes this ...
Sai's user avatar
  • 35
0 votes
0 answers
25 views

SSTable loading concurrent exception

While loading sstables through SSTableLoader command, I am frequently facing this issue. java.util.concurrent.ExecutionException: org.apache.cassandra.streaming.StreamException: Stream failed ...
prasanna's user avatar
2 votes
2 answers
375 views

Upgrade Cassandra 3.0 to 4.0

I need to upgrade 3.0.27 version of Cassandra to at least 4.0.11. Can I upgrade directly from 3.0.27, or should I upgrade first to 3.11 and then to 4.0?
flower21345's user avatar
0 votes
1 answer
43 views

Is there a better option than to drop and recreate an index at regular intervals?

We know Indexes are not at all recommended in CASSANDRA. However in my project its there already and Index Size is not being reduced over time and compaction. Do we have any better option than "...
Cassandra Thrift's user avatar
1 vote
2 answers
154 views

Is it necessary to set auto_bootstrap to false when adding a new datacenter?

I am preparing the documentation for another Cassandra cluster in a new datacenter and wonder how the bootstrap process of the seed nodes and non seed nodes should be done. For the most part I am ...
DisjunkteMenge's user avatar
1 vote
2 answers
598 views

How do I migrate from Cassandra 3.x to 4.x with no downtime or risk of inconsistency?

Background and Observations: I have a 3 node cluster that is running in production (version 3.11). For the migration I first tried creating 1 new node with cassandra 4.1.2 version and added these ...
Saurabh Singh's user avatar
0 votes
2 answers
179 views

Sporadic write failures with UnauthorizedException: Unable to perform authorization of super-user permission: Cannot achieve consistency level QUORUM

I'm using Apache Spark to write data to a Cassandra cluster. The deployment is kubernetes based and am using cassandra helm chart. Sporadically, I encounter a SparkException that leads to job abortion,...
Pro's user avatar
  • 101
0 votes
2 answers
65 views

SSH tunnel to Cassandra ports failing

I am having cassandra community edition 3.11.13 running on private subnet in AWS. I am trying to create tunnel to the cassandra using below commands. ssh -vvv -N -L 9042:cass-ip:9042 username@jumphost-...
rahuls_'s user avatar
  • 19
1 vote
1 answer
98 views

Data inconsistent after restoring database using nodetool refresh in K8s Cassandra

ENV Details: GKE (Google Kubernetes cluster) Snitch Google cloud snitch. https://docs.datastax.com/en/cassandra-oss/3.0/cassandra/architecture/archSnitchGoogle.html 140 nodes with 4 RACKs (4 ...
Sai's user avatar
  • 35
1 vote
1 answer
107 views

Will all nodes get repaired if I run nodetool repair on 1 node?

I have 5 nodes with replication factor 5. This means the node has a range of partitions. if I run nodetool repair --full on node 1, will all my nodes get repaired or will only node 1 get repaired?
Vijayraj M's user avatar
2 votes
2 answers
215 views

Is it okay to have 1000 rows in a single partition?

I have multi tenancy model tenant_template ( tenant_id int, sub_org_id int, code text, active bool, ...... ) with partition key -> (tenant_id, sub_org_id) and clustering key -...
Rahul Kumar's user avatar
0 votes
1 answer
152 views

Is there a way to reduce the time it takes to perform a cleanup?

We are helping 42 nodes Cassandra cluster. For adding a new node to the cluster, we have run clean up on all nodes. We are able to run cleanup for 1 node per day. These actually sum up to 42 days to ...
Purushottam Baghel's user avatar
1 vote
1 answer
208 views

Problem with Cassandra data corruption/inconsistency

My team runs Cassandra for an internal application. This is our setup: We are running Cassandra version 3.11.13. We have multiple keyspaces; each microservice has its own. We have an active-active ...
obsessiveprogrammer's user avatar
1 vote
2 answers
136 views

Cassandra Upgrade 2.1 to 3.11

I have a multi(two) DC Apache cassandra cluster with active replication. DC1 is primary(production) and DC2 is DR. I plan to upgrade from 2.1 to 3.11. What is the best way to achieve the upgrade ...
Ganesh Neupane's user avatar
0 votes
1 answer
93 views

Cassandra 4.0.5 nodes fails to start when replacing dead node

Trying to replace a down node the new nodes fail to start, using property replace_address. WARN [Messaging-EventLoop-3-2] 2023-08-16 14:18:58,565 NoSpamLogger.java:95 - /xxx.xxx.xxx.xxx:7000->/yyy....
anshul's user avatar
  • 1
1 vote
1 answer
273 views

Cassandra client can't connect immediately after Cassandra startup

We have unclustered, single-node Cassandra 3.11.2 instances supporting many separate customer environments. Recently, we have seen many cases where a Cassandra instance is started successfully by a ...
Fred's user avatar
  • 15
6 votes
3 answers
1k views

Is it OK to have nodes with mixed major versions running for months?

We are planning to upgrade to Cassandra 4 (currently on 3.x). The question is -> Is it ok for Cassandra cluster to run for extended periods (months) in a mixed mode. Like some datacenters Cassandra ...
Dmitri Pavlov's user avatar
0 votes
1 answer
92 views

Seeing slow performance for range queries with ALLOW FILTERING in Cassandra 4.0.11

Seeing high latency for range queries with ALLOW FILTERING and CL LOCAL_QUORUM in Cassandra 4.0.11. I see repaired_data_tracking_for_range_reads_enabled property in cassandra.yaml which can impact the ...
Manish Khandelwal's user avatar
0 votes
1 answer
18 views

Experiencing IP conflicts restoring Cassandra DB from snapshots in GKE environment

While restoring 750TB Cassandra database using disk snapshots in GKE (google cloud K8s) environment from one namespace to another namespace we are experiencing issues with IP conflicts, to avoid the ...
Sai's user avatar
  • 35

1
2 3 4 5
10