Skip to main content

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
13 views

Migrating Cassandra cluster between different AWS accounts

Note: The two different accounts could be as well two different physical locations. I would expect the answer to not change based on such a detail. I have a DSE 5.1.x production cluster of 6 nodes + ...
MASL's user avatar
  • 63
0 votes
0 answers
12 views

How to achieve low-cost disaster recovery for a large Cassandra cluster in GKE

We have a Cassandra cluster running on GKE with a 32-CPU node pool and SSD disks. The current cluster size is nearly 1 PB, with each node utilizing an average of 5 TB on 10 TB allocated SSD disks. The ...
Sai's user avatar
  • 37
0 votes
0 answers
12 views

Exception During Rebuilding new datanode from a old datacentre

We are doing cassandra datacenter migration. We are following the below steps for that. Restrict traffic to the existing datacenter. Expand the Cassandra cluster by adding a new datacenter. Rebuild ...
Fire-Hox's user avatar
  • 101
1 vote
2 answers
39 views

Is it expected that reading a whole table takes too long?

I am trying to perform heavy read operations on cassandra DB to plot some graphs however the request is always getting timed out. As a result I increased all the timeout and tried to manually read the ...
Jayesh Popat's user avatar
-2 votes
0 answers
10 views

Wrong Documentation for Time Window CompactionStrategy | unsafe_aggressive_sstable_expiration

I was installing the unsafe_aggressive_sstable_expiration and found out that there is a mistake in the documentation. The documentation told us that we needed to enable in the jvm -Dcassandra....
Jon Corral's user avatar
2 votes
1 answer
16 views

Does updating a frozen column generate a tombstone?

I was planning to change my column from nonfrozen to frozen. I would like to know if there are any guidelines for updating the frozen column with respect to tombstone generation. In some blogs it is ...
Prateek Sharma's user avatar
0 votes
0 answers
18 views

Unsafe_aggressive_sstable_expiration - Procedure to enable unsafe_aggressive_sstable_expiration

I am planning to enable this tag to solve an issue related to some SSTables that are fully expired and are blocking some other expired SSTables from being expired. I have looked for information on ...
Jon Corral's user avatar
1 vote
1 answer
15 views

Why do nodes have increased memory use after upgrading Cassandra?

Nodes appear to be using more memory than when they were running with Cassandra 2.1. When nodes were upgraded to a newer version of Cassandra, the memory utilisation on the servers have suddenly gone ...
Erick Ramirez's user avatar
0 votes
1 answer
73 views

New node cannot join, connection fail during the streaming

I have 3 node cassandra cluster (version 4.1.5). I am trying to join a new node. I've started the new node, the node is in a joining state and data are replicated to it. But after some time the ...
Miroslav Novotný's user avatar
0 votes
1 answer
126 views

How do I connect to a Cassandra cluster from DBeaver community edition?

The DBeaver Cassandra driver is only available in the Pro version. How do I connect to a Cassandra cluster if I'm using the Community Edition?
Erick Ramirez's user avatar
0 votes
1 answer
28 views

Startup fails post upgrade with "AssertionError: null" in o.a.c.schema.TableMetadata$CompactTableMetadata.getCompactValueColumn()

I am trying to upgrade my 3 node Cassandra cluster from version 3.11.13 to 4.1.5. After start the upgrade node I get this error: ERROR [main] 2024-06-20 08:48:23,708 CassandraDaemon.java:915 - ...
Miroslav Novotný's user avatar
0 votes
1 answer
13 views

With RF=3 will data be replicated 3 times in each rack?

We have 9 physical servers, each server has 4 physical disks, which means we have a total of 36 physical disks, each one related to one Cassandra node. We would like to have a replication of 3 across ...
LilRose's user avatar
  • 23
2 votes
1 answer
44 views

How does replication work when there are multiple racks in a DC?

I would like to understand how Replication Factor works when having the following scenario: We have a set of total of 18 disks, each one related to 1 Cassandra node, and all distributed in 3 Racks ...
LilRose's user avatar
  • 23
