Starting MySQL Server

[Nirjonadda]

Can not starting MySQL Server. The service “mysql” appears to be down. Please let me know that how can fix this issue?

[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.

 

[cPanelMichael]

Hello,

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

Thank you.

 

[Nirjonadda]

Hello,

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

Thank you.

No new output. All are old log.

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

2018-01-14 00:10:17 863 [Note] /usr/sbin/mysqld: Shutdown complete

 

[cPanelMichael]

Hello,

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

Thank you.

 

[Nirjonadda]

Hello,

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

Thank you.

This issue happened after v70.0.18 update.

 

[Nirjonadda]

Hello,

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

Thank you.

Support request ID: 9316983

 

[cPanelMichael]

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.