Re: old data / tombstones are not deleted after ttl

2013-03-05 Thread aaron morton
Thx, >> >> Br, >> Matthias Zeilinger >> Production Operation – Shared Services >> >> P: +43 (0) 50 858-31185 >> M: +43 (0) 664 85-34459 >> E: matthias.zeilin...@bwinparty.com >> >> bwin.party services (Austria) GmbH >> Marxergasse 1B &

Re: old data / tombstones are not deleted after ttl

2013-03-05 Thread Michal Michalski
.zeilin...@bwinparty.com bwin.party services (Austria) GmbH Marxergasse 1B A-1030 Vienna www.bwinparty.com -Original Message- From: Matthias Zeilinger [mailto:matthias.zeilin...@bwinparty.com] Sent: Dienstag, 05. März 2013 08:03 To: user@cassandra.apache.org Subject: RE: old data / tomb

Re: old data / tombstones are not deleted after ttl

2013-03-05 Thread Marcus Eriksson
m: Matthias Zeilinger [mailto:matthias.zeilin...@bwinparty.com] > Sent: Dienstag, 05. März 2013 08:03 > To: user@cassandra.apache.org > Subject: RE: old data / tombstones are not deleted after ttl > > Yes it was a major compaction. > I know it´s not a great solution, but I needed

RE: old data / tombstones are not deleted after ttl

2013-03-05 Thread Matthias Zeilinger
[mailto:matthias.zeilin...@bwinparty.com] Sent: Dienstag, 05. März 2013 08:03 To: user@cassandra.apache.org Subject: RE: old data / tombstones are not deleted after ttl Yes it was a major compaction. I know it´s not a great solution, but I needed something to get rid of the old data, because I went out of diskspace

RE: old data / tombstones are not deleted after ttl

2013-03-04 Thread Matthias Zeilinger
bwin.party services (Austria) GmbH Marxergasse 1B A-1030 Vienna www.bwinparty.com -Original Message- From: Michal Michalski [mailto:mich...@opera.com] Sent: Dienstag, 05. März 2013 07:47 To: user@cassandra.apache.org Subject: Re: old data / tombstones are not deleted after ttl Was it

Re: old data / tombstones are not deleted after ttl

2013-03-04 Thread Michal Michalski
nparty.com From: Bryan Talbot [mailto:btal...@aeriagames.com] Sent: Montag, 04. März 2013 23:36 To: user@cassandra.apache.org Subject: Re: old data / tombstones are not deleted after ttl Those older files won't be included in a compaction until there are min_compaction_threshold (4) fil

RE: old data / tombstones are not deleted after ttl

2013-03-04 Thread Matthias Zeilinger
(Austria) GmbH Marxergasse 1B A-1030 Vienna www.bwinparty.com From: Bryan Talbot [mailto:btal...@aeriagames.com] Sent: Montag, 04. März 2013 23:36 To: user@cassandra.apache.org Subject: Re: old data / tombstones are not deleted after ttl Those older files won't be included in a compaction

Re: old data / tombstones are not deleted after ttl

2013-03-04 Thread Bryan Talbot
Those older files won't be included in a compaction until there are min_compaction_threshold (4) files of that size. When you get another SS table -Data.db file that is about 12-18GB then you'll have 4 and they will be compacted together into one new file. At that time, if there are any rows with

Re: old data / tombstones are not deleted after ttl

2013-03-03 Thread Michal Michalski
Did you try checking (using nodetool getsstables) how many SSTables your row's data are spread into? All the "parts" of the row have to be in one SSTable to remove it (data & tombstone). Remember, that even if you do not update your data, you still may have two SSTables containing row's data (o

old data / tombstones are not deleted after ttl

2013-03-03 Thread Matthias Zeilinger
Hi, I´m running Cassandra 1.1.5 and have following issue. I´m using a 10 days TTL on my CF. I can see a lot of tombstones in there, but they aren´t deleted after compaction. I have tried a nodetool -cleanup and also a restart of Cassandra, but nothing happened. total 61G drwxr-xr-x 2 cassand