1 vote
1 answer
28 views

Querying Cassandra from SQL server with where clause issue

I'm facing a strange issue where I have a SQL server connected to Cassandra to pull time series data. I'm using the 'DataStax C/C++ Driver for Apache Cassandra' and have connected via a 'linked' ...
Thomas Gross's user avatar
1 vote
2 answers
44 views

Replacing a dead 3.11 node fails with OOM

When trying to replace a dead node, the replacement node fails after a long time with an OOM error. I believe the issue is linked to secondary indexes on a table. I can see that on the new nodes /...
John Koyle's user avatar
1 vote
1 answer
14 views

Is Cassandra certified on KVM?

I run Cassandra 4.1.3 inside OpenNMS Horizon 30.0.4; we run the solution on vms virtualized with VMware ESXi on Ubuntu 20.0.4 LTS; we were asked by the customer to migrate the solution from VMware to ...
Daniele's user avatar
  • 11
1 vote
1 answer
21 views

Is there a full copy of data on each node if RF=3 and DC has 3 nodes?

When backing up a Scylla cluster (or cassandra for that matter) I understand that its best practice to take a snapshot of every node. However if I have a 6 node distributed cluster spanning 2 ...
imbrian21's user avatar
0 votes
2 answers
34 views

DSBulk count returns more rows than unloaded in CSV files

I'm doing dsbulk unload for one table, with one primary key field, without clustering key. At the end in console I see something like this total | failed | rows/s | p50ms | p99ms | p999ms ...
Viktor Tsymbaliuk's user avatar
0 votes
1 answer
18 views

Incremental repair failed with IOException: "Endpoint /x.x.x.x died"

In Cassandra 3.11 cluster, initiated a incremental repair from one of the nodes in the cluster. The repair got stuck while the tpstats shows the repair task as completed. I see the below logs on that ...
shri vanitha's user avatar
0 votes
1 answer
28 views

Repairs return errors "Failed creating a merkle tree", "Got VALIDATION_REQ failure"

On Cassandra 4.0.7 we are seeing Merkle tree repair errors , we are using cassandra-reaper to do continuous repairs, below is the exception ERROR] [RequestResponseStage-9] 2023-11-05 13:49:58,131 ...
Jeetendra Nalawade's user avatar
0 votes
1 answer
33 views

Debian package for Cassandra 3.11.17 is not available in official repository

While fix release 3.11.17 for Cassandra 3.11.x was announced a while back, the latest version of the Debian package at the official Debian repository as per https://apache.jfrog.io/artifactory/...
Roman's user avatar
  • 3
0 votes
2 answers
48 views

Cassandra service produces no logs whatsoever when trying to start

Time and again I come across this issue where I edit some cassandra config file, and cassandra service does not start anymore. How can I understand why service cassandra start doesn't start Cassandra?...
Pavel Orekhov's user avatar
1 vote
3 answers
59 views

Which Python 2.7.x version is compatible with both Cassandra 3.11 and 4.1?

I'm upgrading Cassandra from 3.11 to 4.1. One of the requirements is the latest python 2.7 updates. I want to upgrade Cassandra with no downtime, so I need to know which python 2.7 update is ...
user avatar
0 votes
1 answer
22 views

Do old inserts get treated as new CDC events during node bootstrap?

When a new Cassandra node bootstraps and receives data from existing tables for which Change Data Capture (CDC) is enabled, do old inserts get treated as new CDC events? I don't see any reference to ...
tdhso's user avatar
  • 5
0 votes
2 answers
27 views

Bulk-loading snapshot, sstableloader returns "[table] doesn't exist"

I have about 60GB of data on a simple scylla cluster and I would like to migrate them to Cassandra 4.1.5. I have taken a snapshot on scylla with command nodetool snapshot -t scylla-20240524 --table &...
Ste's user avatar
  • 103
