紧急请教： mysql 无法正常启动 /usr/sbin/mysqld: Shutdown complete
kmdd33 2018-11-27 15:14:21 +08:00 12733 次点击这是一个创建于 2577 天前的主题，其中的信息可能已经有所发展或是发生改变。
原因：由于忘记及时续费一个站点，DO 设置成了 suspended 状态，续费后，DO power on 然而发现 mysql 状态是关闭的，然后我尝试启动失败。
环境：openresty+php+mysql
正常的：openresty 和 php-fpm 都是 active 状态
非正常的：执行 systemctl status mysql
● mysqld.service - MySQL Community Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: failed (Result: start-limit) since Tue 2018-11-27 06:40:18 UTC; 9min ago Process: 2266 ExecStartPost=/usr/bin/mysql-systemd-start post (code=exited, status=0/SUCCESS) Process: 2265 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=203/EXEC) Process: 2250 ExecStartPre=/usr/bin/mysql-systemd-start pre (code=exited, status=0/SUCCESS) Main PID: 2265 (code=exited, status=203/EXEC)
Nov 27 06:40:18 systemd[1]: Failed to start MySQL Community Server. Nov 27 06:40:18 systemd[1]: Unit mysqld.service entered failed state. Nov 27 06:40:18 systemd[1]: mysqld.service failed. Nov 27 06:40:18 systemd[1]: mysqld.service holdoff time over, scheduling restart. Nov 27 06:40:18 systemd[1]: start request repeated too quickly for mysqld.service Nov 27 06:40:18 systemd[1]: Failed to start MySQL Community Server. Nov 27 06:40:18 systemd[1]: Unit mysqld.service entered failed state. Nov 27 06:40:18 systemd[1]: mysqld.service failed.
排查过程：
ls -ld /var/lib/mysql/
drwxr-xr-x 5 mysql mysql 268 Nov 27 06:27 /var/lib/mysql/
ls -lh /var/lib/mysql/
total 29M -rw-rw---- 1 mysql mysql 16K Apr 13 2018 aria_log.00000001
-rw-rw---- 1 mysql mysql 52 Apr 13 2018 aria_log_control
-rw-rw---- 1 mysql mysql 18M Nov 22 04:47 ibdata1
-rw-rw---- 1 mysql mysql 5.0M Nov 27 05:52 ib_logfile0
-rw-rw---- 1 mysql mysql 5.0M Apr 13 2018 ib_logfile1
drwx------ 2 mysql mysql 4.0K Apr 13 2018 mysql
srwxrwxrwx 1 mysql mysql 0 Nov 27 05:52 mysql.sock
-rw-r----- 1 mysql mysql 5.8K Apr 13 2018 newdomainname.err
drwx------ 2 mysql mysql 12K Nov 22 00:57 domainname
drwx------ 2 mysql mysql 4.0K Apr 13 2018 performance_schema
-rw-r--r-- 1 mysql mysql 286 Apr 13 2018 RPM_UPGRADE_HISTORY
-rw-r--r-- 1 mysql mysql 286 Apr 13 2018 RPM_UPGRADE_MARKER-LAST
netstat -ntlp
Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 127.0.0.1:9000 0.0.0.0:* LISTEN 1303/php-fpm: maste tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 783/mysqld
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN 1/systemd
tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 1329/nginx: master
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1285/sshd
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 1159/master
tcp 0 0 0.0.0.0:443 0.0.0.0:* LISTEN 1329/nginx: master
tcp6 0 0 :::111 :::* LISTEN 1/systemd
tcp6 0 0 :::80 :::* LISTEN 1329/nginx: master
tcp6 0 0 :::22 :::* LISTEN 1285/sshd
tcp6 0 0 ::1:25 :::* LISTEN 1159/master
ps -ef | grep mysqld
root 660 1 0 05:52 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe
mysql 783 660 0 05:52 ? 00:00:02 /usr/sbin/mysqld --basedir=/usr --
datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-
error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --
socket=/var/lib/mysql/mysql.sock
root 2650 1022 0 06:54 pts/1 00:00:00 grep --color=auto mysqld
/var/log/mysqld.log 显示如下：
https://i.imgur.com/4yKhZ2d.png
https://i.imgur.com/YYuAO6G.png
请问如何解决呢？问题到底出在哪里了？
 | 1 kmdd33 OP 执行了：# journalctl -xe 发现： # journalctl -xe -- Unit mysqld.service has begun starting up. Nov 27 07:18:32 newoneacreland systemd[3106]: Failed at step EXEC spawning /usr/bin/mysqld_safe -- Subject: Process /usr/bin/mysqld_safe could not be executed -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- The process /usr/bin/mysqld_safe could not be executed and failed. -- -- The error number returned by this process is 13. Nov 27 07:18:32 newoneacreland systemd[1]: mysqld.service: main process exited, code=exited, st Nov 27 07:18:33 newoneacreland systemd[1]: Failed to start MySQL Community Server. -- Subject: Unit mysqld.service has failed -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysqld.service has failed. -- -- The result is failed. Nov 27 07:18:33 newoneacreland systemd[1]: Unit mysqld.service entered failed state. Nov 27 07:18:33 newoneacreland systemd[1]: mysqld.service failed. Nov 27 07:18:33 newoneacreland systemd[1]: mysqld.service holdoff time over, scheduling restart Nov 27 07:18:33 newoneacreland systemd[1]: start request repeated too quickly for mysqld.servic Nov 27 07:18:33 newoneacreland systemd[1]: Failed to start MySQL Community Server. |
Select Language
