[debian-mysql] Bug#988089: Bug#988089: Bug#988089: mariadb-server: MariaDB uninstalled on dist-upgrade Debian 10 -> 11

[Faustin Lammler]

Hi!

So, I also tried the apt debug commands but I could not find the exact
problem (this is also way too verbose for me ATM).

Here are some questions regarding galera (because I believe the problem
might come from it):
- why bullseye/sid provide both galera-3 and galera-4?
- why installing galera-4 removes mariadb-server-10.3, see bellow:
| docker run -it debian:10 bash -c \
|   "apt-get update \
|   && apt-get upgrade -y \
|   && apt-get install -y 'mariadb-server' \
|   && dpkg -l | egrep '(mariadb|mysql|galera)' \
|   && printf 'deb http://deb.debian.org/debian bullseye main' >/etc/apt/sources.list \
|   && apt-get clean \
|   && apt-get update \
|   && apt-get install galera-4 \
|   && dpkg -l | egrep '(mariadb|mysql|galera)'"

@Otto, I believe that the salsa CI did not catch this problem because we
are upgrading using the generated deb `apt install ./*.deb` and not
using a mirror and `apt-get full-upgrade` (and maybe because we are
explicitly asking apt to upgrade galera).

It would be good to also test a very common scenario where we install
only mariadb-server (and it's dependencies) and try to upgrade it using
the recommended Debian method (https://wiki.debian.org/DebianUpgrade). I
have no idea for the moment if this is easy to implement in the salsa CI
but I will do some tests.

Here is the snippet to reproduce the upgrade problem in docker:
| docker run -it debian:10 bash -c \
|   "apt-get update \
|   && apt-get upgrade -y \
|   && apt-get install -y 'mariadb-server' \
|   && dpkg -l | egrep '(mariadb|mysql|galera)' \
|   && printf 'deb http://deb.debian.org/debian bullseye main' >/etc/apt/sources.list \
|   && apt-get clean \
|   && apt-get update \
|   && apt-get full-upgrade -y \
|   && dpkg -l | egrep '(mariadb|mysql|galera)'"

Cheers!

-- 
Faustin Lammler
F652 BCD1 1AA8 8975 F010 48A5 390A 2F27 832A 5C79
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <http://alioth-lists.debian.net/pipermail/pkg-mysql-maint/attachments/20210512/ff14945b/attachment.sig>