Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
The oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY view displays the RootService event history.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TIMESTAMP | timestamp(6) | NO | The time when the event occurred. |
| MODULE | varchar(64) | NO | The name of the module where the event belongs. |
| EVENT | varchar(64) | NO | The name of the event. |
| NAME1 | varchar(256) | YES | The name of the first attribute of the event. |
| VALUE1 | varchar(256) | YES | The value of the first attribute of the event. |
| NAME2 | varchar(256) | YES | The name of the second attribute of the event. |
| VALUE2 | varchar(256) | YES | The value of the second attribute of the event. |
| NAME3 | varchar(256) | YES | The name of the third attribute of the event. |
| VALUE3 | varchar(256) | YES | The value of the third attribute of the event. |
| NAME4 | varchar(256) | YES | The name of the fourth attribute of the event. |
| VALUE4 | varchar(256) | YES | The value of the fourth attribute of the event. |
| NAME5 | varchar(256) | YES | The name of the fifth attribute of the event. |
| VALUE5 | varchar(256) | YES | The value of the fifth attribute of the event. |
| NAME6 | varchar(256) | YES | The name of the sixth attribute of the event. |
| VALUE6 | varchar(256) | YES | The value of the sixth attribute of the event. |
| EXTRA_INFO | varchar(512) | YES | The additional information. |
| RS_SVR_IP | varchar(46) | YES | The IP address of the RootService server. |
| RS_SVR_PORT | bigint(20) | YES | The port number of the RootService server. |
Sample query
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 (0.045 sec)
