Just upgraded to 2.2.1 and NetXMS Core wont start.

[Nick Boardman]

Server = 2012
DB = MySQL

I have run the nxdbmgr utility, and it initially found errors, but they were corrected and the NetXMS Core service will not start.  Any ideas?

Just checked the Event Viewer and there is an Event ID 7011 from the Service Control Manager: A timeout (30000 milliseconds) was reached while waiting for a transaction response from the NetXMSCore service.

Thanks,
Nick

[zev]

What does the server writes in log? Try to run server in console with debug and check what messages does it write?

[Nick Boardman]

D:\Program Files\NetXMS\bin>"D:\Program Files\NetXMS\bin\netxmsd.exe" --config "D:\Program Files\NetXMS\etc\netxmsd.conf" -d
StartServiceCtrlDispatcher() failed: The service process could not connect to the service controller.

[Nick Boardman]

OK.  Found the log file...

2018.01.03 10:35:42.502 Log file opened (rotation policy 2, max size 16777216)
2018.01.03 10:35:42.502 *I* Database driver "mysql.ddr" loaded and initialized successfully
2018.01.03 10:35:42.517 *I* Server ID 2B4559B000006E4C
2018.01.03 10:35:42.549 *I* Server certificate not set
2018.01.03 10:35:42.549 *E* SQL query failed (Query = "SELECT entry_key,value FROM persistent_storage"): Table 'netxms_db.persistent_storage' doesn't exist
2018.01.03 10:42:57.702 *I* NetXMS Server stopped
2018.01.03 10:43:22.283 *E* EXCEPTION 0xC0000005 (Access violation) at 0x68A4FB74 (crash dump was generated); please send files C:\\netxmsd-2912-1514994177.info and C:\\netxmsd-2912-1514994177.mdmp to [email protected]

[zev]

Looks like database was somehow corrupted.
What was the steps you made before it spoted working? (Upgrade to new version?) What errors were there and what commad you used to fix them?

[Nick Boardman]

I just sent a link to the 2 dump files.  One is 25 MB and too big to mail.

There were a couple of interfaces that were orphaned, and one or two other errors.  After telling the nxdbmgr check command to fix the errors, all of the checks have PASSED....

[Nick Boardman]

Sorry.  It was an upgrade to 2.2.1....

[zev]

From what version? It looks like some upgrade procedures were not executed or failed.

Try to execute next sql queries on NetXMS DB and run server again:
CREATE TABLE policy_pstorage_actions (
rule_id integer not null,
ps_key varchar(255) not null,
value varchar(2000) null,
action integer not null,
 PRIMARY KEY(rule_id,ps_key,action)

CREATE TABLE persistent_storage (
entry_key varchar(256) not null,
value varchar(2000) null,
PRIMARY KEY(entry_key))

Check that in server log there are no other sql errors.

[victor]

Hi,

from the dump it seems that server crashes on shutdown because it tries to deallocate resources that were not allocated. But it is not the reason to not starting, just a side effect - it is some error during initialization that cause server to abort initialization process. Could you run it with debug level set to 9 and post log file?

Best regards,
Victor