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
1answer
17 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
0answers
43 views

Unable to set “consistency LOCAL_ONE;” to cassandra container startup

I am new to Cassandra DB and want to run YCSB benchmarking tool on single Cassandra container within docker for testing purpose. I am doing this with docker-compose and also come-up with the required ...
0
votes
1answer
17 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
1answer
150 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
0answers
22 views

Is there any option in config of OpsCenter to automatically start repair service?

I made an OpsCenter and attach cluster to it. I dont want to "click" manually to start repair service, instead i want repair service to start by default (config?) Any help?
0
votes
1answer
78 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
0answers
177 views

Exception in thread CompactionExecutor - Cassandra

I have a Cassandra keyspace whose tables are partitioned by a string which is the result of concatenating the current year and month. In the most of the tables there are no problems but one of them ...
0
votes
1answer
80 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
1answer
113 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
0answers
22 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
1answer
143 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
1answer
40 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
1answer
230 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
1answer
2k views

Can't authenticate to cassendra: 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
0answers
509 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
1answer
27 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
1answer
40 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 ?
2
votes
1answer
355 views

How to restrict Cassandra to use fixed memory

We are using Cassandra in order to collect the data from things board. The memory it started with was 4GB (after executing the systemctl status for Cassandra) and after 15 hours it has reached up to 9....
1
vote
1answer
74 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
1answer
775 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
1answer
178 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
1answer
2k 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
1answer
484 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
1answer
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
1answer
515 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
1answer
274 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
0answers
139 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
1answer
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 ...
0
votes
0answers
48 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
1answer
360 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
1answer
418 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
1answer
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 ...
0
votes
1answer
401 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
0answers
223 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 ...
3
votes
0answers
4k 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> ...
2
votes
0answers
231 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 ...
3
votes
1answer
962 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....
0
votes
1answer
129 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 ...
0
votes
1answer
107 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 ...
1
vote
0answers
67 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 ...
5
votes
2answers
2k 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 :...
0
votes
2answers
979 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 ...
-1
votes
2answers
58 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....
1
vote
2answers
1k views

cassandra unable to create thrift socket

I do not know why i am not able to enable thrift protocol on cassandra. in cassandra.yaml rpc_start=true port=9160. OS centos 7 iptables not running firewalld not running cassandra ver 3.7 (...
0
votes
0answers
200 views

Cassandra hang on startup

I'm running cassandra 3.0.6 and i'm seeing it hang when i start the cassandra service about 1/4 of the time. Is anyone else seeing this? Has anyone else had this problem? I end up having to restart ...
1
vote
1answer
759 views

Cassandra 2.2 - “nodetool repair” VS “nodetool repair -dc dc1,dc2,dc3”

I want to completely repair a Cassandra 2.2 cluster composed of 3 datacenters (dc1, dc2, dc3) by running only one single command line on a single node. Do I need to run? nodetool repair or nodetool ...
1
vote
1answer
1k views

Cassandra 2.2 - Streaming errors at repair/bootstrap/decommission

We're using Cassandra 2.2.7 and we get strange streaming issues when repairing/bootstrapping/decommissioning some nodes. As an example, I was trying to decommission a fresh bootstrapped node and I ...
0
votes
1answer
496 views

How to install old version of datastax-agent for opscenter in cassandra

when i am trying to manually install agents through yum latest version of agent is getting installed rather than the version i am currently using, how can i install the version of agent i want do i ...
-1
votes
1answer
83 views

How to test to observe Latency Differences when running Cassandra on HDD vs SSD

We had a 3 node cluster running on HDDs. After migrating to SSDs, we ran a load test but haven't seen any latency difference. So we are thinking about running a stress test. Is there any threshold or ...
0
votes
1answer
597 views

Cassandra node networking accross multiple datacenter

For Multiple datacenter Cassandra cluster deployment Do i need public ip for every nodes? Suppose i've architecture as follows: Datacenter US Node1: eth0 =162.63.93.45 (public ip) eth1= 192.168.56....

1
2 3 4 5