Apache Cassandra is an open source distributed database management system.

learn more… | top users | synonyms

0
votes
0answers
13 views

How to join multiple data sources in Cassandra

I'm working for the first time with Cassandra and I have some doubts. My data sources are csv files. I have three: flights, airplane and airport. I will put the structure of each csv file to ...
0
votes
0answers
29 views

Opscenter can not connect to the nodes

Our opscenter can not connect to the nodes, in the logs the next error appears: 2015-08-17 08:56:37+0200 [SNPaware_Cluster] INFO: Nodes with agents that appear to be no longer running: 172.31.7.245, ...
0
votes
1answer
33 views

Datastax Agent 5.1.3 Short os-stats collector failed

after starting datastax agent 5.1.3 on our new servers we are getting following error in the agent.log. ERROR [os-metrics-6] 2015-08-05 13:49:41,565 Short os-stats collector failed ...
0
votes
1answer
42 views

Opscenter 5.2 missing data for 1day and 1week graph scale

I recently update Opscenter from 5.1 to 5.2, and yesterday just discovered that if I select different 1day or 1week graph scales no data will be shown in the graph. I checked the logs and the chrome ...
0
votes
0answers
21 views

Using external IP with DataStax Enterprise

We are in a situation where we need Cassandra nodes to be accessible from an external IP, but there is no interface with that IP; traffic to that IP is NATted to the node. Per DataStax's ...
0
votes
0answers
24 views

DROP TABLE makes C* unreachable

After a DROP KEYSPACE or DROP TABLE command from CQLSH I often get the output: errors={}, last_host=127.0.0.1 When I try restart with /opt/cassandra/bin/cassandra -f &; I have got this error: ...
0
votes
1answer
25 views

Unattended install (upgrade) of cassandra via chef

I'm creating a cassandra upgrade/install recipe with chef. package "cassandra" do version "2.1.8" action :install end When I install over the top of an existing version I get prompted about new ...
0
votes
0answers
27 views

How to delete all data in a Cassandra

I'm looking for a way to delete all of data in cassandra using script shell who will be executed from rundeck job. thanks in advance
0
votes
1answer
95 views

