{question}

How do I confirm that an upgrade process has completed successfully?

{question}

{answer}

 Check the following query: YES for upgrade completed:

SQL> select case when version = GETEFFECTIVEPLATFORMVERSION() then 'YES' else 'NO' end as TE_RESTARTED_AFTER_UPGRADE from system.versions where property = 'SYSTEM_TABLES_VERSION';
TE_RESTARTED_AFTER_UPGRADE
--------------------------               
YES

You can check the RELEASE_VER in system.nodes to confirm that all processes should have the correct upgraded version number. 

SQL> select ID,STATE,TYPE,PLATFORM_VER,RELEASE_VER from system.nodes;

ID STATE    TYPE           PLATFORM_VER RELEASE_VER
 --- ------- ----------- ------------- ------------------

5 Running Storage        1048576       3.2.4-2-53c4ee9f3b
6 Running Storage        1048576       3.2.4-2-53c4ee9f3b
3 Running Transaction    1048576       3.2.4-2-53c4ee9f3b
4 Running Transaction    1048576       3.2.4-2-53c4ee9f3b

Compare the following value to the PLATFORM_VER that you got for each process in system.nodes.

SQL> SELECT geteffectiveplatformversion() FROM DUAL;

GETEFFECTIVEPLATFORMVERSION
 ----------------------------

1048576

You should also see this value 1048576 updated in several properties values when you run the following query: 

SQL> SELECT * from system.versions;

If you don't see it, it means that you did not start a TE after "upgrade database <database_name> version <new_version#>;".

Database version confirmation with nuoadmin:

nuocmd show database-versions --db-name <dbname>

In case you performed a partial upgrade, the output will show as the following:

nuocmd show database-versions --db-name test 
effective version ID: 1245184, effective version: 3.4, max version ID: 1245184 
Available versions: 
Process versions: 
version ID: 1245184, version: 3.4, release: 3.4.3-1-9e6ec78560 
 [SM] sm1/192.168.16.4:48006 [start_id = 0] [server_id = nuoadmin0] [pid = 41] [node_id = 1] [last_ack = 1.19] MONITORED:RUNNING 
 [SM] sm2/192.168.16.5:48006 [start_id = 1] [server_id = nuoadmin1] [pid = 38] [node_id = 2] [last_ack = 1.18] MONITORED:RUNNING 
 [TE] te2/192.168.16.8:48006 [start_id = 3] [server_id = nuoadmin1] [pid = 38] [node_id = 4] [last_ack = 1.19] MONITORED:RUNNING 
version ID: 1310720, version: 4.0, release: 4.0-1-2f01499300 
 [TE] te1/192.168.16.6:48006 [start_id = 4] [server_id = nuoadmin0] [pid = 40] [node_id = 5] [last_ack = 2.09] MONITORED:RUNNING

Database version confirmation with nuoagent:

show database version database DBNAME details true

Example:

nuodb [domain/test_nuodb] > show database version database test_nuodb details true
Database Version: 4.0
Available Upgrade Versions: None
Node Versions:
84c269360f56:48005 [ nodeId = 1 ] Release 4.0-1-b947d0fa06 (Version 4.0)
127.0.0.1:48006 [ nodeId = 2 ] Release 4.0-1-b947d0fa06 (Version 4.0)

{answer}