Check upgrade results

This topic describes how to check the status of an OceanBase cluster after it is upgraded.

Procedure

1. Log in to OceanBase Database.

   For example:

   Log in to the sys tenant of OceanBase Database as the root user.

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

2. Query the corresponding view for information about events related to cluster upgrades.

   For example:

   SELECT * FROM oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY WHERE MODULE='UPGRADE'\G
   

   The result is as follows:

   *************************** 1. row ***************************
   TIMESTAMP: 2024-05-22 14:42:37.876473
      MODULE: UPGRADE
      EVENT: BEGIN_UPGRADE
      NAME1: cluster_version
      VALUE1: 4.3.0.1
      NAME2: build_version
      VALUE2: 4.3.0.1_200000082024022210-d597f573c0f7fcdeefc74e78f6e66e9c0435a2bb(Feb 22 2024 11:01:15)
      NAME3:
      VALUE3:
      NAME4:
      VALUE4:
      NAME5:
      VALUE5:
      NAME6:
      VALUE6:
   EXTRA_INFO:
   *************************** 2. row ***************************
   TIMESTAMP: 2024-05-22 14:42:37.895952
      MODULE: UPGRADE
      EVENT: BEGIN_ROLLING_UPGRADE
      NAME1: cluster_version
      VALUE1: 4.3.0.1
      NAME2: build_version
      VALUE2: 4.3.0.1_200000082024022210-d597f573c0f7fcdeefc74e78f6e66e9c0435a2bb(Feb 22 2024 11:01:15)
      NAME3:
      VALUE3:
      NAME4:
      VALUE4:
      NAME5:
      VALUE5:
      NAME6:
      VALUE6:
   EXTRA_INFO:
   *************************** 3. row ***************************
   TIMESTAMP: 2024-05-22 14:52:47.609906
      MODULE: UPGRADE
      EVENT: END_ROLLING_UPGRADE
      NAME1: cluster_version
      VALUE1: 4.3.1.0
      NAME2: ori_cluster_version
      VALUE2: 4.3.0.1
      NAME3: build_version
      VALUE3: 4.3.1.0_100000172024050810-fa1385d2910f990a8bb646c53ac03e2529d1bab8(May  8 2024 10:41:26)
      NAME4:
      VALUE4:
      NAME5:
      VALUE5:
      NAME6:
      VALUE6:
   EXTRA_INFO:
   3 rows in set
   

References

• For more information about how to connect to OceanBase Database, see Overview of connection methods.

• For more information about the view that displays cluster-level important events, see oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY.