3.3 timescale upgrade procedure

[jermudgeon]

               
WARNING: Background upgrades pending. Please run nxdbmgr background-upgrade when possible.
[jaustin@jaustin systems]$ nxdbmgr background-upgrade                                   
NetXMS Database Manager Version 3.3.285 Build 3.3-285-gfe2e9b646f (UNICODE)
                                                                         
Running background upgrade procedure for version 33.6
Converting table idata_sc_default                   
Converting table idata_sc_7     
Converting table idata_sc_30                                                   
Converting table idata_sc_90                                             
Converting table idata_sc_180                                 
Converting table idata_sc_other                                                                                                                                           
WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corru
pted shared memory.                                                                     
HINT:  In a moment you should be able to reconnect to the database and repeat your command.

----

I restarted the background-upgrade process and got this:

RNING: Background upgrades pending. Please run nxdbmgr background-upgrade when possible.
[jaustin@jaustin systems]$ nxdbmgr background-upgrade
NetXMS Database Manager Version 3.3.285 Build 3.3-285-gfe2e9b646f (UNICODE)

Running background upgrade procedure for version 33.6
Converting table idata_sc_default
SQL query failed (42P01 ERROR:  relation "v33_5_idata_sc_default" does not exist
LINE 1: ...stamp(idata_timestamp),idata_value,raw_value FROM v33_5_idat...
                                                            ^):
INSERT INTO idata_sc_default (item_id,idata_timestamp,idata_value,raw_value) SELECT item_id,to_timestamp(idata_timestamp),idata_value,raw_value FROM v33_5_idata_sc_default
Background upgrade procedure for version 33.6 failed

----

So apparently the upgrade process can't handle a resume, as it breaks on the tables that have already been migrated. (It had already dropped successful tables.)

I manually completed the inserts from the remaining tables using ON CONFLICT DO NOTHING, and dropped the remaining v33_5 tables.

However, the same problem exists -- I can't complete the upgrade because the v33_5 tables no longer exist.

[victor]

Hi,

if you already migrated and dropped temporary tables you should clear pending background update indicator by executing query

UPDATE metadata SET var_value='' WHERE var_name='PendingOnlineUpgrades';

Best regards,
Victor

[jermudgeon]

Thanks, Victor.

[jaustin@jaustin ~]$ nxdbmgr background-upgrade
NetXMS Database Manager Version 3.3.285 Build 3.3-285-gfe2e9b646f (UNICODE)

No pending background upgrades