Nagios Support Forum

Hi Team,

While looking at the "windows server list" hostgroup under Host Group Management, we can see 163 hosts in manage hosts. But while added the same hostgroup (windows server list) in the helpdesk dashboard as host status summary it showed only a total of 156 hosts. Attached screenshot for your reference.

So there is a difference of 7 hosts between the two sections. Can you help me to figure out the issue?

Thanks

Could you please me PM a System Profile zip? I can diagnose further if I can take a look at the data.

Hi,

I have shared with you the profile file as PM.

Thanks

Hi,

Thank you. We received your profile and are currently reviewing the logs and we'll update you shortly.

Best Regards,
Benjamin

Hi,

can you update on this issue

Thanks

HI,

Sorry for the delay. In the Configuration Manager, it will show all of the hosts, both active and inactive. Can you verify that the 7 missing hosts have not been deactivated? I believe that maybe the issue here.

If not, the database log was not in the profile, can you retrieve that form the server and post it to the thread.

Thanks,
Benjamin

Hi,

I have removed all deactivated hosts from hostgroup. But the number of hosts showing under host group management reduced to 154. And under dashboard, it is showing 157 hosts.

Still, I can see some differences in the number of hosts.

I think the database is not getting updated the information correctly.

I have sent you the database log as a private message. Please have a look and let us know.

Thanks

Hi @mejokj

The database log is showing crashed tables, so please run the following command as root from the CLI. If the issue persists, are you logged in as the nagiosadmin?

Run the following command to dump the nagiosql database, and I will try to replicate this on a test server. Thanks, Benjamin

Hello We have repair and it shows successful. I will send log via chat.

Hi @mejokj,

Sounds good. If the original issue still persists, please send me the nagiosql database as well.