GaussDB-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.
| 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 |
更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…
