[jira] [Created] (CASSANDRA-17357) Snapshot true size computation does not include secondary indexes

["Paulo Motta (Jira)" <ji...@apache.org>]

Paulo Motta created CASSANDRA-17357:
---------------------------------------

             Summary: 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


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.1#820001)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org