网站制作学习网Database→正文:The unit mysql.service has entered the 'failed' state with result 'timeout'
字体:

The unit mysql.service has entered the 'failed' state with result 'timeout'

Database 2025/3/18 14:31:44  点击:不统计

%77w%77%2E%66%6F%72%61%73%70%2E%63%6E

 mysql从库在启动时,无法启动,没有任何报错,后来发现是 磁盘 剩余不足,不能load完毕历史innodb undo文件导致
 
下面是提示的错误:
命令行提示:
service mysqld startRedirecting to /bin/systemctl start mysqld.service Job for mysqld.service failed because the control process exited with error code. See "systemctl sta tus mysqld.service"and "journalctl -xe" for details.
 
日志错误:
Mar 17 21:34:54 root systemd[1]: mysql.service: Killing process 7768 (n/a) wi>
Mar 17 21:34:54 root systemd[1]: mysql.service: Killing process 7770 (n/a) wi>
Mar 17 21:34:54 root systemd[1]: mysql.service: Killing process 7771 (n/a) wi>
Mar 17 21:34:55 root systemd[1]: mysql.service: Failed with result 'timeout'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- The unit mysql.service has entered the 'failed' state with result 'timeout'.
Mar 17 21:34:55 root systemd[1]: Failed to start MySQL Community Server.
-- Subject: A start job for unit mysql.service has failed
 
排查 步骤:
1. 查看 mysql 错误日志 
sudo cat /var/log/mysql/error.log | tail -n 100
或者
sudo cat /var/log/mysql/[主机名称].err | tail -n 100
 
2. 如果没有任何报错Error 那看一下磁盘剩余
df -h
 
3. 启动时, 查看 内存使用,如果 启动时到一定额度不能正常启动就要看一下磁盘使用情况。
 
删除磁盘部分不需要的内容后  ,再次启动即可。
 

学习www.网for站asp制.cn作

·上一篇:mysql show processlist >>    ·下一篇:mysql同步错误Coordinator stopped because there wer >>
推荐文章
最新文章