{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}
Comments