mysqld.service holdoff time over, scheduling restart.

本文介绍了在CentOS 7.4环境下使用MySQL 5.7.17时遇到的启动错误问题及其解决办法。主要原因是MySQL的数据存储路径发生变动但配置文件中未同步更新,导致启动失败。文中提供了两种解决方案:一是更改配置文件中的路径设置;二是保留原有的数据路径。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

环境:
centos7.4 + mysql5.7.17
启动mysql报错:
mysqld.service holdoff time over, scheduling restart.
报错原因:
MySQL的配置文件里变更了数据存储路径,将/var/lib/mysql的整个目录mv到/opt/lib/下,但是配置文件里的sock文件的路径和pid文件的路径没有改动,仍然是/var/lib/mysql,但是此时/var/lib/下已经没有mysql目录了,所以启动报错
解决:
方案一:将配置文件/etc/my.cnf里的sock等路径更改为跟数据存储路径一致,即从/var/lib/mysql改为/opt/lib/mysql
方案二:配置文件里的sock等路径不变,确保/var/lib/mysql还存在,并且属主属组依然为mysql

-- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 16:01:55 localhost.localdomain mysql-systemd-start[12907]: 2025-06-19 16:01:55 0 [Note] / usr/sbin/mysqld (mysqld 5.6.51) starting as process 12930 ... 6月 19 16:01:55 localhost.localdomain mysql-systemd-start[12907]: 2025-06-19 16:01:55 12930 [Not e] /usr/sbin/mysqld: Shutdown complete 6月 19 16:01:55 localhost.localdomain mysql-systemd-start[12907]: 2025-06-19 16:01:55 0 [Note] / usr/sbin/mysqld (mysqld 5.6.51) starting as process 12941 ... 6月 19 16:01:55 localhost.localdomain mysql-systemd-start[12907]: 2025-06-19 16:01:55 12941 [Not e] /usr/sbin/mysqld: Shutdown complete 6月 19 16:01:55 localhost.localdomain mysql-systemd-start[12907]: --defaults-file argument to my sqld_safe when starting the server 6月 19 16:01:56 localhost.localdomain mysqld_safe[12953]: 250619 16:01:56 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 16:01:56 localhost.localdomain mysqld_safe[12953]: 250619 16:01:56 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 16:01:56 localhost.localdomain mysqld_safe[12953]: 250619 16:01:56 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended 6月 19 16:11:55 localhost.localdomain systemd[1]: mysqld.service start-post operation timed out. Stopping. -- Subject: Unit mysqld.service has failed -- Unit mysqld.service has failed. 6月 19 16:11:55 localhost.localdomain systemd[1]: Unit mysqld.service entered failed state. 6月 19 16:11:55 localhost.localdomain systemd[1]: mysqld.service failed. 6月 19 16:11:56 localhost.localdomain systemd[1]: mysqld.service holdoff time over, scheduling r estart. -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 16:11:56 localhost.localdomain mysqld_safe[19213]: 250619 16:11:56 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 16:11:56 localhost.localdomain mysqld_safe[19213]: 250619 16:11:56 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 16:11:57 localhost.localdomain mysqld_safe[19213]: 250619 16:11:57 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 16:23:58 localhost.localdomain mysql-systemd-start[27149]: 2025-06-19 16:23:58 0 [Note] / usr/sbin/mysqld (mysqld 5.6.51) starting as process 27165 ... 6月 19 16:24:00 localhost.localdomain mysql-systemd-start[27149]: 2025-06-19 16:24:00 0 [Note] / usr/sbin/mysqld (mysqld 5.6.51) starting as process 27201 ... 6月 19 16:24:02 localhost.localdomain mysql-systemd-start[27149]: --defaults-file argument to my sqld_safe when starting the server 6月 19 16:24:03 localhost.localdomain mysqld_safe[27239]: 250619 16:24:03 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 16:24:03 localhost.localdomain mysqld_safe[27239]: 250619 16:24:03 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql -- Subject: Unit mysqld.service has finished start-up -- Unit mysqld.service has finished starting up. -- Subject: Unit mysqld.service has begun shutting down -- Unit mysqld.service has begun shutting down. 6月 19 16:42:34 localhost.localdomain mysqld_safe[27239]: 250619 16:42:34 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 16:42:35 localhost.localdomain mysqld_safe[35199]: 250619 16:42:35 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 16:42:35 localhost.localdomain mysqld_safe[35199]: 250619 16:42:35 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql -- Subject: Unit mysqld.service has finished start-up -- Unit mysqld.service has finished starting up. 6月 19 17:22:37 localhost.localdomain sudo[52110]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl restart mysqld -- Subject: Unit mysqld.service has begun shutting down -- Unit mysqld.service has begun shutting down. 6月 19 17:22:38 localhost.localdomain mysqld_safe[35199]: 250619 17:22:38 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 17:22:39 localhost.localdomain mysqld_safe[52143]: 250619 17:22:39 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 17:22:39 localhost.localdomain mysqld_safe[52143]: 250619 17:22:39 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 17:22:41 localhost.localdomain mysqld_safe[52143]: 250619 17:22:41 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended 6月 19 17:23:26 localhost.localdomain sudo[52851]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl restart mysqld -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 17:23:26 localhost.localdomain mysqld_safe[52874]: 250619 17:23:26 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 17:23:26 localhost.localdomain mysqld_safe[52874]: 250619 17:23:26 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 17:23:28 localhost.localdomain mysqld_safe[52874]: 250619 17:23:28 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 17:24:11 localhost.localdomain mysqld_safe[53592]: 250619 17:24:11 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 17:24:11 localhost.localdomain mysqld_safe[53592]: 250619 17:24:11 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 17:24:14 localhost.localdomain mysqld_safe[53592]: 250619 17:24:14 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended 6月 19 17:25:12 localhost.localdomain systemd[1]: mysqld.service: control process exited, code=k illed status=9 -- Subject: Unit mysqld.service has failed -- Unit mysqld.service has failed. 6月 19 17:25:12 localhost.localdomain systemd[1]: Unit mysqld.service entered failed state. 6月 19 17:25:12 localhost.localdomain systemd[1]: mysqld.service failed. 6月 19 17:25:12 localhost.localdomain systemd[1]: mysqld.service holdoff time over, scheduling r estart. -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 17:25:13 localhost.localdomain mysqld_safe[54465]: 250619 17:25:13 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 17:25:13 localhost.localdomain mysqld_safe[54465]: 250619 17:25:13 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 17:25:15 localhost.localdomain mysqld_safe[54465]: 250619 17:25:15 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended 6月 19 17:25:34 localhost.localdomain sudo[54929]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl restart mysqld -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 17:25:34 localhost.localdomain mysqld_safe[54953]: 250619 17:25:34 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 17:25:34 localhost.localdomain mysqld_safe[54953]: 250619 17:25:34 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 17:25:36 localhost.localdomain mysqld_safe[54953]: 250619 17:25:36 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended 6月 19 17:26:42 localhost.localdomain sudo[55901]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/pkill -9 mysqld 6月 19 17:26:49 localhost.localdomain sudo[55973]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/mysqld_safe --defaults-file=/etc/my.cnf 6月 19 17:31:13 localhost.localdomain sudo[58906]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl status mysqld 6月 19 17:33:49 localhost.localdomain sudo[60461]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl status mysqld 6月 19 17:33:59 localhost.localdomain sudo[60563]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/sbin/service mysqld status 6月 19 17:34:08 localhost.localdomain sudo[60663]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl start mysqld 6月 19 17:34:32 localhost.localdomain sudo[60935]: root : TTY=pts/0 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl start mysqld 6月 19 17:34:50 localhost.localdomain sudo[61150]: root : TTY=pts/0 ; PWD=/root ; USER=root ; COMMAND=/sbin/service mysqld status 6月 19 17:35:34 localhost.localdomain systemd[1]: mysqld.service start-post operation timed out. Stopping. -- Subject: Unit mysqld.service has failed -- Unit mysqld.service has failed. 6月 19 17:35:34 localhost.localdomain systemd[1]: Unit mysqld.service entered failed state. 6月 19 17:35:34 localhost.localdomain systemd[1]: mysqld.service failed. 6月 19 17:35:34 localhost.localdomain systemd[1]: mysqld.service holdoff time over, scheduling r estart. -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 17:35:35 localhost.localdomain mysqld_safe[61625]: 250619 17:35:35 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 17:35:35 localhost.localdomain mysqld_safe[61625]: 250619 17:35:35 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 17:35:37 localhost.localdomain mysqld_safe[61625]: 250619 17:35:37 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended
最新发布
06-20
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值