Verifying the Rolling Upgrade

After you upgrade a host, you can follow the steps here to verify the upgrade.

During the rolling upgrade process, you may monitor version information in the SQL System Tables. In particular, the SYSTEM.NODES system table (see ) provides the platform version and release version that were used to start each database process. The following query result shows what the SYSTEM.NODES table might look like during the rolling upgrade process, before it is complete:

SQL> SELECT id,address,platform_ver,release_ver FROM system.nodes;

ID     ADDRESS     PLATFORM_VER      RELEASE_VER
--  -------------- ------------  -------------------

3   54.191.244.162    196610     2.3.3-15-e8afa1ae20
4   172.31.32.189     196610     2.3.3-15-e8afa1ae20
5   54.191.244.162    196610     2.3.3-15-e8afa1ae20
6   54.187.192.14     589824     2.6.0-05-82e1397e00
7   54.187.192.14     589824     2.6.0-05-82e1397e00

This shows that the database processes with node IDs 3,4, and 5 are still running NuoDB 2.3.3. At this time, a query of the system function, GETEFFECTIVEPLATFORMVERSION() returns the older platform version. It will continue to return the older platform version, until all running database processes were created with the newer release. For example:

SQL> SELECT geteffectiveplatformversion() FROM dual;
 ------
 196610

At the end of the rolling upgrade, the SYSTEM.NODES table shows that for all database processes, PLATFORM_VER is the latest platform version (in this case, 589824) and RELEASE_VER is the latest release version, (in this case, 2.6.0-05-82e1397e00). The GETEFFECTIVEPLATFORMVERSION() function should now return 589824.

SQL> SELECT id,address,platform_ver,release_ver FROM system.nodes;

 ID       ADDRESS    PLATFORM_VER      RELEASE_VER        
 ---  -------------- ------------- ------------------------- 

  3   54.191.244.162    589824     2.6.0-05-82e1397e00
  4   172.31.32.189     589824     2.6.0-05-82e1397e00
  5   54.191.244.162    589824     2.6.0-05-82e1397e00
  6   54.187.192.14     589824     2.6.0-05-82e1397e00 
  7   54.187.192.14     589824     2.6.0-05-82e1397e00 
 
SQL> SELECT geteffectiveplatformversion() FROM dual;
 ------ 
 589824