NetXMS 2.2.8 released

[alk]

Hello

NetXMS version 2.2.8 is out. Changes since previous release:

• Delayed actions in event processing policy
• Raw event data stored in event log
• New hook scripts: PostObjectCreate and DiscoveryPoll
• Implemented watchdog functionality for external subagents
• SNMP port and context can be specified in NXSL function CreateSNMPTransport
• Fixed Summary DCI table fail when row limit set
• Fixed menu path creation for Summary DCI Table and folder creation for graph view
• New command line options for Windows agent installer: /FORCECREATECONFIG, /LOGFILE=, /FILESTORE=, /CONFIGINCLUDEDIR=
• Server optimization for high load
• Fixed SQL errors during database import or migration
• New dashboard element "Port view"
• Fixed issues:
      NX-1377 (Can't upgrade sqlite database from version 21.4 to 21.5 with error "Unable to set not null constraint")
      NX-1435 (AgentTunnelListenPort configuration parameter is missing from config table)
      NX-1458 (DB upgrade from 0.454 to 0.455 failing for sqlite)
      NX-1459 (Online upgrade for 22.21 failed on sqlite)
      NX-1471 (Add option to create node in maintenance mode)
      NX-1472 (Physical Hyper-V Hosts are reporting as Node Type "Virtual" in 2.2.7)
      NX-1480 (Varbinds in SNMP Traps restricted to 255 characters)
      NX-1481 (Configuration option to disable topology based event correlation)
      NX-1482 (NetXMS server ignoring Syslog and Traps from devices in a Zone which are sending directly to NetXMS server)
      NX-1484 (Corrupted event messages if MySQL is used as backend database)
      NX-1488 ("Use active thresholds" checkbox gets checked after clicking on OK in map link properties)
      NX-1492 (Changes in object status not reflected on geo map)

[alk]

There is a known issue with upgrading utf8/16 database on older mysql (pre-5.7):

Upgrading from version 22.32 to 22.33
SQL query failed (Specified key was too long; max key length is 767 bytes):
CREATE TABLE policy_timer_cancellation_list (   rule_id integer not null,   timer_key varchar(255) not null,   PRIMARY KEY(rule_id,timer_key))
Rolling back last stage due to upgrade errors...
Database upgrade failed

We are working on that, but in a meantime you can perform this upgrade step manually:

CREATE TABLE policy_timer_cancellation_list(rule_id integer not null, timer_key varchar(191) not null, PRIMARY KEY(rule_id,timer_key));

UPDATE metadata SET var_value='33' WHERE var_name='SchemaVersionMinor';

After these changes, re-run "nxdbmgr upgrade" to finish upgrade.

[hayarm]

спасибо вам большое, все отлично работает

[Tursiops]

We're running an installation with ~250k DCIs and our experience with the new version so far:
Total SQL queries handled by the server per minute have doubled (as in "it can do more" as opposed to "more load on the server"), DCI writer queues have halved and are steady, large numbers of unused threads after a spike are closed significantly faster (minutes instead of days) reducing memory pressure.
Overall, this has been a massive boost to performance for our installation.

Thanks

[Spheron]

Hello @all,

i would like to update from 2.2.7 to 2.2.8. The database upgrade doesn't work. It throws the following error:

Upgrading database...
Upgrading from version 22.35 to 22.36
SQL query failed (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'row_number=0 WHERE row_number IS NULL' at line 1):
UPDATE dct_threshold_instances SET row_number=0 WHERE row_number IS NULL
Rolling back last stage due to upgrade errors...
Database upgrade failed

NetXMS is running on Windows 7 (64bit) and MySQL 8.0.12 (64-bit).

Any help will be welcome... Thanx.

Greetings
Marco

[alk]

MySQL8 now use "row_number" as a keyword.
We'll look into it.
Thank you for report.

@spheron said in NetXMS 2.2.8 released:

Hello @all,

i would like to update from 2.2.7 to 2.2.8. The database upgrade doesn't work. It throws the following error:

Upgrading database...
Upgrading from version 22.35 to 22.36
SQL query failed (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'row_number=0 WHERE row_number IS NULL' at line 1):
UPDATE dct_threshold_instances SET row_number=0 WHERE row_number IS NULL
Rolling back last stage due to upgrade errors...
Database upgrade failed

NetXMS is running on Windows 7 (64bit) and MySQL 8.0.12 (64-bit).

Any help will be welcome... Thanx.

Greetings
Marco

[pzandvoort]

https://netxms.org/download/releases/2.2/2.2.8/netxms-websvc-2.2.8.war doesn't seem to be available....

[alk]

@pzandvoort said in NetXMS 2.2.8 released:

https://netxms.org/download/releases/2.2/2.2.8/netxms-websvc-2.2.8.war doesn't seem to be available....

Fixed, thanks for the report