[
https://issues.apache.org/jira/browse/CASSANDRA-20448?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Brad Schoening updated CASSANDRA-20448:
---------------------------------------
Description:
A key reason to run sstableexpiredblockers is that you have disk space
accumulating and you wish to investigate what's consuming the disk space.
If size was included in the output (as shown below), it would make the output
more useful. Generally, when you find a blocked expired table, the first step
is to check what size it is to see if it's large enough to be a problem.
{quote}[BigTableReader(path='/var/lib/cassandra/data/keyspace1/standard1-0665ae80b2d711e886c66d2c86545d91/mc-2-big-Data.db')
(minTS = 5, maxTS = 5, maxLDT = 2147483647)], blocks 1 expired sstables from
getting dropped:
[BigTableReader(path='/var/lib/cassandra/data/keyspace1/standard1-0665ae80b2d711e886c66d2c86545d91/mc-3-big-Data.db')
(\{*}diskSize = 135.7 GB\{*}, minTS = 1536349775157606, maxTS =
1536349780311159, maxLDT = 1536349780)],
{quote}
Also, it would be preferable to report min/max timestamp in date-time format
e.g.:
{quote} diskSize =134.3 GB, minTimestamp = 2025-03-10T00:00:00.000+00:00
{quote}
was:
A key reason to run sstableexpiredblockers is that you have disk space
accumulating and you wish to investigate what's consuming the disk space.
If size was included in the output (as shown below), it would make the output
more useful. Generally, when you find a blocked expired table, the first step
is to check what size it is to see if it's large enough to be a problem.
{quote}[BigTableReader(path='/var/lib/cassandra/data/keyspace1/standard1-0665ae80b2d711e886c66d2c86545d91/mc-2-big-Data.db')
(minTS = 5, maxTS = 5, maxLDT = 2147483647)], blocks 1 expired sstables from
getting dropped:
[BigTableReader(path='/var/lib/cassandra/data/keyspace1/standard1-0665ae80b2d711e886c66d2c86545d91/mc-3-big-Data.db')
({*}diskSize = 135.7 GB{*}, minTS = 1536349775157606, maxTS =
1536349780311159, maxLDT = 1536349780)],{quote}
Also, it would be preferable to report min/max timestamp in date-time format
e.g.:
{quote} diskSize =134.3 GB, minTimestamp = 2025-03-10T00:00:00.000+00:00
{quote}
> Utility sstableexpiredblockers should report the size of expired tables
> -----------------------------------------------------------------------
>
> Key: CASSANDRA-20448
> URL: https://issues.apache.org/jira/browse/CASSANDRA-20448
> Project: Apache Cassandra
> Issue Type: Improvement
> Reporter: Brad Schoening
> Priority: Normal
>
> A key reason to run sstableexpiredblockers is that you have disk space
> accumulating and you wish to investigate what's consuming the disk space.
> If size was included in the output (as shown below), it would make the output
> more useful. Generally, when you find a blocked expired table, the first step
> is to check what size it is to see if it's large enough to be a problem.
> {quote}[BigTableReader(path='/var/lib/cassandra/data/keyspace1/standard1-0665ae80b2d711e886c66d2c86545d91/mc-2-big-Data.db')
> (minTS = 5, maxTS = 5, maxLDT = 2147483647)], blocks 1 expired sstables from
> getting dropped:
> [BigTableReader(path='/var/lib/cassandra/data/keyspace1/standard1-0665ae80b2d711e886c66d2c86545d91/mc-3-big-Data.db')
> (\{*}diskSize = 135.7 GB\{*}, minTS = 1536349775157606, maxTS =
> 1536349780311159, maxLDT = 1536349780)],
> {quote}
> Also, it would be preferable to report min/max timestamp in date-time format
> e.g.:
> {quote} diskSize =134.3 GB, minTimestamp =
> 2025-03-10T00:00:00.000+00:00
> {quote}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
