Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

The service “mysql” appears to be down.

Discussion in 'Database Discussions' started by jamescurl, Nov 6, 2017.

  1. jamescurl

    jamescurl Registered

    Joined:
    Jun 12, 2009
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    51
    I am having a nightmare! All of my clients who have a database can't access their website.
    I have received so many of the following emails saying that the MYSQL failed to start.

    This is what I get.
    Any suggestions?
    Code:
    
    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 37
    Service Check Raw Output
    The subprocess “/usr/local/cpanel/scripts/restartsrv_mysql” reported error number 9 when it ended.
    Startup Log Nov 06 15:16:18  systemd[1]: Started MySQL Server.
    Nov 06 15:16:18  systemd[1]: Starting MySQL Server...
    Nov 06 15:16:18  mysqld_safe[16550]: 171106 15:16:18 mysqld_safe Logging to '/var/lib/mysql/.err'.
    Nov 06 15:16:18  mysqld_safe[16550]: 171106 15:16:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    Log Messages 171106 15:16:18 mysqld_safe mysqld from pid file /var/lib/mysql/.pid ended
    InnoDB: To fix the problem and start mysqld:
    171106 15:16:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    171106 15:16:18 mysqld_safe Logging to '/var/lib/mysql/'.
    171106 15:11:09 mysqld_safe mysqld from pid file /var/lib/mysql/.pid ended
    InnoDB: To fix the problem and start mysqld:
    171106 15:11:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    171106 15:11:09 mysqld_safe Logging to '/var/lib/mysql/.err'.
    171106 15:05:56 mysqld_safe mysqld from pid file /var/lib/mysql/.pid ended
    InnoDB: To fix the problem and start mysqld:
    Memory Information
    Used 1.53 GB
    Available 21.84 GB
    Installed 23.38 GB
    Load Information 0.01 0.02 0.05
    Uptime 3 hours, 7 minutes, and 26 seconds
    IOStat Information avg-cpu: %user %nice %system %iowait %steal %idle 0.30 0.08 0.09 0.12 0.00 99.41 Device: tps kB_read/s kB_wrtn/s kB_read kB_wrtn sda 13.90 222.72 140.85 2504606 1584000
    Top Processes
    PID Owner CPU % Memory % Command
    17807 root 17.78 0.06 /usr/local/cpanel/scripts/restartsrv_mailman --check --notconfigured-ok
    17614 epecho 6.23 0.43 spamd child
    1805 root 1.15 0.41 /usr/local/cpanel/3rdparty/perl/524/bin/perl -T -w /usr/local/cpanel/3rdparty/bin/spamd --allowed-ips=127.0.0.1,::1 --max-children=5 --pidfile=/var/run/spamd.pid --listen=5 --listen=6
    17587 root 0.93 0.11 tailwatchd - chkservd - mailman check
    1963 named 0.33 0.29 /usr/sbin/named -u named -c /etc/named.conf
    
    
     
    #1 jamescurl, Nov 6, 2017
    Last edited by a moderator: Nov 6, 2017
  2. Haym

    Haym Active Member

    Joined:
    May 12, 2017
    Messages:
    36
    Likes Received:
    5
    Trophy Points:
    8
    Location:
    UK
    cPanel Access Level:
    Root Administrator
    What does /var/lib/mysql/.err contain?
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    41,502
    Likes Received:
    1,616
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Could you let us know the output from the MySQL error log (/var/lib/mysql/$hostname.err) when attempting to start MySQL?

    Thank you.
     
Loading...

Share This Page