NetXMS Support Forum

Hi, a have problem after upgrade from 1.2.7 to 1.2.8 (Win x86 Server)

C:\Program Files\NetXMS\bin>nxdbmgr.exe check
NetXMS Database Manager Version 1.2.7

Checking database (excluding collected data):
* Checking zone objects...                                            [PASSED]
* Checking node objects...                                            [PASSED]
* Checking interface objects...                                       [PASSED]
* Checking network service objects...                                 [PASSED]
* Checking cluster objects...                                         [PASSED]
* Checking template to node mapping...                                [PASSED]
* Checking object properties...                                       [PASSED]
* Checking event processing policy...                                 [PASSED]
Database doesn't contain any errors
Database check completed

C:\Program Files\NetXMS\bin>nxdbmgr.exe upgrade
NetXMS Database Manager Version 1.2.8

Upgrading database...
Upgrading from version 279 to 280
SQL query failed (near "DROP": syntax error):
ALTER TABLE dc_tables DROP COLUMN instance_column
Rolling back last stage due to upgrade errors...
Database upgrade failed

C:\Program Files\NetXMS\bin>

Hi!

Yes, it's a bug in database upgrade procedure which is only happens on SQLite database. You an run nxdbmgr with -X option to force upgrade to continue, or wait for 1.2.9 release where this bug will be fixed.

Best regards,
Victor

Thank you very much, it helped.

Are there any risks if they missed a database upgrade from 279 to 280

Pavel


C:\NetXMS\bin>nxdbmgr.exe upgrade
NetXMS Database Manager Version 1.2.8

Upgrading database...
Upgrading from version 279 to 280
SQL query failed (near "DROP": syntax error):
ALTER TABLE dc_tables DROP COLUMN instance_column
Rolling back last stage due to upgrade errors...
Database upgrade failed

C:\NetXMS\bin>nxdbmgr.exe -X upgrade
NetXMS Database Manager Version 1.2.8

Upgrading database...
Upgrading from version 279 to 280
SQL query failed (near "DROP": syntax error):
ALTER TABLE dc_tables DROP COLUMN instance_column
Upgrading from version 280 to 281
Upgrading from version 281 to 282
Upgrading from version 282 to 283
Upgrading from version 283 to 284
Upgrading from version 284 to 285
Database upgrade succeeded

C:\NetXMS\bin>nxdbmgr.exe check
NetXMS Database Manager Version 1.2.8

Checking database (excluding collected data):
* Checking zone objects...                                            [PASSED]
* Checking node objects...                                            [PASSED]
* Checking interface objects...                                       [PASSED]
* Checking network service objects...                             [PASSED]
* Checking cluster objects...                                         [PASSED]
* Checking template to node mapping...                         [PASSED]
* Checking object properties...                                      [PASSED]
* Checking event processing policy...                             [PASSED]
Database doesn't contain any errors
Database check completed

C:\NetXMS\bin>

You will have unused column in table "dc_tables". It should not impact server operation besides tiny storage small space overhead.

Best regards,
Victor