Re: Tombstone Generation in Cassandra 4.1.3 Despite No Update/Delete Operations

2024-10-24 Thread Bowen Song via user
Is one tombstone scanned per query causing any issue? I mean real issues, not the scanning of tombstone itself. On 24/10/2024 04:56, Naman kaushik wrote: Thanks everyone for your responses. We have columns with |list| and |list| types, and after using |sstabledump|, we found that the tombston

Re: Tombstone Generation in Cassandra 4.1.3 Despite No Update/Delete Operations

2024-10-23 Thread Naman kaushik
Thanks everyone for your responses. We have columns with list and list types, and after using sstabledump, we found that the tombstones are being generated due to these columns. I’ve encountered another issue related to tombstones in a table that is not involved in any write operations, as it is s

Re: Tombstone Generation in Cassandra 4.1.3 Despite No Update/Delete Operations

2024-10-09 Thread Jeff Jirsa
The easiest option here, though still unpleasant, is sstabledump to json and look at the tombstoneUsually when this happens it’s because something unexpected is happening - actually writing nulls or doing deleted or weird short TTLs without realizing it Dump the sstable and look, it’ll be faster th

Re: Tombstone Generation in Cassandra 4.1.3 Despite No Update/Delete Operations

2024-10-09 Thread Jon Haddad
Overwriting non collections does not generate tombstones on compaction. — Jon Haddad Rustyrazorblade Consulting rustyrazorblade.com On Wed, Oct 9, 2024 at 9:57 AM James Shaw wrote: > Hi, Naman: > How does the client side load large amounts of data ? Most > likely it has a retry polic

Re: Tombstone Generation in Cassandra 4.1.3 Despite No Update/Delete Operations

2024-10-09 Thread James Shaw
Hi, Naman: How does the client side load large amounts of data ? Most likely it has a retry policy, either by tool's default or by setting. If it has a retry policy, will have duplicated records, after compaction, will have tombstones. Another possibility, client set ttl, it will overri

Re: Tombstone Generation in Cassandra 4.1.3 Despite No Update/Delete Operations

2024-10-08 Thread Jon Haddad
Are you using collections? — Jon Haddad Rustyrazorblade Consulting rustyrazorblade.com On Tue, Oct 8, 2024 at 10:52 PM Naman kaushik wrote: > Hi Community, > > We are currently using Cassandra version 4.1.3 and have encountered an > issue related to tombstone generation. We have two tables sto

Tombstone Generation in Cassandra 4.1.3 Despite No Update/Delete Operations

2024-10-08 Thread Naman kaushik
Hi Community, We are currently using Cassandra version 4.1.3 and have encountered an issue related to tombstone generation. We have two tables storing monthly data: table_september and table_october. Each table has a TTL of 30 days. For the month of October, data is being inserted into the table_