Hi Otto,
was helping Sven with triaging, so bit more info what I did...
First I tried the pinning setup like Sven did, but as I'm not 100%
sure that my pinning works as intended, I also tried another approach
The base for those experiments was a buster pbuilder chroot with
mariadb installed manually and then adding sources for bullseye and testing.
After pinning so that only '*mariadb*' and '*mysql'* packages might be pulled
from testing, apt policy maradb-server showed me the version from testing is
candidate while all other packages are not pulled from testing.
However, apt dist-upgrade still thought the solution is to remove mysql-server...
As I am not 100% sure that I understood pinning correctly, I did another approach:
I've repbuilt the packge from testing for bullseye, kind of something that would be
good for stable-proposed-updates. Rebuild has been done in a bullseye pbuilder env
without any changes, as in:
apt source mariadb-10.5
DIST=bullseye pbuilder build mariadb-10.5_10.5.12-1.dsc
I've placed the resulting packages in a local apt repository; and then loged in into
an buster pbuilder chroot (DIST=buster pbuilder login)
There, I installed mariadb and then activated in sources.list the local repo and bullseye,
followed by apt dist-upgrade.
Unfortunatly, this also tries to remove mariadb-server:
root@isildor:/# apt dist-upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
The following packages were automatically installed and are no longer required:
iproute2 libaio1 libapt-inst2.0 libboost-iostreams1.67.0 libboost-system1.67.0 libbpf0 libbsd0
libcap2 libcap2-bin libconfig-inifiles-perl libcwidget3v5 libdbi-perl libelf1 libmd0 libmnl0
libncurses6 libpopt0 libreadline5 libreadline7 libsnappy1v5 libwrap0 libxtables12 lsof
mariadb-common mariadb-server-core-10.3 mysql-common psmisc rsync socat
Use 'sudo apt autoremove' to remove them.
The following packages will be REMOVED:
g++-8 galera-3 gcc-8 libgcc-8-dev libstdc++-8-dev mariadb-client-10.3 mariadb-client-core-10.3
mariadb-server mariadb-server-10.3
The following NEW packages will be installed:
cpp-10 g++-10 gcc-10 gcc-10-base gcc-9-base libapt-pkg6.0 libasan6 libboost-iostreams1.74.0 libbpf0
libbsd0 libcrypt-dev libcrypt1 libctf-nobfd0 libctf0 libcwidget4 libffi7 libgcc-10-dev libgcc-s1
libgssapi-krb5-2 libhogweed6 libisl23 libk5crypto3 libkeyutils1 libkrb5-3 libkrb5support0 libmd0
libnettle8 libnsl-dev libnsl2 libpcre2-8-0 libperl5.32 libreadline8 libstdc++-10-dev libtirpc-common
libtirpc-dev libtirpc3 libxxhash0 logsave perl-modules-5.32
The following packages will be upgraded:
apt apt-utils aptitude aptitude-common base-files base-passwd bash binutils binutils-common
binutils-x86-64-linux-gnu bsdutils build-essential bzip2 ccache coreutils cpp dash debconf
debian-archive-keyring debianutils diffutils dpkg dpkg-dev e2fsprogs fdisk findutils g++ gawk gcc
gpgv grep gzip hostname init-system-helpers iproute2 libacl1 libaio1 libasan5 libatomic1 libattr1
libaudit-common libaudit1 libbinutils libblkid1 libbz2-1.0 libc-bin libc-dev-bin libc6 libc6-dev
libcap-ng0 libcap2 libcap2-bin libcc1-0 libcom-err2 libconfig-inifiles-perl libdb5.3 libdbi-perl
libdebconfclient0 libdpkg-perl libelf1 libext2fs2 libfdisk1 libgcrypt20 libgdbm-compat4 libgdbm6
libgmp10 libgnutls30 libgomp1 libgpg-error0 libgpm2 libidn2-0 libitm1 liblsan0 liblz4-1 liblzma5
libmnl0 libmount1 libmpc3 libmpfr6 libncurses6 libncursesw6 libp11-kit0 libpam-modules
libpam-modules-bin libpam-runtime libpam0g libpcre3 libpopt0 libquadmath0 libseccomp2 libselinux1
libsemanage-common libsemanage1 libsepol1 libsigc++-2.0-0v5 libsigsegv2 libsmartcols1 libsnappy1v5
libsqlite3-0 libss2 libssl1.1 libstdc++6 libsystemd0 libtasn1-6 libtinfo6 libtsan0 libubsan1
libudev1 libunistring2 libuuid1 libwrap0 libxapian30 libxtables12 libzstd1 linux-libc-dev login
lsb-base lsof make mariadb-common mawk mount mysql-common ncurses-base ncurses-bin passwd patch perl
perl-base psmisc readline-common rsync socat sysvinit-utils tar tzdata util-linux vim vim-common
vim-runtime xxd xz-utils zlib1g
143 upgraded, 39 newly installed, 9 to remove and 0 not upgraded.
Need to get 0 B/125 MB of archives.
After this operation, 22.7 MB of additional disk space will be used.
Do you want to continue? [Y/n] n
Abort.
root@isildor:/# apt policy mariadb-server
mariadb-server:
Installed: 1:10.3.29-0+deb10u1
Candidate: 1:10.5.12-1
Version table:
1:10.5.12-1 500
500 file:/home/tobi/pbuilder_repo/deps ./ Packages
1:10.5.11-1 500
500
http://ftp.de.debian.org/debian bullseye/main amd64 Packages
*** 1:10.3.29-0+deb10u1 500
500
http://ftp.de.debian.org/debian buster/main amd64 Packages
100 /var/lib/dpkg/status
apt -s -o Debug::pkgProblemResolver=yes dist-upgrade 2>&1 | tee /tmp/apt-resolver
(apt-resolver is attachd to this mail.)
--
Cheers,
tobi