Nirjonadda

Well-Known Member
May 8, 2013
724
27
78
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,203
363
Hello,

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

Thank you.
 

Nirjonadda

Well-Known Member
May 8, 2013
724
27
78
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.
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,203
363
Hello,

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

Thank you.