sstablerepairedset
Sets status as repaired or unrepaired on a given set of SSTables and updates the repairedAt field to denote the time of the repair while offline.
This metadata facilitates incremental repairs.
Use this tool in the process of migrating an installation to incremental repair.
Restriction: Stop HCD before you run this command.
|
Use sstableutil to list the *.db files in a keyspace. |
The default location of this SSTable tool depends on the type of installation:
-
Package installations:
/usr/bin/ -
Tarball installations:
<installation_location>/resources/cassandra/tools/bin
Synopsis
sstablerepairedset
--really-set [--is-repaired | --is-unrepaired]
[-f <sstable_list_file> | <sstable_filepath>]Definition
The short form and long form parameters are comma-separated.
Command arguments
- -f sstable_list_file
-
The filepath to a file that contains a list of SSTables. For example, a *.txt file.
- --is-repaired
-
Sets repaired status.
- --is-unrepaired
-
Sets unrepaired status.
- --really-set
-
Acknowledgement of potential command impact with HCD stopped.
- sstable_filepath
-
The explicit or relative filepath to the SSTable data file ending in
Data.db.
Examples
Verify HCD is not running
nodetool statusDatacenter: Graph
================================
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
-- Address Load Tokens Owns Host ID Rack
UN 10.200.177.92 265.04 KiB 1 ? 980cab6a-2e5d-44c6-b897-0733dde580ac rack1
DN 10.200.177.94 426.21 KiB 1 ? 7ecbbc0c-627d-403e-b8cc-a2daa93d9ad3 rack1Mark SSTable as repaired
Restriction: Stop HCD before you run this command.
sstablerepairedset --really-set --is-repaired /var/lib/cassandra/data/cycling/cyclist_category-e1f76e21ce4311e8949e33016bf887c0/aa-1-bti-Data.dbThere is no command output.
Use file to list SSTables to mark as unrepaired
Restriction: Stop HCD before you run this command.
sstablerepairedset --is-unrepaired -f repairSetSSTables.txtwhere the repairSetSSTables.txt file contains a list of SSTables (*Data.db) files, like:
/data/cycling/cyclist_by_country-82246fc065ff11e5a4c58b496c707234/ma-1-big-Data.db
/data/cycling/cyclist_by_birthday-8248246065ff11e5a4c58b496c707234/ma-1-big-Data.db
/data/cycling/cyclist_by_birthday-8248246065ff11e5a4c58b496c707234/ma-2-big-Data.db
/data/cycling/cyclist_by_age-8201305065ff11e5a4c58b496c707234/ma-1-big-Data.db
/data/cycling/cyclist_by_age-8201305065ff11e5a4c58b496c707234/ma-2-big-Data.db