> > >> +1, though because you can't drop the snapshots those two commands > automatically create (if the snapshot-before-DROP even works with disk > full, which it probably doesn't...) you still need access to the machines > to reclaim your disk space. > >
True.. I actually disabled the snapshot feature for this reason. A "without snapshot" feature to drop/truncate table would be nice. > And realistically, how do you even recover from this situation? You can't >> compact the table, and you can't delete data or truncate the table either. >> > > 1) Delete some SSTables on the OS level and restart Cassandra. This is > obviously bad for consistency. > OR > Yes… luckily our tables are partitioned by day so I just deleted the oldest day. > 2) Add disk space to your node. This may not be possible. > > Yes… it's not possible because you can't compact the table without some minor amount of disk space :-/ -- Founder/CEO Spinn3r.com Location: *San Francisco, CA* blog: http://burtonator.wordpress.com … or check out my Google+ profile <https://plus.google.com/102718274791889610666/posts> <http://spinn3r.com>
