[debian-mysql] Bug#1004262: Bug#1004262: Bug#1004262: Acknowledgement (mariadb-server: Instead of being upgraded, mariadb-server gets removed after apt update)

[Faustin Lammler]

Hi!

I can still reproduce this with:

| ❯ podman run -it debian:11 bash -c "apt-get update && \
|   apt-get upgrade -y && \
|   apt-get -y install mariadb-server && \
|   echo 'deb http://deb.debian.org/debian sid main' >/etc/apt/sources.list && \
|   apt-get update && \
|   apt-get full-upgrade"
| ...
| The following packages were automatically installed and are no longer required:
|   libaio1 libffi7 libperl5.32 libsepol1 libssl1.1 perl-modules-5.32
| Use 'apt autoremove' to remove them.
| The following packages will be REMOVED:
|   libsemanage1 mariadb-client-10.5 mariadb-client-core-10.5 mariadb-server-10.5
|   mariadb-server-core-10.5
| The following NEW packages will be installed:
|   gcc-12-base libdaxctl1 libffi8 libkmod2 libndctl6 libnuma1 libperl5.34 libpmem1
|   libregexp-ipv6-perl libsemanage2 libsepol2 libssl3 liburing2 mariadb-client-10.6
|   mariadb-client-core-10.6 mariadb-server-10.6 mariadb-server-core-10.6 perl-modules-5.34
|   sensible-utils sgml-base util-linux-extra
| The following packages will be upgraded:
|   adduser apt base-files base-passwd bash bsdutils coreutils dash debconf debianutils diffutils dpkg
|   e2fsprogs findutils galera-4 gcc-10-base gcc-9-base gpgv grep gzip init-system-helpers iproute2
|   libacl1 libaio1 libapt-pkg6.0 libatm1 libattr1 libaudit-common libaudit1 libblkid1 libbpf0 libbsd0
|   libbz2-1.0 libc-bin libc6 libcap-ng0 libcgi-pm-perl libclone-perl libcom-err2 libcrypt1 libdb5.3
|   libdbd-mariadb-perl libdbi-perl libdebconfclient0 libedit2 libelf1 libencode-locale-perl
|   libext2fs2 libfcgi-perl libgcc-s1 libgcrypt20 libgdbm-compat4 libgdbm6 libgmp10 libgnutls30
|   libgpg-error0 libgpm2 libgssapi-krb5-2 libhogweed6 libhtml-parser-perl libhtml-template-perl
|   libhttp-message-perl libidn2-0 libio-html-perl libk5crypto3 libkeyutils1 libkrb5-3 libkrb5support0
|   liblzma5 libmariadb3 libmd0 libmount1 libncurses6 libncursesw6 libnettle8 libp11-kit0
|   libpam-modules libpam-modules-bin libpam-runtime libpam0g libpcre2-8-0 libpcre3 libperl5.32
|   libpopt0 libprocps8 libreadline8 libseccomp2 libselinux1 libsemanage-common libsigsegv2
|   libsmartcols1 libsnappy1v5 libss2 libssl1.1 libstdc++6 libsystemd0 libtasn1-6 libterm-readkey-perl
|   libtinfo6 libtirpc-common libtirpc3 libudev1 libunistring2 liburi-perl libuuid1 libxtables12
|   libxxhash0 libzstd1 login logsave lsb-base lsof mariadb-common mariadb-server mawk mount
|   mysql-common ncurses-base ncurses-bin passwd perl perl-base perl-modules-5.32 procps psmisc
|   readline-common rsync sed socat sysvinit-utils tzdata util-linux zlib1g
| 133 upgraded, 21 newly installed, 5 to remove and 0 not upgraded.
| Need to get 73.6 MB of archives.
| After this operation, 60.6 MB of additional disk space will be used.
| Do you want to continue? [Y/n]

Otto Kekäläinen <otto at debian.org>,
21/02/2022 – 23:10:00 (-0800):

> As part of our CI we run a Bullseye MariaDB 10.5 to Debian Sid MariaDB
> 10.6 upgrade on every commit. If passes correctly with:
>
> The following packages will be REMOVED:
>   mariadb-client-10.5 mariadb-client-core-10.5 mariadb-server-10.5
>   mariadb-server-core-10.5
> The following NEW packages will be installed:
>   libdaxctl1 libkmod2 libndctl6 libnuma1 libodbc2 libodbccr2 libpcre2-posix3
>   libpmem1 liburing2 mariadb-client-10.6 mariadb-client-core-10.6
>   mariadb-server-10.6 mariadb-server-core-10.6

Yes, this is also still true, but unfortunately it does not reproduce
exactly the problem IMO.

> To continue with solving this issue I would like to first get it
> reproduced in the CI. The root cause why we have an upgrade issue is
> that there is a scenario users can hit that is not covered by our CI.
> Fixing that would ensure proper testing coverage and forever working
> MariaDB upgrades.
So we should create a new step that would:
- install the produced package on Debian stable;
- full-upgrade to Debian testing;
- verify that mariadb-server was upgraded (and not removed).

@Otto, does that look like something good to have in the CI? I will
propose a MR then...

Cheers!

-- 
Faustin
-------------- 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/20220823/31a3df9b/attachment.sig>