Re: Unable to complete request: one or more nodes were unavailable.

2014-04-16 Thread Vivek Mishra
Thanks, i think got the point.CAS doesn't make much sense on single node. -Vivek On Wed, Apr 16, 2014 at 6:37 PM, Tupshin Harper wrote: > It will work for correctness, but give you a very inaccurate view of > performance,. > > -Tupshin > On Apr 16, 2014 6:05 AM, "Vivek Mishra" wrote: > >> Tha

Re: Unable to complete request: one or more nodes were unavailable.

2014-04-16 Thread Tupshin Harper
It will work for correctness, but give you a very inaccurate view of performance,. -Tupshin On Apr 16, 2014 6:05 AM, "Vivek Mishra" wrote: > Thanks Mark and Tuphsin. > > So on single node, if i set consistency level to SERIAL and create a > keyspace with RF=1? Would that work? > > > -Vivek > > >

Re: Unable to complete request: one or more nodes were unavailable.

2014-04-16 Thread Vivek Mishra
Thanks Mark and Tuphsin. So on single node, if i set consistency level to SERIAL and create a keyspace with RF=1? Would that work? -Vivek On Wed, Apr 16, 2014 at 6:32 PM, Mark Reddy wrote: > The Paxos protocol used for CAS operations will always use at least a > consistency level effectively

Re: Unable to complete request: one or more nodes were unavailable.

2014-04-16 Thread Mark Reddy
The Paxos protocol used for CAS operations will always use at least a consistency level effectively equivalent to QUORUM (called SERIAL) when writing, even if you explicitly specify a lower level, e.g. ANY or ONE. Setting consistency level to ALL will make the write execute on all replicas if the c

Re: Unable to complete request: one or more nodes were unavailable.

2014-04-16 Thread Tupshin Harper
No, but you do need a quorum of nodes. http://www.datastax.com/documentation/cassandra/2.0/cassandra/dml/dml_config_consistency_c.html SERIAL A write must be written conditionally to the commit log and memory table on a quorum of replica nodes. Used to achievelinearizable consistency

Re: Unable to complete request: one or more nodes were unavailable.

2014-04-16 Thread Vivek Mishra
Thanks Mark. does this mean with RF=3, all 3 nodes must be up and running for CAS updates? -Vivek On Wed, Apr 16, 2014 at 6:22 PM, Mark Reddy wrote: > create keyspace twitter with replication = {'class':'SimpleStrategy', >> 'replication_factor' : 3} > > > Your replication factor is your issue

Re: Unable to complete request: one or more nodes were unavailable.

2014-04-16 Thread Tupshin Harper
That is entirely the problem. By having one node, but RF=3, you have created this exact problem. Each node can own, at most, one copy of each row of data, so the cluster is treating this (correctly) as a degraded runtime environment where no operation requiring CL > 1 will always fail. LWT requ

Re: Unable to complete request: one or more nodes were unavailable.

2014-04-16 Thread Mark Reddy
> > create keyspace twitter with replication = {'class':'SimpleStrategy', > 'replication_factor' : 3} Your replication factor is your issue here, you have a single node and a RF=3. For a single node setup your RF should be 1. You can find more info about replication here: http://www.datastax.com/

Re: Unable to complete request: one or more nodes were unavailable.

2014-04-16 Thread Vivek Mishra
Hi, Mine is a simple case. Running on single node only. Keyspace is: create keyspace twitter with replication = {'class':'SimpleStrategy', 'replication_factor' : 3} -Vivek On Wed, Apr 16, 2014 at 1:27 AM, Tupshin Harper wrote: > Please provide your keyspace definition, and the output of "nod

Re: Unable to complete request: one or more nodes were unavailable.

2014-04-15 Thread Jason Wee
hmm.. I get a similar output as yours yesterday when trying to truncate a table in a 3 nodes cluster where one of the node went offline. but the alternative that I have is that, instead of truncate, i just drop the table and recreate it. using cassandra version 2.0.6 by the way. On Wed, Apr 1

Re: Unable to complete request: one or more nodes were unavailable.

2014-04-15 Thread Tupshin Harper
Please provide your keyspace definition, and the output of "nodetool ring" -Tupshin On Apr 15, 2014 3:52 PM, "Vivek Mishra" wrote: > Hi, > I am trying Cassandra light weight transaction support with Cassandra 2.0.4 > > cqlsh:twitter> create table user(user_id text primary key, namef text); > cq