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.

check_mysql has determined that there are corrupted database tables

Discussion in 'Database Discussions' started by Creative Visual, Sep 21, 2015.

  1. Creative Visual

    Creative Visual Registered

    Joined:
    Sep 21, 2015
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Woodbury, NJ
    cPanel Access Level:
    Root Administrator
    Hello, I keep getting these emails from my server:

    check_mysql has determined that there are corrupted database tables
    cPanel & WHM has determined that the following database tables are corrupt:

    Database Error
    mysql

    /usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect

    We recommend that you repair these tables with WHM’s “Repair a MySQL Database” interface (WHM Home » SQL Services » Repair a MySQL Database). If the repair fails, contact cPanel Support for further assistance.

    This notice is the result of a request from “check_mysql”.
    This notice was generated on “Monday, September 21, 2015” at “4:58:51 AM UTC”.




    When I go to repair, I get an error, so I reboot the VPS. After it boots, I'll repair and it works fine for less than a day until my WP sites have an error establishing db message, then I have to reboot again.

    I contacted my host about these emails as well as other emails I was getting about disk usage when I was only using less than half of the server space:



    "Earlier this week we did find that the space on the NODE that your VPS is on was close to being full. We have since migrated a VPS off the NODE and freed up space. At this time there is around 15% or more free space and no more VPS's will be provisioned on the server. You should stop getting those notifications.
    As for the MYSQL Database issues. That will likely need to be repaired and possibly rebooted. If its related to the space issue it should be cleared after that fix. If not you will want to consult with Cpanel as these are self managed solutions. MySQL being a service that Cpanel manages they likely will be able to get that issue resolved. This may mean that Mysql configuration is not setup correctly or permissions were modified."



    I never modified anything and it just started randomly acting up. Any idea what could be causing this? Could that first issue with the node have done something to the mysql?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

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

    It's possible some databases were corrupted when your VPS hardware node reached it's disk space limit. Do you notice any error messages in /var/lib/mysql/$hostname.err when this issue occurs?

    Thank you.
     
  3. Creative Visual

    Creative Visual Registered

    Joined:
    Sep 21, 2015
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Woodbury, NJ
    cPanel Access Level:
    Root Administrator
    Hi Michael, thanks for the reply.
    Not sure if this is what you're looking for, but this is what it says in the whm process manager under Command for mysql:

    /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/s1081086.instanturl.net.err --open-files-limit=10000 --pid-file=/var/lib/mysql/s1081086.instanturl.net.pid
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    No, you will need to access the server via SSH as "root" and review the MySQL error log to see if you notice any particular error messages at the times this issue occurs.

    Thank you.
     
Loading...

Share This Page