紧急求助，重启系统后，mysql无法启动

maomaodegege

Starting mysql (via systemctl): mysql.serviceJob for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
failed!


重启了一下系统，结果mysql无法启动了，并且日志是空的。。。

licess

要有日志才行，反馈必读帖子里面有说明
按提示分别执行：systemctl status mysql.service
journalctl -xe
贴出返回信息

maomaodegege

licess 发表于 2023-4-25 08:16
要有日志才行，反馈必读帖子里面有说明
按提示分别执行：systemctl status mysql.service
journalctl -xe

systemctl status mysql.service # 执行后的日志
● mysql.service - MySQL Community Server
     Loaded: loaded (/etc/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Tue 2023-04-25 09:03:57 CST; 6min ago
    Process: 431 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
        CPU: 443ms

Apr 25 09:03:55 Host-By systemd[1]: Starting MySQL Community Server...
Apr 25 09:03:55 Host-By mysql[431]: Starting MySQL
Apr 25 09:03:57 Host-By mysql[431]: ..The server quit without updating PID file (/usr/local/mysql/va>
Apr 25 09:03:57 Host-By mysql[1031]:  failed!
Apr 25 09:03:57 Host-By systemd[1]: mysql.service: Control process exited, code=exited, status=1/FAI>
Apr 25 09:03:57 Host-By systemd[1]: mysql.service: Failed with result 'exit-code'.
Apr 25 09:03:57 Host-By systemd[1]: Failed to start MySQL Community Server.

maomaodegege

journalctl -xe   #执行后的返回信息
Apr 25 09:08:38 Host-By sshd[3438]: Invalid user postgres from 164.92.157.35 port 48036
Apr 25 09:08:38 Host-By sshd[3438]: pam_unix(sshd:auth): check pass; user unknown
Apr 25 09:08:38 Host-By sshd[3438]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid>
Apr 25 09:08:40 Host-By sshd[3438]: Failed password for invalid user postgres from 164.92.157.35 por>
Apr 25 09:08:41 Host-By sshd[3438]: Connection closed by invalid user postgres 164.92.157.35 port 48>
Apr 25 09:09:16 Host-By sshd[3785]: Invalid user testuser from 164.92.157.35 port 46990
Apr 25 09:09:16 Host-By sshd[3785]: pam_unix(sshd:auth): check pass; user unknown
Apr 25 09:09:16 Host-By sshd[3785]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid>
Apr 25 09:09:19 Host-By sshd[3785]: Failed password for invalid user testuser from 164.92.157.35 por>
Apr 25 09:09:20 Host-By sshd[3785]: Connection closed by invalid user testuser 164.92.157.35 port 46>
Apr 25 09:09:23 Host-By sshd[3848]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid>
Apr 25 09:09:25 Host-By sshd[3848]: Failed password for root from 186.248.219.210 port 46416 ssh2
Apr 25 09:09:27 Host-By sshd[3848]: Received disconnect from 186.248.219.210 port 46416:11: Bye Bye >
Apr 25 09:09:27 Host-By sshd[3848]: Disconnected from authenticating user root 186.248.219.210 port >
Apr 25 09:09:37 Host-By sshd[3974]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid>
Apr 25 09:09:38 Host-By sshd[3974]: Failed password for root from 187.51.208.158 port 47351 ssh2
Apr 25 09:09:40 Host-By sshd[3974]: Received disconnect from 187.51.208.158 port 47351:11: Bye Bye [>
Apr 25 09:09:40 Host-By sshd[3974]: Disconnected from authenticating user root 187.51.208.158 port 4>
Apr 25 09:09:45 Host-By ntpd[457]: kernel reports TIME_ERROR: 0x41: Clock Unsynchronized
Apr 25 09:10:12 Host-By sshd[4291]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid>
Apr 25 09:10:14 Host-By sshd[4291]: Failed password for sshd from 152.89.196.55 port 10799 ssh2
Apr 25 09:10:15 Host-By sshd[4291]: Received disconnect from 152.89.196.55 port 10799:11: Client dis>
Apr 25 09:10:15 Host-By sshd[4291]: Disconnected from authenticating user sshd 152.89.196.55 port 10>

maomaodegege

licess 发表于 2023-4-25 08:16
要有日志才行，反馈必读帖子里面有说明
按提示分别执行：systemctl status mysql.service
journalctl -xe

已经排查到原因了，应该是硬盘写入故障了，谢谢军哥

明月登楼

我也碰到过这种情况好几次！都是重置系统恢复的！