Jeff, Thank you i got this- how about Dropping the existing Tombstones right now can setting gc_grace time to zero per Table level would be good or what would you suggest?
On Wed, Mar 14, 2018 at 1:41 PM, Jeff Jirsa <jji...@gmail.com> wrote: > What version of Cassandra? > > https://issues.apache.org/jira/browse/CASSANDRA-7304 sort of addresses > this in 2.2+ > > > > > On Wed, Mar 14, 2018 at 11:32 AM, Madhu-Nosql <odba.ma...@gmail.com> > wrote: > >> Rahul, >> >> Tomstone caused is on the Application driver side so even though they are >> not using some of the Columns in their logic >> waht they did is that they mentioned in driver logic that means if you >> are updateting one Column so the rest of the Columns so the driver >> automatically >> pick some nulls, internally behind the schnes cassandra threat them as a >> Tombstones >> >> On Wed, Mar 14, 2018 at 12:58 PM, Rahul Singh < >> rahul.xavier.si...@gmail.com> wrote: >> >>> Then don’t write nulls. That’s the root of the issue. Sometimes they >>> surface from prepared statements. Othertimes they come because of default >>> null values in objects. >>> >>> -- >>> Rahul Singh >>> rahul.si...@anant.us >>> >>> Anant Corporation >>> >>> On Mar 13, 2018, 2:18 PM -0400, Madhu-Nosql <odba.ma...@gmail.com>, >>> wrote: >>> >>> We assume that's becoz of nulls >>> >>> On Tue, Mar 13, 2018 at 12:58 PM, Rahul Singh < >>> rahul.xavier.si...@gmail.com> wrote: >>> >>>> Are you writing nulls or does the data cycle that way? >>>> >>>> -- >>>> Rahul Singh >>>> rahul.si...@anant.us >>>> >>>> Anant Corporation >>>> >>>> On Mar 13, 2018, 11:48 AM -0400, Madhu-Nosql <odba.ma...@gmail.com>, >>>> wrote: >>>> >>>> Rahul, >>>> >>>> Nodetool scrub is good for rescue, what if its happening all the time? >>>> >>>> On Tue, Mar 13, 2018 at 10:37 AM, Rahul Singh < >>>> rahul.xavier.si...@gmail.com> wrote: >>>> >>>>> Do you anticipate this happening all the time or are you just trying >>>>> to rescue? >>>>> >>>>> Nodetool scrub can be useful too. >>>>> >>>>> >>>>> -- >>>>> Rahul Singh >>>>> rahul.si...@anant.us >>>>> >>>>> Anant Corporation >>>>> >>>>> On Mar 13, 2018, 11:29 AM -0400, Madhu-Nosql <odba.ma...@gmail.com>, >>>>> wrote: >>>>> >>>>> I got few ways to Drop Tombstones- Chos Monkey/Zombie Data mainly to >>>>> avoid Data Resurrection (you deleted data it will comes back in >>>>> future) >>>>> >>>>> I am thinking of below options, let me know if you have any best >>>>> practice for this >>>>> >>>>> 1.using nodetool garbagecollect >>>>> 2.only_purge_repaired_tombstones >>>>> 3.At Table level making GC_Grace_period to zero and compact >>>>> >>>>> Thanks, >>>>> Madhu >>>>> >>>>> >>>> >>> >> >
