service mysql start failed on ubuntu

Question

Here is my dilemma (somehow similar to this resource and 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.log is empty, but there is weird stuff in /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

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.

Answer 1

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.