Package: mysql-server
Version: 9.7.2-1
Followup-For: Bug #1142408
X-Debbugs-Cc: [email protected]
Dear Maintainer,
I upgraded mysql from 8.0.46-1 to 9.7.2-1 on an Unstable server running
Mediawiki. This installation dates back to 2007.
I can confirm I ran into the "no upgrade path" issue reported in this
bug. Five hours later (following any number of unsound decisions on my
part, including installing the mysql-community-8.0 packages from the
MySQL upstream), I was able to get my database running again by building
the 8.0 packages from source, installing them, and restoring a backup of
my /var/lib/mysql taken before the update. This was obviously
undesirable.
I couldn't simply reinstall the 8.0 packages, since those are no longer
in the archive. Once I rebuilt them, though, that sufficed.
I ran into two other problems prior to exposing this one:
- 9.7 refused to start, complaining about an unknown command line option
character_set=utf8. To eliminate this, I commented out some
"character_set_server=utf8" and "collation_server=utf8_unicode_ci"
lines that had been in my my.cnf for well over a decade, and
apparently had been ignored for at least one major release cycle.
- 9.7 failed to start complaining about "error 22 on posix_fallocate()
when reserving space for [some file]." To get around this, I had to
enable extents and dir_index on the underlying ext3 filesystem with:
tune2fs -O extents,dir_index /dev/sda
After doing this, I no longer saw the error.
So you might want NEWS entries regarding those two issues. Obviously the
"no upgrade path" is the more severe problem.
-- System Information:
Debian Release: forky/sid
APT prefers unstable
APT policy: (990, 'unstable')
Architecture: amd64 (x86_64)
Kernel: Linux 7.0.5-x86_64-linode173 (SMP w/4 CPU threads; PREEMPT)
Kernel taint flags: TAINT_WARN
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages mysql-server depends on:
ii debconf [debconf-2.0] 1.5.92
ii mysql-client 8.0.46-1
ii mysql-common 5.8+1.1.1
ih mysql-server-8.0 8.0.46-1
pn mysql-server-core <none>
ii passwd 1:4.19.3-2
ii perl 5.42.2-3
ii psmisc 23.7-2
ii systemd [systemd-sysusers] 261.2-1
Versions of packages mysql-server recommends:
pn libhtml-template-perl <none>
pn mecab-ipadic-utf <none>
mysql-server suggests no packages.
