check_mysql has determined that there are corrupted database tables

Creative Visual

• September 21, 2015 08:10

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?

• 

  cPanelMichael

  • September 21, 2015 15:57

  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.

  0
• 

  Creative Visual

  • September 21, 2015 16:33

  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

  0
• 

  cPanelMichael

  • September 21, 2015 17:11

  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.

  0

Please sign in to leave a comment.