Difference in number of hosts in hostgroups

[mejokj]

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

[dchurch]

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

[mejokj]

Hi,

I have shared with you the profile file as PM.

Thanks

[benjaminsmith]

Hi,

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

Best Regards,
Benjamin

[mejokj]

Hi,

can you update on this issue

Thanks

[benjaminsmith]

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

[mejokj]

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

[benjaminsmith]

Hi @mejokj

The database log is showing crashed tables, so please run the following command as root from the CLI.

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh

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

Code: Select all

mysqldump -uroot -pnagiosxi nagiosql > nagiosql.sql

[mejokj]

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

[benjaminsmith]

Hi @mejokj,

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

Code: Select all

mysqldump -uroot -pnagiosxi nagiosql > nagiosql.sql