[debian-mysql] Bug#1029136: configuration files not properly migrated on switch to unversioned packages

[Michael Biebl]

Package: mariadb-server
Version: 1:10.11.1-1
Severity: serious

The latest update switch to unversioned packages.

One issue I immediately noticed is that /etc/init.d/mariadb was
installed 644, i.e. is not executable.

Even, after purging the now obsolete -10.6 packages, I got this:

Löschen der Konfigurationsdateien von mariadb-server-10.6 (1:10.6.11-2) ...
Löschen der Konfigurationsdateien von mariadb-client-10.6 (1:10.6.11-2) ...
[master 28eeae9] committing changes in /etc made by "aptitude"
 Author: Michael Biebl <biebl at debian.org>
 12 files changed, 80 deletions(-)
 delete mode 100644 logcheck/ignore.d.paranoid/mariadb-server-10_6
 delete mode 100644 logcheck/ignore.d.server/mariadb-server-10_6
 delete mode 100644 logcheck/ignore.d.workstation/mariadb-server-10_6
 delete mode 120000 rc0.d/K01mariadb
 delete mode 120000 rc1.d/K01mariadb
 delete mode 120000 rc2.d/S01mariadb
 delete mode 120000 rc3.d/S01mariadb
 delete mode 120000 rc4.d/S01mariadb
 delete mode 120000 rc5.d/S01mariadb
 delete mode 120000 rc6.d/K01mariadb
 delete mode 120000 systemd/system/multi-user.target.wants/mariadb.service


This is not good.
May advice would be to keep (emtpy) transitional packages
mariadb-server-10.6/mariadb-client-10.6 and
mariadb-server-10.5/mariadb-client-10.5
which itself depend on the unversioned mariadb package.
This will not only make the upgrade smoother, it will also ensure that
if you purge the empty transitional packages, you do not accidentally
remove any import configuration state.

Post bookworm you can then safely drop those empty transitional
packages.


Regards,
Michael


-- System Information:
Debian Release: bookworm/sid
  APT prefers unstable
  APT policy: (500, 'unstable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 6.1.0-1-amd64 (SMP w/4 CPU threads; PREEMPT)
Kernel taint flags: TAINT_FIRMWARE_WORKAROUND
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages mariadb-server depends on:
ii  adduser                    3.130
ii  debconf [debconf-2.0]      1.5.82
ii  galera-4                   26.4.11-1+b2
ii  gawk                       1:5.1.0-1
ii  iproute2                   6.1.0-1
ii  libc6                      2.36-8
ii  libdbi-perl                1.643-4
ii  libpam0g                   1.5.2-6
ii  libssl3                    3.0.7-1
ii  libstdc++6                 12.2.0-14
ii  lsb-base                   11.5
ii  lsof                       4.95.0-1
ii  mariadb-client             1:10.11.1-1
ii  mariadb-common             1:10.11.1-1
ii  mariadb-server-core        1:10.11.1-1
ii  passwd                     1:4.13+dfsg1-1
ii  perl                       5.36.0-7
ii  procps                     2:4.0.2-3
ii  psmisc                     23.6-1
ii  rsync                      3.2.7-1
ii  socat                      1.7.4.4-2
ii  sysvinit-utils [lsb-base]  3.06-2
ii  zlib1g                     1:1.2.13.dfsg-1

Versions of packages mariadb-server recommends:
ii  libhtml-template-perl  2.97-2
ii  pv                     1.6.20-1

Versions of packages mariadb-server suggests:
ii  bsd-mailx [mailx]  8.1.2-0.20220412cvs-1
pn  mariadb-test       <none>
ii  netcat-openbsd     1.219-1

-- Configuration Files:
/etc/logcheck/ignore.d.paranoid/mariadb-server [Errno 13] Keine Berechtigung: '/etc/logcheck/ignore.d.paranoid/mariadb-server'
/etc/logcheck/ignore.d.server/mariadb-server [Errno 13] Keine Berechtigung: '/etc/logcheck/ignore.d.server/mariadb-server'

-- debconf information excluded