Hanging pending compactions

2015-07-08 Thread Jens Rantil
Hi, After executing `nodetool cleanup` on some nodes they are all showing lots (123, 97, 64) of pending compaction tasks, but not a single active task. I'm running Cassandra 2.0.14 with Leveled Compaction Strategy on most of our tables. Anyone experienced this before? Also, is there any way for

Re: Consistent reads and first write wins

2015-07-08 Thread Jens Rantil
Hi John, The general answer: Each cell in a CQL table has a corresponding timestamp which is taken from the clock on the Cassandra node that orchestrates the write. When you are reading from a Cassandra cluster the node that coordinates the read will compare the timestamps of the values it

Datastax agent - Connection issue

2015-07-08 Thread Francisco Andrade
Hi there, Im having some trouble here trying to execute the datastax agent on my cassandra nodes on ubuntu 14.04. I have a cassandra 2.0.15 cluster running on docker containers , so i guess my main problem must be related to the container port exposure. The cluster is ok. The nodetool status

Re: Read Repair

2015-07-08 Thread Robert Coli
On Wed, Jul 8, 2015 at 2:07 PM, Saladi Naidu naidusp2...@yahoo.com wrote: Suppose I have a row of existing data with set of values for attributes I call this State1, and issue an update to some columns with Quorum consistency. If the write is succeeded in one node, Node1 and and failed on

Read Repair

2015-07-08 Thread Saladi Naidu
Suppose I have a row of existing data with set of values for attributes I call this State1, and issue an update to some columns with Quorum consistency.  If the write is succeeded in one node, Node1 and and failed on remaining nodes. As there is no Rollback, Node1 row attributes will remain new

Re: Is there a way to remove a node with Opscenter?

2015-07-08 Thread Jean Tremblay
When you do a nodetool command and you don’t specify a hostname, it sends the requests via JMX to the localhost node. If that node is down then the command will not succeed. In your case you are probably doing the command from a machine which has not cassandra running, in that case you need to

Re: Example Data Modelling

2015-07-08 Thread Saladi Naidu
If going by Month as partition key then you need to duplicate the data. I dont think going with name as partition key is good datamodel practice as it will create a hotspot. Also I believe your queries will be mostly by employee not by month.  You can create employee id as partition key and

RE: Read Repair

2015-07-08 Thread Ashic Mahtab
One thing to note is that the exception you get... in this case, you'll get a timeout, not a failure. i.e. as far as Cassandra is concerned, the write is still ongoing - it hasn't failed; but from the client's perspective, it's timed out. In this case (i.e. timeout), the application would