Cannot add an existing Cassandra cluster to OpsCenter ('ascii' codec can't encode character)

While trying to add an existing Cassandra cluster to OpsCenter I encountered the following error: Error creating cluster: 'ascii' codec can't encode character u'\u03a7' in position 0: ordinal not ...
0
votes
1answer
28 views

Cassandra NetworkTopologyStrategy

I would like to configure the following multi-datacenter Cassandra cluster: DC-EUROPE has 3 Cassandra nodes (1.1.1.1, 1.1.1.2, 1.1.1.3) DC-ASIA has 3 Cassandra nodes (2.2.2.1, 2.2.2.2, 2.2.2.3) Each ...
0
votes
1answer
46 views

Installing tablesnap

I'm trying to install tablesnap in my Cassandra servers, following what I have found in the Jeremy Grosser's Github repo tablesnap but I am not able to do it. I'm not a system administrator and I'm ...
0
votes
0answers
58 views

Cassandra - DataStax OpsCenter: Error provisioning cluster

I installed Cassandra on my local mac, together with opscenter from DataStax. When I create the new cluster, it gives me the error: Error provisioning cluster: Unable to login to some nodes. ...
0
votes
1answer
51 views

OpsCenter 5.1.2 fails to start with SSL enabled on CentOS 5

This applies to OpsCenter 5.1.0 and 5.1.1 as well. I got the following error when trying to run OpsCenter 5.1.2 on a CentOS 5 server: Unhandled Error Traceback (most recent call last): File ...
1
vote
0answers
17 views

Trouble configuring Opscenter (5.1.1) Email alerts

I was wondering if anyone could assist me in figuring out why my opscenter email alerts aren't working. My environment is docker running in native network mode with opscenter in a container. ...
0
votes
0answers
127 views

Datastax Installation Opscenter errors

I am installing a 5 node cluster of Datastax Enterprise 4.7 on 5 separate AWS instances. I have gone through the installation process (simple install) and it appeared to succeed. However, upon ...
0
votes
1answer
128 views

EBS vs Instance Local storage for MongoDB in ec2

Cassandra recommends using instance local storage for EC2 deployments instead of EBS I am deploying MongoDB in EC2... should I also be using instance local storage instead of EBS PIOPS?
1
vote
1answer
195 views

nodetool repair fails with snapshot error

When running nodetool repair, the repair fails on the system_auth keyspace with the following log entries: INFO [AntiEntropySessions:5] 2015-03-17 20:00:34,795 RepairSession.java:260 - [repair ...
0
votes
1answer
1k views

datastax-agent Cannot connect Error

Seeing an issue with the Opscenter Agents. Opscenter reports the agents are not connected and in the agent.log on each node, they all report the following: ...
-1
votes
1answer
52 views

Cassandra versions supported in OpsCenter 5.1.0

We are planning to use Cassandra 2.0.11 but the latest OpsCenter 5.1.0 doesn't support creating a new cluster with Cassandra 2.0.11 package. It shows only 2.0.9. How do we proceed?
1
vote
3answers
1k views

DataStax OpsCenter agent fails to start when Cassandra requires authentication

Problem I can not get OpsCenter get to connect to datastax-agent. It seems that datastax-agent starts and tries to connect to cassandra, fails because it does not know the correct credentials, but it ...
0
votes
0answers
94 views

cassandra on centos 7 - service control issues

I'm trying to join a set of new CentOS 7 servers to an existing cassandra cluster. All systems are running the same version (2.1.2). Running into these problems and would appreciate some pointers: ...
2
votes
1answer
140 views

Incredibly high load average on a Centos server

I have a Centos 6.4 server that's being used as a Cassandra node in a production environment, it is still working and responding to queries etc, but the load average is rather "high" a.k.a. buggy? In ...
1
vote
1answer
127 views

4 node cassandra - skip redundancy?

After much pleading and case building my group got the budget to buy 4 nodes and start a cassandra cluster. Each machine has 3x1Tb drives so I'm wondering whether it's reasonable to skip the 1 way ...
0
votes
0answers
31 views

opscenter agent -f works

I feel certain this is something fairly basic that I'm missing, I'm new to Cassandra and very new to Opscenter and the agent. In brief, Opscenter is working fine and the agent install seems to have ...
3
votes
2answers
481 views

Tunneling cassandra via ssh gives me a connection closed error

I have a server with two network interfaces. Cassandra is listening on a dedicated internal database network on eth1 (not accessable from outside). So I do my tunnel like this: ssh -f -N ...
1
vote
0answers
251 views

Repairing OpsCenter rollups60 Results in Snapshot Errors

I am running a 6 node cluster using Apache Cassandra 2.1.2 with DataStax OpsCenter 5.0.2 from the AWS EC2 AMI "DataStax Auto-Clustering AMI 2.5.1-hvm" (DataStax Community AMI). When I try to run a ...
0
votes
0answers
99 views

OpsCenter : Error loading column family: Make sure all agents are running and connected properly

I'm using OpsCenter version: 5.0.2 and Cassandra 2.1.2 on localhost. I can access keyspaces and see columns list, but when trying to display content of any column I'm getting message: Error ...
0
votes
1answer
77 views

datastax opscenter - how is 'storage capacity' determined?

I installed the OS version this recently (5.0.2) and am wondering about this graph. To date I've had a hard time finding a metric for 'cluster capacity' when it comes to Cassandra. Magically, datastax ...
2
votes
1answer
923 views

Cassandra: do more storage size, needs more CPU and RAM

I have gone through the recommended architecture of the Cassandra node configuration! according to which the recommended hardware infrastructure for the node is to have RAM: 16-32 GB, storage: 500GB ...
0
votes
0answers
691 views

Opscenter is connected to datastax agents but no data available

We installed opscenter and datastax agents on a cluster with private network through datastax community packages. Configurations seems to be ok and we don't have connectivity issues on jmx or stomp. ...
0
votes
1answer
117 views

How to avoid constant schema disagreement flapping in Cassandra?

We have a 3 node Cassandra cluster with a small amount of data on 'em (about 2.3GB total). The nodes are hosted on GCE and each have four cores and 16GB memory. We're running the Debian package build ...
7
votes
1answer
914 views

How to resolve a stuck major compaction in Apache Cassandra?

I've got a one-node Cassandra cluster which is currently stuck in a major compaction process. After executing a nodetool compactit started the compaction and I see the tmp-sstable files with a size of ...
1
vote
1answer
123 views

Change hostname in datastax-agent

I've noticed when working in Opscenter that all the nodes are displayed with the result of hostname and their IP address. For an ec2 host this is a little redundant since the hostnames look like ...
1
vote
1answer
37 views

cassandra setup - uneven load - what did I do wrong?

For the sake of understanding I setup a 4 node cluster using the latest/greatest(released) version of Cassandra. The four nodes were brought up in sequence using almost entirely default settings and ...
1
vote
1answer
252 views

cassandra nodetool repair - how to schedule properly?

Im putting together a 16 node cassandra cluster (replication factor 2) and want to setup a schedule for nodetool repair. gc_grace_seconds is at the default. Two questions: My first impulse is to ...
1
vote
2answers
195 views

Cassandra: understanding replication factor

Hypothetical situation: Setup a cassandra cluster with N nodes. Create a keyspace and set replication_factor to 1 and use SimpleStrategy. Add some data. Remove 1 node. Does this mean that 1/N of ...
0
votes
1answer
159 views

Which direction does `nodetool repair` go?

Let's say I log into a Cassandra node X and issue nodetool repair. Will I only repair the data residing on X? Or will I also automatically repair all other nodes that have replicas of what X holds ...
0
votes
1answer
146 views

Agent connected to Opscenter but no data available

I'm currently running Cassandra, the OpsCenter, and the OpsCenter agent all on my dev Windows box. The agent is successfully connected to OpsCenter and I can see it listed there along with the amount ...
0
votes
1answer
227 views

Can't get datastax-agent to run on a new node

I'm trying to install the datastax-agent on a new CentOS node (there are 3 other nodes currently up and running correctly). After installing the datastax-agent via the Opscenter UI it appears to ...
0
votes
1answer
43 views

Cassandra: when to add capacity?

How does one know when it's time to add capacity to a cassandra cluster? Error msgs? Performance? Some other tell-tale sign? Since capacity planning with Cassandra is a (seemingly) black art knowing ...
1
vote
0answers
152 views

When adding data to cassandra cluster from C#, I get an this exception

From C# when I try to add data to a cassandra cluster, I get this exception: {Not enough replicas available for query at consistency One (1 required but only 0 alive)"} When I run nodetool from ...
0
votes
1answer
98 views

Multiple data centers and DataStax OpsCenter

Multiple questions regarding DataStax OpsCenter. I am evaluating for our use OpsCenter 5.0.1 I am able to build a cassandra cluster using opscenter sucessfully. However, all nodes belong to one ...
1
vote
1answer
69 views

Datastax Opscenter 5.0: Getting “InvalidGroup.NotFound” when adding node via AWS

I am getting an "InvalidGroup.NotFound" when trying to add an additional node to my cluster through OpsCenter via AWS. The existing node running OpsCenter is in the VPC and is already using the ...
1
vote
1answer
190 views

Operator \> and \< (string version comparison) are not recognised in shell script

I am trying to run Casandra nodetool and getting warnings coming from .sh script. [root@d11ca4cc-fa95-c8a9-e133-e64c434f0e6f ~]# nodetool status /opt/local/share/cassandra/bin/nodetool[53]: .[97]: ...
0
votes
2answers
210 views

azure endpoint for cassandra does not work for ports 7000, 7001, 7199

I have setup apache cassandra on a centos7 compatible linux machine in azure. I can telnet directly to port 7000, etc on the IP address on the machine, however I cannot telnet to that same port from ...
0
votes
0answers
43 views

Cassandra 2.x - Problems with not accessible data

I had 3 nodes with 1.5TB of data. At some point my import hit a wall as disk space ended on one of those 3 nodes. I've resized disks and added 4 more nodes and 1.5TB of data more. I did also repair ...
1
vote
2answers
189 views

How to authenticate with cassandra-stress 2.1

Is there a way to authenticate to cassandra using the new cassandra-stress tool released with cassandra 2.1? It appears as if the '-un' (username) and '-pw' (password) switches have been removed from ...
0
votes
1answer
1k views

Cassandra 2.x - cluster does not rebalance after adding new nodes

I had 3 nodes, all with ~550GB, and added 4 more. I hoped that data would migrate on its own from old servers to new ones. Unfortunately after one day, data seems to stay in old places. In parallel, ...
1
vote
0answers
105 views

VPN load balancing between AWS regions for DataStax cluster

I am testing some DataStax Enterprise clusters in different AWS regions and working on a desirable architecture. Currently - I have one cluster with datacenters in us-east, us-west, and eu-ireland. I ...
1
vote
1answer
139 views

DataStax OpsCenter 5.0.0 API doesn't increase last_seen when nodes down if DataStax OpsCenter Agent is down, used to work with 3.2.2

I've been using the DataStax OpsCenter (Enterprise) 5.0.0 REST API with DSE 4.5.1 (Cassandra 2.0.9) to query the /$cluster_name/nodes endpoint and see the last_seen field for the number of seconds ...