Re: Deletions getting omitted

2023-02-16 Thread shankha b
, February 6, 2023 3:54 PM To: shankha b Cc: user@cassandra.apache.org Subject: Re: Deletions getting omitted Can you check the write timestamp of the data you're attempting to delete? https://docs.datastax.com/en/cql-oss/3.3/cql/cql_using/useWritetime.html If the timestamp of the write is i

Re: Deletions getting omitted

2023-02-06 Thread C. Scott Andreas
e are getting hit by a read repair?From: shankha b Sent: Monday, February 6, 2023 7:10 AM To: user@cassandra.apache.org Subject: Re: Deletions getting omitted  I read through the ticket a few number of times. We have replication factor 3 and LocalQuorum.Do we still think  CASSANDRA-15690 is a

Re: Deletions getting omitted

2023-02-06 Thread shankha b
By any chance do you think we are getting hit by a read repair? From: shankha b Sent: Monday, February 6, 2023 7:10 AM To: user@cassandra.apache.org Subject: Re: Deletions getting omitted I read through the ticket a few number of times. We have replication factor 3 and LocalQuorum. Do we

Re: Deletions getting omitted

2023-02-06 Thread shankha b
Subject: Re: Deletions getting omitted While you'd expect only_purge_repaired_tombstones:true to be sufficient, your gc_grace_secnds of 1 hour is making you unusually susceptible to resurrecting data. (To be clear, you should be safe to do this, but if there is a bug hiding in there somewhere,

Re: Deletions getting omitted

2023-02-04 Thread shankha b
I will look into raising the gc_grace_seconds. We are using LocalQuorum for all reads and writes. We do not use ALL exactly for outage reasons. From: Jeff Jirsa Sent: Saturday, February 4, 2023 8:44 PM To: user@cassandra.apache.org Subject: Re: Deletions

Re: Deletions getting omitted

2023-02-04 Thread Jeff Jirsa
While you'd expect only_purge_repaired_tombstones:true to be sufficient, your gc_grace_secnds of 1 hour is making you unusually susceptible to resurrecting data. (To be clear, you should be safe to do this, but if there is a bug hiding in there somewhere, your low gc_grace_seconds will make it lik