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 <math...@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 supe...@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. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs