[debian-mysql] Bug#838190: mysql-server-5.5: Troubles starting MySQL during and after security update

[Olaf van der Spek]

Package: mysql-server-5.5
Version: 5.5.52-0+deb8u1
Severity: normal

Dear Maintainer,

The problem didn't happen on all systems and I'm not sure what exactly is going wrong. During a apt-get upgrade run MySQL failed to upgrade..
Some weird stuff:

syslog:
mysqld_safe[22411]: 160918 10:22:05 [Note] /usr/sbin/mysqld (mysqld 5.5.52-0+deb7u1-log) starting as process 22431 ...
mysqld_safe[22411]: 160918 10:22:05 [Note] /usr/sbin/mysqld (mysqld 5.5.52-0+deb7u1-log) starting as process 22445 ...

Why is it trying to start twice as two different processes?

mysqld_safe[22580]: ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
mysqld_safe[22580]: 160918 10:22:08 [ERROR] Aborting

mysqld_safe[13729]: ERROR: 1050  Table 'plugin' already exists

I now ran MySQL manually by executing mysqld but I'd like to solve this properly.

Gr,
Olaf


-- System Information:
Debian Release: 8.6
  APT prefers stable
  APT policy: (500, 'stable'), (1, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 3.16.0-4-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_GB, LC_CTYPE=en_GB (charmap=ISO-8859-1)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages mysql-server-5.5 depends on:
ii  adduser                3.113+nmu3
ii  debconf [debconf-2.0]  1.5.56
ii  initscripts            2.88dsf-59
ii  libc6                  2.19-18+deb8u6
ii  libdbi-perl            1.631-3+b1
ii  libgcc1                1:4.9.2-10
ii  libstdc++6             4.9.2-10
ii  lsb-base               4.1+Debian13+nmu1
ii  mysql-client-5.5       5.5.52-0+deb8u1
ii  mysql-common           5.5.52-0+deb8u1
ii  mysql-server-core-5.5  5.5.52-0+deb8u1
ii  passwd                 1:4.2-3+deb8u1
ii  perl                   5.20.2-3+deb8u6
ii  psmisc                 22.21-2
ii  zlib1g                 1:1.2.8.dfsg-2+b1

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

Versions of packages mysql-server-5.5 suggests:
ii  heirloom-mailx [mailx]  12.5-4
pn  tinyca                  <none>

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