Upgrade to 6.0.2 - Database upgrade fails

[dreamscape]

Hi all,

Just updating from 6.0.1 to 6.0.2, get the error below?

Any ideas please

C:\NetXMS\bin>nxdbmgr.exe check
NetXMS Database Manager Version 6.0.2 Build 6.0-504-g549db2d3a0

Checking database (excluding collected data):
Your database has format version 60.33, this tool is compiled for version 60.34.
Use "upgrade" command to upgrade your database first.
Database check aborted

C:\NetXMS\bin>nxdbmgr.exe upgrade
NetXMS Database Manager Version 6.0.2 Build 6.0-504-g549db2d3a0

Upgrading database...
Upgrading from version 60.33 to 60.34
Rolling back last stage due to upgrade errors...
Database upgrade failed

[dreamscape]

Bit more info

C:\NetXMS\bin>nxdbmgr -t upgrade
NetXMS Database Manager Version 6.0.2 Build 6.0-504-g549db2d3a0

Upgrading database...
Upgrading from version 60.33 to 60.34
Rolling back last stage due to upgrade errors...
Database upgrade failed
>>> SELECT var_value FROM metadata WHERE var_name='PendingOnlineUpgrades'

C:\NetXMS\bin>

[dreamscape]

Anyone have any ideas please?

I also do not have a 'PendingOnlineUpgrades' in my metadata table, see below.

---

[Filipp Sudanov]

This issue was fixed, fix will be available in next patch release.

If you do not want to wait for it, you can run these queries to the database:

ALTER TABLE userdb_custom_attributes ALTER COLUMN attr_value varchar(max) NULL;
UPDATE metadata SET var_value='34' WHERE var_name='SchemaVersionMinor';

and nxdbmgr upgrade again after that

[dreamscape]

Great, thanks for the reply and for fixing  it.

I get this after running the sql

C:\NetXMS\bin>nxdbmgr upgrade
NetXMS Database Manager Version 6.0.2 Build 6.0-504-g549db2d3a0

Upgrading database...
Core database schema is up to date
Database upgrade succeeded

[johnnyva]

When do you expect the next patch release to be available for this fix?

[victor]

Just published 6.0.3 - it should have the fix.