You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "xxxcai999 (Jira)" <ji...@apache.org> on 2024/02/22 07:15:00 UTC
[jira] [Created] (CASSANDRA-19421) expired data in sstable not remove
xxxcai999 created CASSANDRA-19421:
-------------------------------------
Summary: expired data in sstable not remove
Key: CASSANDRA-19421
URL: https://issues.apache.org/jira/browse/CASSANDRA-19421
Project: Cassandra
Issue Type: Bug
Reporter: xxxcai999
Attachments: sstabledump.txt
Version: cassandra:3.11.3
My table is using a TTL of 90 days. but sometimes expired data not deleted, The file size will increase to several hundred gigabytes, occupying a large amount of disk space.
Liked this sstable file:
-rw-r--r-- 1 cassandra cassandra 396G Sep 10 00:16 mc-22009-big-Data.db
-rw-r--r-- 1 cassandra cassandra 9 Sep 10 00:16 mc-22009-big-Digest.crc32
-rw-r--r-- 1 cassandra cassandra 37K Sep 10 00:16 mc-22009-big-Filter.db
-rw-r--r-- 1 cassandra cassandra 533M Sep 10 00:16 mc-22009-big-Index.db
-rw-r--r-- 1 cassandra cassandra 12K Sep 10 00:16 mc-22009-big-Statistics.db
-rw-r--r-- 1 cassandra cassandra 15K Sep 10 00:16 mc-22009-big-Summary.db
-rw-r--r-- 1 cassandra cassandra 92 Sep 10 00:16 mc-22009-big-TOC.txt
By using sstabledump tool, i found all rows expired
17 {
18 "type" : "row",
19 "position" : 104,
20 "clustering" : [ 1689491660981 ],
21 "liveness_info" : \{ "tstamp" : "2023-07-16T07:14:24.273004Z", "ttl" : 7776000, "expires_at" : "2023-10-14T07:14:24Z", "expired" : true },
22 "cells" : [
23 \{ "name" : "long_v", "value" : 1 }
24 ]
25 }
This issue makes my disk space estimation unpredictable, so i want get some help.
The attachment contains information on sstablemetadata.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org