VPS侦探论坛

 找回密码
 注册
查看: 1642|回复: 5

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

[复制链接]
发表于 2023-4-24 20:54:34 | 显示全部楼层 |阅读模式

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无法启动了,并且日志是空的。。。

美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2023-4-25 08:16:34 | 显示全部楼层


要有日志才行,反馈必读帖子里面有说明
按提示分别执行:systemctl status mysql.service
journalctl -xe
贴出返回信息
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
 楼主| 发表于 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[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.
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
 楼主| 发表于 2023-4-25 09:15:07 | 显示全部楼层



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>
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
 楼主| 发表于 2023-4-25 10:33:09 | 显示全部楼层

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

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

军哥运维代购:http://shop63846532.taobao.com/

发表于 2023-5-4 17:54:19 | 显示全部楼层

我也碰到过这种情况好几次!都是重置系统恢复的!
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2024-11-5 12:22 , Processed in 0.027065 second(s), 16 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表