Note
This view is available starting with V4.2.0.
Purpose
This view displays the arbitration member information of the current tenant.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| LS_ID | bigint(20) | NO | The log stream ID. |
| 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 Paxos proposal ID. |
| CONFIG_VERSION | varchar(128) | NO | The version number of the configuration information. |
| ACCESS_MODE | varchar(32) | NO | The access mode. |
| PAXOS_MEMBER_LIST | varchar(1024) | NO | The member list. |
| PAXOS_REPLICA_NUM | bigint(20) | NO | The number of required replicas. |
| ARBITRATION_MEMBER | varchar(128) | NO | The arbitration member. |
| DEGRADED_LIST | varchar(1024) | NO | The list of degraded replicas. |
Sample query
Query 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
Query the communication status between the current tenant and the arbitration service on each node: GV$OB_ARBITRATION_SERVICE_STATUS
For more information about the arbitration service, see the following topics: