Page 1 of 1
memory not graphing
Posted: Mon Jan 25, 2021 2:32 pm
by rnjie
Hello, i have been having graphing issues for memory for some time now where graphing just stops for certain hosts, now i am aware as to how to fix this by deleting the rrd files in /usr/local/nagios/share/perfdata so it generates another one, but how can i prevent this from happening at all, its frustrating not to be able to see the graphing for memory when its needed and there is also no way to tell if it has stopped graphing unless you click on the host and check, i have thousands of them so thats out of the question.
so how can this be prevented and also is there an easier way to find out if the do stop graphing? i have attached profile for your review
Re: memory not graphing
Posted: Tue Jan 26, 2021 5:31 pm
by vtrac
Hi rnjie,
I noticed you have several errors in your database's log:
Code: Select all
190419 12:15:02 [Warning] mysqld: Disk is full writing '/var/lib/mysql/nagios/nagios_logentries.TMM' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
190419 12:15:02 [Warning] mysqld: Retry in 60 secs. Message reprinted in 600 secs
190419 12:16:26 [Warning] mysqld: Disk is full writing './nagios/nagios_hoststatus.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
190419 12:16:26 [Warning] mysqld: Retry in 60 secs. Message reprinted in 600 secs
200902 22:01:35 [ERROR] mysqld: Table './nagios/nagios_servicechecks' is marked as crashed and should be repaired
200902 22:01:35 [Warning] Checking table: './nagios/nagios_servicechecks'
200902 22:01:35 [ERROR] mysqld: Table './nagios/nagios_notifications' is marked as crashed and should be repaired
200902 22:01:35 [Warning] Checking table: './nagios/nagios_notifications'
200902 22:01:36 [ERROR] mysqld: Table './nagios/nagios_statehistory' is marked as crashed and should be repaired
200902 22:01:36 [Warning] Checking table: './nagios/nagios_statehistory'
Please follow the below article to repair your database:
https://assets.nagios.com/downloads/nag ... tabase.pdf
Please remember to restart Nagios XI after completed:
Also, could you please give me more detail as to what hosts and services were having issues?
Regards,
Vinh
Re: memory not graphing
Posted: Tue Jan 26, 2021 5:40 pm
by vtrac
Also, please run the below two commands to check for "max_connections" and "Max_used_connections":
Code: Select all
mysql -uroot -pnagiosxi -e "show variables like 'max_connections';"
mysql -uroot -pnagiosxi -e "show global status like 'Max_used_connections';"
If the number returned is the same as (or close to max_connections) then you need to increase the allowed number of max_connections.
Please follow the URL below:
https://support.nagios.com/kb/article.php?id=513
Regards,
Vinh
Re: memory not graphing
Posted: Thu Jan 28, 2021 8:50 pm
by rnjie
i repaird the data base as you requested and this is th eoutput of the command above
mysql -uroot -pnagiosxi -e "show variables like 'max_connections';"
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 151 |
+-----------------+-------+
You have mail in /var/spool/mail/root
~]# mysql -uroot -pnagiosxi -e "show global status like 'Max_used_connections';"
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| Max_used_connections | 104 |
+----------------------+-------+
Re: memory not graphing
Posted: Fri Jan 29, 2021 10:19 am
by vtrac
Hi,
Please restart your system and wait about 20 - 30 minutes then check again.
Please let me know how the graph looks.
Regards,
Vinh