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: 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. For details, see Migrating to incremental repairs

Usage:
  • Cassandra Package installations: 
    sstablerepairedset [--is-repaired | --is-unrepaired] [-f sstable-list | sstables]
  • Cassandra 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.1.10/data/data/test/cyclist_by_country-82246fc065ff11e5a4c58b496c707234/ma-1-big-Data.db
/home/user/apache-cassandra-2.1.10/data/data/test/cyclist_by_birthday-8248246065ff11e5a4c58b496c707234/ma-1-big-Data.db
/home/user/apache-cassandra-2.1.10/data/data/test/cyclist_by_birthday-8248246065ff11e5a4c58b496c707234/ma-2-big-Data.db
/home/user/apache-cassandra-2.1.10/data/data/test/cyclist_by_age-8201305065ff11e5a4c58b496c707234/ma-1-big-Data.db
/home/user/apache-cassandra-2.1.10/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.1.10/data/data/test/' -iname "*Data.db*"