sstablerepairedset

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: This command should only be run with Cassandra stopped.
Usage:
  • Package installations: $ sstablerepairedset [--is-repaired | --is-unrepaired] [-f sstable-list | sstables]
  • Tarball installations: 
    cd install_location/tools
$ bin/sstablerepairedset [--is-repaired | --is-unrepaired] [-f sstable-list | sstables]

Procedure

  • Choose SSTables to mark as repaired. 
    sstablerepairedset --is-repaired /var/lib/cassandra/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
    An example file includes the path to the Data.db files:
    /home/user/apache-cassandra-2.2.3/data/data/test/cyclist_by_country-82246fc065ff11e5a4c58b496c707234/ma-1-big-Data.db
/home/user/apache-cassandra-2.2.3/data/data/test/cyclist_by_birthday-8248246065ff11e5a4c58b496c707234/ma-1-big-Data.db
/home/user/apache-cassandra-2.2.3/data/data/test/cyclist_by_birthday-8248246065ff11e5a4c58b496c707234/ma-2-big-Data.db
/home/user/apache-cassandra-2.2.3/data/data/test/cyclist_by_age-8201305065ff11e5a4c58b496c707234/ma-1-big-Data.db
/home/user/apache-cassandra-2.2.3/data/data/test/cyclist_by_age-8201305065ff11e5a4c58b496c707234/ma-2-big-Data.db
    A command to use to list all the Data.db files in a keyspace is the following:
    find '/home/user/apache-cassandra-2.2.3/data/data/test/' -iname "*Data.db*"