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

Chris Grooms

• February 10, 2016 14:14

we have been getting multiple of these emails every day for month, any advice is appreciated:
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

  • February 11, 2016 15:15

  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.

  0

Please sign in to leave a comment.