OnCommand Storage Management Software Discussions

OCUM 9.4, unable to start mysqld

Hello,

 

Recently we had to reboot the OCUM server after a outage on ESX level, ever since the reboot, OCUM would not start and upon investigation found out that it was mysqld which fails to start.

Tried restarting mysql manually but the serivce just would not start. Following is the status as of now. Any help would be highly appreciated.

 

[root@gvecsl7619ips netapp]# systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Thu 2018-06-28 11:56:51 UTC; 2s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 24469 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=1/FAILURE)
Process: 24439 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

Jun 28 11:56:47 gvecsl7619ips systemd[1]: Starting MySQL Server...
Jun 28 11:56:49 gvecsl7619ips mysqld[24469]: Initialization of mysqld failed: 0
Jun 28 11:56:49 gvecsl7619ips systemd[1]: mysqld.service: control process exited, code=exited status=1
Jun 28 11:56:51 gvecsl7619ips systemd[1]: Stopped MySQL Server.
Jun 28 11:56:51 gvecsl7619ips systemd[1]: Unit mysqld.service entered failed state.
Jun 28 11:56:51 gvecsl7619ips systemd[1]: mysqld.service failed.
[root@gvecsl7619ips netapp]#

1 REPLY

Re: OCUM 9.4, unable to start mysqld

Try checking the mysql server log for error details. I had a similar issue on RHEL 7, where tmpfilesd missed to create the directory for the pid at /run/mysql after the reboot.

Forums