Print Page - NetXMS 2.0-RC2 released

Title: NetXMS 2.0-RC2 released
Post by: Victor Kirhenshtein on October 16, 2015, 06:29:24 PM

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

Title: Re: NetXMS 2.0-RC2 released
Post by: Benjamin Dill on October 16, 2015, 10:57:23 PM

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!

Title: Re: NetXMS 2.0-RC2 released
Post by: multix on October 17, 2015, 12:13:39 PM

Hi.
Thanks for new version.

I can't download management console for mac.

Title: Re: NetXMS 2.0-RC2 released
Post by: Dani@M3T on October 17, 2015, 12:45:36 PM

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

Title: Re: NetXMS 2.0-RC2 released
Post by: 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

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

Code Select

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

Title: Re: NetXMS 2.0-RC2 released
Post by: 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

Title: Re: NetXMS 2.0-RC2 released
Post by: Victor Kirhenshtein on October 17, 2015, 07:39:05 PM

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

Title: Re: NetXMS 2.0-RC2 released
Post by: multix on October 18, 2015, 02:47:16 AM

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.

Title: Re: NetXMS 2.0-RC2 released
Post by: 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

Title: Re: NetXMS 2.0-RC2 released
Post by: multix on October 18, 2015, 08:35:50 PM

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

Title: Re: NetXMS 2.0-RC2 released
Post by: yordi on October 18, 2015, 08:41:41 PM

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

Title: Re: NetXMS 2.0-RC2 released
Post by: multix on October 18, 2015, 08:56:36 PM

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

Code Select

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.

Title: Re: NetXMS 2.0-RC2 released
Post by: Victor Kirhenshtein on October 19, 2015, 11:19:13 AM

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

Title: Re: NetXMS 2.0-RC2 released
Post by: Dani@M3T on October 19, 2015, 11:46:38 AM

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

Title: Re: NetXMS 2.0-RC2 released
Post by: Alex Kirhenshtein on October 19, 2015, 01:59:20 PM

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.

Title: Re: NetXMS 2.0-RC2 released
Post by: Alex Kirhenshtein on October 19, 2015, 02:01:16 PM

Can you please share nxagent.db from affected system?

Title: Re: NetXMS 2.0-RC2 released
Post by: Dani@M3T on October 19, 2015, 02:11:23 PM

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

Title: Re: NetXMS 2.0-RC2 released
Post by: Alex Kirhenshtein on October 19, 2015, 02:49:25 PM

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

Title: Re: NetXMS 2.0-RC2 released
Post by: Victor Kirhenshtein on October 19, 2015, 03:04:31 PM

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

Title: Re: NetXMS 2.0-RC2 released
Post by: Dani@M3T on October 19, 2015, 07:16:54 PM

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

Title: Re: NetXMS 2.0-RC2 released
Post by: Dani@M3T on October 20, 2015, 02:00:54 PM

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

thanks!
Dani

Title: Re: NetXMS 2.0-RC2 released
Post by: iGodunoff on October 21, 2015, 11:49:00 AM

Just installed NetXMS 2.0 RC2 (previous version was 2.0-M5 that worked fine). The installation process goes and finishes normally. However I can't start the NetXMS Core service. In Windows logs (System) I receive the following error message from NetXMSCore: "Your database has format version 356, but server is compiled for version 374". What does it mean and how can I get NetXMS server working?

P. S. Database server is MySQL 5.6.27 (GPL).

Title: Re: NetXMS 2.0-RC2 released
Post by: Andreas@rc on October 21, 2015, 02:14:29 PM

Quote from: iGodunoff on October 21, 2015, 11:49:00 AM
Just installed NetXMS 2.0 RC2 (previous version was 2.0-M5 that worked fine). The installation process goes and finishes normally. However I can't start the NetXMS Core service. In Windows logs (System) I receive the following error message from NetXMSCore: "Your database has format version 356, but server is compiled for version 374". What does it mean and how can I get NetXMS server working?

P. S. Database server is MySQL 5.6.27 (GPL).

Simply upgrade your database: https://wiki.netxms.org/wiki/Server_Installation_Guide (https://wiki.netxms.org/wiki/Server_Installation_Guide)

Title: Re: NetXMS 2.0-RC2 released
Post by: iGodunoff on October 21, 2015, 03:29:59 PM

OK, thank you! NetXMS 2.0-RC2 installer upgrades the database automatically after the installation itself has finished. However my database contained some errors and of course was not upgraded. All works fine after the database repairing.

Title: Re: NetXMS 2.0-RC2 released
Post by: Toepfe on November 02, 2015, 12:26:37 PM

Hi Victor,

Big thanks for the new release! Great that you realised a maintenance mode implementation. I played a little bit around with it and it seems that I found a bug:

If I edit a future scheduled task (change hour), the Schedule Type (Maintenance:Enter) get a strange name and after a while I get the message "'Delete scheduled task' has encountered a problem. Cannot update scheduled tasks: Connection reset by peer: socket write error" (See also screenshots). In my case, this is reproduceable.

This problem does not ocour if the scheduled task is configured as cron schedule. But there is a small cosmetic issue. When entering the edit mode both "schedule marks" are active ("One time execution" / "Cron schedule").

It would be nice if it would be possible to mark a group or more than one nodes (as if in the Package Manager when distributing new versions of nxagent) when configuring a scheduled task.

Bye
Heimo ;)

Title: Re: NetXMS 2.0-RC2 released
Post by: slako on December 25, 2015, 08:19:13 AM

missed kannel.sms driver on Windows installation. Checked fresh install on windows7 and windows 2003
No such file in bin directory

upd: dummy.sms is absent too

upd2: Can anyone attach missed files here?

Title: Re: NetXMS 2.0-RC2 released
Post by: Victor Kirhenshtein on December 30, 2015, 11:24:09 PM

Hi,

we've included kannel.sms into new release (2.0). Do you still need 2.0-RC2 version?

Best regards,
Victor

Title: Re: NetXMS 2.0-RC2 released
Post by: slako on December 31, 2015, 10:20:46 AM

No, thank you! Happy New Year!

NetXMS Support Forum

General => Announcements => Topic started by: Victor Kirhenshtein on October 16, 2015, 06:29:24 PM