Questions tagged [cassandra]

Apache Cassandra is an open source distributed key-value database cluster, designed to scale linearly when adding nodes. It provides multi-datacenter replication.

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

Do cassandra contact nodes act as proxies

I am using a very large cluster with hundreds of nodes. I only specify several nodes as contact points. My question is, do I have to open a firewall to all of the cluster's nodes, or can I only open ...
f.khantsis's user avatar
0 votes
0 answers
49 views

Kubernetes : 0/2 nodes are available: 2 node(s) didn't match pod anti-affinity rules. preemption

I'm experiencing this issue: Pending Pod due to nodes didn't match pod anti-affinity rules NAME READY STATUS RESTARTS AGE IP ...
Raphael10's user avatar
  • 157
1 vote
1 answer
487 views

failed to create cluster: failed to join node with kubeadm

I've been told my k8ssandra people that the following errors are related to kubernetes What do I have to do to detect, and solve, the issue? kind seems working fine: root@k8s-eu-1-master:~# kind ...
Raphael10's user avatar
  • 157
0 votes
0 answers
138 views

url=/api/v0/probes/readiness status=500 Internal Server Error

url=/api/v0/probes/readiness status=500 Internal Server Error Always get this INFO in Cassandra logs how to resolve this? Things I did to resolve it which did not worked out Scale up and down node ...
Shivi Bhatt's user avatar
0 votes
0 answers
138 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
0 votes
0 answers
60 views

Necessity to backup Cassandra system keyspaces

I was wondering about the necessity to backup (in order to restore of course) the system keyspaces of Cassandra. My backup/restore procedure is the following: backup: snapshots (nodetool) + dump of ...
drkmkzs's user avatar
  • 311
1 vote
1 answer
43 views

What data type do big applications use to store time data?

I am trying to find out which data type is better to store time data inside either MySQL or Cassandra database for a big application like Facebook or Instagram? There are a lot of similar questions ...
best_of_man's user avatar
2 votes
1 answer
466 views

Is it better to generate "UUID" and "TIMESTAMP" within the NodeJS application or using the database built-in functions?

I am writing a TypeScript-NodeJS application and want to handle object ids and created_at TIMESTAMP within the NodeJS application, instead of using MySQL or Cassandra built-in UUID or TIMESTAMP ...
best_of_man's user avatar
-1 votes
1 answer
288 views

How can I release previously allocated resources of a deleted pod?

I already had 3 Cassandra node/pods running. I deleted them and tried to re create them again using the same YAML file as following, on the same Kind cluster, but it stuck pending status: apiVersion: ...
best_of_man's user avatar
1 vote
1 answer
65 views

How should I replace this line "provisioner: k8s.io/minikube-hostpath" for a "Kind" statefulset.yaml file?

The following is a StatefulSet.yaml file for deploying Cassandra database on a minikube cluster. I am not sure what lines should be replaced if I want to use a Kind cluster instead of a minikube one, ...
best_of_man's user avatar
0 votes
2 answers
3k views

What is the equivalent command of "minikube start --memory 5120 --cpus=4" for "Kind"?

Here in Cassandra deployment instruction, it says: Caution: Minikube defaults to 2048MB of memory and 2 CPU. Running Minikube with the default resource configuration results in insufficient resource ...
best_of_man's user avatar
0 votes
1 answer
88 views

When and How we should specify "clusterIP" inside the "service.yaml" file?

I tried to deploy mysql and cassandra databases using kubernetes.io/docs instructions. In both of them, within the service.yaml files, they use clusterIP: None like following: For cassandra: ...
best_of_man's user avatar
0 votes
1 answer
248 views

Why "Cassandra" uses "StatefulSet" instead of "Deploymdnt" file for "Kubernetes"?

I am trying to deploy Cassandra on my local Kind cluster running on my Ubuntu 22.04 machine. The only instruction I found is this, that uses a StatefulSet for that. I am just wondering to know, isn't ...
best_of_man's user avatar
2 votes
1 answer
2k views

Which version of the JDK should we install for Cassandra 4.0.1

We are planning to upgrade our Cassandra servers from 3.0.11 to 4.0.1 Here it says to use JDK 8. I would like to know if as of this writing this is still the case. I believe the latest released Oracle ...
adinas's user avatar
  • 123
1 vote
0 answers
1k views

High CPU usage and traffic on some Cassandra nodes

As stated in the title, we are having a problem with our Cassandra cluster. There are 9 nodes with a replication factor of 3 using NetworkTopologyStrategy. All in the same DC and Rack. Cassandra ...
kylethedeveloper's user avatar
1 vote
0 answers
112 views

Throttle Spark Cassandra Connector Reads on a Production Cluster

We're currently running a 24 Node Cassandra Cluster in Production that holds 30Tb of data and handles an average live load of 100k Requests Per Min 24/7. We support multiple partners. One of our ...
Mano's user avatar
  • 11
0 votes
1 answer
543 views

Does Cassandra rebalance the data after inserting additional disks?

I'm running a Cassandra cluster with 5 nodes, each having 10 1Tb disks (JBOD). Currently, one of the nodes is in the problematic situation where a large compaction can no longer succesfully complete ...
RikJ's user avatar
  • 3
