Page 1 of 1
Host and service status show 0
Posted: Mon Mar 14, 2016 9:10 am
by amit.ahuja
sometimes when i log in to nagiosxi, host and service status are showing 0. I don't see any host or service detail. Looks like they're all gone but services are still checking, alerts still sending out. I have to do repair_database to get all my hosts and services back in nagiosxi console. Do you know why this is happening sometimes?
Re: Host and service status show 0
Posted: Mon Mar 14, 2016 9:49 am
by bwallace
What version of XI are you running?
To confirm, when repairing the db, did you follow the steps in this doc?
http://assets.nagios.com/downloads/nagi ... tabase.pdf
+ check /var/log/httpd/error_log for errors, specifically for "segmentation fault" - feel free to post this log here if in any doubt, thanks.
Re: Host and service status show 0
Posted: Mon Mar 14, 2016 10:45 am
by amit.ahuja
version 5.2.0
i'm using repair_databases.sh instead of repairmysql.sh
Re: Host and service status show 0
Posted: Mon Mar 14, 2016 12:26 pm
by rkennedy
You may be hitting a throttle with resources. What is the result of top|head -19?
Re: Host and service status show 0
Posted: Mon Mar 14, 2016 1:28 pm
by amit.ahuja
top - 14:27:10 up 2 days, 15:56, 1 user, load average: 0.06, 0.13, 0.14
Tasks: 226 total, 1 running, 225 sleeping, 0 stopped, 0 zombie
Cpu(s): 4.5%us, 1.0%sy, 0.0%ni, 93.3%id, 1.1%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 32876492k total, 5629524k used, 27246968k free, 613020k buffers
Swap: 8388604k total, 0k used, 8388604k free, 3219780k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
20446 nagios 20 0 51236 2880 1040 S 2.0 0.0 23:22.76 ndo2db
1 root 20 0 19360 1580 1268 S 0.0 0.0 0:01.99 init
2 root 20 0 0 0 0 S 0.0 0.0 0:00.01 kthreadd
3 root RT 0 0 0 0 S 0.0 0.0 0:07.32 migration/0
4 root 20 0 0 0 0 S 0.0 0.0 0:00.83 ksoftirqd/0
5 root RT 0 0 0 0 S 0.0 0.0 0:00.00 stopper/0
6 root RT 0 0 0 0 S 0.0 0.0 0:00.13 watchdog/0
7 root RT 0 0 0 0 S 0.0 0.0 0:07.68 migration/1
8 root RT 0 0 0 0 S 0.0 0.0 0:00.00 stopper/1
9 root 20 0 0 0 0 S 0.0 0.0 0:00.92 ksoftirqd/1
10 root RT 0 0 0 0 S 0.0 0.0 0:00.11 watchdog/1
11 root RT 0 0 0 0 S 0.0 0.0 0:07.28 migration/2
Re: Host and service status show 0
Posted: Tue Mar 15, 2016 8:23 am
by lmiltchev
I have to do repair_database to get all my hosts and services back in nagiosxi console. Do you know why this is happening sometimes?
It is not unusual to see 0 hosts/services when you have database errors/crashed tables. Most often, the database corruption is caused by power outages, improper shutting down of the VM, or running out of disk space. For more information on the topic, please read our "Crashed Database Tables" KB article here:
https://support.nagios.com/kb/article.php?id=24