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 | NUMBER(38) | NO | The ID of the tenant. |
| LS_ID | NUMBER(38) | NO | The ID of the log stream. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the arbitration server. |
| SVR_PORT | NUMBER(38) | NO | The port number of the arbitration server. |
| PROPOSAL_ID | NUMBER(38) | NO | The proposal ID of Paxos. |
| CONFIG_VERSION | VARCHAR2(128) | NO | The version number of the configuration. |
| ACCESS_MODE | VARCHAR2(32) | NO | The access mode. |
| PAXOS_MEMBER_LIST | VARCHAR2(1024) | NO | The list of Paxos members. |
| PAXOS_REPLICA_NUM | NUMBER(38) | NO | The quorum. |
| ARBITRATION_MEMBER | VARCHAR2(128) | NO | The arbitration member. |
| DEGRADED_LIST | VARCHAR2(1024) | NO | The list of degraded replicas. |
Sample query
Query the arbitration member information of the current tenant.
obclient[SYS]> SELECT * FROM SYS.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 |
+-----------+-------+----------------+----------+-------------+-------------------------------+-------------+---------------------------------------------+-------------------+---------------------+---------------+
| 1004 | 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 | NULL |
| 1004 | 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 | NULL |
+-----------+-------+----------------+----------+-------------+-------------------------------+-------------+---------------------------------------------+-------------------+---------------------+---------------+
2 rows in set
References
View the communication status between nodes and the arbitration service of the current tenant: GV$OB_ARBITRATION_SERVICE_STATUS
For more information about the arbitration service, see the following topics: