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
: Deletions getting omitted 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

Re: Deletions getting omitted

2023-02-04 Thread shankha b
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, your low gc_grace_se

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

Deletions getting omitted

2023-02-04 Thread shankha b
We are facing an issue on one of our production systems where after we delete the data the data doesn't seem to get deleted. We have a Get call just after the delete call. The data shows up. Versions cassandra : 3.11.6 gocqlx : v2 v2.1.0 1. Client Settings: LocalQuorum 2. Number of No