[Bug 326768] Re: mysqld_safe thinks mysqld has crashed when it hasn't

[Mario Limonciello]

There are two problems at stake here actually:

1) something is sending HUP to mysqld_safe.  That's not been determined
yet.  Clearly it's some root process that is doing it.  It can't be
mythbackend because it doesn't run as root.

2) mysqld_safe is not properly handling the HUP.   When the trap goes off,
it's supposed to mearly send a refresh command to mysqld.  Here's what's
actually happening:

1) essentially, "mysqld & wait" is running
So mysqld is running in the background, and the bash script is blocked by
the wait command.
2) the trap comes in and causes wait to exit status 128
3) the refresh is issued to mysqld
3) the bash script continues and runs kill -9 mysqld

So, the logic that's INTENDED by the patch isn't working.

On Thu, May 7, 2009 at 14:14, Mathias Gug <mathiaz at ubuntu.com> wrote:

> Thanks for taking to prepare a debdiff and conduct some testing. However
> I'm not comfortable with releasing an update that changes the signal
> handling, especially removing one.
>
> I'd like to understand *why* is mysqld crashing in the first place. It
> seems that mythbackend is making mysqld crash. Could you enable the
> general query log (http://dev.mysql.com/doc/refman/5.0/en/query-
> log.html <http://dev.mysql.com/doc/refman/5.0/en/query-%0Alog.html>) and
> try to figure out which SQL statement makes the daemon
> crash?
>
> If the proposed debdiff fixes the issue it means that something during
> the boot process sends a HUP signal to the mysql_safe process. I'd like
> to figure out what is sending the HUP signal to mysql_safe.
>
> ** Changed in: mysql-dfsg-5.0 (Ubuntu Jaunty)
>        Status: Fix Committed => Confirmed
>
> ** Tags removed: verification-needed
>
> --
> mysqld_safe thinks mysqld has crashed when it hasn't
> https://bugs.launchpad.net/bugs/326768
> You received this bug notification because you are a member of Mythbuntu
> Developers, which is subscribed to Mythbuntu.
>


-- 
Mario Limonciello
superm1 at gmail.com

-- 
mysqld_safe thinks mysqld has crashed when it hasn't
https://bugs.launchpad.net/bugs/326768
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.