Note
This view is introduced since OceanBase Database V4.2.0.
Purpose
The GV$OB_ARBITRATION_MEMBER_INFO view displays information about arbitration members in the current tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| LS_ID | bigint(20) | NO | The ID of the log stream. |
| SVR_IP | varchar(46) | NO | The IP address of the arbitration server. |
| SVR_PORT | bigint(20) | NO | The port number of the arbitration server. |
| PROPOSAL_ID | bigint(20) | NO | The proposal ID of Paxos. |
| CONFIG_VERSION | varchar(128) | NO | The version number of the configuration. |
| ACCESS_MODE | varchar(32) | NO | The access mode. |
| PAXOS_MEMBER_LIST | varchar(1024) | NO | The list of Paxos members. |
| PAXOS_REPLICA_NUM | bigint(20) | NO | The quorum. |
| ARBITRATION_MEMBER | varchar(128) | NO | The arbitration member. |
| DEGRADED_LIST | varchar(1024) | NO | The list of degraded replicas. |
Sample query
View the arbitration member information of the current tenant.
obclient[oceanbase]> SELECT * FROM oceanbase.GV$OB_ARBITRATION_MEMBER_INFO;
The query result is as follows:
+-----------+-------+----------------+----------+-------------+-------------------------------+-------------+---------------------------------------------+-------------------+---------------------+---------------+
| TENANT_ID | LS_ID | SVR_IP | SVR_PORT | PROPOSAL_ID | CONFIG_VERSION | ACCESS_MODE | PAXOS_MEMBER_LIST | PAXOS_REPLICA_NUM | ARBITRATION_MEMBER | DEGRADED_LIST |
+-----------+-------+----------------+----------+-------------+-------------------------------+-------------+---------------------------------------------+-------------------+---------------------+---------------+
| 1002 | 1 | xxx.xx.xxx.224 | 2882 | 1 | {proposal_id:1, config_seq:2} | APPEND | xxx.xx.xxx.207:2882:1,xxx.xx.xxx.218:2882:1 | 2 | xxx.xx.xxx.224:2882 | |
| 1002 | 1001 | xxx.xx.xxx.224 | 2882 | 1 | {proposal_id:1, config_seq:2} | APPEND | xxx.xx.xxx.207:2882:1,xxx.xx.xxx.218:2882:1 | 2 | xxx.xx.xxx.224:2882 | |
+-----------+-------+----------------+----------+-------------+-------------------------------+-------------+---------------------------------------------+-------------------+---------------------+---------------+
2 rows in set
References
View the communication status between nodes of the current tenant and the arbitration service: GV$OB_ARBITRATION_SERVICE_STATUS
For more information about operations on the arbitration service, see the following topics: