Deleting the json manifest worked like a charm. After 2 days of compactions I've got 50GB extra space! :)
Just a quick addendum, after deleting the json metadata file, I needed to restart the node, otherwise it just reloads the file from memory. Version: 1.2.16 On Wed, Aug 27, 2014 at 8:13 PM, Robert Coli <rc...@eventbrite.com> wrote: > On Wed, Aug 27, 2014 at 3:27 PM, Nate McCall <n...@thelastpickle.com> > wrote: > >> Another option to force things - deleting the json metadata file for that >> table will cause LCS to put all SSTables in level 0 and begin recompacting >> them. >> > > That's possible in versions where the level is in a JSON file, which is > versions before 2.0. In 2.0+ you can use nodetool for the same purpose. > > https://issues.apache.org/jira/browse/CASSANDRA-5271 (Fixed; 2.0 beta 1): > "Create tool to drop sstables to level 0" > > =Rob > > -- *Paulo Motta* Chaordic | *Platform* *www.chaordic.com.br <http://www.chaordic.com.br/>* +55 48 3232.3200
