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.

Usage:
  • Package installations:
  • Tarball installations: 
C:\> cd "Program Files\DataStax Community\apache-cassandra\tools\bin"
C:\> sstablerepairedset [--really-set] [--is-repaired | --is-unrepaired] [-f sstable-list | sstables]

Procedure

  • Choose SSTables to mark as repaired. 
    C:\>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. 
    C:\> sstablerepairedset --is-unrepaired repairSetSSTables.txt
    A file like repairSetSSTables.txt would contain a list of SSTable (.db) files, as in the following example:
    \data\data\cycling\cyclist_by_country-82246fc065ff11e5a4c58b496c707234\ma-1-big-Data.db
\data\data\cycling\cyclist_by_birthday-8248246065ff11e5a4c58b496c707234\ma-1-big-Data.db
\data\data\cycling\cyclist_by_birthday-8248246065ff11e5a4c58b496c707234\ma-2-big-Data.db
\data\data\cycling\cyclist_by_age-8201305065ff11e5a4c58b496c707234\ma-1-big-Data.db
\data\data\cycling\cyclist_by_age-8201305065ff11e5a4c58b496c707234\ma-2-big-Data.db
    Use the following command to list all the Data.db files in a keyspace:
    dir /s /q C:\"Program Files\DataStax Community"\data\data\keyspace1\*.db