Update from 2.2.10 to 2.2.11 - "nxdbmgr check" fails

Started by rauchi, January 14, 2019, 09:57:22 AM

Previous topic - Next topic

rauchi

Hello @all

Before and after running the update from 2.2.10 to 2.2.11 on my Windows Server I usually run a "nxdbmgr check" to verify if the DB is in a good shape.

After Updating to version 2.2.11 I get the following output:

---------------

nxdbmgr check
NetXMS Database Manager Version 2.2.11 Build 9516 (2.2.11) (UNICODE)

Checking database (excluding collected data):
* Zone object properties                                               [PASSED]
* Node object properties                                               [PASSED]
* Node to subnet bindings                                             [PASSED]
* Interface object properties                                         [PASSED]
* Interface bindings                                                     [PASSED]
* Network service object properties                                [PASSED]
* Network service bindings                                            [PASSED]
* Cluster object properties                                            [PASSED]
* Cluster member nodes                                                [PASSED]
* Template to node mapping                                          [PASSED]
* Object properties                                                      [PASSED]
* Container membership                                                [PASSED]
* Event processing policy                                              [PASSED]
* Network map links                                                     [   0SQL
query failed (Query was empty):
SELECT network_map_links.map_id,network_map_links.element1,network_map_links.ele
ment2 FROM network_map_links LEFT OUTER JOIN network_map_elements ON    network_
map_links.map_id = network_map_elements.map_id AND    network_map_links.element1
= network_map_elements.element_id WHERE network_map_elements.element_id IS NULL

SQL query failed (Query was empty):
SELECT network_map_links.map_id,network_map_links.element1,network_map_links.ele
ment2 FROM network_map_links LEFT OUTER JOIN network_map_elements ON    network_
map_links.map_id = network_map_elements.map_id AND    network_map_links.element2
= network_map_elements.element_id WHERE network_map_elements.element_id IS NULL

[PASSED]
* Data tables                                                          [PASSED]
* Raw DCI values table                                             [PASSED]
* DCI thresholds                                                      [PASSED]
* Table DCI thresholds                                              [PASSED]
Database doesn't contain any errors
Database check completed

---------------

Any Idea? Some help is greatly appreciated.

regards
Marco


Alex Kirhenshtein

Hello.

That's known issue (it's windows specific). As a workaround, please download and replace libnetxms.dll from this topic https://www.netxms.org/forum/installation/update-from-2-2-10-to-2-2-11-log-flooding/.
New release will be available shortly as well.

rauchi

#2
Hello Alex

Thank you for your fast response and your help.

I just replaced the "libnetxms.dll" on the NetXMS Server with the one provided in the referenced link.

After the replacement I tried first to run "nxdbmgr check" again. With the replaced .dll I get now this error:

"The procedure entry point nx_memdup could not be located in the dynamic link library C:\NetXMS\bin\libnxdb.dll."

I have added the error as attachment (Libnxdb-dll-error.jpg) for reverence.

After switching back to the previous "libnetxms.dll" I can also start the "NetXMS Core" Service again.

Please let me know if you need some more information.

best regards
Marco

Victor Kirhenshtein

Hi,

there are some incompatibilities in dlls. We will publish release 2.2.12 with a fix tomorrow.

Best regards,
Victor

rauchi

Hi,

Great news. Thank you very much for your support.

best regards
Marco

rauchi

Hi,

Problems are gone with the new release 2.2.12.

Thank you  :D

best regards
Marco