Unable to start mysql - no such process
Linode
Linode Staff
After rebooting my Centos7 server, I am no longer able to start MySQL:
systemd: Starting LSB: start and stop MariaDB...
mysql: Starting MariaDB.190712 10:23:33 mysqld_safe Logging to example.com
mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
../etc/rc.d/init.d/mysql: line 260: kill: (4459) - No such process
mysql ERROR!
systemd: mysql.service: control process exited, code=exited status=1
systemd: Failed to start LSB: start and stop MariaDB.
systemd: Unit mysql.service entered failed state.
systemd: mysql.service failed.
1 Reply
rmoyer
Linode Staff
The error messages above don't give a whole lot to go on. As an initial step, I'd suggest turning on higher verbosity. Since you are starting mysql via systemd, you'll want to do the following:
- Create the mariadb.service.d file for systemd
mkdir -p /etc/systemd/system/mariadb.service.d/
- Turn on "debug" level logging
sudo tee /etc/systemd/system/mariadb.service.d/syslog.conf <<EOF
[Service]
Environment=SYSTEMD_LOG_LEVEL=debug
EOF
- Reload the systemd daemon to refresh the changes.
systemctl daemon-reload
- Now, restart mysql again and check journalctl for further errors:
journalctl -u mariadb
As always with database issues, ensure that you have sufficient disk space available:
df -h