maomaodegege 发表于 2023-4-24 20:54:34

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

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 发表于 2023-4-25 08:16:34

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

maomaodegege 发表于 2023-4-25 09:12:24

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

maomaodegege 发表于 2023-4-25 09:15:07

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

maomaodegege 发表于 2023-4-25 10:33:09

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


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

明月登楼 发表于 2023-5-4 17:54:19

我也碰到过这种情况好几次!都是重置系统恢复的!
页: [1]
查看完整版本: 紧急求助,重启系统后,mysql无法启动