[debian-mysql] Bug#418685: mysql-server-5.0: /etc/init.d/mysql stop fails - does not wait a few seconds

[Lubomir Host]

Package: mysql-server-5.0
Version: 5.0.51a-24+lenny2
Followup-For: Bug #418685


'/etc/init.d/mysql stop' fails when mysql shutdown takes ~3 seconds to
complete:

090903 21:53:40 [Note] /usr/sbin/mysqld: Normal shutdown

090903 21:53:40 [Note] Slave I/O thread killed while reading event
090903 21:53:40 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000820', position 70246536
090903 21:53:40 [Note] Error reading relay log event: slave SQL thread was killed
090903 21:53:40  InnoDB: Starting shutdown...
090903 21:53:43  InnoDB: Shutdown completed; log sequence number 2 1239585845
090903 21:53:43 [Note] /usr/sbin/mysqld: Shutdown complete

22:07 root at Apollo [/etc/mysql] ##: /usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping ; /etc/init.d/mysql stop; /usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping
mysqld is alive
Stopping MySQL database server: mysqld failed!
/usr/bin/mysqladmin: connect to server at '127.0.0.1' failed
error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 111'

Command above fails, but mysql is correctly stopped. Here is a quick
workaround how to fix this issue:

22:08 root at Apollo [/etc/mysql] ##: diff -u /etc/init.d/mysql.orig /etc/init.d/mysql
--- /etc/init.d/mysql.orig      2009-09-03 21:53:13.695739703 +0200
+++ /etc/init.d/mysql   2009-09-03 22:08:05.740062997 +0200
@@ -139,6 +139,7 @@
          set +e
          shutdown_out=`$MYADMIN shutdown 2>&1`; r=$?
          set -e
+         sleep 5;
          if [ "$r" -ne 0 ]; then
            log_end_msg 1
            [ "$VERBOSE" != "no" ] && log_failure_msg "Error: $shutdown_out"

But it is not a good idea to add sleep command into init script.

Best regards,
Lubomir Host

-- System Information:
Debian Release: 5.0.2
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 2.6.26-2-686 (SMP w/2 CPU cores)
Locale: LANG=C, LC_CTYPE=sk_SK.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server-5.0 depends on:
ii  adduser                3.110             add and remove users and groups
ii  debconf [debconf-2.0]  1.5.24            Debian configuration management sy
ii  libc6                  2.7-18            GNU C Library: Shared libraries
ii  libdbi-perl            1.605-1           Perl5 database interface by Tim Bu
ii  libgcc1                1:4.3.2-1.1       GCC support library
ii  libmysqlclient15off    5.0.51a-24+lenny2 MySQL database client library
ii  libncurses5            5.7+20081213-1    shared libraries for terminal hand
ii  libreadline5           5.2-3.1           GNU readline and history libraries
ii  libstdc++6             4.3.2-1.1         The GNU Standard C++ Library v3
ii  libwrap0               7.6.q-16          Wietse Venema's TCP wrappers libra
ii  lsb-base               3.2-20            Linux Standard Base 3.2 init scrip
ii  mysql-client-5.0       5.0.51a-24+lenny2 MySQL database client binaries
ii  mysql-common           5.0.51a-24+lenny2 MySQL database common files
ii  passwd                 1:4.1.1-6         change and administer password and
ii  perl                   5.10.0-19         Larry Wall's Practical Extraction 
ii  psmisc                 22.6-1            Utilities that use the proc filesy
ii  zlib1g                 1:1.2.3.3.dfsg-12 compression library - runtime

Versions of packages mysql-server-5.0 recommends:
ii  bsd-mailx [mailx]  8.1.2-0.20071201cvs-3 A simple mail user agent
ii  libhtml-template-p 2.9-1                 HTML::Template : A module for usin

Versions of packages mysql-server-5.0 suggests:
pn  tinyca                        <none>     (no description available)

-- debconf information:
* mysql-server/root_password_again: (password omitted)
* mysql-server/root_password: (password omitted)
  mysql-server-5.0/really_downgrade: false
  mysql-server-5.0/need_sarge_compat: false
  mysql-server-5.0/start_on_boot: true
  mysql-server/error_setting_password:
  mysql-server-5.0/nis_warning:
  mysql-server-5.0/postrm_remove_databases: false
  mysql-server-5.0/need_sarge_compat_done: true
  mysql-server/password_mismatch: