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.
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
Thanks, Victor.
[jaustin@jaustin ~]$ nxdbmgr background-upgrade
NetXMS Database Manager Version 3.3.285 Build 3.3-285-gfe2e9b646f (UNICODE)
No pending background upgrades