Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
1answer
21 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
votes
0answers
13 views

Retrieving Data from A NoSQL DB

In RDBMS I know that query retrieves information from the database using clustered and non clustered indexes if exists , and if not , they do a full table scan. My question is - how is the same thing ...
1
vote
0answers
43 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
11 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
24 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 ?
0
votes
0answers
35 views

How can I monitor my Cassandra Docker Image with Prometheus?

I am trying to monitor a cassandra docker instance from a prometheus docker instance. I'm getting confused as it seems there is many possibilities and packages to do so. Right now, prometheus says: ...
2
votes
1answer
27 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....
0
votes
0answers
271 views

Cassandra: high CPU usage and network traffic between nodes

I installed Cassandra on Google Cloud Platform using the provided Bitnami image. I have a 3-nodes cluster. I'm observing constant CPU overload so I started investigating. So I ran a dstat: ----...
0
votes
0answers
64 views

cassandra cluster monitoring using graphite -grafana

I am new to Cassandra and trying to setup monitoring tool to monitor Cassandra production cluster. So i have setup one graphite-grafana on one of the cassandra node & i'm able to get metrics of ...
-1
votes
0answers
4 views

GraphiteReporter.java:192 - Unable to report to Graphite [duplicate]

I'm running Graphite- Grafana setup to monitor cassandra cluster. I was thinking its runnnig fine(can see the graphs in graphite-web) until one day i came across /var/log/cassandra/system.log output. ...
1
vote
1answer
52 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
167 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
0answers
93 views

One node in cassandra cluster starts eating more CPU and does a lot of read IOPS

I am running a cluster of 8 apache cassandra (3.11.2) nodes and it receives a longrun traffic from one node. About 1 day the rate starts to drop and one node starts to eat more CPU and more read-IOPS. ...
0
votes
0answers
38 views

Does running scrub on a table joins SSTables?

My table has time window compaction strategy enabled (TWCS), for some reason I have a lot of SStables just with tombstones. When I run a manual compaction on a single sstable, it does not get ...
0
votes
1answer
73 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
610 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
0answers
151 views

How to configure JanusGraph with Cassandra docker images?

I'm trying to configure Janus with Cassandra (ScyllaDB docker image) but I'm very confused about all the configurations. In the docs they do not refer to a file (see http://docs.janusgraph.org/latest/...
0
votes
1answer
167 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
2k 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
280 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
147 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
80 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
956 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
26 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
264 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
232 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
566 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
295 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
187 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
2k 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
193 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
594 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
111 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
92 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
57 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
1answer
847 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
53 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
850 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
149 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
562 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 ...
0
votes
1answer
745 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
417 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
74 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
0answers
419 views

Cassandra fails to rebuild on a new Datacenter with vnodes

We have a 4 node cluster (without vnodes) that we want to migrate to use 8 smaller machines with vnodes. Although, despite our efforts, following the steps to add a new datacenter always fail on the "...
0
votes
1answer
455 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....
0
votes
1answer
998 views

how to read statistics.db and summary.db file in cassandra

i am trying to read the Statistics.db file and summary.db file but i couldn't read I want to know what is the data that will be stored in it, any specific format. if so what is the format and what ...
0
votes
2answers
4k views

Cassandra nodes disk space usage above 90%

Hi I'm running a 5 node dse cassandra cluster. Every node is about 90 % disk usage ,so I've deleted data from my keyspace(I've only one keyspace).but my disk space is still 90 % .Is there anyway to ...
0
votes
1answer
154 views

Cassandra 3.x on Kubernetes 1.2-release (5 cassandra nodes)

Has anyone been able to get cassandra 3.x running on kubernetes? cassandra 2.1.13 runs great but 3.3 is have trouble talking to other cassandra nodes. My yamls are the same except for the container. ...
1
vote
2answers
197 views

cassandra data migration from regular drive to SSD on production server

we want migrate our data from regular drives on production server to new SSD drives. how we can do that without taking down the node no longer than 4 hours(hinted hand-off is 4 hours) our data is in ...