Check the status after the upgrade

This topic describes how to check the status after you upgrade an OceanBase cluster.

Procedure

1. Log in to OceanBase Database.

   Here is an example:

   Connect to the sys tenant as the root user.

   obclient -h10.10.10.1 -P2881 -uroot@sys -p******
   

2. Query the views to obtain the information about the events related to the cluster upgrade.

   Here is an example:

   SELECT * FROM oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY WHERE MODULE='UPGRADE';
   

   The return 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 Overview of connection methods.
• For more information about the views that display important events at the cluster level, see oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY.