Page 1 of 1
Nagios locking checks
Posted: Fri Apr 17, 2020 9:23 am
by anderson.bastos
Hello,
I have a problem in nagios where it locks checks and to return I have to restart the database and nagios service, sometimes even having to restart the nagios machine.
The Monitoring Engine Check Statistics panel is reset to zero when it crashes.
Re: Nagios locking checks
Posted: Fri Apr 17, 2020 11:27 am
by ssax
Please PM me a copy of your profile, you can download it from
Admin > System Profile > Download Profile.
Additionally, please send the output of these commands (as root):
- 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
echo "SELECT relname as Table, pg_size_pretty(pg_total_relation_size(relid)) As Size, pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as ExternalSize FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;" | psql nagiosxi nagiosxi
Re: Nagios locking checks
Posted: Mon Apr 20, 2020 11:10 am
by anderson.bastos
I believe that at the moment we can close this topic I ended up running the database repair script and the failure does not occur in 3 days.
Thank you very much for your attention.
Re: Nagios locking checks
Posted: Mon Apr 20, 2020 12:27 pm
by scottwilkerson
anderson.bastos wrote:I believe that at the moment we can close this topic I ended up running the database repair script and the failure does not occur in 3 days.
Thank you very much for your attention.
Great!
Locking thread