Stable/unstable packages?

2011-05-27 Thread Marcus Bointon
Are there separate repos/packages for stable/unstable releases of Cassandra? I was a bit surprised to find the official debian repo pushing out 0.8b2 as a normal update to the cassandra package. Would it not be better to have a cassandra-unstable package for bleeding edge and plain cassandra for

Re: Stable/unstable packages?

2011-05-27 Thread Marcus Bointon
On 27 May 2011, at 10:10, Marcus Bointon wrote: > Are there separate repos/packages for stable/unstable releases of Cassandra? > I was a bit surprised to find the official debian repo pushing out 0.8b2 as a > normal update to the cassandra package. Would it not be better to have a > cassandra-u

python cql driver select count(*) failed

2011-05-27 Thread Donal Zang
Hi, I'm using the jar from the trunk source code . I tried the following select cql, but it get the wrong result.(I can get the right result using pycassa's get_count()) /cqlsh> select count(1) from t_container where KEY = '2011041210' ; (0,) cqlsh> select count(*) from t_container where KEY =

Re: Corrupted Counter Columns

2011-05-27 Thread Sylvain Lebresne
On Thu, May 26, 2011 at 2:21 PM, Utku Can Topçu wrote: > Hello, > > I'm using the the 0.8.0-rc1, with RF=2 and 4 nodes. > > Strangely counters are corrupted. Say, the actual value should be : 51664 > and the value that cassandra sometimes outputs is: either 51664 or 18651001. What does sometimes

Fwd: Mixing different OS in a cassandra cluster

2011-05-27 Thread Mikael Wikblom
Hi, I tried to mix windows and linux in a cassandra cluster version 0.7.4 and got an exception on a linux node bootstrapping from a windows node. java.lang.StringIndexOutOfBoundsException: String index out of range: -1 at java.lang.String.substring(Unknown Source) at org.apache.cassandra.io.s

Re: Fwd: Mixing different OS in a cassandra cluster

2011-05-27 Thread Jonathan Ellis
Right. This is not supported. On May 27, 2011 7:25 AM, "Mikael Wikblom" wrote: > Hi, > > I tried to mix windows and linux in a cassandra cluster version 0.7.4 > and got an exception on a linux node bootstrapping from a windows node. > > java.lang.StringIndexOutOfBoundsException: String index out o

average repair/bootstrap durations

2011-05-27 Thread Jonathan Colby
Hi - Operations like repair and bootstrap on nodes in our cluster (average load 150GB each) take a very long time. By long I mean 1-2 days. With nodetool "netstats" I can see the progress % very slowly progressing. I guess there are some throttling mechanisms built into cassandra. And yes the

Re: python cql driver select count(*) failed

2011-05-27 Thread Jonathan Ellis
(and if it did, it would be the SQL row count, which is different than the column count from pycassa.) On Fri, May 27, 2011 at 10:13 AM, Jonathan Ellis wrote: > CQL does not support count(). > > On Fri, May 27, 2011 at 4:18 AM, Donal Zang wrote: >> Hi, >>  I'm using the jar from the trunk source

Re: average repair/bootstrap durations

2011-05-27 Thread Edward Capriolo
On Fri, May 27, 2011 at 9:08 AM, Jonathan Colby wrote: > Hi - > > Operations like repair and bootstrap on nodes in our cluster (average > load 150GB each) take a very long time. > > By long I mean 1-2 days. With nodetool "netstats" I can see the > progress % very slowly progressing. > > I guess

Re: python cql driver select count(*) failed

2011-05-27 Thread Jonathan Ellis
CQL does not support count(). On Fri, May 27, 2011 at 4:18 AM, Donal Zang wrote: > Hi, >  I'm using the jar from the trunk source code . > I tried the following select cql, but it get the wrong result.(I can get the > right result using pycassa's get_count()) > cqlsh> select count(1) from t_conta

Cluster not recovering when a single node dies

2011-05-27 Thread Paul Loy
We have a 4 node cluster with a replication factor of 2. When one node dies, the other nodes throw UnavailableExceptions for quorum reads (as expected initially). They never get out of that state. Is there something we can do in nodetool to make the remaining nodes function? Thanks. --

Re: Cluster not recovering when a single node dies

