You are here

NDO not importing

3 posts / 0 new
Last post
mmcc0912
mmcc0912's picture
NDO not importing

Opsview Core 3.20130822.0

It's happened before and it's always been an easy fix.  There used to be in the /usr/local/nagios/bin two files.  First run the cleanup_import and then import_runtime with the -v option.  With the current version I'm on I don't see these anymore.  I'm looking around still but wanted to start a thread and see if there is any changes which are updates to these cleanup and import.  I'm not finding anything in the log files in /var/log/opsview or /usr/local/nagios/var/log so far that would point me to any direction of the problem.  It's been running for a year or more without an issue. 

mmcc0912
mmcc0912's picture
Here's where I've gotten.  I

Here's where I've gotten.  I've set debugging options in opsview and perl .conf files, but I'm not getting output.  Even the log files in the .conf files are not being created and creating them manually doesn't make a difference. 

Reading a post, the following query comes back with no data.  select conninfo_id, connect_time, timediff(disconnect_time,connect_time) as duration from nagios_conninfo where time_to_sec(timediff(disconnect_time,connect_time)) > 5 order by connect_time desc limit 10

What I noticed is when restarting, it's saying that import_ndologsd is not running.  Executing it as the nagios user or restarting the opsview services and the box itself it always tells me the same message.  Here are the running import processes:

nagios     367  0.1  0.4 164784 17448 ?        Ss   17:02   0:00 import_perfdatarrd
nagios     369  0.0  0.3 112296 13036 ?        Ss   17:02   0:00 import_ndoconfigend

Checked the processlist, looks good to me. 

mysql> show full processlist;
+-----+----------+--------------------+---------+---------+------+-------+-----------------------+
| Id  | User     | Host               | db      | Command | Time | State | Info                  |
+-----+----------+--------------------+---------+---------+------+-------+-----------------------+
| 170 | readonly | 10.10.10.208:63837 | runtime | Sleep   |  187 |       | NULL                  |
| 171 | readonly | 10.10.10.208:63838 | runtime | Sleep   |  187 |       | NULL                  |
| 201 | opsview  | localhost          | opsview | Sleep   |   30 |       | NULL                  |
| 207 | nagios   | localhost          | runtime | Sleep   |   31 |       | NULL                  |
| 208 | opsview  | localhost          | opsview | Sleep   |  165 |       | NULL                  |
| 221 | opsview  | localhost          | opsview | Sleep   |    0 |       | NULL                  |
| 222 | nagios   | localhost          | runtime | Sleep   |    0 |       | NULL                  |
| 231 | opsview  | localhost          | opsview | Sleep   |   75 |       | NULL                  |
| 239 | nagios   | localhost          | runtime | Sleep   |  230 |       | NULL                  |
| 243 | nagios   | localhost          | runtime | Sleep   |  230 |       | NULL                  |
| 261 | opsview  | localhost          | opsview | Sleep   |   15 |       | NULL                  |
| 265 | nagios   | localhost          | runtime | Sleep   |   15 |       | NULL                  |
| 266 | nagios   | localhost          | runtime | Sleep   |  230 |       | NULL                  |
| 268 | opsview  | localhost          | opsview | Sleep   |   45 |       | NULL                  |
| 269 | nagios   | localhost          | runtime | Sleep   |   45 |       | NULL                  |
| 270 | nagios   | localhost          | runtime | Sleep   |  230 |       | NULL                  |
| 271 | root     | localhost          | NULL    | Query   |    0 | NULL  | show full processlist |
| 275 | opsview  | localhost          | opsview | Sleep   |  151 |       | NULL                  |
| 276 | nagios   | localhost          | runtime | Sleep   |  152 |       | NULL                  |
| 277 | opsview  | localhost          | opsview | Sleep   |  225 |       | NULL                  |
| 280 | opsview  | localhost          | opsview | Sleep   |   45 |       | NULL                  |
| 282 | opsview  | localhost          | opsview | Sleep   |   15 |       | NULL                  |
+-----+----------+--------------------+---------+---------+------+-------+-----------------------+
22 rows in set (0.00 sec)

mysql>

Currently, I have some strace to go through.  For the running import processes and from trying to start the ndo process.  Anyone have any suggestions?

Thanks. 

mmcc0912
mmcc0912's picture
Fixed

But is anyone viewing. 

It generated a file too big to import.  Clearing the first file and starting it again, now it's importing. 

 

[root@server ndologs]# ls -ltr | head
total 1819484
-rw------- 1 nagios nagios 1182781 Nov 24 15:29 1416864566.018448
-rw------- 1 nagios nagios   10018 Nov 24 15:29 1416864571.079967
-rw------- 1 nagios nagios     366 Nov 24 15:29 1416864576.009355
-rw------- 1 nagios nagios    4013 Nov 24 15:29 1416864581.099716
-rw------- 1 nagios nagios     208 Nov 24 15:29 1416864586.013997
-rw------- 1 nagios nagios    9155 Nov 24 15:29 1416864591.100680
-rw------- 1 nagios nagios     366 Nov 24 15:29 1416864596.018108
-rw------- 1 nagios nagios   17803 Nov 24 15:30 1416864601.149259
-rw------- 1 nagios nagios     208 Nov 24 15:30 1416864606.024899
[root@ogismon01 ndologs]# rm 1416864566.018448
rm: remove regular file `1416864566.018448'? y
[root@server ndologs]#