The sstablerepairedset utility will reset the level to 0 on a given set of SSTables.

This tool is intended to mark specific SSTables as repaired or unrepaired. It is used to set the repairedAt status on a given set of SSTables. This metadata facilitates incremental repairs. It can take in the path to an individual SSTable or the path to a file containing a list of SSTables paths.
Warning: Do not run this command until you have stopped Cassandra on the node.

Use this tool in the process of migrating a Cassandra installation to incremental repair.

  • Cassandra package installations:
    sstablerepairedset [--really-set] [--is-repaired | --is-unrepaired] [-f sstable-list | sstables]
  • Cassandra tarball installations:
    cd install_location/tools
    $ bin/sstablerepairedset [--really-set] [--is-repaired | --is-unrepaired] [-f sstable-list | sstables]


  • Choose SSTables to mark as repaired.
    sstablerepairedset --really-set --is-repaired data/data/cycling/cyclist_name-a882dca02aaf11e58c7b8b496c707234/la-1-big-Data.db
  • Use a file to list the SSTable to mark as unrepaired.
    /sstablerepairedset --is-unrepaired -f repairSetSSTables.txt
    A file like repairSetSSTables.txt would contain a list of SSTable (.db) files, as in the following example:
    Use the following command to list all the Data.db files in a keyspace:
    find '/home/user/apache-cassandra-3.0.2/data/data/keyspace1/' -iname "*Data.db*"