Page 1 of 1
State Change is not appearing in State History Log
Posted: Thu Jan 06, 2022 3:44 pm
by meganwilliford
Hello, we had a occurrence recently where we saw the state changed (OK to Warning) for a service but it can't be found anywhere in the state history log. In fact no state history changes appeared for anything being monitored on that day. Any ideas on why this may have occurred? As of today, state history records are appearing.
Here you can see the state change:
warning state.png
But when searching the state history log it does not appear:
no state history.png
Re: State Change is not appearing in State History Log
Posted: Fri Jan 07, 2022 10:25 am
by ssax
Please
PM me a copy of your
profile.zip, you can download it from Admin > System Profile by clicking the Download Profile button.
Additionally, please send the output of these commands:
- NOTE: You may need to adjust the -h 127.0.0.1, the -uroot, and -pnagiosxi in the first command if your DB is offloaded to another server and/or you've changed the root mysql password
Code: Select all
echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table