NetXMS 2.0-RC2 released

Benjamin Dill

Hi Victor,

a really nice release with some great new features, works fine for now ;D

I have some wishes on the new rack-feature:

Drag and Drop on the rack would be nice to move the components around
I would like to have front and rear view for a rack
Rack-placement for clusters would be nice; for example I have some NetApp SANs which consists of two monitored heads, but are build in one enclosure
Popup on mouseover on the components, same as on network maps

Thanks for the new file upload feature, finally a can push my PowerShell scripts to the nodes.
Can you give some example how to use it?

Keep on the superb work, love your tool!

multix

Hi.
Thanks for new version.

I can't download management console for mac.

Dani@M3T

On the download page the Generic Linux static version for x64 is missing.

Dani@M3T

After update from V2.0RC1 to V2.0RC2 we get thousands of this errors in the nxagentd-log on the NetXMS server:

[17-Oct-2015 12:18:14.018] [ERROR] SQL query failed (Query = "INSERT INTO dc_queue (server_id,dci_id,dci_type,dci_origin,snmp_target_guid,timestamp,value) VALUES (?,?,?,?,?,?,?)"): UNIQUE constraint failed: dc_queue.server_id, dc_queue.dci_id, dc_queue.timestamp

So we also get thousands of false alarms (and emails) per minute.

Server is Linux x64 build from sources.

I have to stop the agent. Maybe revert to RC1. Or is there a quick fix?

best regards
Dani

Edit:
Once we get this error in server log:

[17-Oct-2015 12:32:03.639] [ERROR] SQL query failed (Query = "INSERT INTO alarm_events (alarm_id,event_id,event_code,event_name,severity,source_object_id,event_timestamp,message) VALUES (?,?,?,?,?,?,?,?)"): 23505 ERROR:  duplicate key value violates unique constraint "alarm_events_pkey"
DETAIL:  Key (alarm_id, event_id)=(9342, 5208076) already exists.

Victor Kirhenshtein

@user54119 said in NetXMS 2.0-RC2 released:

After update from V2.0RC1 to V2.0RC2 we get thousands of this errors in the nxagentd-log on the NetXMS server:
[17-Oct-2015 12:18:14.018] [ERROR] SQL query failed (Query = "INSERT INTO dc_queue (server_id,dci_id,dci_type,dci_origin,snmp_target_guid,timestamp,value) VALUES (?,?,?,?,?,?,?)"): UNIQUE constraint failed: dc_queue.server_id, dc_queue.dci_id, dc_queue.timestamp
So we also get thousands of false alarms (and emails) per minute.

Try to stop the agent, delete nxagent.db file (likely in /var/lib/netxms or <install prefix>/var/lib/netxms), and start agent again.

Best regards,
Victor

Victor Kirhenshtein

@user54119 said in NetXMS 2.0-RC2 released:

On the download page the Generic Linux static version for x64 is missing.

Fixed.

Best regards,
Victor

multix

@victor said in NetXMS 2.0-RC2 released:

@user54119 said in NetXMS 2.0-RC2 released:
After update from V2.0RC1 to V2.0RC2 we get thousands of this errors in the nxagentd-log on the NetXMS server:
[17-Oct-2015 12:18:14.018] [ERROR] SQL query failed (Query = "INSERT INTO dc_queue (server_id,dci_id,dci_type,dci_origin,snmp_target_guid,timestamp,value) VALUES (?,?,?,?,?,?,?)"): UNIQUE constraint failed: dc_queue.server_id, dc_queue.dci_id, dc_queue.timestamp
So we also get thousands of false alarms (and emails) per minute.
Try to stop the agent, delete nxagent.db file (likely in /var/lib/netxms or <install prefix>/var/lib/netxms), and start agent again.

Best regards,
Victor

I did as you say. And alarms gone for a short time. Then, there they are. I restarted my server and nxagent again, if it occurs again, I will inform.

Thanks.

After I restarted both server and agent, everything is ok.

Dani@M3T

Hi Victor

The download link is ok now, thanks for that.

