Note
This view is available starting with V4.1.0.
Overview
Accessed only by the system tenant, the DBA_OB_CLUSTER_EVENT_HISTORY view displays important cluster-level events. Currently, it only supports displaying cluster upgrade-related events.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| TIMESTAMP | timestamp(6) | NO | Created At |
| MODULE | varchar(256) | NO | Module Name |
| EVENT | varchar(256) | NO | Event Name |
| NAME1 | varchar(256) | NO | Name of the first event attribute |
| VALUE1 | text | NO | Value of the first event attribute |
| NAME2 | varchar(256) | NO | Name of the Second Event Attribute |
| VALUE2 | text | NO | Value of the second event attribute |
| NAME3 | varchar(256) | NO | Name of the third event attribute |
| VALUE3 | text | NO | Value of the third event attribute |
| NAME4 | varchar(256) | NO | Name of the fourth event attribute |
| VALUE4 | text | NO | Value of the Fourth Event Attribute |
| NAME5 | varchar(256) | NO | The fifth event attribute name. |
| VALUE5 | text | NO | Value of the fifth event attribute |
| NAME6 | varchar(256) | NO | Name of the sixth event attribute |
| VALUE6 | text | NO | Value of the sixth event attribute |
| EXTRA_INFO | text | NO | More information |
Sample query
Query important events at the cluster level.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY;
The query result is as follows:
+----------------------------+-----------+-------------------+-----------------+---------+---------------+-------------------------------------------------------------------------------------------+---------------------+---------+----------------------+---------+-----------+--------+-------+--------+------------+
| TIMESTAMP | MODULE | EVENT | NAME1 | VALUE1 | NAME2 | VALUE2 | NAME3 | VALUE3 | NAME4 | VALUE4 | NAME5 | VALUE5 | NAME6 | VALUE6 | EXTRA_INFO |
+----------------------------+-----------+-------------------+-----------------+---------+---------------+-------------------------------------------------------------------------------------------+---------------------+---------+----------------------+---------+-----------+--------+-------+--------+------------+
| 2023-12-15 15:06:31.586618 | BOOTSTRAP | BOOTSTRAP_SUCCESS | cluster_version | 4.2.1.0 | | | | | | | | | | | |
| 2023-12-15 16:10:33.035367 | UPGRADE | UPGRADE_ALL | cluster_version | 4.2.1.0 | build_version | 4.2.2.0_100000012023120716-c33e61340b84acea88d8cfe868d2a75f7f3b042d(Dec 7 2023 16:30:05) | target_data_version | 4.2.2.0 | current_data_version | 4.2.1.0 | tenant_id | 1 | | | |
+----------------------------+-----------+-------------------+-----------------+---------+---------------+-------------------------------------------------------------------------------------------+---------------------+---------+----------------------+---------+-----------+--------+-------+--------+------------+
2 rows in set