[ https://issues.apache.org/jira/browse/CASSANDRA-17357?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Paulo Motta updated CASSANDRA-17357: ------------------------------------ Fix Version/s: (was: 4.1) > Snapshot true size computation does not include secondary indexes > ----------------------------------------------------------------- > > Key: CASSANDRA-17357 > URL: https://issues.apache.org/jira/browse/CASSANDRA-17357 > Project: Cassandra > Issue Type: Bug > Components: Local/Snapshots > Reporter: Paulo Motta > Assignee: Paulo Motta > Priority: Normal > > The true size is supposed to show the total size of the snapshot minus any > live sstables. > Nevertheless, sstables from secondary indexes are not included in the > computation of the true size, causing a mismatch between the true size and > snapshot size when there are indexes and no live sstables. > It's possible to fetch the global snapshot size per table and indexes > separately via nodetool tablestats, but not for individual snapshots. > This behavior seems to be there since before 3.0, so I think it has always > been like this. > Reproduction steps: > {noformat} > % ccm node1 nodetool -- snapshot -t test test_ks > Requested creating snapshot(s) for [test_ks] with snapshot name [test] > Snapshot directory: test > % ccm node1 nodetool listsnapshots > Snapshot Details: > Snapshot name Keyspace name Column family name True size Size on disk > test test_ks tbl 0 bytes 10.76 KB > Total TrueDiskSpaceUsed: 0 bytes > % ccm node1 nodetool tablestats test_ks.tbl | grep -i snapshot > Space used by snapshots (total): 0 > % ccm node1 nodetool tablestats test_ks.tbl.tbl_val_idx | grep -i snapshot > Space used by snapshots (total): 0 > % ccm node1 nodetool compact test_ks tbl.tbl_val_idx > % ccm node1 nodetool compact test_ks tbl_val_idx > % ccm node1 nodetool tablestats test_ks.tbl | grep -i snapshot > Space used by snapshots (total): 5027 > % ccm node1 nodetool tablestats test_ks.tbl.tbl_val_idx | grep -i snapshot > Space used by snapshots (total): 5060 > % ccm node1 nodetool listsnapshots > Snapshot Details: > Snapshot name Keyspace name Column family name True size Size on disk > test test_ks tbl 4.91 KB 10.76 KB > Total TrueDiskSpaceUsed: 4.91 KB > {noformat} -- This message was sent by Atlassian Jira (v8.20.7#820007) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org