[debian-mysql] Bug#1035949: mariadb: upgrade issue: mariadb-server-10.5 fails to stop after all other -10.5 packages were removed

[Otto Kekäläinen]

Here is the apt resolver output for debugging:

# apt install default-mysql-server -o Debug::pkgDepCache::Marker=1 -o
Debug::pkgDepCache::AutoInstall=1 -o Debug::pkgProblemResolver=1
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
  MarkInstall default-mysql-server:amd64 < 1.0.7 -> 1.1.0 @ii pumU Ib > FU=1
  Installing mariadb-server:amd64 as Depends of default-mysql-server:amd64
     Removing: mariadb-server-10.5:amd64 as upgrade is not an option
for mariadb-server:amd64 (1:10.11.2-1)
      MarkDelete mariadb-server-10.5:amd64 < 1:10.5.19-0+deb11u2 @ii
mK Ib > FU=0
    MarkInstall mariadb-server:amd64 < none -> 1:10.11.2-1 @un puN Ib > FU=0
    Installing mariadb-common:amd64 as PreDepends of mariadb-server:amd64
      MarkInstall mariadb-common:amd64 < 1:10.5.19-0+deb11u2 ->
1:10.11.2-1 @ii pumU > FU=0
    Installing mariadb-client:amd64 as Depends of mariadb-server:amd64
       Removing: mariadb-client-10.5:amd64 as upgrade is not an option
for mariadb-client:amd64 (1:10.11.2-1)
        MarkDelete mariadb-client-10.5:amd64 < 1:10.5.19-0+deb11u2 @ii
mK Ib > FU=0
       Removing: mariadb-client-core-10.5:amd64 as upgrade is not an
option for mariadb-client:amd64 (1:10.11.2-1)
        MarkDelete mariadb-client-core-10.5:amd64 <
1:10.5.19-0+deb11u2 @ii mK > FU=0
      MarkInstall mariadb-client:amd64 < none -> 1:10.11.2-1 @un puN Ib > FU=0
      Installing mariadb-client-core:amd64 as Depends of mariadb-client:amd64
         Removing: mariadb-server-core-10.5:amd64 as upgrade is not an
option for mariadb-client-core:amd64 (1:10.11.2-1)
          MarkDelete mariadb-server-core-10.5:amd64 <
1:10.5.19-0+deb11u2 @ii mK > FU=0
        MarkInstall mariadb-client-core:amd64 < none -> 1:10.11.2-1
@un puN Ib > FU=0
        Installing libc6:amd64 as Depends of mariadb-client-core:amd64
          MarkInstall libc6:amd64 < 2.31-13+deb11u5 -> 2.36-9 @ii pumU
NPb > FU=0
        Installing libssl3:amd64 as Depends of mariadb-client-core:amd64
          MarkInstall libssl3:amd64 < none -> 3.0.8-1 @un puN > FU=0
    Installing mariadb-server-core:amd64 as Depends of mariadb-server:amd64
      MarkInstall mariadb-server-core:amd64 < none -> 1:10.11.2-1 @un
puN Ib > FU=0
      Installing libpmem1:amd64 as Depends of mariadb-server-core:amd64
        MarkInstall libpmem1:amd64 < none -> 1.12.1-2 @un puN Ib > FU=0
        Installing libdaxctl1:amd64 as Depends of libpmem1:amd64
          MarkInstall libdaxctl1:amd64 < none -> 76.1-1 @un puN Ib > FU=0
          Installing libkmod2:amd64 as Depends of libdaxctl1:amd64
            MarkInstall libkmod2:amd64 < none -> 30+20221128-1 @un puN Ib > FU=0
            Installing libzstd1:amd64 as Depends of libkmod2:amd64
              MarkInstall libzstd1:amd64 < 1.4.8+dfsg-2.1 ->