0 votes
1 answer
2k views

Spark-Cassandra-Connector Issue Exception in thread "main" java.lang.NoClassDefFoundError: com/datastax/spark/connector/rdd/reader/RowReaderFactory

What is going wrong with the Spark Cassandra Connector could you please help to solve this? Scala File: import com.datastax.spark.connector._ import org.apache.spark.sql.SparkSession import org.apache....
Subhrangshu Adhikary's user avatar
0 votes
0 answers
113 views

Required best GUI of Cassandra DB for user interface communication

I am new to the Cassandra DB. Started learning using the command shell. I am searching for the GUI, so please suggest me the best GUI for the Cassandra DB. GUI should have all features like DDL, DML, ...
Sucharitha's user avatar
0 votes
1 answer
286 views

Cassandra NAMED datacenter

After a day of research, I open a question. I can't rename a cassandra node. I would like to put a node at D1, and another one at D2 both in rack1. But here is the result I get $ nodetool status ...
whoami's user avatar
  • 103
0 votes
1 answer
71 views

cassandra backup - errors during compression

My cassandra backup often returns with errors because users move/change it during the compression (we just tar it). Users are logged to the server 24/7 so we can't just change backup hours. I need ...
Galmachar's user avatar
0 votes
1 answer
1k views

cassandra replication not 100 percent on each node

I had Cassandra cluster of 3 nodes. I was performing some colud migration activity and for that, I added two more nodes in an existing cluster and the result is as follows. Datacenter: datacenter1 ===...
innervoice's user avatar
0 votes
1 answer
825 views

Elassandra "action_request_validation_exception"

Elasticsearch DEBUG: 2019-09-23T09:23:39Z starting request { "method": "HEAD", "castExists": true, "path": "/my_keyspace", "query": {} } Elasticsearch TRACE: 2019-09-23T09:23:39Z ...
Max0999's user avatar
  • 223
0 votes
1 answer
400 views

System_auth keyspace overwritten in Cassandra cluster

