Re: Transaction failed because of timeout, retry failed because of the first try actually succeeded.

2016-06-30 Thread Robert Wille
I had this problem, and it was caused by my retry policy. For reasons I don’t remember (but is documented in a C* Jira ticket), when onWriteTimeout() is called, you cannot call RetryDecision.retry(cl), as it will be a CL that is incompatible with LWT. After the fix (2.1.?), you can pass null, an

Transaction failed because of timeout, retry failed because of the first try actually succeeded.

2016-06-30 Thread Justin Lin
Hi everyone, I recently encountered a problem wrt light weight transaction. My query is to insert a row to a table if the row doesn't exist. It goes like this: Insert Into mytable (key, col1, col2) Value("key1", 1, 2) If Not Exist My case is the driver somehow gets time out from waiting for coor

Re: Motivation for a DHT ring

2016-06-30 Thread Utkarsh Sengar
With fault tolerance and reliability, it also gives a faster lookup mechanism across various nodes in a cluster. Amazon's dynamo paper might be a better read to understand the reasoning behind a DHT based system: http://www.allthingsdistributed.com/files/amazon-dynamo-sosp2007.pdf On Wed, Jun 29,

Migrating to Incremental Repair

2016-06-30 Thread Kathiresan S
Hi, We have a 12 node cassandra 3.0.4 cluster (not DSE) and recently upgraded from 2.0.5 to 3.0.4. We have a scheduled nightly repair on each node with *sequence* *full* options and would like to start running the incremental repairs. As per below documentation, it looks like we need to follow th

RE: C* files getting stuck

2016-06-30 Thread Amit Singh F
Hi Josh, On which version are you facing this issue. Is it 2.0.x branch ? Regards Amit From: Josh Smith [mailto:josh.sm...@careerbuilder.com] Sent: Thursday, June 30, 2016 7:39 PM To: user@cassandra.apache.org Subject: RE: C* files getting stuck I have also faced this issue. Rebooting the insta

RE: C* files getting stuck

2016-06-30 Thread Josh Smith
I have also faced this issue. Rebooting the instance has been our fix so far. I am very interested if anyone else has a solution. I was unable to get a definitive answer from Datastax during the last Cassandra Summit. From: Amit Singh F [mailto:amit.f.si...@ericsson.com] Sent: Thursday, June

Re: Changing a cluster name

2016-06-30 Thread Romain Hardouin
Indeed when you want to flush the system keyspace you need to specify it. The flush without argument filters out the system keyspace. This behavior is still the same in the trunk. If you dig into the sources, look at "nodeProbe.getNonSystemKeyspaces()" when "cmdArgs" is empty:-  https://github.c

RE: C* files getting stuck

2016-06-30 Thread Amit Singh F
Hi All, Please check fi anybody has faced below issue and if yes what best can be done to avoid this.? Thanks in advance. Regards Amit Singh From: Amit Singh F [mailto:amit.f.si...@ericsson.com] Sent: Wednesday, June 29, 2016 3:52 PM To: user@cassandra.apache.org Subject: C* files getting stuck

Re: C* 3.0.7 - Compactions pending after TRUNCATE

2016-06-30 Thread Stefano Ortolani
Small update: I have managed to attach a thread dump. Looks like the compaction threads are just waiting for work. My understanding is that, since the SStables got deleted, the compaction tasks that were once pending are currently stuck. I've also tried to flush the memtable so to have one SStabl

Performance impact on schema

2016-06-30 Thread Siddharth Verma
Hi, We have a schema where a table has 90 columns. We have read request patterns where say api 1 reads column 1-20 api 2 reads column 20-40 api 3 reads column 40-60 api 4 reads column 60-90 And say, we have a write access pattern on the same corresponding group of columns. Do the write pattern (o

RE: Exception in logs using LCS .

2016-06-30 Thread Prakash Chauhan
Hi Paulo, Thanks for the reply. Running scrub every time the exception occurs is not a possible solution for us. We don’t have a log patrolling system in place that verify the log on regular basis. I have some queries based on your reply: 1. You mentioned race condition. Can you please

Re: Ring connection timeouts with 2.2.6

2016-06-30 Thread Jens Rantil
Hi, Could it be garbage collection occurring on nodes that are more heavily loaded? Cheers, Jens Den sön 26 juni 2016 05:22Mike Heffner skrev: > One thing to add, if we do a rolling restart of the ring the timeouts > disappear entirely for several hours and performance returns to normal. > It'

Re: some questions

2016-06-30 Thread Jens Rantil
You forgot FROM in your CQL query. Jens Den sön 26 juni 2016 08:30lowping skrev: > Hi : > > > question 1: > > I got a error about this cql, have you fix it already ??? > select collection_type where id in (‘a’,’b’) > > question 2: > > I want use UDF in update, but this cql can’t execute. have

UNSUBSCRIBE

2016-06-30 Thread Brian Fleming