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!

Starting MySQL Server

Discussion in 'Database Discussion' started by Nirjonadda, Feb 27, 2018.

  1. Nirjonadda

    Nirjonadda Well-Known Member

    Joined:
    May 8, 2013
    Messages:
    597
    Likes Received:
    15
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    Can not starting MySQL Server. The service “mysql” appears to be down. Please let me know that how can fix this issue?

    Code:
    [2018-02-27 20:40:02 +0600] info [restartsrv_mysql] systemd failed to start the service “mysqld” (The “/usr/bin/systemctl” command (process 20268) reported error number 1 when it ended.): Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details. [2018-02-27 20:40:07 +0600] info [restartsrv_mysql] systemd failed to start the service “mysqld” (The “/usr/bin/systemctl” command (process 20582) reported error number 1 when it ended.): Job for mysqld.service failed because start of the service was attempted too often. See "systemctl status mysqld.service" and "journalctl -xe" for details. To force a start use "systemctl reset-failed mysqld.service" followed by "systemctl start mysqld.service" again. [2018-02-27 20:40:13 +0600] info [restartsrv_mysql] systemd failed to start the service “mysqld” (The “/usr/bin/systemctl” command (process 20593) reported error number 1 when it ended.): Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details. Waiting for “mysqld” to start ………Unrecognized configuration options may have caused the MySQL startup errors. The system has attempted to auto-update your MySQL configuration file for your MySQL version. This should resolve any errors that stem from an outdated MySQL configuration file. …Unrecognized configuration options may have caused the MySQL startup errors. The system has attempted to auto-update your MySQL configuration file for your MySQL version. This should resolve any errors that stem from an outdated MySQL configuration file. …failed.
    
    Cpanel::Exception::Services::StartError Service Status
    
    Service Error
    (XID anqfrd) The “mysqld” service failed to start.
    
    Startup Log
    Feb 27 20:40:17 hostname.com systemd[1]: Failed to start MySQL Server.
    Feb 27 20:40:17 hostname.com systemd[1]: Unit mysqld.service entered failed state.
    Feb 27 20:40:17 hostname.com systemd[1]: mysqld.service failed.
    Feb 27 20:40:17 hostname.com systemd[1]: mysqld.service holdoff time over, scheduling restart.
    Feb 27 20:40:17 hostname.com systemd[1]: start request repeated too quickly for mysqld.service
    Feb 27 20:40:17 hostname.com systemd[1]: Failed to start MySQL Server.
    Feb 27 20:40:17 hostname.com systemd[1]: Unit mysqld.service entered failed state.
    Feb 27 20:40:17 hostname.com systemd[1]: mysqld.service failed.
    
    Log Messages
    /usr/sbin/mysqld[0x7a12d5]
    /usr/sbin/mysqld[0x7a80e4]
    /usr/sbin/mysqld[0xcea655]
    /usr/sbin/mysqld[0xf452e1]
    /usr/sbin/mysqld[0x781aa4]
    
    Startup Log
    Feb 27 20:40:17 hostname.com systemd[1]: Failed to start MySQL Server.
    Feb 27 20:40:17 hostname.com systemd[1]: Unit mysqld.service entered failed state.
    Feb 27 20:40:17 hostname.com systemd[1]: mysqld.service failed.
    Feb 27 20:40:17 hostname.com systemd[1]: mysqld.service holdoff time over, scheduling restart.
    Feb 27 20:40:17 hostname.com systemd[1]: start request repeated too quickly for mysqld.service
    Feb 27 20:40:17 hostname.com systemd[1]: Failed to start MySQL Server.
    Feb 27 20:40:17 hostname.com systemd[1]: Unit mysqld.service entered failed state.
    Feb 27 20:40:17 hostname.com systemd[1]: mysqld.service failed.
    
    Log Messages
    /usr/sbin/mysqld[0x7a12d5]
    /usr/sbin/mysqld[0x7a80e4]
    /usr/sbin/mysqld[0xcea655]
    /usr/sbin/mysqld[0xf452e1]
    /usr/sbin/mysqld[0x781aa4]
    
    mysqld has failed. Contact your system administrator if the service does not automagically recover.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,961
    Likes Received:
    1,821
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Could you let us know the output to /var/lib/mysql/$hostname.err when attempting to restart MySQL?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Nirjonadda

    Nirjonadda Well-Known Member

    Joined:
    May 8, 2013
    Messages:
    597
    Likes Received:
    15
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    No new output. All are old log.

    /var/lib/mysql/ba.mysite.com.err

    Code:
    2018-01-14 00:10:17 863 [Note] /usr/sbin/mysqld: Shutdown complete
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,961
    Likes Received:
    1,821
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Could you open a support ticket using the link in my signature so we can take a closer look?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Nirjonadda

    Nirjonadda Well-Known Member

    Joined:
    May 8, 2013
    Messages:
    597
    Likes Received:
    15
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    This issue happened after v70.0.18 update.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. Nirjonadda

    Nirjonadda Well-Known Member

    Joined:
    May 8, 2013
    Messages:
    597
    Likes Received:
    15
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    Support request ID: 9316983
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,961
    Likes Received:
    1,821
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    To update, it was determined this was related to InnoDB corruption. The following URL was provided to help repair the InnoDB data:

    InnoDB Corruption Repair Guide

    Thank you.
     
    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