I was adding a Node2 to another cassandra Node1 to form a cluster and I lost my user database (which caused authentication problems). I appreciate if someone can help me to understand what happened (...
wmac's user avatar
  • 111
1 vote
1 answer
457 views

Apache Cassandra repair snapshots are not deleted

On a Cassandra cluster running Apache Cassandra 3.11.4 that is repaired using Cassandra Reaper 1.4.1, I am experiencing the problem that the snapshots that are created by the repair process are ...
Sebastian Marsching's user avatar
1 vote
0 answers
61 views

Risks of adding Cassandra 3.11 nodes to a 2.1 cluster

We're running DSE v4.8.5 (which uses Cassandra 2.1.13), and we need to migrate to the community edition of Cassandra v3.11 and then retire the old DSE servers. Someone (it might have been me) ...
Rich's user avatar
  • 11
0 votes
1 answer
213 views

Access Cassandra on Google Cloud - Kubernetes from local DataStax Studio

I've setup Cassandra cluster on Kubernetes on GCP. I can very well execute the cqlsh from my local machine, using the CLI. However, I've DataStax Studio installed in my machine and I wish to access ...
Diptiman's user avatar
0 votes
1 answer
214 views

Cassandra long queries (33s for dropping empty table)

Currently trying a setup for a large project. The project will utilize tens of thousands of tables to chunk the big data into separate pieces that are faster to search. So to test this I'm creating ...
Niels's user avatar
  • 1
0 votes
1 answer
847 views

Connection refused with internal private DNS name

I have a Cassandra cluster set up on 5 EC2 nodes. The nodes can communicate using the private IP addresses just fine, but get connection failures when using the private internal DNS name. Localhost ...
MeanwhileInHell's user avatar
1 vote
1 answer
7k views

Can't authenticate to cassandra: cannot achieve consistency level LOCAL_ONE

Context: We have a Cassandra cluster with 3 nodes deployed as a Stateful Set in Openshift. The three nodes are configured in the same datacenter, same rack. I also made a script to test the ...
aspyct's user avatar
  • 360
1 vote
0 answers
1k views

How to use Cassandra with Spark in a Docker image?

(I hope this question is fit for ServerFault, if not, comment and I'll delete it) I'm trying to create a docker image where Cassandra and Spark would be installed and configured to work together. I ...
HypeWolf's user avatar
  • 113
0 votes
1 answer
111 views

What happens when I insert empty column families in cassandra. How many memtables and sstables will be created?

What happens when I insert empty column families in cassandra. How many memtables and sstables will be created ?
Milindkumar Shinalkar's user avatar
1 vote
1 answer
51 views

I have 2 DCs, RF is 3 in both of them and consistency is set to quorum. What will happen when a read/write request comes and one of the DC is down?

I have 2 DCs, RF is 3 in both of them and consistency is set to quorum. What will happen when a read/write request comes and one of the DC is down ?
Milindkumar Shinalkar's user avatar
3 votes
1 answer
2k views

How to restrict Cassandra to use fixed memory

We are using Cassandra in order to collect data from Thingsboard. The memory it started with was 4GB (after executing the systemctl status for Cassandra) and after 15 hours it has reached up to 9.3GB. ...
vishruti's user avatar
  • 131
1 vote
1 answer
154 views

Should I see identical sstables on multiple cassandra nodes?

We're trying to verify the state of replication in our cassandra cluster. My colleague has found that only a small number of sstable files exist on multiple nodes. The others are all unique. To me, ...
daxlerod's user avatar
  • 223
0 votes
1 answer
2k views

Can't remove tombstones cells in Cassandra

we are using a cassandra single node cluster for experimenting and one problem we are hitting now is tombstones cells. Each row contain 2 tombstone cells and we are stuck in trying to remove them. ...
BangTheBank's user avatar
0 votes
1 answer
265 views

Trigger compactions when TWCS TTL changes in Cassandra 3.0

I have a table in cassandra where I saved data using clients TTL = 1 month (tables TTL is 0), the table is configured with time window compaction strategy. Everyday Cassandra cleaned one single ...
Hohenheimsenberg's user avatar
1 vote
1 answer
3k views

cassandra port is closed

I am trying to connect to a cassandra installation from a remote machine. Cassandra is running the thrift service on 9160 which is the default port. But I cannot connect the DB and I always get ...
Thiru's user avatar
  • 13
0 votes
1 answer
2k views

Unable to start Cassandra cluster after configure SSL configuration

I configured client-node encryption using reference http://cloudurable.com/blog/cassandra-ssl-cluster-setup/index.html cassandra version 2.1.16 java version jdk1.8.0_131 JCE version JAVA 8 netty-all-...
sateesh's user avatar
4 votes
1 answer
3k views

Error When Starting Cassandra for First Time [closed]

I'm trying to get a single-node cluster of Cassandra set up on my VPS for a school project. So I installed cassandra on Ubuntu 16.04 (JVM 1.8.0_161), but when I run, I encounter this error... https://...
cclloyd's user avatar
  • 613
1 vote
1 answer
871 views

Cassandra multinode installation,Cannot open file /var/log/cassandra/gc.log due to Permission denied

I want to install Cassandra on 4 remote nodes. Everything works fine until I come to point when I check status nodetool status Datacenter: datacenter1 ======================= Status=Up/Down |/ State=...
MikiBelavista's user avatar
0 votes
1 answer
653 views

.UnavailableSocketError: Inet address 127.0.0.1:7000 is not available

I tried to create a cluster with three Cassandra nodes on my machine.I have unpacked tar.gz and changed listen and rpc_addresses, also JMX_PORT.It did not work ~/apache-cassandra-3.11.1-1/bin$ ...
MikiBelavista's user avatar
1 vote
0 answers
248 views

How to edit my host file to enable three Cassandra nodes?

This is my /etc/host cat /etc/hosts 127.0.0.1 localhost 127.0.1.1 jholmes-System-Product-Name My nodetool status nodetool --host 127.0.0.1 status Datacenter: datacenter1 ======================= ...
MikiBelavista's user avatar
1 vote
1 answer
3k views

What is the side effect of having Cassandra tables with partition sizes of more than 100MB?

I am running Apache Cassandra 3.11.1 and have 6 tables sizes in the failing state. Max partition is larger than 100MB. For these 6 tables the partition sizes are on average between 200MB and upwards ...
Charles Green's user avatar
0 votes
0 answers
82 views

Not able to open doors on router

I have a Cassandra broker in my lan and I want to allow to execute query on it from the web. So I made an association on my router (vodafone station revolution) between the external port 9042 with ...
Akinn's user avatar
  • 135
1 vote
1 answer
481 views

How to do an automated Restore of Cassandra Backup(Snapshot)?

I do have a single node Cassandra EC2 instance (apache-cassandra-3.10), in which I take snapshots (backup) on daily basis and upload it on AWS S3. I also take the backup of complete "schema" and "...
Ashutosh Dwivedi's user avatar
1 vote
1 answer
619 views

Can't access Cassandra remote node

I’m using cassandra on a remote node I can access just with console. Since the node has a private ip, the cluster manager set a proxy to access private_ip:9042 in order to allow me to execute query ...
Akinn's user avatar
  • 135
0 votes
1 answer
2k views

Cassandra initial token in cassandra.yaml

I followed the following steps to migrate all the data from one cluster to a completely new cluster: http://datascale.io/cloning-cassandra-clusters-fast-way/ I managed to get all the data to the new ...
Vladimir's user avatar
  • 331
0 votes
1 answer
478 views

Ubuntu - Install cassandra version 3.0.9 fails: Version '3.0.9' for 'cassandra' was not found

I have ansible scripts that were used to provision some cassandra servers a couple months ago. They are failing now on this command: ubuntu@ip-172-30-0-193:~$ sudo apt-get install cassandra=3.0.9 ...
Drew's user avatar
  • 123
1 vote
0 answers
260 views

Apache Cassandra / Presto select query

We have 2 node cluster with RF2. When we select data using Presto and passing all partition key in where condition. Sometime data is returned and sometimes it is not though the cqlsh does return data ...
Abhishek Mishra's user avatar

1
2 3 4 5