Re: Urgent Problem - Disk full

2018-04-04 Thread Jürgen Albersdorfer
Thank You All for your hints on this. I added another folder on the commitlog Disk to compensate immediate urgency. Next Step will be to reorganize and deduplicate the data into a 2nd table. Then drop the original one, clean the snapshot, consolidate back all data Files away from the commitlog

RE: Urgent Problem - Disk full

2018-04-04 Thread Kenneth Brotman
Agreed that you tend to add capacity to nodes or add nodes once you know you have no unneeded data in the cluster. From: Alain RODRIGUEZ [mailto:arodr...@gmail.com] Sent: Wednesday, April 04, 2018 9:10 AM To: user cassandra.apache.org Subject: Re: Urgent Problem - Disk full Hi, When

Re: Urgent Problem - Disk full

2018-04-04 Thread Alain RODRIGUEZ
.@yahoo.com.INVALID] > Sent: Wednesday, April 04, 2018 7:28 AM > To: user@cassandra.apache.org > Subject: RE: Urgent Problem - Disk full > > Jeff, > > Just wondering: why wouldn't the answer be to: > 1. move anything you want to archive to colder storage off the > cluste

RE: Urgent Problem - Disk full

2018-04-04 Thread Kenneth Brotman
There's also the old snapshots to remove that could be a significant amount of memory. -Original Message- From: Kenneth Brotman [mailto:kenbrot...@yahoo.com.INVALID] Sent: Wednesday, April 04, 2018 7:28 AM To: user@cassandra.apache.org Subject: RE: Urgent Problem - Disk full Jeff

RE: Urgent Problem - Disk full

2018-04-04 Thread Kenneth Brotman
Jirsa [mailto:jji...@gmail.com] Sent: Wednesday, April 04, 2018 7:10 AM To: user@cassandra.apache.org Subject: Re: Urgent Problem - Disk full Yes, this works in TWCS. Note though that if you have tombstone compaction subproperties set, there may be sstables with newer filesystem timestamps

Re: Urgent Problem - Disk full

2018-04-04 Thread Jeff Jirsa
There is zero reason to believe a full repair would make this better and a lot of reason to believe it’ll make it worse For casual observers following along at home, this is probably not the answer you’re looking for. -- Jeff Jirsa > On Apr 4, 2018, at 4:37 AM, Rahul Singh

Re: Urgent Problem - Disk full

2018-04-04 Thread Jeff Jirsa
Yes, this works in TWCS. Note though that if you have tombstone compaction subproperties set, there may be sstables with newer filesystem timestamps that actually hold older Cassandra data, in which case sstablemetadata can help finding the sstables with truly old timestamps Also if you’ve

RE: Urgent Problem - Disk full

2018-04-04 Thread Kenneth Brotman
, April 04, 2018 4:38 AM To: user@cassandra.apache.org; user@cassandra.apache.org Subject: Re: Urgent Problem - Disk full Nothing a full repair won’t be able to fix. On Apr 4, 2018, 7:32 AM -0400, Jürgen Albersdorfer <juergen.albersdor...@zweiradteile.net>, wrote: Hi, I have an urgent P

Re: Urgent Problem - Disk full

2018-04-04 Thread Rahul Singh
Nothing a full repair won’t be able to fix. On Apr 4, 2018, 7:32 AM -0400, Jürgen Albersdorfer , wrote: > Hi, > > I have an urgent Problem. - I will run out of disk space in near future. > Largest Table is a Time-Series Table with