After deleting the nxagent.db file and restart of server and agent, it's quite for a few seconds or minutes. After that the same goes on, 1000 of the same error messages in the agent log and 1000 up and down emails in a few minutes.
I have to stop the agent and server again. When I only stop the agent, the agent is autom. restarted after a while.

kind regards
Dani

multix

@user54119 said in NetXMS 2.0-RC2 released:

Hi Victor

The download link is ok now, thanks for that.

After deleting the nxagent.db file and restart of server and agent, it's quite for a few seconds or minutes. After that the same goes on, 1000 of the same error messages in the agent log and 1000 up and down emails in a few minutes.
I have to stop the agent and server again. When I only stop the agent, the agent is autom. restarted after a while.

kind regards
Dani

I have the same symptoms.
My error log is :
[ERROR] SQL query failed (Query = "INSERT INTO dc_queue (server_id,dci_id,dci_type,dci_origin,snmp_target_guid,timestamp,value) VALUES (?,?,?,?,?,?,?)"): UNIQUE constraint failed: dc_queue.server_id, dc_queue.dci_id, dc_queue.timestamp

yordi

could not find NetXMS 2.0-RC2 with apt-get update / upgrade ..

multix

I set agent debug level to 9.
I am using this agent for 4-5 sql query. My log looks as below :

DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.793] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.793] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.793] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.793] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.793] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.793] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.793] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.793] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.794] [DEBUG] GetTableValue(): result is 0 (SUCCESS)
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.794] [DEBUG] Requesting table "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.795] [DEBUG] GetTableValue(): result is 0 (SUCCESS)
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.796] [DEBUG] Requesting table "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.797] [DEBUG] Requesting table "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.797] [DEBUG] GetTableValue(): result is 0 (SUCCESS)
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.798] [DEBUG] GetTableValue(): result is 0 (SUCCESS)
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.799] [DEBUG] Requesting table "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"

This is the part that I could place here. It is not stopping writing this error.
Perhaps it can help.

Victor Kirhenshtein

Try to turn off data collection cache for that agent (node properties, "Polling" page, select cache mode "Off"). You'll me be needed to delete nxagent.db again after switching off cache. I'll try to reproduce this issue on my system.

Best regards,
Victor

Dani@M3T

Ok, I started the server, turned off the cache mode for the agent on the NetXMS server.
Than I deleted nxagent.db and started the agent. All the DCIs on other nodes where the NetXMS server is the source node (on these DCIs there is still cache enabled because of this thread: https://www.netxms.org/forum/general-support/best-practice-to-analyse-event-'sys_thread_hang') get no values.

So i rebooted the server once. After that I got again 500 false alerts.

I have to shutdown the server again.

edit:
I only disabled the agent on the server and started the server again (I had to disable my EPP rule which automaticaly restarts the agent when crashed)

thanks
Dani

Alex Kirhenshtein

Hello

Check now, it should be avaiable

@mkemerci said in NetXMS 2.0-RC2 released:

Hi.
Thanks for new version.

I can't download management console for mac.

Alex Kirhenshtein

Can you please share nxagent.db from affected system?

Dani@M3T

see attached file from the agent on the NetXMS server itself:

nxagentd.db

Alex Kirhenshtein

Thank you, we found the bug. Patch will be available shortly.

Victor Kirhenshtein

For those who build from sources - replace src/server/core/node.cpp with attached one and re-compile server. Problem should go away. Repacked sources and binaries will be available shortly as well.

Best regards,
Victor

node.cpp

Dani@M3T

I was out of office for a few hours.
But now I recompiled the server with your patched file. I also revert the agent on the NetXMS server itself back to cache mode = default. Then I rebooted the NetXMS server. The problem is here again. So I stopped the agent and deleted nxagentd.db again and started the agent again.
Now It's quite
Than I rebooted the server again for testing. At the moment I see the problem no more.
But to be sure I have to check again tomorrow.

Thanks Victor and Alex

Dani

Dani@M3T

I can confirm, problem is fixed with the patched 'node.cpp'.

thanks!
Dani

NetXMS Forum

NetXMS 2.0-RC2 released