RE: RE: Cassandra tombstones being created by updating rows with TTL's

2015-04-23 Thread Walsh, Stephen
for a while and see what happens Steve From: Anuj Wadehra [mailto:anujw_2...@yahoo.co.in] Sent: 22 April 2015 19:07 To: user@cassandra.apache.org Subject: Re: RE: Cassandra tombstones being created by updating rows with TTL's Hi Stephen, Dropping cf or keyspace and recreating it

Re: RE: Cassandra tombstones being created by updating rows with TTL's

2015-04-22 Thread Anuj Wadehra
745)       From: Anuj Wadehra [mailto:anujw_2...@yahoo.co.in] Sent: 21 April 2015 19:04 To: user@cassandra.apache.org Subject: Re: Cassandra tombstones being created by updating rows with TTL's   Whats ur sstable count for the CF? I hope compactions are working fine. Also

RE: Cassandra tombstones being created by updating rows with TTL's

2015-04-22 Thread Walsh, Stephen
5 19:04 To: user@cassandra.apache.org Subject: Re: Cassandra tombstones being created by updating rows with TTL's Whats ur sstable count for the CF? I hope compactions are working fine. Also check the full stacktrace of FileNotFoundException ..if its related to compactionyou c

Re: Cassandra tombstones being created by updating rows with TTL's

2015-04-21 Thread Anuj Wadehra
. Thanks Anuj Wadehra Sent from Yahoo Mail on Android From:"Laing, Michael" Date:Tue, 21 Apr, 2015 at 10:21 pm Subject:Re: Cassandra tombstones being created by updating rows with TTL's Hmm - we read/write with Local Quorum always - I'd recommend that as that is your 'c

Re: Cassandra tombstones being created by updating rows with TTL's

2015-04-21 Thread Laing, Michael
urrected - the main reason for running > repair within gc_grace_seconds. > > > > > > > > On Tue, Apr 21, 2015 at 11:49 AM, Walsh, Stephen > wrote: > > Maybe thanks Michael, > > I will give these setting a go, > > How do you do you periodic node-tool

RE: Cassandra tombstones being created by updating rows with TTL's

2015-04-21 Thread Walsh, Stephen
: 21 April 2015 17:09 To: user@cassandra.apache.org Subject: Re: Cassandra tombstones being created by updating rows with TTL's Discussions previously on the list show why this is not a problem in much more detail. If something changes in your cluster: node down, new node, etc - you run repair

Re: Cassandra tombstones being created by updating rows with TTL's

2015-04-21 Thread Laing, Michael
* user@cassandra.apache.org > *Subject:* Re: Cassandra tombstones being created by updating rows with > TTL's > > > > If you never delete except by ttl, and always write with the same ttl (or > monotonically increasing), you can set gc_grace_seconds to 0. > > > >

RE: Cassandra tombstones being created by updating rows with TTL's

2015-04-21 Thread Walsh, Stephen
...@nytimes.com] Sent: 21 April 2015 16:26 To: user@cassandra.apache.org Subject: Re: Cassandra tombstones being created by updating rows with TTL's If you never delete except by ttl, and always write with the same ttl (or monotonically increasing), you can set gc_grace_seconds to 0. That's what we

Re: Cassandra tombstones being created by updating rows with TTL's

2015-04-21 Thread Laing, Michael
If you never delete except by ttl, and always write with the same ttl (or monotonically increasing), you can set gc_grace_seconds to 0. That's what we do. There have been discussions on the list over the last few years re this topic. ml On Tue, Apr 21, 2015 at 11:14 AM, Walsh, Stephen wrote: >

Cassandra tombstones being created by updating rows with TTL's

2015-04-21 Thread Walsh, Stephen
We were chatting to Jon Haddena about a week ago about our tombstone issue using Cassandra 2.0.14 To Summarize We have a 3 node cluster with replication-factor=3 and compaction = SizeTiered We use 1 keyspace with 1 table Each row have about 40 columns Each row has a TTL of 10 seconds We insert a