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

DSE Unified Auticatication does not working

I would like to use these two pages to enable DSE Unified Authentication and realize a secure environment. I have tried to configure it but it does not work. How is it as a symptom. When I type ...
  • 31
0 votes
0 answers
15 views

Creating Copy of Cassandra Source Cluster

I have a question about Cassandra Backup & Restore procedure. I have setup a 3-node source cluster and now I took a backup of a keyspace using: https://docs.datastax.com/en/dse/6.8/dse-admin/...
1 vote
1 answer
14 views

How can I cassandra stress test

I took the DS210 course offered by Datastax and prepared a cluster of almost the same configuration by myself. I edited the /etc/dse/cassandra/cassandra-env.sh file in Exercise 2.3, but I still got &...
  • 31
1 vote
1 answer
10 views

How do I add a numpy array into cassandra table

I am creating a table where I need to store an image translated into a numerical array ( typically float values ). While I am able to create a table with the numerical array column declared as BLOB ...
1 vote
1 answer
21 views

Can we reduce the memory usage for "Redistributing index summaries" in Cassandra?

We have deployed cassandra-cluster in EKS. For some days we are getting alert messages Pod cassandra-0 Memory usage is 90.08 percentage in last 2 minute We checked cassandra pod logs, we were not ...
1 vote
1 answer
18 views

Cassandra 4 - java.lang.OutOfMemoryError: unable to create new native thread

After upgrading Cassandra 3.x to 4.X follows error occurs. INFO [NonPeriodicTasks:1] 2022-09-24T04:41:26,003 SSTable.java:111 - Deleting sstable: XXX/cassandra/data/system/compaction_history-...
1 vote
1 answer
58 views

If Cassandra is so good for write, why read isn't encouraged?

Background for this question I have a machine learning pipeline where all our Features and pre-calculated prediction scores are stored in PostgreSQL database. I have in excess of 800 columns as ...
  • 137
1 vote
1 answer
11 views

Can I safely stop the decommission of a Cassandra node?

Is possible to rollback / cancel a nodetool decommission if something goes wrong on the other nodes or on the clients?
  • 3,416
1 vote
1 answer
12 views

Cassandra cluster still trying to reach old IP

I've seen a strange behaviour since a node decommission; regularly some Cassandra nodes start massively outputting these logs: OutboundTcpConnection.java:570 - Cannot handshake version with /10.208.58....
  • 3,416
0 votes
2 answers
29 views

Cassandra producing inconsistent results

I have a Cassandra cluster with 3 nodes and a replication factor of 3. A colleague of mine moved the data for each of the nodes from one disk to the other. It is possible that something wrong happened ...
1 vote
1 answer
17 views

Can we just copy the data directory of production nodes to DR nodes if the prod Cassandra cluster is down?

Requirement: Cassandra PROD container runs in one reqion and DR container runs in another region. Take full snapshot of data folder and incremental snapshot of data folder If PROD region goes down, ...
  • 11
1 vote
1 answer
11 views

Cassandra 4.0.6 repair returned "/IP failed the prepare phase for incremental repair session"

We recentally migrated to Cassandra 4.0.6 from 3.11.6 on Dev environment. During the testing of this version of cassandra, I tried running incremental repair on a table in keyspace and it failed. In ...
1 vote
1 answer
40 views

Unable to clone keyspace using DSE Backup & Restore Service

I'm trying to restore from old keyspace to new keyspace but getting below error. cqlsh> RESTORE geo1 ... FROM BACKUP ks1_config_name-20220916194400.146-ea3173fc-760e-4dcd-9d7b-6f928c40eab5 ......
  • 41
0 votes
1 answer
20 views

How can we enforce custom password complexity in Cassandra?

Is there any way to enforce password policy for Cassandra database users? Something like the password must contains 8 characters with a special character , an upper case character and a lower case. ...
-1 votes
0 answers
23 views

Cassandra 4.0.5 : Nodetool repair hangs (Incremental repair) on a particular keyspace

My nodetool repair hangs at a particular keyspace, and the system logs does not show anything. [2022-09-15 08:05:32,480] Starting repair command #5 (1480-34f7-11ed-ae24-0543e5ff06cc), repairing ...
1 vote
1 answer
47 views

Column information still present in sstables after "drop column"

