nodetool scrub
Creates a snapshot and then rebuilds SSTables for one or more tables on a node.
If possible use nodetool upgradesstables
instead of scrub.
Scrub automatically discards broken data and removes any tombstone rows that have exceeded the grace period of the table. If partition key values do not match the column data type, the partition is considered corrupt and the process automatically stops.
The sstablescrub
utility is an offline version of nodetool scrub
.
For LeveledCompactionStrategy (LCS), |
Synopsis
nodetool [<connection_options>] scrub
[-j <num_jobs>] [-n] [-ns] [-r] [-s]
[--] [<keyspace_name> <table_name> [<table_name> ...]]
Definition
The short- and long-form options 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 username for authenticating with secure JMX.
Command arguments
--
-
Separates an option from an argument that could be mistaken for an option.
- -j, --jobs num_jobs
-
-
Number greater than 0: Set the number of SSTables affected simultaneously.
-
0: Use all available compaction threads.
-
Default: 2
-
- keyspace_name
-
The keyspace name.
- -n, --no-validate
-
Do not validate columns using column validator.
- -r, --reinsert-overflowed-ttl
-
Rewrite rows with overflowed expiration date affected by
CASSANDRA-14092
with the maximum supported expiration date of2038-01-19T03:14:06+00:00
. Rows are rewritten with the original timestamp incremented by one millisecond to override/supersede any potential tombstone that might have been generated during compaction of the affected rows. See Recover expired data caused by TTL year 2038 problem. - -s, --skip-corrupted
-
Skip corrupted partitions even when scrubbing counter tables. Default:
false
. - table_name
-
One or more table names, separated by a space.
Examples
Scrub a single table on a keyspace
nodetool scrub cycling cyclist_id
Scrub an entire keyspace while skipping corrupted partitions
nodetool scrub -s cycling