memory not graphing

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
rnjie
Posts: 157
Joined: Wed Mar 20, 2019 4:59 pm

memory not graphing

Post 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
You do not have the required permissions to view the files attached to this post.
Top
User avatar
vtrac
Posts: 903
Joined: Tue Oct 27, 2020 1:35 pm

Re: memory not graphing

Post 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:

Code: Select all

systemctl restart nagios.service
Also, could you please give me more detail as to what hosts and services were having issues?

Regards,
Vinh
Top
User avatar
vtrac
Posts: 903
Joined: Tue Oct 27, 2020 1:35 pm

Re: memory not graphing

Post 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
Top
rnjie
Posts: 157
Joined: Wed Mar 20, 2019 4:59 pm

Re: memory not graphing

Post 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 |
+----------------------+-------+
Top
User avatar
vtrac
Posts: 903
Joined: Tue Oct 27, 2020 1:35 pm

Re: memory not graphing

Post by vtrac »

Hi,
Please restart your system and wait about 20 - 30 minutes then check again.

Code: Select all

systemctl restart nagios.service
Please let me know how the graph looks.


Regards,
Vinh
Top

Return to “Nagios XI”