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.

MySQL Fail

Discussion in 'Database Discussions' started by linux4me2, Mar 9, 2016.

  1. linux4me2

    linux4me2 Well-Known Member

    Joined:
    Aug 21, 2015
    Messages:
    83
    Likes Received:
    15
    Trophy Points:
    8
    Location:
    USA
    cPanel Access Level:
    Root Administrator
    I'm running a CENTOS 6.7 x86_64 virtuozzo VPS host with WHM 54.0 (build 19) and MariaDB 10.0. I ran MySQL up until a couple of weeks ago, but converted to MariaDB since it was the recommended database. This is the first mysql crash I've had in the nine years this server has been running.

    The only thing I changed today was to upgrade from PHP 5.6.18 to 5.6.19 using EasyApache 3 a couple of hours before the crash. A couple of hours after the upgrade, I received an email notice that mysql had failed with the following log entry:
    followed by a long list of database tables that were marked as crashed and should be repaired.

    The other relevant information in the email was as follows:
    I checked some of the database tables using phpMyAdmin, and they checked out OK, but I ran repair on them all anyway.

    I'm wondering why it would fail when it has functioned so well for so long, and if there is anything I can do to prevent it from happening again.
     
  2. linux4me2

    linux4me2 Well-Known Member

    Joined:
    Aug 21, 2015
    Messages:
    83
    Likes Received:
    15
    Trophy Points:
    8
    Location:
    USA
    cPanel Access Level:
    Root Administrator
    I had another failure of mysqld this morning. This time, the email included the following:
    However, the email with the above log excerpt showed the following:
    I tried running:
    Code:
    find -name plugin.frm -print
    
    and didn't find the file, if that helps any.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  4. linux4me2

    linux4me2 Well-Known Member

    Joined:
    Aug 21, 2015
    Messages:
    83
    Likes Received:
    15
    Trophy Points:
    8
    Location:
    USA
    cPanel Access Level:
    Root Administrator
    Here is /etc/my.cnf:
     
  5. linux4me2

    linux4me2 Well-Known Member

    Joined:
    Aug 21, 2015
    Messages:
    83
    Likes Received:
    15
    Trophy Points:
    8
    Location:
    USA
    cPanel Access Level:
    Root Administrator
    MySQL failed again last night. I ran a check table with phpMyAdmin on some of the tables that were listed as crashed, but their status shows they're okay. Do I need to run repair on all the tables listed every time mysql crashes like this?
     
  6. storminternet

    storminternet Well-Known Member

    Joined:
    Nov 2, 2011
    Messages:
    462
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Looking at the error logs you have provided , mysql is crashing due to the problem with memory allocation
    It can be due to the insufficient memory on hardware node on which your vps is created or may be due to
    kernel issues. It is better to contact your hosting provider and check with this issue with them.
     
  7. linux4me2

    linux4me2 Well-Known Member

    Joined:
    Aug 21, 2015
    Messages:
    83
    Likes Received:
    15
    Trophy Points:
    8
    Location:
    USA
    cPanel Access Level:
    Root Administrator
    Thanks for the reply. I was hoping it was something simple I was not familiar with. I'll check with the host.
     
Loading...

Share This Page