Re: Records in table after deleting sstable manually

2020-08-11 Thread Kunal
Thanks Jeff. Appreciate your reply. as you said , looks like some there were entries in commitlogs and when cassandra was brought up after deleting sstables, data from commitlog replayed. May be next time I will let the replay happen after deleting sstable and then truncate table using CQL. This wi

Re: Records in table after deleting sstable manually

2020-08-11 Thread Jeff Jirsa
The data probably came from either hints or commitlog replay. If you use `truncate` from CQL, it solves both of those concerns. On Tue, Aug 11, 2020 at 8:42 AM Kunal wrote: > HI, > > We have a 3 nodes cassandra cluster and one of the table grew big, around > 2 gb while it was supposed to be fe

Records in table after deleting sstable manually

2020-08-11 Thread Kunal
HI, We have a 3 nodes cassandra cluster and one of the table grew big, around 2 gb while it was supposed to be few MBs. During nodetool repair, one of the cassandra went down. Even after multiple restart, one of the node was going down after coming up for few mins. We decided to truncate the table