Upgrade complete confirmation

{question}

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

{question}

 

{answer}

 

You can check the RELEASE_VER in system.nodes, all processes should have the version that you upgraded to.

 

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 it means that you did not start a TE after "upgrade database <database_name> version <new_version#>;",

 

Database version check:

  • In Nuoagent,  database version checks syntax: (starting at NuoDB v3.4)
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)

 

  • In Nuoadmin,  database version checks syntax:
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

 

More information can be found here

{answer}

Have more questions? Submit a request

Comments