We are running Cassandra 3.11.4 (yes, I know it's old - we will upgrade soon). We have unfortunately run into an issue where I am doing restore/PITR that fails to do "nodetool refresh" on a ...
2 votes
1 answer
50 views

Cassandra nodes removal, most appropriate strategy?

Due to disk underuse, I am considering reducing the size of a Cassandra cluster (v 3.11.13) from 12 to 9 nodes (from 4 to 3 nodes per rack). The cluster is therefore spread across 3 racks and has a ...
  • 123
0 votes
0 answers
15 views

Using the root user in service commands

I am attempting to use the root user as the cassandra user but getting an error in the output log: Running Cassandra as root user or group is not recommended - please start Cassandra using a different ...
0 votes
0 answers
25 views

IN restrictions are not supported on indexed columns

I pull cassnadra:latest image in docker and make container. when I exec container and run following query: select count(*) from items where item_id in (ef2ca439-ce2a-4254-96d2-dc0c3bbed85c, c190676f-...
2 votes
2 answers
29 views

Repurposed Cassandra node unable to bootstrap, returns "IllegalStateException: Unable to contact any seeds"

Not sure if this is bug with cassandra 4.0.5 but when i remove data directory and clean up all other directory and try to join node to cluster i get below error. 4.0.4 seem to be works fine DEBUG [...
0 votes
0 answers
22 views

cassandra creation with docker-compose

I am very new to cassandra I am trying to bring up cassnadra using docker-compose but it is giving connection error for cqlsh. Can you please let me know what am I missing here and how can I run init....
  • 101
3 votes
2 answers
87 views

How do I migrate from PropertyFileSnitch to GossipingPropertyFileSnitch in DataStax Enterprise?

I have followed this link to migrate PropertyFileSnitch to GossipingPropertyFileSnitch but I'm getting this error: INFO [DSE main thread] 2022-09-08 14:12:44,295 StorageService.java:286 - Detected ...
  • 41
2 votes
2 answers
31 views

Is data still available if 2 Cassandra nodes go down with RF=2?

I'm newbie to C*, so can anyone please help. Suppose, in my environment there is a cluster of 6 nodes and a keyspace with RF=2. One day, two out of six nodes are down, so can I get data from the other ...
  • 21
2 votes
1 answer
10 views

What steps are required to mitigate the CVE-2021-44521 exploit in Cassandra UDFs?

Cassandra operators are concerned that they are vulnerable to the exploit identified in CVE-2021-44521. What steps can operators take to mitigate the risk and exposure to the vulnerability?
3 votes
1 answer
134 views

Are client-side JOINs preferred in Cassandra?

Since server-side joins are not supported in CQL, are client-side joins the preference as a workaround?
2 votes
1 answer
36 views

What is the procedure for downgrading Cassandra 4.x to 3.x?

My cluster runs on Cassandra 3. Upgrading of my cluster involves many steps, included switching to Cassandra 4.Upgrading process goes node by node, to provide High Availability. So if one of the nodes ...
0 votes
1 answer
16 views

On which Cassandra nodes will hints get generated?

I am trying to experiment with some of the settings related to hint files for my cluster. https://cassandra.apache.org/doc/latest/cassandra/operating/hints.html My cluster configuration is pretty ...
  • 101
2 votes
1 answer
30 views

How do I migrate data in tables to a new Cassandra cluster?

How do I migrate application tables in an existing Cassandra cluster to a new cluster? The new cluster has a different topology and token assignments to the source cluster.
0 votes
1 answer
17 views

How do I restore Cassandra snapshots to another cluster with identical configuration?

This is a common question from Cassandra operators who want to migrate data from one cluster to another. What would be the procedure for restoring snapshots of a Cassandra cluster to another cluster ...
0 votes
1 answer
14 views

OutOfMemory error for OpsCenter agent

We met OpsCenter agent out of memory issue before and increased -Xmx in datastax-agent-env.sh to 2048M according to Datastax doc. It has been running well for past few month, recently two agents has ...
  • 1
4 votes
1 answer
69 views

Failed upgrade path for Cassandra 2.0.17 -> 3.11.11 -> 4.0.5

I have Cassandra cluster which has been initially installed Cassandra 2.0.17 version. During the time it has been upgraded through minor and major version, at the end it's on 3.11.11 version. Now I'm ...
3 votes
1 answer
23 views

Are there data modelling tools available for Cassandra?

This question comes up quite often. For those who are new to Cassandra and particularly to data modelling, what tools are available?
2 votes
1 answer
16 views

Repair on a 3-node Cassandra cluster returns error "Got negative replies from endpoints"

I have a 3 node cluster that is running as side-car in K8. One of the node went down and there was data update while it was down. I tried to run repair, nodetool repair sourcekeyspace priceconfig to ...
  • 21
2 votes
1 answer
17 views

Is it still possible to connect to Astra DB using DataStax Studio?

Developer Studio used to available on the Astra web UI which provided a notebook-like interface for interacting with the database. It looks like it is no longer part of the Astra Dashboard. Is it ...
1 vote
1 answer
25 views

Cassandra can't start with an old backup of /var/lib/cassandra

I have an old Cassandra backup of /var/lib/cassandra on an external drive and I want to setup a new database with this backup. I install the same Cassandra version as then and in the yaml file I ...
1 vote
2 answers
44 views

How would I change cluster_name for an existing Cassandra cluster?

I would like to know how to change or modify the cluster name for the existing Cassandra cluster. I followed to update the cluster name using the below query but it failed while trying to alter the ...
3 votes
2 answers
76 views

Is there a way to limit the hints stored for a Cassandra node?

In a situation where a node keeps going up and down (for example, becomes temporarily unresponsive due to GC), is there a way to limit the the hints stored for the problematic node to prevent build up ...
2 votes
1 answer
229 views

How can I access cassandra.yaml in Docker?

I use cassandra image to create cassnadra container. I use volumes as follow: - ./samt_tmp/cassandra_data/cassandra:/etc/cassandra/ I want create cassandra.yaml from docker in my pc but this path isn'...
2 votes
1 answer
62 views

How do I get a Cassandra node to show the IPv4 address in the nodetool status output?

I'm currently working on a cluster with DataStax Enterprise 6.8, but the address part of the picture is showing up as localhost (127.0.0.1). How can I get it to show the actual IPv4 address?
  • 31
1 vote
2 answers
20 views

Does firewall access on the gossip port need to be opened for all nodes in a Cassandra cluster?

When configuring firewall access lists (ACLs), is it necessary to open the gossip port between nodes for all nodes in a Cassandra cluster?
1 vote
1 answer
29 views

Can someone explain in simple terms Cassandra nodetool commands like compact and cleanup?

Hello Everyone I am new in databases and i am trying to understand some Cassandra commands. I would like to know about the following commands : nodetool compact nodetool cleanup nodetool repair ...
1 vote
1 answer
14 views

Cassandra log reports "MarshalException: UUID should be 16 or 0 bytes (14)"

While monitoring the logs of Cassandra I'm getting the below error in the logs. It's not causing any issue till now, just want to confirm if it's a potential issue & how can I rectify this error. ...
2 votes
3 answers
33 views

How do I block all IP addresses from connecting remotely to Cassandra?

I want access to remote cassandra with one ip address. how can I change cassandra.yaml to block all ip address except ip that I want to connect? Can I do by cassandra.yaml ?
0 votes
1 answer
21 views

Cassandra System.Log shows nodtool tpstats output

We have a Docker Cassandra container running 6.8.21. At times when the container is restarted the the Logs show the usual startup activities and all just works well post that. But on a few occasions ...
  • 1
1 vote
1 answer
23 views

Not able to wrap values in quotes when exporting CQL table to CSV

I am not able to copy data into a CSV file and have them wrapped with single quotes: e.g. Table: myks.mytable column1 column2 value1 value2 command used: copy myks.mytable (column1,column2) to '...
2 votes
1 answer
506 views

nodetool with Java 8u331 returns "URISyntaxException: 'Malformed IPv6 address at index 7: rmi://[127.0.0.1]:7199'"

Why does running nodetool return the following exception? nodetool: Failed to connect to '127.0.0.1:7199' - \ URISyntaxException: 'Malformed IPv6 address at index 7: rmi://[127.0.0.1]:7199'. This ...
1 vote
1 answer
19 views

What is replica filtering protection in Cassandra?

There are instances where operators see the following warning in the Cassandra logs: WARN ... Replica filtering protection has cached over 2000 rows during query \ [SELECT ... FROM ... WHERE ...]. (...
1 vote
1 answer
20 views

Which versions of DataStax Enterprise have the fix for CVE-2020-13946?

Early versions of Apache Cassandra had a vulnerability that could potentially allow a local attacker to manipulate the RMI registry to capture credentials and gain access to the JMX interface (CVE-...
1 vote
1 answer
46 views

Disk space is not released after compaction

We have deleted some of the partionons of some tables in cassandra database. But after the delete space was not recliamed becuase of size-tiered compaction . Manualy compacted tables with -s options. ...
1 vote
1 answer
41 views

dsbulk unload fails on a specific row after running for nearly 2 minutes

We would like to export all data from a Cassandra Keyspace table to CSV with dsbulk. dsbulk unload -k KEYSPACE -t TABLE -f ./application.conf > export_TABLE.csv If we do so, it completes with 1 ...

1
2 3 4 5