Home > FAQs > What does the alert notification about ps count.processes mean?
What does the alert notification about ps count.processes mean?
What does the alert notification about ps count.processes mean?
Table of Contents
Background Information
What does the following RightScale Alert mean?
RightScale Alert: warning Servername processes-alert/ps_count.processes is 1.00 This is an auto-generated RightScale alert. This message will be repeated every 24 hours while the condition persists. You may customize this message or add additional actions by logging in at http://www.rightscale.com and navigating to Design -> Alert -> Escalations and selecting the 'warning' escalation. processes-alert/ps_count.processes is '1.00', this is > '0.0' for over 1.00 minute(s) on server ServerName of deployment DeploymentName
Answer
This alert applies to MySQL servers and can mean one of three things:
- The slave database is > 60 seconds out of sync with the master
- The slave database backup did not complete
- The master database backup did not complete
To determine the actual problem you will want to do the following:
- If the server is a master then you can be sure the master backup is failing. Try running it manually as an operational script.
- If the server is a slave you can determine if the slave is falling behind the master by doing an ssh to the server and doing the following:
> mysql
> SHOW SLAVE STATUS \G;
The last entry shows the seconds behind the master. If it is Null or greater than sixty then there is a replication problem. If it is a number less then sixty then there is a problem with the slave backup. You can check the log files for the automated backups at:
/var/log/mysql_database_cron.log
/var/log/mysqld.log
- © Copyright 2015 RightScale Technical Support