ADMIN SET REPLICA VERSION
Description
This statement is used to manually set the version, last successful version, and last failed version of a specified replica. It is primarily used for recovering replicas from an abnormal state when an issue occurs in the system.
Syntax
ADMIN SET REPLICA VERSION PROPERTIES ("<key>"="<value>" [,...])Required Parameters
** 1. "<key>"="<value>"**
| key | value type | Notes |
|---|---|---|
tablet_id | Int | The ID of the tablet whose replica version needs to be modified. |
backend_id | Int | The ID of the BE node where the replica is located. |
Optional Parameters
** 1. "<key>"="<value>"**
| key | value type | Notes |
|---|---|---|
version | Int | Sets the version of the replica. |
last_success_version | Int | Sets the last successful version of the replica. |
last_failed_version | Int | Sets the last failed version of the replica. |
Notes
-
If the specified replica does not exist, the operation will be ignored.
-
Modifying these values may cause subsequent data read and write failures, leading to data inconsistency. Please proceed with caution!
-
Record the original values before making modifications. After making changes, verify table read and write operations. If they fail, revert to the original values. However, reverting may also fail.
-
Do not perform this operation on a tablet that is currently writing data!
Access Control Requirements
The user executing this SQL command must have at least the following privileges:
| Privilege | Object | Notes |
|---|---|---|
| Admin_priv | Database | Required to execute administrative operations on the database, including managing tables, partitions, and system-level commands. |
Examples
-
Clear the failed status flag for the replica of tablet 10003 on BE 10001
ADMIN SET REPLICA VERSION PROPERTIES("tablet_id" = "10003", "backend_id" = "10001", "last_failed_version" = "-1"); -
Set the replica version of tablet 10003 on BE 10001 to 1004
ADMIN SET REPLICA VERSION PROPERTIES("tablet_id" = "10003", "backend_id" = "10001", "version" = "1004");