[debian-mysql] Bug#739708: mysql-server-5.5: Broken /etc/init.d/mysql conffile handling

[Bob Proulx]

Package: mysql-server-5.5
Version: 5.5.35+dfsg-2
Severity: normal

The daily upgrade of Sid brought in the latest mysql-server-5.5 which
prompted for a change in /etc/init.d/mysql.

  -Configuration file '/etc/init.d/mysql'
   ==> Modified (by you or by a script) since installation.
   ==> Package distributor has shipped an updated version.
     What would you like to do about it ?  Your options are:
      Y or I  : install the package maintainer's version
      N or O  : keep your currently-installed version
        D     : show the differences between the versions
        Z     : start a shell to examine the situation
   The default action is to keep your current version.
  *** mysql (Y/I/N/O/D/Z) [default=N] ? Y

However that file has no local modifications.  It is the stock file
from version 5.5.35+dfsg-1.  There were no local changes.

--- /etc/init.d/mysql   2013-12-29 17:59:05.401201931 -0700
+++ /etc/init.d/mysql.dpkg-new  2014-02-18 12:13:59.000000000 -0700
@@ -109,7 +109,8 @@
            /usr/bin/mysqld_safe > /dev/null 2>&1 &
 
            # 6s was reported in #352070 to be too few when using ndbcluster
-           for i in 1 2 3 4 5 6 7 8 9 10 11 12 13 14; do
+        # 14s was reported in #736452 to be too few with large installs
+        for i in $(seq 1 30); do
                 sleep 1
                if mysqld_status check_alive nowarn ; then break; fi
                log_progress_msg "."
@@ -119,7 +120,6 @@
                # Now start mysqlcheck or whatever the admin wants.
                output=$(/etc/mysql/debian-start)
                [ -n "$output" ] && log_action_msg "$output"
-               : "ensure $? is 0"
            else
                log_end_msg 1
                log_failure_msg "Please take a look at the syslog"
@@ -186,4 +186,3 @@
        ;;
 esac
 
-exit 0

The /var/log/dpkg.log file shows this upgrade transition.

  2014-02-21 10:04:09 upgrade mysql-server-5.5:amd64 5.5.35+dfsg-1 5.5.35+dfsg-2

I think something is broken in the conffile handling of this file.

Thanks!
Bob


-- System Information:
Debian Release: jessie/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 3.12-1-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages mysql-server-5.5 depends on:
ii  adduser                3.113+nmu3
ii  debconf [debconf-2.0]  1.5.52
ii  initscripts            2.88dsf-51
ii  libc6                  2.18-1
ii  libdbi-perl            1.631-1
ii  libgcc1                1:4.8.2-16
ii  libstdc++6             4.8.2-16
ii  lsb-base               4.1+Debian12
iu  mysql-client-5.5       5.5.35+dfsg-2
ii  mysql-common           5.5.35+dfsg-2
iu  mysql-server-core-5.5  5.5.35+dfsg-2
ii  passwd                 1:4.1.5.1-1
ii  perl                   5.18.2-2
ii  psmisc                 22.21-1
ii  zlib1g                 1:1.2.8.dfsg-1

Versions of packages mysql-server-5.5 recommends:
ii  libhtml-template-perl  2.95-1

Versions of packages mysql-server-5.5 suggests:
ii  bsd-mailx [mailx]  8.1.2-0.20131005cvs-1
pn  tinyca             <none>

-- Configuration Files:
/etc/apparmor.d/usr.sbin.mysqld [Errno 2] No such file or directory: u'/etc/apparmor.d/usr.sbin.mysqld'
/etc/init.d/mysql changed [not included]
/etc/logcheck/ignore.d.paranoid/mysql-server-5_5 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.paranoid/mysql-server-5_5'
/etc/logcheck/ignore.d.server/mysql-server-5_5 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.server/mysql-server-5_5'
/etc/logcheck/ignore.d.workstation/mysql-server-5_5 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.workstation/mysql-server-5_5'
/etc/mysql/debian-start changed [not included]

-- debconf information:
  mysql-server-5.5/nis_warning:
  mysql-server/error_setting_password:
  mysql-server/no_upgrade_when_using_ndb:
  mysql-server-5.5/really_downgrade: false
  mysql-server/password_mismatch:
  mysql-server-5.5/start_on_boot: true
  mysql-server-5.5/postrm_remove_databases: false