Your message dated Mon, 17 Apr 2023 13:05:11 +0200
with message-id <[email protected]>
and subject line mysql-5.5 has been superseded by mariadb (and mysql-8.0)
has caused the Debian Bug report #838190,
regarding mysql-server-5.5: Troubles starting MySQL during and after security
update
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
838190: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=838190
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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:
--- End Message ---
--- Begin Message ---
Version: 5.5.46-0+deb8u1+rm
mysql-5.5 was last released with Debian 8 (jessie) in April 2015
and was removed from the Debian archive afterwards.
It has been superseded by mariadb (and mysql-8.0, but that does not get
into a stable release).
See https://bugs.debian.org/811158 for details on the removal.
I'm closing the remaining bug reports now.
Andreas
--- End Message ---
