Bug #4596 MySQL blocking ACPI suspend

Description:
The following bug was filed to the Debian Bug Reporting System by
  Loïc Minier <lool@dooz.org>
and is visible at
  <http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=259745>
He also reported it to the MySQL general mailing list where others experiented the bug, too:
  <http://lists.mysql.com/mysql/169221>
  <http://lists.mysql.com/mysql/169222>

-christian-
    
------------------------

It seems that MySQL blocks the attempts made by the kernel to suspend
 with ACPI.

 This is what syslog has to say:

 Jul 16 15:56:41 bee kernel: PM: Preparing system for suspend
 Jul 16 15:56:49 bee kernel: Stopping tasks:
 ==========================================================================================================
 Jul 16 15:56:49 bee kernel:  stopping tasks failed (1 tasks remaining)
 Jul 16 15:56:49 bee kernel: Restarting tasks...<6> Strange, mysqld not
 stopped
 Jul 16 15:56:49 bee kernel:  done

 If I stop MySQL before suspending, I won't get this error.

How to repeat:
Use acipd, kernel 2.6 and suspend feature. Please contact Loic for further information.

Suggested fix:
none

Found the same behaviour.

Found the same behaviour.

Was discussed and confirmed by several people at linux-thinkpad mailing list, too.

I experince the same on Fedora so its general issue with ACPI daemon

I can also confirm this annoying bug in SuSE 9.1 Professional.

We were also able to reproduce this bug on SUSE Linux 9.1 and filed a bug at the SUSE Bugzilla about it (#45953, if you have access to the SUSE Bugs DB). Pavel Machek of SUSE acknowledged it as a kernel bug and came up with a patch (see attachement) against the latest SUSE 2.6.8 kernel. There is not much we can do about this until this fix has been applied upstream - for now, I will resolve this bug as "Not a bug" (on our end).

As a workaround, it is possible to configure the ACPI subsystem to shut down certain processes before performing the suspend - simply make sure that "mysqld" is one of them.

Patch for signal.c to work around the kernel hang during suspend

Attachment: signal.c.patch (text/x-patch), 558 bytes.