Debian Bug report logs - #259745
mysql-server: Can not ACPI suspend with MySQL running

Toggle useless messages

Message #5 received at submit@bugs.debian.org (full text, mbox):

From: Loic Minier <lool@dooz.org>
To: Debian Bug Tracking System <submit@bugs.debian.org>
Subject: mysql-server: Can not ACPI suspend with MySQL running
Date: Fri, 16 Jul 2004 16:09:07 +0200

Package: mysql-server
Version: 4.0.20-3
Severity: minor

   Hi,

 Trying to suspend my laptop with ACPI fails because of MySQL, extract
 of syslog:
 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$

 Stopping MySQL permits me to suspend further.

 I am using 2.6.8-rc1-mm1, and I've found the relevant code to be in
 kernel/power/process.c, and I couldn't do much better than this grep,
 sorry.

 I believe this is due to some task/thread flag, or some signal handling
 of mysqld.

 I have no idea how I can help you solve this, sorry again.

-- System Information:
Debian Release: testing/unstable
  APT prefers unstable
  APT policy: (500, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.8-rc1-mm1-bee-1
Locale: LANG=fr_FR@euro, LC_CTYPE=fr_FR@euro

Versions of packages mysql-server depends on:
ii  adduser                     3.57         Add and remove users and groups
ii  debconf                     1.4.29       Debian configuration management sy
ii  libc6                       2.3.2.ds1-13 GNU C Library: Shared libraries an
ii  libdbi-perl                 1.42-3       The Perl5 Database Interface by Ti
ii  libgcc1                     1:3.3.4-3    GCC support library
ii  libmysqlclient12            4.0.20-3     mysql database client library
ii  libssl0.9.7                 0.9.7d-4     SSL shared libraries
ii  libstdc++5                  1:3.3.4-3    The GNU Standard C++ Library v3
ii  libwrap0                    7.6.dbs-4    Wietse Venema's TCP wrappers libra
ii  mysql-client                4.0.20-3     mysql database client binaries
ii  passwd                      1:4.0.3-29   Change and administer password and
ii  perl                        5.8.4-2      Larry Wall's Practical Extraction 
ii  psmisc                      21.5-1       Utilities that use the proc filesy
ii  zlib1g                      1:1.2.1.1-5  compression library - runtime

-- debconf information:
* mysql-server/start_on_boot: true
* mysql-server/mysql_install_db_notes:
  mysql-server/nis_warning:
* mysql-server/postrm_remove_database: false

   Regards,

-- 
Loïc Minier <lool@dooz.org>

Message #10 received at 259745@bugs.debian.org (full text, mbox):

From: Christian Hammers <ch@debian.org>
To: Loic Minier <lool@dooz.org>, 259745@bugs.debian.org
Subject: Re: Bug#259745: mysql-server: Can not ACPI suspend with MySQL
 running
Date: Fri, 16 Jul 2004 16:49:30 +0200

[Message part 1 (text/plain, inline)]

Hello Loic

On 2004-07-16 Loic Minier wrote:
>  I am using 2.6.8-rc1-mm1, and I've found the relevant code to be in
>  kernel/power/process.c, and I couldn't do much better than this grep,
>  sorry.
> 
>  I believe this is due to some task/thread flag, or some signal handling
>  of mysqld.
> 
>  I have no idea how I can help you solve this, sorry again.

Well, sadly, I have neither. :-(
You could try to ask on the general mysql mailing list (see www.mysql.com).
I could try to file a bug at www.mysql.com, but writing on the list would have
the benefit that other users might help you, too. If it gives useful
information you should add the acpid config and parts of your .config
kernel configuration, too.

bye,

-christian-

[Message part 2 (application/pgp-signature, inline)]

Message #15 received at 259745@bugs.debian.org (full text, mbox):

From: Loic Minier <lool@dooz.org>
To: Christian Hammers <ch@debian.org>
Cc: 259745@bugs.debian.org
Subject: Re: Bug#259745: mysql-server: Can not ACPI suspend with MySQL running
Date: Sun, 18 Jul 2004 10:21:34 +0200

Christian Hammers <ch@debian.org> - Fri, Jul 16, 2004:

> I could try to file a bug at www.mysql.com, but writing on the list would have
> the benefit that other users might help you, too. If it gives useful
> information you should add the acpid config and parts of your .config
> kernel configuration, too.

 I have reported it[1] in the MySQL General Discussion mailing list.  It
 seems others[2] have the same problem.
   I couldn't submit a bug at mysql.com myself, probably because of
 restricted access, or simply because I didn't find where.

   Regards,

[1] <http://lists.mysql.com/mysql/169221>
[2] <http://lists.mysql.com/mysql/169222>

-- 
Loïc Minier <lool@dooz.org>

Message #24 received at 259745@bugs.debian.org (full text, mbox):

From: Christian Hammers <ch@debian.org>
To: 259745@bugs.debian.org, 259745-submitter@bugs.debian.org
Cc: control@bugs.debian.org
Subject: ACPI bug in kernel
Date: Sat, 25 Sep 2004 18:22:40 +0200

[Message part 1 (text/plain, inline)]

reassign 259745 kernel-source-2.6
tags 259745 + upstream
thanks

Hello

The ACPI problem reported against the mysql-server package seems to be caused
by a kernel bug. Read attached mail from MySQL.

bye,

-christian-

[Message part 2 (message/rfc822, inline)]

From: Bug Database <dev-bugs@mysql.com>
To: ch@debian.org
Subject: Bug #4596 [Ver->!Bg]: MySQL blocking ACPI suspend
Date: 25 Sep 2004 15:43:02 -0000

ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at
http://bugs.mysql.com/?id=4596&edit=2


 ID:               4596
 Updated by:       Lenz Grimmer
 Reported by:      Christian Hammers
 User Type:        User
-Status:           Verified
+Status:           Not a Bug
 Priority:         Low
 Severity:         Non-critical
 Category:         Server
 Operating System: Debian GNU/Linux
 Version:          4.0.20
 Assigned To:      lenz@mysql.com
 New Comment:

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.


Previous Comments:
------------------------------------------------------------------------

[2004-09-05 16:53:10] Eduardo Robles

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

------------------------------------------------------------------------

[2004-09-01 06:11:13] Alexander Keremidarski

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

------------------------------------------------------------------------

[2004-08-16 09:43:00] name withheld

Found the same behaviour.

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

------------------------------------------------------------------------

[2004-08-16 09:42:08] name withheld

Found the same behaviour.

------------------------------------------------------------------------

[2004-07-18 05:36:31] 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

------------------------------------------------------------------------

[Message part 3 (application/pgp-signature, inline)]

Message #38 received at 259745@bugs.debian.org (full text, mbox):

From: maximilian attems <maks@debian.org>
To: control@bugs.debian.org
Cc: 259745@bugs.debian.org
Subject: closing 259745
Date: Mon, 17 Sep 2007 19:47:42 +0200

# Automatically generated email from bts, devscripts version 2.10.7
# fixed some time ago
close 259745 

Message #43 received at 259745-submitter@bugs.debian.org (full text, mbox):

From: maximilian attems <max@stro.at>
To: undisclosed-recipients: ;
Subject: mass closing old kernel bugs
Date: Tue, 18 Sep 2007 14:28:39 +0200

thank you for submitting a bug report concerning the debian kernel.
In a cleanup run on old kernel bugs your report has been closed,
as either it is fixed or presumed to be fixed on a newer version.
old sata or intel board bugs can be assumed to work. 

if you can still reproduce the trouble just scream and the bug will
be reopened. it is very usefull if you still have the trouble to try
out the latest trunk version that just installs fine in etch/lenny/sid:
see trunk apt lines for 2.6.23-rc5 and bug reporting
-> http://wiki.debian.org/DebianKernel
-> http://wiki.debian.org/DebianKernelReportingBugs

best regards

-- 
maks





-- 
maks

Send a report that this bug log contains spam.