nodetool repair

Repairs one or more tables in a cluster when all involved replicas are up and accessible..

Repairs tables on one or more nodes in a cluster when all involved replicas are up and accessible.

Important: Tables with NodeSync enabled will be skipped for repair operations run against all or specific keyspaces. For individual tables, running the repair command will be rejected when NodeSync is enabled.

See Repairing nodes. Before using this command, be sure to have an understanding of how node repair works.

Important: If repair encounters a down replica, an error occurs and the repair process halts. Re-run repair after bringing all replicas back online.

OpsCenter provides a repair option in the Nodes UI for .

Synopsis

nodetool [connection_options] repair 
[-dcpar | -seq] 
[-full | -inc]
[-hosts ip_address [ip_address ...]]
[-local | -dc datacenter_name[,datacenter_name,...]] 
[-pl] [-pr] [-prv] 
[-pull -hosts local_ip_address [remote_ip_address]
[-j job_threads]
[-st start_token -et end_token] 
[-tr] [--] 
[keyspace_name table_name [table_name ...]]
Table 1. Legend
Syntax conventions Description
UPPERCASE Literal keyword.
Lowercase Not literal.
Italics Variable value. Replace with a valid option or user-defined value.
[ ] Optional. Square brackets ( [ ] ) surround optional command arguments. Do not type the square brackets.
( ) Group. Parentheses ( ( ) ) identify a group to choose from. Do not type the parentheses.
| Or. A vertical bar ( | ) separates alternative elements. Type any one of the elements. Do not type the vertical bar.
... Repeatable. An ellipsis ( ... ) indicates that you can repeat the syntax element as often as required.
'Literal string' Single quotation ( ' ) marks must surround literal strings in CQL statements. Use single quotation marks to preserve upper case.
{ key:value } Map collection. Braces ( { } ) enclose map collections or key value pairs. A colon separates the key and the value.
<datatype1,datatype2> Set, list, map, or tuple. Angle brackets ( < > ) enclose data types in a set, list, map, or tuple. Separate the data types with a comma.
cql_statement; End CQL statement. A semicolon ( ; ) terminates all CQL statements.
[ -- ] Separate the command line options from the command arguments with two hyphens ( -- ). This syntax is useful when arguments might be mistaken for command line options.
' <schema> ... </schema> ' Search CQL only: Single quotation marks ( ' ) surround an entire XML schema declaration.
@xml_entity='xml_entity_type' Search CQL only: Identify the entity and literal value to overwrite the XML element in the schema and solrconfig files.

The short form and long form parameters are comma-separated.

Connection options

-h, --host hostname
The hostname or IP address of a remote node or nodes. When omitted, the default is the local machine.
-p, --port jmx_port
The JMX port number.
-pw, --password jmxpassword
The JMX password for authenticating with secure JMX. If a password is not provided, you are prompted to enter one.
-pwf, --password-file jmx_password_filepath
The filepath to the file that stores JMX authentication credentials.
-u, --username jmx_username
The user name for authenticating with secure JMX.

Command arguments

--
Separates an option from an argument that could be mistaken for a option.
-dc datacenter_name, --in-dc datacenter_name
Comma-separated list of datacenters to limit repairs to. Datacenter names are case sensitive. Decreases network traffic while repairing more nodes than the local option. When this option is not specified, repair is run cluster-wide on all nodes that contain replicas.
-dcpar, --dc-parallel
Run repairs on all nodes with the same replica data at the same time, recommended for repairs across datacenters. A single node in each datacenter runs repair, one after another until the repair is complete. This option combines sequential and parallel repair by simultaneously running a sequential repair in all datacenters. Use with the -local option only when the datacenter nodes have all the data for all ranges.
-et, --end-token end_token
The token at which the range ends. Requires start token (-st).
-force, --force
Filter out down endpoints.
-full, --full
Issue a full repair.
-hosts, --in-hosts host_name
Repair specific hosts.
-inc, --inc
Issue an incremental repair.
-j, --job-threads num_threads
Number of threads to run repair jobs. Usually this means number of tables to repair concurrently. Default: 1. Max: 4.
Warning: Increasing job threads puts more load on repairing nodes.
keyspace_name
The keyspace name.
-local, --in-local-dc
Repair only against nodes in the same datacenter.
-pl, --pull
Runs a one-way repair directly from another node that has a replica in the same token range. This option minimizes performance impact when cross-datacenter repairs are required.
-pr, --partitioner-range
Repair only the first range returned by the partitioner.
-prv, --preview
Determine ranges and amount of data to be streamed, but doesn't perform repair.
-seq, --sequential
Perform sequential repair.
-st, --start-token start_token
The token at which the range starts. Requires end token (-et).
table_name
One or more table names, separated by a space.
-tr, --trace
Trace the repair. Traces are logged to system_traces.events.
-vd, --validate
Checks that repaired data is in sync between nodes.
Note: Out of sync repaired data indicates a full repair should be run.

Examples

All nodetool repair command options are optional. When optional command arguments are not specified, the defaults are:
  • Full repair runs on all keyspaces and all tables.
  • Repair runs in parallel on all nodes with the same replica data at the same time.
  • The number of job threads is 1.
  • No tracing. No validation.

Sequential repair of all keyspaces 

nodetool repair -seq

Partitioner range repair 

nodetool repair -pr

Start-point-to-end-point repair of all nodes between two nodes on the ring

nodetool repair -st -9223372036854775808 -et -3074457345618258603

Restrict repair to local datacenter

nodetool repair -dc DC1
Results in output: 
[2014-07-24 21:59:55,326] Nothing to repair for keyspace 'system'
                    [2014-07-24 21:59:55,617] Starting repair command #2, repairing 490 ranges 
                    for keyspace system_traces (seq=true, full=true)
                    [2014-07-24 22:23:14,299] Repair session 323b9490-137e-11e4-88e3-c972e09793ca 
                    for range (820981369067266915,822627736366088177] finished
                    [2014-07-24 22:23:14,320] Repair session 38496a61-137e-11e4-88e3-c972e09793ca 
                    for range (2506042417712465541,2515941262699962473] finished
                    . . .
The system.log shows repair runs only on IP addresses in DC1. 
. . .
                    INFO  [AntiEntropyStage:1] 2014-07-24 22:23:10,708 RepairSession.java:171 
                    - [repair #16499ef0-1381-11e4-88e3-c972e09793ca] Received merkle tree 
                    for sessions from /192.168.2.101
                    INFO  [RepairJobTask:1] 2014-07-24 22:23:10,740 RepairJob.java:145 
                    - [repair #16499ef0-1381-11e4-88e3-c972e09793ca] requesting merkle trees 
                    for events (to [/192.168.2.103, /192.168.2.101])
                    . . .