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.
217
questions
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 ...
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 ...
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 ...
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
...
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 ...
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 ...
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 ...
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 ...
-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: ...
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, ...
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
...
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:
...
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 ...
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 ...
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 ...
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 ...
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 ...
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....
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, ...
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
...
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 ...
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
===...
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
...
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 (...
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 ...
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) ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ?
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 ?
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. ...
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, ...
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. ...
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 ...
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 ...
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-...
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://...
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=...
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$ ...
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
=======================
...
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 ...
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 ...
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 "...
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 ...
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 ...
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
...
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 ...