1.5.4+dfsg2-5 @ii pumU > FU=0
        Installing libndctl6:amd64 as Depends of libpmem1:amd64
          MarkInstall libndctl6:amd64 < none -> 76.1-1 @un puN > FU=0
      Installing libstdc++6:amd64 as Depends of mariadb-server-core:amd64
        MarkInstall libstdc++6:amd64 < 10.2.1-6 -> 12.2.0-14 @ii pumU Ib > FU=0
        Installing gcc-12-base:amd64 as Depends of libstdc++6:amd64
          MarkInstall gcc-12-base:amd64 < none -> 12.2.0-14 @un puN > FU=0
      Installing liburing2:amd64 as Depends of mariadb-server-core:amd64
        MarkInstall liburing2:amd64 < none -> 2.3-3 @un puN > FU=0
    Installing mariadb-plugin-provider-bzip2:amd64 as Recommends of
mariadb-server:amd64
      MarkInstall mariadb-plugin-provider-bzip2:amd64 < none ->
1:10.11.2-1 @un uN > FU=0
    Installing mariadb-plugin-provider-lz4:amd64 as Recommends of
mariadb-server:amd64
      MarkInstall mariadb-plugin-provider-lz4:amd64 < none ->
1:10.11.2-1 @un uN > FU=0
    Installing mariadb-plugin-provider-lzma:amd64 as Recommends of
mariadb-server:amd64
      MarkInstall mariadb-plugin-provider-lzma:amd64 < none ->
1:10.11.2-1 @un uN > FU=0
    Installing mariadb-plugin-provider-lzo:amd64 as Recommends of
mariadb-server:amd64
      MarkInstall mariadb-plugin-provider-lzo:amd64 < none ->
1:10.11.2-1 @un uN Ib > FU=0
      Installing liblzo2-2:amd64 as Depends of mariadb-plugin-provider-lzo:amd64
        MarkInstall liblzo2-2:amd64 < none -> 2.10-2 @un uN > FU=0
    Installing mariadb-plugin-provider-snappy:amd64 as Recommends of
mariadb-server:amd64
      MarkInstall mariadb-plugin-provider-snappy:amd64 < none ->
1:10.11.2-1 @un uN Ib > FU=0
      Installing libsnappy1v5:amd64 as Depends of
mariadb-plugin-provider-snappy:amd64
        MarkInstall libsnappy1v5:amd64 < 1.1.8-1 -> 1.1.9-3 @ii umU > FU=0
    Installing pv:amd64 as Recommends of mariadb-server:amd64
      MarkInstall pv:amd64 < none -> 1.6.20-1 @un uN > FU=0
Starting pkgProblemResolver with broken count: 0
Starting 2 pkgProblemResolver with broken count: 0
Done
The following package was automatically installed and is no longer required:
  libaio1
Use 'apt autoremove' to remove it.
The following additional packages will be installed:
  gcc-12-base libc-bin libc6 libdaxctl1 libkmod2 liblzo2-2 libndctl6
libpmem1 libsnappy1v5 libssl3 libstdc++6 liburing2 libzstd1
mariadb-client mariadb-client-core mariadb-common
  mariadb-plugin-provider-bzip2 mariadb-plugin-provider-lz4
mariadb-plugin-provider-lzma mariadb-plugin-provider-lzo
mariadb-plugin-provider-snappy mariadb-server mariadb-server-core pv
Suggested packages:
  glibc-doc libc-l10n locales libnss-nis libnss-nisplus mailx
mariadb-test netcat-openbsd doc-base
Recommended packages:
  manpages
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:
  gcc-12-base libdaxctl1 libkmod2 liblzo2-2 libndctl6 libpmem1 libssl3
liburing2 mariadb-client mariadb-client-core
mariadb-plugin-provider-bzip2 mariadb-plugin-provider-lz4
  mariadb-plugin-provider-lzma mariadb-plugin-provider-lzo
mariadb-plugin-provider-snappy mariadb-server mariadb-server-core pv
The following packages will be upgraded:
  default-mysql-server libc-bin libc6 libsnappy1v5 libstdc++6 libzstd1
mariadb-common
7 upgraded, 18 newly installed, 4 to remove and 253 not upgraded.
Need to get 21.4 MB of archives.
After this operation, 38.3 MB of additional disk space will be used.
Do you want to continue? [Y/n]


We only care about mariadb-client-10.5 upgrading to mariadb-client
(from 10.11, without version suffix):

# dpkg -S /usr/bin/mariadb-admin
mariadb-client-10.5: /usr/bin/mariadb-admin