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

[Otto Kekäläinen]

Hi!

I managed now to reproduce this. The purge step is not relevant, but
simply the upgrade itself.


In clean Docker container with Debian unstable:

$ apt install -y mariadb-server-10.6
-> install successful

$ apt full-upgrade -y
-> does nothing

$ service mariadb restart
Stopping MariaDB database server: mariadbd.
Starting MariaDB database server: mariadbd.

$ apt install mariadb-server -y
The following packages will be REMOVED:
  mariadb-client-10.6 mariadb-client-core-10.6 mariadb-server-10.6
mariadb-server-core-10.6
The following NEW packages will be installed:
  mariadb-client mariadb-client-core mariadb-server mariadb-server-core pv

$ service mariadb restart
mariadb: unrecognized service

-> upgrade successful, but service stopped working - the service file
has no executable bit anymore.

$ dpkg -l | grep -iE 'maria|mysql|galera'
ii  galera-4                  26.4.11-1+b2       amd64
Replication framework for transactional applications
ii  libdbd-mariadb-perl       1.22-1+b1          amd64        Perl5
database interface to the MariaDB/MySQL databases
ii  libmariadb3:amd64         1:10.11.1-1        amd64        MariaDB
database client library
ii  mariadb-client            1:10.11.1-1        amd64        MariaDB
database client binaries
rc  mariadb-client-10.6       1:10.6.11-2        amd64        MariaDB
database client binaries
ii  mariadb-client-core       1:10.11.1-1        amd64        MariaDB
database core client binaries
ii  mariadb-common            1:10.11.1-1        all          MariaDB
common configuration files
ii  mariadb-server            1:10.11.1-1        amd64        MariaDB
database server binaries
rc  mariadb-server-10.6       1:10.6.11-2        amd64        MariaDB
database server binaries
ii  mariadb-server-core       1:10.11.1-1        amd64        MariaDB
database core server files
ii  mysql-common              5.8+1.1.0          all          MySQL
database common files, e.g. /etc/mysql/my.cnf

$ find /etc -name '*mariadb*' -type f -ls
-rw-r--r--   1 root     root         6387 Jan 15 22:45 /etc/init.d/mariadb
-rw-r--r--   1 root     root         1859 Jan 15 22:45 /etc/logrotate.d/mariadb
-rw-r--r--   1 root     root         1126 Jan  8 01:45 /etc/mysql/mariadb.cnf
-rw-r--r--   1 root     root          730 Jan  3 06:42
/etc/apparmor.d/usr.sbin.mariadbd
-rw-r--r--   1 root     root          716 Jan  3 06:42
/etc/logcheck/ignore.d.paranoid/mariadb-server-10_6
-rw-r--r--   1 root     root          716 Jan 15 22:45
/etc/logcheck/ignore.d.paranoid/mariadb-server
-rw-r--r--   1 root     root         2153 Jan  3 06:42
/etc/logcheck/ignore.d.server/mariadb-server-10_6
-rw-r--r--   1 root     root         2153 Jan 15 22:45
/etc/logcheck/ignore.d.server/mariadb-server
-rw-r--r--   1 root     root         2153 Jan  3 06:42
/etc/logcheck/ignore.d.workstation/mariadb-server-10_6
-rw-r--r--   1 root     root         2153 Jan 15 22:45
/etc/logcheck/ignore.d.workstation/mariadb-server

$ apt purge 'mariadb-*-10.6' -y
The following packages will be REMOVED:
  mariadb-client-10.6* mariadb-server-10.6*

$ find /etc -name '*mariadb*' -type f -ls
-rw-r--r--   1 root     root         6387 Jan 15 22:45 /etc/init.d/mariadb
-rw-r--r--   1 root     root         1859 Jan 15 22:45 /etc/logrotate.d/mariadb
-rw-r--r--   1 root     root         1126 Jan  8 01:45 /etc/mysql/mariadb.cnf
-rw-r--r--   1 root     root          730 Jan  3 06:42
/etc/apparmor.d/usr.sbin.mariadbd
-rw-r--r--   1 root     root          716 Jan 15 22:45
/etc/logcheck/ignore.d.paranoid/mariadb-server
-rw-r--r--   1 root     root         2153 Jan 15 22:45
/etc/logcheck/ignore.d.server/mariadb-server
-rw-r--r--   1 root     root         2153 Jan 15 22:45
/etc/logcheck/ignore.d.workstation/mariadb-server

-> purge works as expected