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 columns
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 type. PRIMARY_MODE: The node is a primary node. STANDBY_MODE: The node is a standby node. CASCADE_STANDBY_MODE: The node is a cascaded standby node. PENDING_MODE: The node is in the arbitration phase. RECOVERY_MODE: The node is in the restoration phase. STANDBY_CLUSTER_MODE: The node is a 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 type. PRIMARY_MODE: The node is a primary node. STANDBY_MODE: The node is a standby node. CASCADE_STANDBY_MODE: The node is a cascaded standby node. PENDING_MODE: The node is in the arbitration phase. RECOVERY_MODE: The node is in the restoration phase. STANDBY_CLUSTER_MODE: The node is a 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	Location where the master node writes the cache to the disk.
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	Location where the standby node writes the cache to the disk.
receiver_replay_location	text	Redo location of the standby node