Note
This view is available starting with V4.0.0.
Overview
The DBA_OB_ROOTSERVICE_EVENT_HISTORY view displays the event history of Root Service.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| TIMESTAMP | timestamp(6) | NO | Event Time |
| MODULE | varchar(64) | NO | Module name to which the event belongs |
| EVENT | varchar(64) | NO | Event Name |
| NAME1 | varchar(256) | YES | Name of the first event attribute |
| VALUE1 | varchar(256) | YES | Value of the first event attribute |
| NAME2 | varchar(256) | YES | Name of the Second Event Attribute |
| VALUE2 | varchar(256) | YES | Value of the second event attribute |
| NAME3 | varchar(256) | YES | Name of the third event attribute |
| VALUE3 | varchar(256) | YES | Value of the third event attribute |
| NAME4 | varchar(256) | YES | Name of the fourth event attribute |
| VALUE4 | varchar(256) | YES | Value of the Fourth Event Attribute |
| NAME5 | varchar(256) | YES | The fifth event attribute name. |
| VALUE5 | varchar(256) | YES | Value of the fifth event attribute |
| NAME6 | varchar(256) | YES | Name of the sixth event attribute |
| VALUE6 | varchar(256) | YES | Value of the sixth event attribute |
| EXTRA_INFO | varchar(512) | YES | Additional information |
| RS_SVR_IP | varchar(46) | YES | Root Service Server IP Address |
| RS_SVR_PORT | bigint(20) | YES | Root Service Server Port Number |
Sample query
The system tenant views the event history of the Root Service in the cluster.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY limit 2;
The query result is as follows:
+----------------------------+--------+----------------------+---------+----------+--------+------------------------+-----------+-----------+-------+--------+-------+--------+-------+--------+------------+----------------+-------------+
| TIMESTAMP | MODULE | EVENT | NAME1 | VALUE1 | NAME2 | VALUE2 | NAME3 | VALUE3 | NAME4 | VALUE4 | NAME5 | VALUE5 | NAME6 | VALUE6 | EXTRA_INFO | RS_SVR_IP | RS_SVR_PORT |
+----------------------------+--------+----------------------+---------+----------+--------+------------------------+-----------+-----------+-------+--------+-------+--------+-------+--------+------------+----------------+-------------+
| 2024-01-05 14:33:07.488316 | unit | create_resource_pool | name | sys_pool | unit | sys_unit_config | zone_list | ["zone1"] | | | | | | | | xx.xx.xx.xx | 28824 |
| 2024-01-05 14:33:07.490910 | unit | create_unit | unit_id | 1 | server | "xx.xx.xx.xx:28824" | | | | | | | | | | xx.xx.xx.xx | 28824 |
+----------------------------+--------+----------------------+---------+----------+--------+------------------------+-----------+-----------+-------+--------+-------+--------+-------+--------+------------+----------------+-------------+
2 rows in set