This topic describes how to check the status of an OceanBase cluster after it is upgraded.
Procedure
Log on to OceanBase Database.
Log on to the sys tenant of OceanBase Database as the
rootuser.obclient -h10.10.10.1 -P2881 -uroot@sys -p******Use the view to query information about the cluster upgrade event.
Here is an example:
SELECT * FROM oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY WHERE MODULE='UPGRADE';The result is as follows:
+----------------------------+---------+-------------+-----------------+---------+---------------+-------------------------------------------------------------------------------------------+---------------------+---------+----------------------+---------+-----------+--------+-------+--------+------------+ | TIMESTAMP | MODULE | EVENT | NAME1 | VALUE1 | NAME2 | VALUE2 | NAME3 | VALUE3 | NAME4 | VALUE4 | NAME5 | VALUE5 | NAME6 | VALUE6 | EXTRA_INFO | +----------------------------+---------+-------------+-----------------+---------+---------------+-------------------------------------------------------------------------------------------+---------------------+---------+----------------------+---------+-----------+--------+-------+--------+------------+ | 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 | | | | +----------------------------+---------+-------------+-----------------+---------+---------------+-------------------------------------------------------------------------------------------+---------------------+---------+----------------------+---------+-----------+--------+-------+--------+------------+ 1 row in set
References
- For more information about how to connect to OceanBase Database, see Connection methods.
- For more information about views that display important cluster-level events, see oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY.