Greetings,
I have a situation where discovery has been working fine, on my first 40 subnets. I have been adding subnets 10 at a time to the discovery configuration.
On the last 10 subnets I added, discovery actually discovered some devices within the remote subnets, however, the routers themselves for those subnets, and also some other devices within the remote subnets were NOT discovered (or at least, not displayed).
I am using version 1.2.3. Any help is appreciated!
-Kevin C.
I have upgraded to 1.2.5, and this issue persists.
I even removed the subnets and let it re-discover, which it did, but again the routers themselves for those last 10 subnets are not being discovered. However, some printers and managed switch devices on each of those subnets are being discovered.
I could manually add the routers, but - any ideas on what to check, or what would cause this?
-Kevin C.
could you run server with debug level 5 for some time and send me the log? Preferrably with screenshot of network discovery configuration?
Best regards,
Victor
As requested, I have attached the log file. I wasn't able to attach the screen shot of the discovery settings (my attachment was over 1MB in size, your message board declined to accept it). I will see if I can create a smaller image file, and then post it if possible.
In looking at the log entries, I do seem to have some database corruption...
Thanks for your help!
-Kevin C.
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.
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 ! :-)
Hi!
Looks like MySQL issue. You should try to run REPAIR TABLE on all reported tables: http://dev.mysql.com/doc/refman/5.0/en/repair-table.html (http://dev.mysql.com/doc/refman/5.0/en/repair-table.html). Probably there also should be a tool to repair all of them.
If you decide to re-create database, you can try to do export and then import into empty database with nxdbmgr export and import commands. I also suggest to try out PostgreSQL as backend database.
Best regards,
Victor
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.
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.
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.
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 :)