Re: Error: No module named cql

2014-10-14 Thread Ben Bromhead
It looks like easy_install is using python2.6 and installing cql in the 2.6 packages directory: /usr/lib/python2.6/site-packages/ cqlsh is using the python executable for you environment (which looks like 2.7) and thus is looking for cql in the site packages dir (amongst others). To quickly insta

Exception at Tried to hard link to file that does not exist

2014-10-14 Thread luolee.me
Hi, I'm new to cassandra and told to write a script to backup the cassandra cluster every day, but it throws an exception at one node as below: Exception in thread "main" java.lang.RuntimeException: Tried to hard link to file that does not exist /var/cassandra/data/forseti/activity/forseti-activ

Error: No module named cql

2014-10-14 Thread Tim Dunphy
Hey all, I'm using cassandra 2.1.0 on CentOS 6.5 And when I try to run cqlsh on the command line I get this error: root@beta-new:~] #cqlsh Python CQL driver not installed, or not on PYTHONPATH. You might try "easy_install cql". Python: /usr/local/bin/python Module load path: ['/usr/local/apa

Question about adding nodes incrementally to a new datacenter: wait til all hosts come up so they can learn the token ranges?

2014-10-14 Thread Donald Smith
Suppose I create a new DC with 25 nodes. I have their IPs in cassandra-topology.properties. Twenty-three of the nodes start up, but two of the nodes fail to start. If I start replicating (via "nodetool rebuild") without those two nodes, then when those 2 nodes enter the DC the distribution o

Re: repair getting stuck

2014-10-14 Thread Robert Coli
On Tue, Oct 14, 2014 at 6:46 AM, Prem Yadav wrote: > Every ones in a while Opscenter throws an error that repair service failed > die to errors. In the logs we can see multiple lines like: > > Repair task (, > (-6964720218971987043L, -6963882488374905088L), set([tables])) timed out > after 3600

RE: validation compaction

2014-10-14 Thread S C
Thanks Rob. Date: Mon, 13 Oct 2014 13:42:39 -0700 Subject: Re: validation compaction From: rc...@eventbrite.com To: user@cassandra.apache.org On Mon, Oct 13, 2014 at 1:04 PM, S C wrote: I have started repairing a 10 node cluster with one of the table having > 1TB of data. I notice that the

Anyone know when DSE will support Cassandra 2.1?

2014-10-14 Thread Jason Lewis
I can't find any info related to dates anywhere. jas

Re: describe tables… and vertical formatting?

2014-10-14 Thread graham sanderson
Ha oops - typo on my part On Oct 14, 2014, at 10:55 AM, Tyler Hobbs wrote: > You want this: > > select keyspace_name, columnfamily_name from system.schema_columnfamilies; > > On Sun, Oct 12, 2014 at 5:16 PM, Kevin Burton wrote: > huh. That sort of works. The problem now is that there are mu

Re: LOCAL_* consistency levels

2014-10-14 Thread graham sanderson
There were some versions of C* that didn’t allow you to use LOCAL_* and a single DC NetworkTopologyStrategy, or with SimpleTopologyStrategy. https://issues.apache.org/jira/browse/CASSANDRA-6238 I think You should use a NetworkTopologyStrategy with one DC for now. On Oct 14, 2014, at 7:39 AM, Ro

Re: describe tables… and vertical formatting?

2014-10-14 Thread Tyler Hobbs
You want this: select keyspace_name, columnfamily_name from system.schema_columnfamilies; On Sun, Oct 12, 2014 at 5:16 PM, Kevin Burton wrote: > huh. That sort of works. The problem now is that there are multiple > entries per table... > > On Sun, Oct 12, 2014 at 10:39 AM, graham sanderson >

repair getting stuck

2014-10-14 Thread Prem Yadav
Hi, this is an issue we have a faced a couple times now. Every ones in a while Opscenter throws an error that repair service failed die to errors. In the logs we can see multiple lines like: Repair task (, (-6964720218971987043L, -6963882488374905088L), set([tables])) timed out after 3600 second

LOCAL_* consistency levels

2014-10-14 Thread Robert Wille
I’m wondering if there’s a best practice for an annoyance I’ve come across. Currently all my environments (dev, staging and live) have a single DC. In the future my live environment will most likely have a second DC. When that happens, I’ll want to use LOCAL_* consistency levels. However, if I w

Re: How do you run integration tests for your cassandra code?

2014-10-14 Thread Daniel Compton
At SMX we use https://github.com/SMX-LTD/ccm-clj for our Cassandra integration tests. ccm-clj is a Clojure wrapper around CCM. -- Daniel > On 14/10/2014, at 6:54 pm, Ranjib Dey wrote: > > you can use tools like chef along side vagrant to bring a cassandra. I > personally prefer LXC container