Note
This view is available starting with V4.0.0.
Purpose
The DBA_OB_ROOTSERVICE_EVENT_HISTORY view displays the event history of the Root Service.
By default, this view retains data for 7 days. To adjust the data retention period, you can configure the ob_event_history_recycle_interval parameter.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TIMESTAMP | timestamp(6) | NO | The time when the event occurred. |
| MODULE | varchar(64) | NO | The name of the module to which the event belongs. |
| EVENT | varchar(64) | NO | The name of the event. |
| NAME1 | varchar(256) | YES | The name of the first event attribute. |
| VALUE1 | varchar(256) | YES | The value of the first event attribute. |
| NAME2 | varchar(256) | YES | The name of the second event attribute. |
| VALUE2 | varchar(256) | YES | The value of the second event attribute. |
| NAME3 | varchar(256) | YES | The name of the third event attribute. |
| VALUE3 | varchar(256) | YES | The value of the third event attribute. |
| NAME4 | varchar(256) | YES | The name of the fourth event attribute. |
| VALUE4 | varchar(256) | YES | The value of the fourth event attribute. |
| NAME5 | varchar(256) | YES | The name of the fifth event attribute. |
| VALUE5 | varchar(256) | YES | The value of the fifth event attribute. |
| NAME6 | varchar(256) | YES | The name of the sixth event attribute. |
| VALUE6 | varchar(256) | YES | The value of the sixth event attribute. |
| EXTRA_INFO | varchar(512) | YES | Additional information. |
| RS_SVR_IP | varchar(46) | YES | The IP address of the Root Service server. |
| RS_SVR_PORT | bigint(20) | YES | The port number of the Root Service server. |
Sample query
Query the event history of the Root Service in the cluster as the sys tenant.
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