NetXMS Support Forum

Hello @all,

after Upgrading NetXMS and the NetXMS Webserver from 2.2.11 to 2.2.12 (Windows 7 64bit, MySQL 5.7.24 64bit) i get an error 46 if i call the Website of NetXMS. I'm using Firefox 65.0 (Win64) Version (please see Attachment).

The NetXMS Management Console works without any problems...

Have anyone else this error?

Greets
Marco

Maybe it has to do with this one (if you have installed V2.2.11):

https://www.netxms.org/forum/installation/update-from-2-2-10-to-2-2-11-log-flooding/
https://www.netxms.org/forum/installation/update-from-2-2-10-to-2-2-11-'nxdbmgr-check'-fails/

Greets
Marco

Hi Victor,

thanks for the fix. I replaced the libnetxms.dll with the provided and Dashboard+Perfomance Tabs works like before...  :-)

Many many thanks for searching for this bug...  :-)

Greetings
Marco

Hi Victor,

i installed NetXMS via the provided installer.  (Installed via command:  netxms-2.2.11-7-x64.exe /silent )

After that, log file shows the following:



^{2019.01.10 17:16:45.714 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_4437 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=0000000008D3DD40 local=0000000008D3DD40
2019.01.10 17:16:45.714 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_4437 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:16:45.751 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_6326 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=0000000008AFDE60 local=0000000008AFDE60
2019.01.10 17:16:45.751 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_6326 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:16:45.831 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_4902 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=00000000090ADD50 local=00000000090ADD50
2019.01.10 17:16:45.831 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_4902 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:16:45.928 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_4426 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=000000000885DD50 local=000000000885DD50
2019.01.10 17:16:45.928 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_4426 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:16:45.948 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_6328 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=000000000842DD80 local=000000000842DD80
2019.01.10 17:16:45.948 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_6328 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:16:46.035 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_6326 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=000000000871DE50 local=000000000871DE50
2019.01.10 17:16:46.035 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_6326 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:16:51.510 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_1561 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=0000000008D3DD40 local=0000000008D3DD40
2019.01.10 17:16:51.510 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_1561 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:16:51.510 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_1524 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=0000000008AFDE60 local=0000000008AFDE60
2019.01.10 17:16:51.511 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_1524 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:17:06.381 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_6326 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=0000000008D3DD40 local=0000000008D3DD40
2019.01.10 17:17:06.382 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_6326 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:17:06.384 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_4902 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=000000000885DD50 local=000000000885DD50
2019.01.10 17:17:06.384 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_4902 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:17:06.429 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_6326 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=000000000842DD80 local=000000000842DD80
2019.01.10 17:17:06.429 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_6326 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:17:06.484 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_6328 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=00000000094CDFD0 local=00000000094CDFD0}


...and so on...


Hope that helps...

Greets
Marco

From the full installer (with /silent switch)

This one:
https://www.netxms.org/download/releases/2.2/2.2.11/netxms-2.2.11-x64.exe

MD5 File Hash:

Downloaded File:
D57024956EE56EC9948B5723AD38B23F   C:\test\mysql.ddr

Original File in NetXMS bin Directory:
8E4B91633D8B231C7EA9AFA6429C3C31   C:\NetXMS\bin\mysql.ddr

Hi Victor,

with your mysql.ddr i can't start the NetXMS Core service. There are follwoing error message in log:


^{2019.01.10 11:12:51.043 *E* Unable to load database driver module "mysql.ddr": Die angegebene Prozedur wurde nicht gefunden.}


With the original mysql.ddr i can start the service..

Greets
Marco

The log flooding only happens when i have a dashboard or a perfomance tab open...

In the NetXMS server log is one more line:


_{2019.01.10 08:58:14.609 *E* SQL query failed (Query = "SELECT numbering_scheme,row_count,layout_data FROM port_layouts WHERE device_oid=?"): Query was empty}


Maybe this one might be help at searching for the root cause of this behaviour...

Greets
Marco

Hello Victor,

as i wrote, all my Dashbords and Performance Tabs shows randomly DCI Data Errors.  "Cannot get Value for DCI XXX (Database Failure)". Every Time i hit the refresh button the error messages shows in a different field. See attachment please.

Greets
Marco

PS: Thanx for the fast response...  :-)

Hello @all,

after Upgrade from 2.2.10 to 2.2.11 (Win7 64bit, MySQL 5.7.24) NetXMS Dashboard and Performance Tabs shows randomly "Cannot get Value for DCI XXX (Database Failure)"

If i take a look in de NetXMS Server Log, there are many many lines as the following:


^{2019.01.09 17:45:35.739 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_1561 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.09 17:45:36.633 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_1524 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.09 17:45:36.645 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_2405 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.09 17:45:37.419 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_1561 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.09 17:45:37.462 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_2405 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.09 17:45:38.134 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_1561 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty}


I have run "nxdbmgr check" bevor and after update, but there are no errors...

Should i go back to 2.2.10. ??  Any help is welcome...


Greets
Marco

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

Hello Victor,

thanks for fixing the vmware tools thing... :-)

Greetings
Marco

By the way:

with activated Vmware Tools service nextxms can't read the windows performance counters (if i poll netxms configuration from via netxms server):

[21.06.2018 09:50:32]    Reading list of available Windows Performance Counters...
[21.06.2018 09:50:36]    unable to get Windows Performance Counters list


If i stop the the vmware service, netxms CAN poll the windows performance counters:

[21.06.2018 09:51:13]    Reading list of available Windows Performance Counters...
[21.06.2018 09:51:18]    159 counters read


After starting Vmware Tools service netxms can further polling windows performance counters.

Maybe that help you further...


Greetings
Marco

Hello Victor,

think i found something. System must be a VMWare Windows VM (Server 2008R1/2016), VMWare tools installed. Steps to reproduce:

- NetXMS Agent is running and still the nxagentd.exe handle from svchost.exe exist
- Stopping VMWare Tools Service (Service "VMTools", V10.1.15)
- Waiting for couple of minutes (1-3)
- nxagentd.exe handle from svchost.exe is gone away

Now, i can update des NetXMS Agent via NetXMS Server or agent installer exe

I can this reproduce on all our Windows VM's (Server 2008R2/2016 64bit).

Physical machines seems not be affected. Here i can upgrade the agent without any problems (i looked at process explorer bevor update: there exist no nxagentd.exe handle from svchost.exe

Hope this helps and perhaps, you can find a workaround/fix for that...

Greetings
Marco

Hello @all,

unfortunately the above described behaviour is still present. I tried to update from Windows Agent 2.2.4 (64bit) to Windows Agent 2.2.6 (64bit) but i have no chance to update the agent. Error is the same as described above. I had to reboot all our 30x servers to install the NetXMS agent.

Has anyone more infos or workaround for this problem, please?

Greetings
Marco

----
Running NetXMS Server 2.2.6 64bit on Windows 7 / Agents are at V2.2.4