[debian-mysql] Bug#873460: mariadb-server-10.1: Updates not restarting mariadb at xx services

[Toby Chamberlain]

Package: mariadb-server-10.1
Version: 10.1.26-0+deb9u1
Severity: normal

Dear Maintainer,

When using MariaDB multiple instances the upgrade process shows errors stopping/starting mysql and the servers are not restarted. Would be great if the upgrade scripts could detect running mariadb at xxx services (`systemctl | grep mariadb`??) and stop/restart them, instead of assuming a single mariadb service.

 From the apt-get upgrade messages:
Preparing to unpack .../mariadb-server-10.1_10.1.26-0+deb9u1_amd64.deb ...
Failed to stop mysql.service: Unit mysql.service not loaded.
invoke-rc.d: initscript mysql, action "stop" failed.
dpkg: warning: subprocess old pre-removal script returned error exit status 5
dpkg: trying script from the new package instead ...
dpkg: ... it looks like that went OK

Servers are still running... then, later in the process:
mariadb.service is a disabled or a static unit, not starting it.

A version check on the running servers show that are still running the old version (in this case 10.1.23-MariaDB-9+deb9u1). A manual run of mysql_upgrade fails with a version incompatibility.

Toby



-- System Information:
Debian Release: 9.1
   APT prefers stable
   APT policy: (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 4.9.0-3-amd64 (SMP w/24 CPU cores)
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8), LANGUAGE=en_AU:en (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages mariadb-server-10.1 depends on:
ii  adduser                   3.115
ii  debconf [debconf-2.0]     1.5.61
ii  galera-3                  25.3.19-2
ii  gawk                      1:4.1.4+dfsg-1
ii  init-system-helpers       1.48
ii  iproute2                  4.9.0-1
ii  libaio1                   0.3.110-3
ii  libc6                     2.24-11+deb9u1
ii  libdbi-perl               1.636-1+b1
ii  libpam0g                  1.1.8-3.6
ii  libstdc++6                6.3.0-18
ii  libsystemd0               232-25+deb9u1
ii  lsb-base                  9.20161125
ii  lsof                      4.89+dfsg-0.1
ii  mariadb-client-10.1       10.1.26-0+deb9u1
ii  mariadb-common            10.1.26-0+deb9u1
ii  mariadb-server-core-10.1  10.1.26-0+deb9u1
ii  passwd                    1:4.4-4.1
ii  perl                      5.24.1-3+deb9u1
ii  psmisc                    22.21-2.1+b2
ii  rsync                     3.1.2-1
ii  socat                     1.7.3.1-2+deb9u1
ii  zlib1g                    1:1.2.8.dfsg-5

Versions of packages mariadb-server-10.1 recommends:
ii  libhtml-template-perl  2.95-2

Versions of packages mariadb-server-10.1 suggests:
ii  mailutils [mailx]  1:3.1.1-1
pn  mariadb-test       <none>
pn  netcat-openbsd     <none>
pn  tinyca             <none>

-- Configuration Files:
/etc/init.d/mysql changed [not included]

-- debconf information:
   mariadb-server-10.1/postrm_remove_databases: false
   mariadb-server-10.1/old_data_directory_saved:
   mariadb-server-10.1/nis_warning:

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20170828/60da10d7/attachment.html>