Bug #4596 MySQL blocking ACPI suspend
Submitted: 18 Jul 2004 14:36 Modified: 25 Sep 2004 15:43
Reporter: Christian Hammers (Silver Quality Contributor) (OCA) Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.20 OS:Linux (Debian GNU/Linux)
Assigned to: Lenz Grimmer CPU Architecture:Any

[18 Jul 2004 14:36] Christian Hammers
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
[16 Aug 2004 18:42] [ name withheld ]
Found the same behaviour.
[16 Aug 2004 18:43] [ name withheld ]
Found the same behaviour.

Was discussed and confirmed by several people at linux-thinkpad mailing list, too.
[1 Sep 2004 15:11] Alexander Keremidarski
I experince the same on Fedora so its general issue with ACPI daemon
[6 Sep 2004 1:53] Eduardo Robles
I can also confirm this annoying bug in SuSE 9.1 Professional.
[25 Sep 2004 15:43] Lenz Grimmer
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.
[25 Sep 2004 15:44] Lenz Grimmer
Patch for signal.c to work around the kernel hang during suspend

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