2022 Developer Survey is open! Take survey.

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

Quorum at Scylla. DR orchestrator

I have a strech cluster with Scylla for 2 data centers with a balancer. The principle of operation is Every_Quirum. (After reading the documentation, I came to the conclusion that all DPCs should work)...
user avatar
0 votes
0 answers
11 views

CentOS-7 - Upgrade Cassandra from version 2.2.x to version 3.11.x

I have a problem with up upgrade Cassandra version from 2.2.x to 3.11.x. I don't understand why it's the same cassandra 2.2.x, but when installing with package cassandra-2.2.19-1.noarch.rpm , it can ...
user avatar
0 votes
0 answers
8 views

scylla db service is acting as new cluster after updating the seeds in the configuraion

we have 3 nodes of scylla db cluster, in which we have added in the seeds in /etc/scylla/scylla.yaml : seeds: "172.16..6, 172.16.., 172.16..*", in this format. Later we restarted the 3rd ...
user avatar
0 votes
0 answers
21 views

scylla db service is not getting started in ubuntu

I have installed scylla db following the official docs steps. service is not getting started. I am not able to debug this. these are journlctl details. root@e2e-93-3:~# sudo service scylla-server ...
user avatar
1 vote
1 answer
317 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 ...
user avatar
  • 113
1 vote
0 answers
386 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 ...
user avatar
1 vote
0 answers
34 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 ...
user avatar
  • 11
0 votes
1 answer
155 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 ...
user avatar
  • 3
0 votes
1 answer
557 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....
user avatar
0 votes
0 answers
67 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, ...
user avatar
0 votes
1 answer
128 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 ...
user avatar
0 votes
1 answer
31 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 ...
user avatar
0 votes
1 answer
620 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 ===...
user avatar
0 votes
1 answer
394 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 ...
user avatar
  • 143
0 votes
1 answer
242 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 (...
user avatar
  • 111
1 vote
1 answer
286 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 ...
user avatar
1 vote
0 answers
52 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) ...
user avatar
  • 11
0 votes
1 answer
180 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 ...
user avatar
0 votes
1 answer
108 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 ...
user avatar
  • 1
0 votes
1 answer
547 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 ...
user avatar
1 vote
1 answer
5k 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 ...
user avatar
  • 330
1 vote
0 answers
941 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 ...
user avatar
  • 113
0 votes
1 answer
65 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 ?
user avatar
1 vote
1 answer
42 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 ?
user avatar
3 votes
1 answer
1k 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. ...
user avatar
  • 131
1 vote
1 answer
99 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, ...
user avatar
  • 223
0 votes
1 answer
1k 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. ...
user avatar
0 votes
1 answer
227 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 ...
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 ...
user avatar
  • 13
0 votes
1 answer
1k 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-...
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://...
user avatar
  • 611
1 vote
1 answer
716 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=...
user avatar
0 votes
1 answer
393 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$ ...
user avatar
1 vote
0 answers
198 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 ======================= ...
user avatar
1 vote
1 answer
2k 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 ...
user avatar
0 votes
0 answers
65 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 ...
user avatar
  • 135
1 vote
1 answer
422 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 "...
user avatar
1 vote
1 answer
529 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 ...
user avatar
  • 135
0 votes
1 answer
1k 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 ...
user avatar
  • 321
0 votes
1 answer
437 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 ...
user avatar
  • 123
1 vote
0 answers
235 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 ...
user avatar
3 votes
0 answers
5k views

Cassandra ReadTimeout: code=1200 - Coordinator node timed out waiting for replica nodes

I've got 3 node cluster on DSE 4.8.8 with replication factor = 2 and consistency on write quorum and on read one. When I'm trying to select some of the data I get this error: cqlsh:production> ...
user avatar
2 votes
0 answers
239 views

Monitoring Cassandra Server Logs?

I've done some searching and have not found any examples of people using something like FluentD to forward Cassandra log file data (system.log) to a log indexer. Is this something any is doing? If ...
user avatar
  • 123
3 votes
1 answer
1k views

Cassandra tmpdir change location

Cassandra is failing to start if /tmp is set as noexec, which is pretty much default these days: java.lang.NoClassDefFoundError: Could not initialize class com.sun.jna.Native at org.apache....
user avatar
  • 321
0 votes
1 answer
149 views

PHP 7.0 extcassandra on Centos 7

Am I doing anything wrong when installing php with cassandra extension on a CentosOS 7 server? For dependencies I install https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm and ...
user avatar
0 votes
1 answer
112 views

opscenter "services" tab greyed out

Was hoping to set up an s3 snapshot with my cassandra cluster running opscenter 5.2.4/Cassandra 2.2.7 but for some reason the services menu is greyed out. Cluster stats and information seem fine so it ...
user avatar
1 vote
0 answers
72 views

Changing network interface will cause cassandra node fail?

I have a dse-cassandra cluster for use in production. I would like to attach an network-interface to every node. If I add the ip address of that interface on each cassandra config; would it break the ...
user avatar
5 votes
2 answers
3k views

Cassandra snapshot restoring : random missing data

I'm having a hard time restoring snapshot on Apache Cassandra (version 3.0.9). As far as I can say, I'm following the procedure described on datastax blog, along with several other ones (for instance :...
user avatar
0 votes
2 answers
1k views

Docker swarm and volumes

Considering Docker 1.12. I understand that volumes are not per say portable across the swarm and that solutions like Flocker would be better for larger clusters. Nevertheless, is the option I ...
user avatar
  • 159
-1 votes
2 answers
63 views

aws cluster overprovisioning detection framework/tools

Our team is managing many cassandra clusters on aws, one of our problems is when a user ask us to spawn a new cluster, they can't predict how many nodes they need because of lack of production traffic....
user avatar
  • 161

1
2 3 4 5