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:
