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 service goes down often

Discussion in 'Database Discussion' started by Supriya Aher, Dec 23, 2012.

  1. Supriya Aher

    Supriya Aher Member

    Joined:
    Jan 18, 2012
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    Hello,

    Servers mysql services goes down very often and then needs to be started manually each time.


    If we check the status of mysql service then below is the output:

    "MySQL is running but PID file could not be found [FAILED]"

    On checking the mysql error logs , we get just the below errors:
    ===========================================

    tail -f /var/lib/mysql/servername.err

    121222 22:16:27 [ERROR] /usr/sbin/mysqld: Table './guiaycom_wp458/wp_options' is marked as crashed and should be repaired
    121222 22:16:27 [ERROR] /usr/sbin/mysqld: Table './guiaycom_wp458/wp_options' is marked as crashed and should be repaired
    121222 22:16:27 [ERROR] /usr/sbin/mysqld: Table './guiaycom_wp458/wp_options' is marked as crashed and should be repaired
    121222 22:16:27 [ERROR] /usr/sbin/mysqld: Table './guiaycom_wp458/wp_options' is marked as crashed and should be repaired
    121222 22:25:57 [ERROR] /usr/sbin/mysqld: Table './isprofit_smf1/smf_log_online' is marked as crashed and should be repaired
    121222 22:25:57 [ERROR] /usr/sbin/mysqld: Table './isprofit_smf1/smf_log_online' is marked as crashed and should be repaired
    121222 22:26:53 [ERROR] /usr/sbin/mysqld: Table './fishresc_newfrw/members_online' is marked as crashed and should be repaired
    121222 22:26:53 [ERROR] /usr/sbin/mysqld: Table './fishresc_newfrw/members_online' is marked as crashed and should be repaired
    121222 22:29:12 [ERROR] /usr/sbin/mysqld: Table './isprofit_smf1/smf_log_online' is marked as crashed and should be repaired
    121222 22:29:12 [ERROR] /usr/sbin/mysqld: Table './isprofit_smf1/smf_log_online' is marked as crashed and should be repaired
    121222 22:30:18 [ERROR] /usr/sbin/mysqld: Table './fishresc_newfrw/members_online' is marked as crashed and should be repaired
    121222 22:30:18 [ERROR] /usr/sbin/mysqld: Table './fishresc_newfrw/members_online' is marked as crashed and should be repaired
    =====================================


    Can I know, what can cause this and how to resolve the mysql PID file could not be found error permanently?
     
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