Re: Files not removed after compaction

2015-06-13 Thread Spencer Brown
You can't delete by year unless tables are organized by year. For deleting tables, cassandra keeeps a copy of the file history which you can delete. Also, you could delete all the extra rows using CQL. On Wed, Jun 10, 2015 at 7:15 PM, Jeff Ferland j...@tubularlabs.com wrote: Compaction

Re: Files not removed after compaction

2015-06-10 Thread Robert Coli
On Wed, Jun 10, 2015 at 4:15 PM, Jeff Ferland j...@tubularlabs.com wrote: Compaction finished yesterday, but I still have this going on: 1) What version? 2) Probably file a JIRA, esp. if you can repro on another node? 3) if you do 2, reply to thread so we can track! =Rob

Re: Files not removed after compaction

2015-06-10 Thread Jeff Ferland
Cassandra 2.0.12-200 / DSE 4.6.1 https://issues.apache.org/jira/browse/CASSANDRA-9577 https://issues.apache.org/jira/browse/CASSANDRA-9577 -Jeff On Jun 10, 2015, at 4:36 PM, Robert Coli rc...@eventbrite.com wrote: On Wed, Jun 10, 2015 at 4:15 PM, Jeff Ferland j...@tubularlabs.com

Files not removed after compaction

2015-06-10 Thread Jeff Ferland
Compaction finished yesterday, but I still have this going on: Space used (live), bytes: 878681716067 Space used (total), bytes: 2227857083852 jbf@ip-10-0-2-98:/ebs/cassandra/data/trends/trends$ sudo lsof *-Data.db COMMAND PID USER FD TYPE DEVICE