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!

database connection error

Discussion in 'Database Discussion' started by allhost, Dec 22, 2014.

  1. allhost

    allhost Member

    Joined:
    Dec 22, 2014
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello All,

    This is my first thread, and possibly pretty new on WHM :(.

    My update to the latest WHM got stuck around 50%, doing (Running sanity checks and notifications.), (Processing command `/usr/local/cpanel/scripts/setup_whmxfer_db`), for more than 50 minutes. The page still loads, but nothing is progressing.

    Of course, all my websites are down due to (database connection error), so, once I try to go the the WHM (from a different window), I do see it is updated, and it shows the latest version of 11.46.1, however, I can not seem to start MySQL, which might be corrupted.

    What do you think I should be doing next? I do have a server backup but wish to make this the last resort?

    Any ideas would be highly appreciated?

    Thank you all,
     
    #1 allhost, Dec 22, 2014
    Last edited by a moderator: Dec 22, 2014
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,309
    Likes Received:
    393
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    There is no of course, there. Sites shouldn't be going offline during updates to your cPanel. You shouldn't be restoring backups to sites that went offline during an update, either.

    How are you trying to start it, that's failing? Why do you think it might be corrupted?


    Please feel free to open a ticket to cPanel Technical Support for assistance with this. If you wouldn't mind, post the ticket ID back here in this thread.

    Thanks
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. allhost

    allhost Member

    Joined:
    Dec 22, 2014
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thanks InfoPro.

    Basically, This is what happened. I have 3 sites (wordpress) and all of them showed (database connection error) while WHM is being updated. So weird. While updating cPanel/WHM, I ticked that little box to allow sharing update process with cPanel.

    I started SQL from WHM menu -->restart services --> SQL services. The first time, it failed, then, worked again and show these errors multiple times.

    Code:
    [Warning] /usr/sbin/mysqld: Forcing close of thread 22  user: 'eximstats'
          18:10:13 [Note] /usr/sbin/mysqld: Normal shutdown
         18:09:21 [ERROR] /usr/sbin/mysqld: Can't open file: './whmxfer/sessions.frm' (errno: 24)
    [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/sends.frm' (errno: 24)
         17:33:32 [ERROR] /usr/sbin/mysqld: Can't open file: './modsec/hits.frm' (errno: 24)
         17:32:21 [ERROR] /usr/sbin/mysqld: Can't open file: './i326520_wp1/wp_options.frm' (errno: 24)
    [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/defers.frm' (errno: 24)
         17:31:01 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/sends.frm' (errno: 24)
         17:31:00 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/failures.frm' (errno: 24)

    Now, I am wondering whether my cPanel/WHM upgrade is completely healthy or not? and how to fix these DB errors?

    What do you think?
    Thanks
     
  4. triantech

    triantech Well-Known Member

    Joined:
    Jul 1, 2014
    Messages:
    143
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Kochi, India, India
    cPanel Access Level:
    Root Administrator
    Hello,
    From the logs, it looks like your eximstats db is corrupt.. you may try to repair it or drop the db and rebuild it.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. allhost

    allhost Member

    Joined:
    Dec 22, 2014
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thanks Triantech.

    I have gone and repaired all these DB's, restarted SQL and it seems all these error logs are gone.

    Much appreciated.
     
  6. triantech

    triantech Well-Known Member

    Joined:
    Jul 1, 2014
    Messages:
    143
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Kochi, India, India
    cPanel Access Level:
    Root Administrator
    allhost,

    Great :)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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.
    Dismiss Notice