0 votes
1 answer
30 views

Optimizing Cassandra Table Design for Queries Involving Two Partition Keys

I’m designing a Cassandra table and need advice on the best schema design to handle my query patterns efficiently. The primary queries are as follows: 90% of the queries involve both account_id and ...
Chillax's user avatar
  • 131
1 vote
1 answer
78 views

Cassandra DSE recommendation of 1TB load per node

I would like to understand the recommendation of max. 1TB load per node that is repeatedly being suggested around, Datastax in particular. I have not seen anywhere how such a limit translates into any ...
MASL's user avatar
  • 63
1 vote
2 answers
22 views

Can we move data then start an upgraded Cassandra 4.1 in RHEL 8?

I am planning to upgrade my 6 node Apache Cassandra from 3.0 (RHEL 7.9) to 4.1 version (RHEL 8) without downtime. We are moving to new RHEL 8 server. We are upgrading with 4.1 version on the new RHEL ...
Rakesh D's user avatar
0 votes
1 answer
23 views

Cassandra query response is empty as load increases

Cluster background: We have a three node cassandra cluster. As soon as I clear the entire database and start from scratch soon the load will reach about 100 GB per node and keep on increasing and ...
Jayesh Popat's user avatar
0 votes
1 answer
13 views

Why is disk usage reported by the OpsCenter storage capacity widget different than "Data Size" metric?

DataStax OpsCenter for Cassandra - why is disk usage reported by storage capacity widget different than "Data Size" metric? The Storage Capacity widget shows 38.96 TB used but a graph of the ...
Lars Nordin's user avatar
0 votes
3 answers
49 views

How do I restore snapshots to another table?

Someone accidentally deleted several records from Cassandra's table in the cluster. I want to restore the last snapshot to another copy table with the same structure within the cluster. What is the ...
EdiM's user avatar
  • 31
0 votes
1 answer
28 views

Is a multi-table batch within the same node atomic and isolated?

Im trying to understand this. cassandra batches are atomic always, and if the batch only modifies a single partition of a single table, then that batch is also isolated. but what about multi table ...
InglouriousBastard's user avatar
0 votes
1 answer
27 views

If SSTable sorted, why do we need Sparse Index?

As far as I know, when we create clustered index it restructures the table in B-Tree form and uses binary search when we try to find particular row. SSTable is also sorted by key. Why do we need ...
Shamil's user avatar
  • 3
0 votes
1 answer
99 views

What is the timeline for Cassandra 5.x GA release for commercial use?

I want to use the Vector Search new feature that is added to Cassandra 5.0 with the Vector CQL data type . What is the timeline for Cassandra 5.x GA release for commercial use ?
Vinod Pillai's user avatar
0 votes
2 answers
102 views

Failed to link the C library against JNA, Cannot open shared object file

I am having issues with installing Cassandra 4.0 and 4.1 on my rhel 8 server. I've tried using java 11 openjdk and Corretto 11 openjdk. When I start Cassandra I would receive: Native LibraryLinux.java ...
jexport's user avatar
0 votes
1 answer
103 views

Is there a RHEL compatibility chart for Cassandra?

Could you please let me know if there is any Compatibility chart for Cassandra and RHEL? More specifically want to know if Cassandra 3.11 is Compatible with RHEL8* and RHEL9*? Cassandra 4.1 is ...
Cassandra Thrift's user avatar
0 votes
1 answer
58 views

Unexpected disk state: failed to read transaction log

Has anyone encountered the situation described in this DataStax article? Any ideas on root cause i.e. under what situations does Cassandra not write ABORT or COMMIT as the last entry in the ...
Chris Miller's user avatar
0 votes
1 answer
62 views

TimeWindowCompactionStrategy - are new columns with diminished TTL blocked by older columns with higher TTL?

I've been struggling with how specifically TWCS works lately. In our workflow we have some tables containing time-series data with a mostly static TTL. As such, a decision was made to use TWCS as the ...
LVC's user avatar
  • 3
0 votes
1 answer
88 views

Facing read/write timeout in the middle of Cassandra rolling upgrade from Cassandra 3.0.15 to 4.1.4

Im preparing to upgrade my Cassandra cluster (3 Nodes x 2 DCs) from Cassandra 3.0.15 to 4.1.4, when i tried the upgradation process in a similar setup i faced following issues in the middle of the ...
LUCKNESH's user avatar
0 votes
2 answers
45 views

How do I change the user running DSE?

The user I'm referring to is the user created by the Datastax DSE package install. I'd like to replace that user with another account. I've found a couple of places where the "Cassandra user"...
mkvdba's user avatar
  • 1
1 vote
1 answer
16 views

What do the numbers or tags on the Apache Cassandra FAQ page mean?

I'm new Apache Cassandra and I was just going through the FAQ page of Apache Cassandra. I see sentences such as follows in the answers: See 256 and 43 for more gory details. See topology-changes. I ...
Akshay Hiremath's user avatar
0 votes
1 answer
30 views

What is the impact of increasing batch_size_fail_threshold?

I see this post which recommends not to increase these values but I have a requirement from application to increase it to the below threshold. Could you please let me know what is the impact if I ...
Solver's user avatar
  • 1
0 votes
1 answer
44 views

cqlsh taking too long to respond for connectivity

In our application we have a monitoring service for cassandra which periodically executes a set of nodetool commands to check and update the db status. It also executes cqlsh <ip-address> <...
Jayesh Popat's user avatar
-1 votes
1 answer
33 views

Cassandra 3.11.10 sstable utilities are missing in /bin directory of my cassandra database

We have our Cassandra cluster running on 3.11.10 as you can see from the below nodetool version ReleaseVersion: 3.11.10 Cassandra is installed on Linux OS of version '7' as you can see from the below ...
Vamsi's user avatar
  • 7
0 votes
1 answer
33 views

Why does reading from system.local in Cassandra 4 involve 3 nodes when replication is LocalStrategy?

After upgrading to Cassandra 4, I noticed the increased latency of this very simple query: cqlsh> SELECT * FROM system.local; Here is the tracing: activity ...
YuryV's user avatar
  • 1
0 votes
0 answers
16 views

Getting NullPointerException when running o.a.c.distributed.upgrade.UpgradeTest

I was trying to run the JVM distributed (upgrade) tests under test/distributed/org/apache/cassandra/distributed/upgrade with the command: ant test-jvm-dtest-some -Duse.jdk11=true -Dtest.name=org....
Alen Wang's user avatar
0 votes
1 answer
95 views

Cannot connect to Cassandra 5.0 cluster with cqlsh, getting "ModuleNotFoundError: No module named 'geomet'"

We are upgrade Cassandra Cluster from 4.1 to 5.0 on Red Hat Enterprise Linux release 8.9 (Ootpa). After upgrade, we are trying to connect to instance but no successful. follow the msg: [root@SERVER01 ...
Roberto Magalhaes's user avatar
0 votes
2 answers
95 views

Percent Repaired going low to zero % in matter of seconds

We have three node cassandra cluster which has a set ttl of around 48 hours and automatic compactions enabled and also automatic incremental repair enabled every 24 hours. After doing a db purge[...
Jayesh Popat's user avatar
0 votes
0 answers
16 views

Need help decoding compressed SSTable

It's certainly a dumb idea but I convinced myself to write a sstable decoder in Golang. I've read the spec here. Currently I can decode the Compression file. According to this file it's pretty clear ...
Raphaël MAZELIER's user avatar
0 votes
2 answers
41 views

Is the local coordinator the sole propagator to remote DCs?

When a write to Cassandra uses LOCAL_QUORUM, is the coordinator node at the originating DC the sole propagator to the remote DCs, or can other nodes/DCs share that role if, say, something happens to ...
tdhso's user avatar
  • 5

1
2 3 4 5
11