nodetool resetlocalschema

Reset the node's local schema and resynchronizes.

Synopsis

nodetool <options> resetlocalschema

Table 1. Options
Short	Long	Description
`-h`	`--host`	Hostname or IP address
`-p`	`--port`	Port number
`-pwf`	`--password-file`	Password file path
`-pw`	`--password`	Password
`-u`	`--username`	User name
`--`	Separates an option from an argument that could be mistaken for a option.

Description

Normally, this command is used to rectify schema disagreements on different nodes. It can be useful if table schema changes have generated too many tombstones, on the order of 100,000s.

nodetool resetlocalschema drops the schema information of the local node and resynchronizes the schema from another node. To drop the schema, the tool truncates all the system schema tables. The node will temporarily lose metadata about the tables on the node, but will rewrite the information from another node. If the node is experiencing problems with too many tombstones, the truncation of the tables will eliminate the tombstones.

This command is useful when you have one node that is out of sync with the cluster. The system schema tables must have another node from which to fetch the tables. It is not useful when all or many of your nodes are in an incorrect state. If there is only one node in the cluster (replication factor of 1) – it does not perform the operation, because another node from which to fetch the tables does not exist. Run the command on the node experiencing difficulty.