ADMIN SHOW REPLICA STATUS

Description

This statement is used to display copy status information for a table or partition

Grammar:

ADMIN SHOW REPLICA STATUS FROM [dbu name.]tbl name [PARTITION (p1,…)] [where_clause];

where_clause: WHERE STATUS [!]= “replica_status”

Reply status: OK: Replica 22788;’20581;’ 29366;’24577; DEAD: The Backend of replica is not available VERSION_ERROR: The replica data version is missing SCHEMA ERROR: replica schema hash MISSING: replica does not exist

example

  1. View the status of all copies of the table

ADMIN SHOW REPLICA STATUS FROM db1.tbl1;

  1. View a copy of a partition state of the table as VERSION_ERROR

ADMIN SHOW REPLICA STATUS FROM tbl1 PARTITION (p1, p2)

  1. Check all unhealthy copies of the table

ADMIN SHOW REPLICA STATUS FROM tbl1 WHERE STATUS != “OK”;

keyword

ADMIN,SHOW,REPLICA,STATUS