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 DataStax Enterprise 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>]
Syntax conventions | Description |
---|---|
UPPERCASE |
Literal keyword. |
Lowercase |
Not literal. |
<`Italics>` |
Variable value. Replace with a valid option or user-defined value. |
|
Optional.
Square brackets ( |
|
Group.
Parentheses ( |
|
Or.
A vertical bar ( |
|
Repeatable.
An ellipsis ( |
|
Single quotation ( |
|
Map collection.
Braces ( |
|
Set, list, map, or tuple.
Angle brackets ( |
|
End CQL statement.
A semicolon ( |
|
Separate the command line options from the command arguments with two hyphens ( |
|
Search CQL only: Single quotation marks ( |
|
Search CQL only: Identify the entity and literal value to overwrite the XML element in the schema and solrconfig files. |
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 DSE stopped.
- sstable_filepath
-
The explicit or relative filepath to the SSTable data file ending in
Data.db
.
Examples
Verify DataStax Enterprise is not running
nodetool status
Datacenter: 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 rack1
Mark SSTable as repaired
Restriction: Stop DataStax Enterprise before you run this command.
sstablerepairedset --really-set --is-repaired /var/lib/cassandra/data/cycling/cyclist_category-e1f76e21ce4311e8949e33016bf887c0/aa-1-bti-Data.db
There is no command output.
Use file to list SSTables to mark as unrepaired
Restriction: Stop DataStax Enterprise before you run this command.
sstablerepairedset --is-unrepaired -f repairSetSSTables.txt
where 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