GLOBAL_WAL_SENDER_STATUS

GLOBAL_WAL_SENDER_STATUS displays the redo log transfer and replay status of the primary DN in the current cluster. Only the user with the SYSADMIN or MONADMIN permission can query this view.

**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. Contact Huawei technical support if other node types are displayed.
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