Skip to main content

ADMIN CANCEL REPAIR

Description​

This statement is used to cancel repairing specified tables or partitions with high priority.

tip

This operation requires the SYSTEM-level OPERATE privilege. You can follow the instructions in GRANT to grant this privilege.

Syntax​

ADMIN CANCEL REPAIR TABLE table_name[ PARTITION (p1,...)]

Note

This statement only indicates that the system will no longer repair sharding replicas of specified tables or partitions with high priority. It still repairs these copies by default scheduling.

Examples​

  1. Cancel high priority repair

    ADMIN CANCEL REPAIR TABLE tbl PARTITION(p1);