Host and service status show 0

[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?

[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.

[amit.ahuja]

version 5.2.0
i'm using repair_databases.sh instead of repairmysql.sh

[rkennedy]

You may be hitting a throttle with resources. What is the result of top|head -19?

[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

[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