NetXMS Support Forum

Hi all!

NetXMS 2.0-RC2 is out. It is last RC before final 2.0 release. Changes since previous release are following:


- Maintenance mode for nodes, clusters, and mobile devices (manual and scheduled)
- Fixed broken instance discovery filters
- Fixed agent crash when collecting SNMP data in cached mode
- Agent returns correct OS version on Windows 10
- New NXSL "Node" class attribute: bridgeBaseAddress
- One LDAP attribute can be used in multiple mappings
- Fied deadlock on LDAP user deletion while LDAP synchronization
- Add option to use encrypted password in password fileds in configuration files and in the server configuration parameters.
- Added SMS driver for web service text2reach.com
- SNMP sysContact and sysLocation collected and stored
- Server can accept traps and syslog messages from nodes in all zones (controlled by TrapSourcesInAllZones configuration option)
- On instance discovery pool instance name is updated if it has changed
- New SMS driver - slack.com
- IPv6 support in built-in syslog server
- Fixed event processing policy export/import issues
- Global default retention time and polling interval for data collection
- Initial support for scheduled tasks within system
- Scheduled file upload
- Management console:
   - Object context menu available on geo map
   - Filter in event template configurator
   - Web console use client time zone to display time
   - Added option to use server time zone to display time in console
   - Access to event log, SNMP trap log, and syslog from object context menu
   - Dashboards can be associated with other objects (nodes, containers, etc.) and opened from object's context menu
   - Forced DCI polls from summary tables
   - Script hints
- Fixed issues: #786, #831, #841, #852, #864, #878, #883, #890, #891, #892, #896, #897, #898, #900, #902, #903, #905, #907, #910, #913, #917, #919, #921, #928, #933, #937, #943, #945, #947

Best regards,
Victor

Hi Victor,

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

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!

Hi.
Thanks for new version.

I can't download management console for mac.

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

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.


Quote from: Dani@M3T on October 17, 2015, 01:21:52 PM
After update from V2.0RC1 to V2.0RC2 we get thousands of this errors in the nxagentd-log on the NetXMS server:

Code Select Expand

[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

Quote from: Dani@M3T on October 17, 2015, 12:45:36 PM
On the download page the Generic Linux static version for x64 is missing.

Fixed.

Best regards,
Victor

Quote from: Victor Kirhenshtein on October 17, 2015, 06:55:58 PM

Quote from: Dani@M3T on October 17, 2015, 01:21:52 PM
After update from V2.0RC1 to V2.0RC2 we get thousands of this errors in the nxagentd-log on the NetXMS server:

Code Select Expand

[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.

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

Quote from: Dani@M3T on October 18, 2015, 07:05:20 PM
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

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

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.

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

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

Hello

Check now, it should be avaiable

Quote from: multix on October 17, 2015, 12:13:39 PM
Hi.
Thanks for new version.

I can't download management console for mac.