服务 mysql 在 ubuntu 上启动失败

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/8437600/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-31 21:58:28  来源:igfitidea点击:

service mysql start failed on ubuntu

mysqlubuntuservicemysql5

提问by eistrati

Here is my dilemma (somehow similar to this resourceand I tried everything, but nothing helped):

这是我的困境(某种程度上类似于这个资源,我尝试了一切,但没有任何帮助):

root@vuxomys01:~# service mysql status
mysql start/running

When I'm looking for the process:

当我在寻找过程时:

root@vuxomys01:~# ps ax | grep mysql
2263 pts/0    S+     0:00 grep --color=auto mysql

I checked the logs and /var/log/mysql/error.logis empty, but there is weird stuff in /var/log/syslog...

我检查了日志并且/var/log/mysql/error.log是空的,但是里面有奇怪的东西/var/log/syslog......

root@vuxomys01:~# grep mysql /var/log/syslog
...
Dec  8 15:24:17 vuxomys01 init: mysql post-start process (1963) terminated with status 1
Dec  8 15:24:17 vuxomys01 kernel: [  460.182640] type=1505 audit(1323375857.580:28):  operation="profile_replace" pid=2098 name="/usr/sbin/mysqld"
Dec  8 15:24:17 vuxomys01 init: mysql main process (2102) terminated with status 1
Dec  8 15:24:17 vuxomys01 init: mysql main process ended, respawning
Dec  8 15:24:47 vuxomys01 init: mysql post-start process (2103) terminated with status 1

... and /var/log/daemon.log

... 和 /var/log/daemon.log

root@vuxomys01:~# grep mysql /var/log/daemon.log
...
Dec  8 15:24:17 vuxomys01 init: mysql post-start process (1963) terminated with status 1
Dec  8 15:24:17 vuxomys01 init: mysql main process (2102) terminated with status 1
Dec  8 15:24:17 vuxomys01 init: mysql main process ended, respawning
Dec  8 15:24:47 vuxomys01 init: mysql post-start process (2103) terminated with status 1

Any other ideas would be really appreciated. Thanks in advance!

任何其他想法将不胜感激。提前致谢!

  • Eugene.
  • 尤金。

回答by amrfaissal

I think you have an infinite loop in the post-start script due to an incomplete migration of MySQL. Check this thread, i'm sure the solution is there.

我认为由于 MySQL 的迁移不完整,您在启动后脚本中有一个无限循环。检查此线程,我确定解决方案在那里。