My SQL/ SPAMD service crashing/ restarting lot's of emails

Chris Grooms

Registered
Feb 10, 2016
1
0
1
USA
cPanel Access Level
Root Administrator
we have been getting multiple of these emails every day for month, any advice is appreciated:

Code:
Server
Primary IP Address
Service Name mysql
Service Status failed
Notification The service “mysql” appears to be down.
Service Check Method The system’s command to check or to restart this service failed.
Number of Restart Attempts 1
Startup Log Starting MySQL... SUCCESS!
Log Messages 160210 06:18:15 mysqld_safe mysqld from pid file /var/lib/mysql/wmi.example.com.pid ended
160210 06:18:14 mysqld_safe mysqld restarted
160210 06:18:14 mysqld_safe Number of processes running now: 0
160210 6:18:09 [Note] /usr/sbin/mysqld: ready for connections.
160210 06:18:05 mysqld_safe mysqld restarted
160210 06:18:05 mysqld_safe Number of processes running now: 0
160209 21:55:19 [Note] /usr/sbin/mysqld: ready for connections.
160209 21:55:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160209 21:51:49 mysqld_safe mysqld from pid file /var/lib/mysql/wmi.example.com.pid ended
160209 21:51:49 mysqld_safe mysqld restarted
160209 21:51:49 mysqld_safe Number of processes running now: 0
160209 21:51:23 [Note] /usr/sbin/mysqld: ready for connections.
Memory Information
Used 1.11 GB
Available 4.89 GB
Installed 6 GB
Load Information 0.30 0.90 0.66
Uptime 123 days, 20 hours, 9 minutes, and 43 seconds
IOStat Information avg-cpu: %user %nice %system %iowait %steal %idle 1.93 16.72 2.22 0.01 0.00 79.13 Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
Top Processes
PID Owner CPU % Memory % Command
19580 root 23.43 1.14 /usr/local/cpanel/3rdparty/perl/514/bin/spamd --daemonize --max-spare=1 --max-children=3 --allowed-ips=127.0.0.1 --pidfile=/var/run/spamd.pid -i127.0.0.1
19585 root 10.08 0.00 [tailwatchd]
20014 mysql 4.48 0.73 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/wmi.example.com.err --open-files-limit=10000 --pid-file=/var/lib/mysql/wmi.example.com.pid
20043 root 1.94 0.26 /usr/local/cpanel/scripts/restartsrv_dovecot --check --notconfigured-ok
19567 root 1.31 0.41 tailwatchd - chkservd - imap check





The service “spamd” appears to be down.

Server
Primary IP Address
Service Name spamd
Service Status failed
Notification The service “spamd” appears to be down.
Service Check Method The system’s command to check or to restart this service failed.
Number of Restart Attempts 1
Startup Log No startup log
Memory Information
Used 913 MB
Available 5.11 GB
Installed 6 GB

Load Information 0.30 0.90 0.66
Uptime 123 days, 20 hours, 9 minutes, and 40 seconds
IOStat Information avg-cpu: %user %nice %system %iowait %steal %idle 1.93 16.72 2.22 0.01 0.00 79.13 Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
Top Processes
PID Owner CPU % Memory % Command
19580 root 29.45 1.14 /usr/local/cpanel/3rdparty/perl/514/bin/spamd --daemonize --max-spare=1 --max-children=3 --allowed-ips=127.0.0.1 --pidfile=/var/run/spamd.pid -i127.0.0.1
19567 root 1.25 0.38 tailwatchd - chkservd - mysql check
19589 dovecot 0.57 0.03 dovecot/auth
18586 nobody 0.14 0.52 /usr/local/apache/bin/httpd -k start
18588 nobody 0.13 0.58 /usr/local/apache/bin/httpd -k start
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,228
463
Hello :)

Do you notice any specific output in the MySQL error log when MySQL fails? It's located at:

/var/lib/mysql/$hostname.err

Thank you.