NetXMS Support Forum

Yes, it crashed.  I have started it once again, and will shut it down manually before it runs out of memory.


-Kevin C.

Testos,

Thanks for posting this script - it will be very helpful !


-Kevin C.

OK, the process terminated, and I have attached the latest log file.


-Kevin C.

OK, it did move beyond that point after some time.  I have attached the log as requested.


-Kevin C.

When I run this under valgrind, it seems to hang on "Loading nodes....." on the Linux console, and I am unable to launch the NetXMS GUI (connection refused).


Is this expected behavior at this point?

-Kevin C.

OK, will do, and then I will post the log when finished.


-Kevin C.

Greetings,

NetXMS has been crashing with an out of memory condition on our CentOS server:

CentOS 6.3
Out of memory: Kill process 1852 (netxmsd) score 934 or sacrifice child
Killed process 1852, UID 0, (netxmsd) total-vm:8698304kB, anon-rss:3652072kB, file-rss:424kB

This virtual CentOS server has 4GB of RAM currently allocated - and we have 50 subnets, maybe 20 nodes on average per subnet.  NetXMS and MySQL db are the only things running on it.  4GB should be enough RAM I would think?


-Kevin C.

Working !!  I just had to change the Network Discovery Configuration, and un-check the following:

Accept node if it has NetXMS agent.
Accept node if it has SNMP agent.

The ONLY option I have checked is:

Accept node if it is within given range or subnet.

So it seems that maybe it is working as designed after all 

OK, more information for you on this issue.

It seems that newly discovered subnets on our network will add nodes found on that subnet, but ONLY if they are reachable using SNMP (or a NetXMS agent as well, I would guess).

For Network Discovery filtering, I am using:

Accept node if it has NetXMS agent.
Accept node if it has SNMP agent.
Accept node if it is within given range or subnet.

Then in the Address Filters section I have IP address ranges for each of my subnets (basically .1 thru .100 of each network).

So there seems to be a bug?  I will change around some parameters in the Network Discovery settings to see if I can get desired results.


-Kevin C.

Excellent, thanks !  I will give this a try.


-Kevin C.

Greetings,

We have changed about 30 host names of devices on our network, but when I do a manual re-poll of a device configuration, I get this result:

[30.01.2013 12:44:05] **** Poll request sent to server ****
[30.01.2013 12:44:05] Poll request accepted
[30.01.2013 12:44:05] Starting configuration poll for node _GS-NewZotac
[30.01.2013 12:44:05] Checking node's capabilities...
[30.01.2013 12:44:05]    Checking NetXMS agent...
[30.01.2013 12:44:05]    Checking SNMP...
[30.01.2013 12:44:05]    SNMP agent is active (version 2c)
[30.01.2013 12:44:05]    System description changed to Hardware: x86 Family 6 Model 28 Stepping 10 AT/AT COMPATIBLE - Software: Windows 2000 Version 5.1 (Build 2600 Multiprocessor Free)
[30.01.2013 12:44:05]    System name changed to MP-EPV-FARMINGT
[30.01.2013 12:44:13] Capability check finished
[30.01.2013 12:44:13] Checking interface configuration...
[30.01.2013 12:44:14] Interface configuration check finished
[30.01.2013 12:44:14] Checking node name
[30.01.2013 12:44:14] Node name is OK
[30.01.2013 12:44:14] Finished configuration poll for node _GS-NewZotac
[30.01.2013 12:44:14] Node configuration was changed after poll
[30.01.2013 12:44:14] **** Poll completed successfully ****

