NetXMS Support Forum

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

I asked because I still had the same problems with the agent update from V2.2.3 to V2.2.4 that I had described here

https://www.netxms.org/forum/installation/install-agent-2-2-1-fails/


Maybe i had same Problem at Agent Update as the user who has opened this Thread:

https://www.netxms.org/forum/installation/upgrading-agents/


Greets
Marco