2011-05-27 Thread Jonathan Ellis
Quorum of 2 is 2. You need at least RF=3 for quorum to tolerate losing a node indefinitely. On Fri, May 27, 2011 at 10:37 AM, Paul Loy wrote: > We have a 4 node cluster with a replication factor of 2. When one node dies, > the other nodes throw UnavailableExceptions for quorum reads (as expected

Re: Cluster not recovering when a single node dies

2011-05-27 Thread Paul Loy
ahh, thanks. On Fri, May 27, 2011 at 4:43 PM, Jonathan Ellis wrote: > Quorum of 2 is 2. You need at least RF=3 for quorum to tolerate losing > a node indefinitely. > > On Fri, May 27, 2011 at 10:37 AM, Paul Loy wrote: > > We have a 4 node cluster with a replication factor of 2. When one node >

Re: Cluster not recovering when a single node dies

2011-05-27 Thread Paul Loy
I guess my next question is: the data should be complete somewhere in the ring with RF = 2. Does cassandra not redistribute the replication ring without a nodetool decommission call? On Fri, May 27, 2011 at 4:45 PM, Paul Loy wrote: > ahh, thanks. > > On Fri, May 27, 2011 at 4:43 PM, Jonathan Ell

Re: average repair/bootstrap durations

2011-05-27 Thread Jonathan Colby
Thanks Ed! I was thinking about surrendering more memory to mmap operations. I'm going to try bringing the Xmx down to 4G On Fri, May 27, 2011 at 5:19 PM, Edward Capriolo wrote: > > > On Fri, May 27, 2011 at 9:08 AM, Jonathan Colby > wrote: >> >> Hi - >> >> Operations  like repair and bootstr

pb deletion

2011-05-27 Thread karim abbouh
i use cassandra database replicated in two servers,when want to delete a record using this line : client.remove(keyspace, sKey, new ColumnPath(columnFamily), timestamp, ConsistencyLevel.ONE); but when i check,i see that the record still exist! any idea BR

Re: pb deletion

2011-05-27 Thread Konstantin Naryshkin
What is the ConsitencyLevel of your reads? A ConsistencyLevel.ONE remove returns when it has deleted the record from at least 1 replica (and any other ones will be deleted when they can). It could be the case that you are deleting the record off of one node and then reading it off of the other o

Re: pb deletion

2011-05-27 Thread Peter Schuller
> i use cassandra database replicated in two servers,when want to delete a > record using this line : > client.remove(keyspace, sKey, new ColumnPath(columnFamily), timestamp, > ConsistencyLevel.ONE); > > but when i check,i see that the record still exist! Are you using a "real" timestamp such th

Re: Cluster not recovering when a single node dies

2011-05-27 Thread Jonathan Ellis
It does not. (Most failures are transient, so Cassandra doesn't inflict the non-negligible performance impact of re-replicating a full node's worth of data until you tell it "that guys' not coming back this time.") On Fri, May 27, 2011 at 10:47 AM, Paul Loy wrote: > I guess my next question is: t

Re: Cluster not recovering when a single node dies

2011-05-27 Thread Paul Loy
Sounds reasonable. Thanks. On Fri, May 27, 2011 at 7:12 PM, Jonathan Ellis wrote: > It does not. (Most failures are transient, so Cassandra doesn't > inflict the non-negligible performance impact of re-replicating a full > node's worth of data until you tell it "that guys' not coming back > thi

Re: Re: nodetool move trying to stream data to node no longer in cluster

2011-05-27 Thread Jonathan Colby
Glad to report I fixed this problem. 1. I added the load_ring_state=false flag 2. I was able to arrange a time where I could take down the whole cluster and bring it back up. After that the "phantom" node disappeared. On Fri, May 27, 2011 at 12:48 AM, wrote: > Hi Aaron - Thanks alot for the gre

expiring + counter column?

2011-05-27 Thread Yang
is this combination feature available , or on track ? thanks Yang

Re: expiring + counter column?

2011-05-27 Thread Jonathan Ellis
No. See comments to https://issues.apache.org/jira/browse/CASSANDRA-2103 On Fri, May 27, 2011 at 7:29 PM, Yang wrote: > is this combination feature available , or on track ? > > thanks > Yang > -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of DataStax, the source for profession