Greetings,
The NetXMS service won't start for some reason on CentOS. I ran nxdbmgr check, and had to repair 2 MySQL tables, and also it fixed 17k + errors. Now nxdbmgr check is all good, no errors, but the NetXMS service will not start. The agent service does start.
Yes I know, I need to upgrade - but haven't had the time to do it yet.
-Kevin C.
So, I attempted the upgrade to v2.0.8. nxdbmgr check went fine, so I proceeded, although the db upgrade failed with 2 tables that needed a repair. I ran the repair on the 2 tables (one was ALARMS, the other was EVENT_LOG), now I'm getting this:
[root@netmgmt netxms-2.0.8]# nxdbmgr upgrade
NetXMS Database Manager Version 2.0.8 Build 8078 (2.0.8-RELEASE) (NON-UNICODE)
Upgrading database...
Upgrading from version 387 to 388
SQL query failed (Duplicate column name 'dci_id'):
ALTER TABLE alarms ADD dci_id integer
Rolling back last stage due to upgrade errors...
Database upgrade failed
[root@netmgmt netxms-2.0.8]#
This is a production system, and I need to get it back online. Thanks in advance for your quick response.
-Kevin C.
Major upgrades like this are always best tested on a lab system before upgrading production.
Of course now it is too late for that.
If you have an outage on a production system due to DB errors on upgrade - best to contact Raden for support directly.
Its the fastest way you will get this resolved.
I did a restore on the CentOS server, so I'm now back up and running again on 1.2.17. However, I would still like to upgrade. Is it best to upgrade in incremental steps, instead of going directly to 2.0.8? And if the nxdbmgr check is clear with no errors, shouldn't the database upgrade succeed?
I'm not sure how to contact Raden directly.
-Kevin C.
Hi,
nxdbmgr supposed to be able yto handle upgrades from any version to current. You can try to run upgrade again, just make sure you check and fix all issues with DB before starting upgrade. If you are interested in paid support from Raden Solutions, just send me private message.
Best regards,
Victor