紧急求助,重启系统后,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无法启动了,并且日志是空的。。。
要有日志才行,反馈必读帖子里面有说明
按提示分别执行:systemctl status mysql.service
journalctl -xe
贴出返回信息 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.
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> licess 发表于 2023-4-25 08:16
要有日志才行,反馈必读帖子里面有说明
按提示分别执行:systemctl status mysql.service
journalctl -xe
已经排查到原因了,应该是硬盘写入故障了,谢谢军哥 我也碰到过这种情况好几次!都是重置系统恢复的!
页:
[1]