The new name of this Windows XP machine is "MP-EPV-FARMINGT" (there is no DNS entry for it).  NetXMS detects the name change as seen above, but in the console it remains as the old name (in this instance, "_GS-NewZotac".

When can I expect to see the host name get updated in the console view?  Or can I expect to see the new name?


Thanks for the help,

Kevin C.

I think I know the cause of this, but I'd like to confirm it.

Is there a way that I can tell exactly how NetXMS is finding the routes to remote subnets on our network?

I suspect NetXMS is finding those specific 10 routes from a different network device, and for some reason related to that, it's not adding those 10 routers as new nodes, even though it adds other devices on those remote networks.


-Kevin C.

Hi Victor,

I ran the MySQL repair per your recommendation (I actually repaired the entire database), and also optimized the db - it did find errors that needed to be fixed.  Then I ran the repair again, no errors found.

I then manually deleted the 10 subnets where nodes were missing, then rebooted the server, and NetXMS has again discovered the 10 subnets and some nodes within those subnets - but the Cisco routers for those subnets are not being added as nodes.

Do you have any other thoughts on this?  Should I drop the database and start over?

I have no experience at all with PostgreSQL, so I would rather stick with MySQL unless you believe my problem may be related to using MySQL.


-Kevin C.

So maybe, it is time to DROP the database, and start out fresh?  Is there any way to save all of my discovery and email alert notification settings prior to dropping the DB?

Please don't send me back to SolarWinds !  :-)

An update to this issue:

I stopped the services, ran nxdbmgr check, and it seemed to resolve several errors.  I ran it again, and it showed everything OK.

I rebooted the server, started up the services, but now I am again seeing SQL errors in the log file:


[25-Jan-2013 12:19:58.519] SQL query failed (Query = "INSERT INTO idata_1474 (item_id,idata_timestamp,idata_value) VALUES (?,?,?)"): Table './netxms_db/idata_1474' is marked as crashed and should be repaired
[25-Jan-2013 12:19:58.519] SQL query failed (Query = "INSERT INTO idata_1476 (item_id,idata_timestamp,idata_value) VALUES (?,?,?)"): Table './netxms_db/idata_1476' is marked as crashed and should be repaired
[25-Jan-2013 12:19:58.519] SQL query failed (Query = "INSERT INTO idata_1478 (item_id,idata_timestamp,idata_value) VALUES (?,?,?)"): Table './netxms_db/idata_1478' is marked as crashed and should be repaired
[25-Jan-2013 12:19:58.519] SQL query failed (Query = "INSERT INTO idata_1480 (item_id,idata_timestamp,idata_value) VALUES (?,?,?)"): Table './netxms_db/idata_1480' is marked as crashed and should be repaired
[25-Jan-2013 12:20:57.492] SQL query failed (Query = "UPDATE raw_dci_values SET raw_value=?,transformed_value=?,last_poll_time=? WHERE item_id=?"): Table 'raw_dci_values' is marked as crashed and should be repaired
[25-Jan-2013 12:20:57.493] SQL query failed (Query = "UPDATE raw_dci_values SET raw_value=?,transformed_value=?,last_poll_time=? WHERE item_id=?"): Table 'raw_dci_values' is marked as crashed and should be repaired
[25-Jan-2013 12:20:58.528] SQL query failed (Query = "INSERT INTO idata_1163 (item_id,idata_timestamp,idata_value) VALUES (?,?,?)"): Table './netxms_db/idata_1163' is marked as crashed and should be repaired
[25-Jan-2013 12:20:58.528] SQL query failed (Query = "INSERT INTO idata_1167 (item_id,idata_timestamp,idata_value) VALUES (?,?,?)"): Table './netxms_db/idata_1167' is marked as crashed and should be repaired
[25-Jan-2013 12:20:58.528] SQL query failed (Query = "INSERT INTO idata_1169 (item_id,idata_timestamp,idata_value) VALUES (?,?,?)"): Table './netxms_db/idata_1169' is marked as crashed and should be repaired
[25-Jan-2013 12:20:58.529] SQL query failed (Query = "INSERT INTO idata_1171 (item_id,idata_timestamp,idata_value) VALUES (?,?,?)"): Table './netxms_db/idata_1171' is marked as crashed and should be repaired
[25-Jan-2013 12:20:58.529] SQL query failed (Query = "INSERT INTO idata_1173 (item_id,idata_timestamp,idata_value) VALUES (?,?,?)"): Table './netxms_db/idata_1173' is marked as crashed and should be repaired
[25-Jan-2013 12:20:58.530] SQL query failed (Query = "INSERT INTO idata_1175 (item_id,idata_timestamp,idata_value) VALUES (?,?,?)"): Table './netxms_db/idata_1175' is marked as crashed and should be repaired
[25-Jan-2013 12:20:58.530] SQL query failed (Query = "INSERT INTO idata_1178 (item_id,idata_timestamp,idata_value) VALUES (?,?,?)"): Table './netxms_db/idata_1178' is marked as crashed and should be repaired
[25-Jan-2013 12:20:58.531] SQL query failed (Query = "INSERT INTO idata_1180 (item_id,idata_timestamp,idata_value) VALUES (?,?,?)"): Table './netxms_db/idata_1180' is marked as crashed and should be repaired
[25-Jan-2013 12:20:58.531] SQL query failed (Query = "INSERT INTO idata_1184 (item_id,idata_timestamp,idata_value) VALUES (?,?,?)"): Table './netxms_db/idata_1184' is marked as crashed and should be repaired
[25-Jan-2013 12:20:58.531] SQL query failed (Query = "INSERT INTO idata_1188 (item


-Kevin C.