GLOBAL_WAL_SENDER_STATUS

GLOBAL_WAL_SENDER_STATUS displays the redo log transfer and replay status of the primary DN in the current cluster. This view can be viewed only by the users with monitor admin and sysadmin permission.

**Table 1** GLOBAL_WAL_SENDER_STATUS column
Name	Type	Description
nodename	text	Name of the primary node.
source_ip	text	IP address of the primary node.
source_port	integer	Port of the primary node.
dest_ip	text	IP address of the standby node.
dest_port	integer	Port of the standby node.
sender_pid	integer	PID of the sending thread.
local_role	text	Type of the primary node. UNKNOWN_MODE: The status is unknown. NORMAL_MODE: single-host node. PRIMARY_MODE: primary node. STANDBY_MODE: standby node. CASCADE_STANDBY_MODE: cascaded standby node. PENDING_MODE: The node is in the arbitration phase. RECOVERY_MODE: The node is in the restoration phase. STANDBY_CLUSTER_MODE: standby cluster node. MAIN_STANDBY_MODE: main standby cluster node. NOTE: The expected values of the primary node type are NORMAL_MODE, PRIMARY_MODE, PENDING_MODE, and RECOVERY_MODE. If other node types are displayed, contact Huawei technical support.
peer_role	text	Type of the standby node. UNKNOWN_MODE: The status is unknown. NORMAL_MODE: single-host node. PRIMARY_MODE: primary node. STANDBY_MODE: standby node. CASCADE_STANDBY_MODE: cascaded standby node. PENDING_MODE: The node is in the arbitration phase. RECOVERY_MODE: The node is in the restoration phase. STANDBY_CLUSTER_MODE: standby cluster node. MAIN_STANDBY_MODE: main standby cluster node. NOTE: The expected values of the standby node type are NORMAL_MODE, STANDBY_MODE, CASCADE_STANDBY_MODE, PENDING_MODE, RECOVERY_MODE, STANDBY_CLUSTER_MODE, and MAIN_STANDBY_MODE. If other node types are displayed, contact Huawei technical support.
peer_state	text	Status of the standby node. UNKNOWN_STATE: The node status is unknown. NORMAL_STATE: The node is started properly. NEEDREPAIR_STATE: The current node needs to be repaired. STARTING_STATE: The node is being started. WAITING_STATE: The node is waiting to be upgraded. DEMOTING_STATE: The node is being downgraded. PROMOTING_STATE: The standby node is being upgraded to the primary node. BUILDING_STATE: The standby node fails to be started and needs to be rebuilt. CATCHUP_STATE: The standby node is catching up with the primary node. COREDUMP_STATE: The node breaks down.
state	text	WAL sender status. WALSNDSTATE_STARTUP: startup state. WALSNDSTATE_BACKUP: backup state. WALSNDSTATE_CATCHUP: catch-up state. WALSNDSTATE_STREAMING: streaming replication state.
sender_sent_location	text	Sending position of the primary node.
sender_write_location	text	Writing position of the primary node.
sender_flush_location	text	Flushing position of the primary node.
sender_replay_location	text	Redo position of the primary node.
receiver_received_location	text	Receiving position of the standby node.
receiver_write_location	text	Writing position of the standby node.
receiver_flush_location	text	Flushing location of the standby node.
receiver_replay_location	text	Redo location of the standby node.