TWCS not cleaning up data as fast as expected

2021-10-14 Thread Eric Wong
Hi all: I am using Cassandra 4.0 and a table called 'minute' is configured to use TWCS. Since it is TWCS, I do not have cassandra-reaper to perform any repair of the table. There is also no manual compaction performed on the table. When we insert data into the db, we set a TTL of one day from

Re: Tombstones? 4.0.1

2021-10-14 Thread Joe Obernberger
I'm not sure if tombstones is the issue; is it?  Grace is set to 10 days, that time has not passed yet. -Joe On 10/14/2021 1:37 PM, James Brown wrote: What is gc_grace_seconds set to on the table? Once that passes, you can do `nodetool scrub` to more emphatically remove tombstones... On Thu,

Re: Tombstones? 4.0.1

2021-10-14 Thread James Brown
What is gc_grace_seconds set to on the table? Once that passes, you can do `nodetool scrub` to more emphatically remove tombstones... On Thu, Oct 14, 2021 at 8:49 AM Joe Obernberger < joseph.obernber...@gmail.com> wrote: > Hi all - I have a table where I've needed to delete a number of rows. > I'

Tombstones? 4.0.1

2021-10-14 Thread Joe Obernberger
Hi all - I have a table where I've needed to delete a number of rows.  I've run repair, but I still can't select from the table. select * from doc.indexorganize limit 10; OperationTimedOut: errors={'172.16.100.37:9042': 'Client request timeout. See Session.execute[_async](timeout)'}, last_host