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!

MySQL is down on server

Discussion in 'Database Discussion' started by suge1w, Jan 7, 2016.

  1. suge1w

    suge1w Member

    Joined:
    Jan 22, 2014
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Yesterday, my website crashed. Or, what appears to be a crash.

    My host (JustHost) have disclosed that it was a SAN problem and have been rebuilding it. It's hard to get anymore information out of them because they are playing their cards very close to their chest for some reason.

    I have suffered almost 24 hours downtime in 2 days and I'm getting fed up.

    The error I am receiving on the frontend of the website is:
    Code:
    Database connection error (2): Could not connect to MySQL.Database connection error (2): Could not connect to MySQL.
    Trying to access my phpMyadmin from cPanel gives me the following error: i67.tinypic.com/2h6x5cj.png

    Accessing SSH and trying to start the mysql service via putty I get:
    Code:
    Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql        /mysqld.pid).
    Can anyone please help me resolve this issue as my host is rather useless!

    Thanks!
     
    #1 suge1w, Jan 7, 2016
    Last edited by a moderator: Jan 7, 2016
  2. Infopro

    Infopro cPanel Sr. Product Evangelist Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,764
    Likes Received:
    457
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    What does this mean exactly? MySQL is not running on your server, hence those error messages. Are they still rebuilding things or are they done and you're on your own?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 Infopro, Jan 7, 2016
  3. suge1w

    suge1w Member

    Joined:
    Jan 22, 2014
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I don't know what it means, I cannot garner anymore information out of them. I've sent them 3 emails, spoke to several customer service representatives on live chat, rang them and "tweet'd" them and all I get is "we're rebuilding SAN"...

    I haven't attempted to do anything on my own. I have trusted them to restore things but I don't think it's likely to happen.
     
    #3 suge1w, Jan 7, 2016
  4. Infopro

    Infopro cPanel Sr. Product Evangelist Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,764
    Likes Received:
    457
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Without knowing more from them, there's really nothing more you can do but wait to hear back.


    cPanel should automagically restart MySQL if it goes down for some reason. You might try restarting it yourself from WHM:
    Restart Services - Documentation - cPanel Documentation

    At the bottom of that page is a link to more command line options.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 Infopro, Jan 7, 2016
  5. suge1w

    suge1w Member

    Joined:
    Jan 22, 2014
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thanks for the information.

    I have just tried to restart the SQL server and I received "mysql has failed, please contact the sysadmin (result was "mysql is not running")."
     
    #5 suge1w, Jan 7, 2016
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    46,390
    Likes Received:
    2,048
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    You can review the /var/lib/mysql/$hostname.err log file to see if additional information about MySQL failing is available.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 cPanelMichael, Jan 8, 2016
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySQL down server
  1. Sametto Chan

    MySQL Database crashed/CPU higher on server to down

    Sametto Chan, Oct 21, 2017, in forum: Workarounds and Optimization
    Replies:
    10
    Views:
    1,574
    Sametto Chan
    Oct 26, 2017
  2. webos

    Downgrade from MySql 5.7 to MySql 5.6 Centos 7

    webos, Jan 27, 2019, in forum: Database Discussion
    Replies:
    1
    Views:
    401
    cPanelMichael
    Jan 30, 2019
  3. Jeff P.

    [CPANEL-23547] MySQL down after failed MariaDB upgrade

    Jeff P., Nov 7, 2018, in forum: Database Discussion
    Replies:
    12
    Views:
    486
    cPanelMichael
    Nov 8, 2018
  4. APatchworkBoy

    Changed MySQL root pw, Service Status: down (but it isn't)

    APatchworkBoy, Oct 25, 2018, in forum: Database Discussion
    Replies:
    6
    Views:
    257
    cPanelLauren
    Oct 26, 2018
  5. asdcxz@1239

    cPanel reports MySQL down but sites work

    asdcxz@1239, Aug 6, 2018, in forum: Database Discussion
    Replies:
    7
    Views:
    328
    cPanelMichael
    Aug 7, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice