[debian-mysql] Bug#861782: mariadb-server-10.1: Upgrade fails because mariadb-server-10.1.prerm fails to stop mysqld.

[Ondřej Surý]

Chris,

I don't use KDE, so I will need a little of your help.

Could you do on a running system:

ps uax | grep $(pidof -c /usr/sbin/mysqld)

and

is there a difference between:

pidof /usr/sbin/mysqld

and

pidof -c /usr/sbin/mysqld

?

Cheers,
-- 
Ondřej Surý <ondrej at sury.org>
Knot DNS (https://www.knot-dns.cz/) – a high-performance DNS server
Knot Resolver (https://www.knot-resolver.cz/) – secure, privacy-aware,
fast DNS(SEC) resolver
Vše pro chleba (https://vseprochleba.cz) – Mouky ze mlýna a potřeby pro
pečení chleba všeho druhu

On Thu, May 4, 2017, at 03:17, chris wrote:
> Package: mariadb-server-10.1
> Version: 10.1.22-4
> Severity: important
> 
> Dear Maintainer,
> 
> Upgrade from 1 month old version failed.
> 
> Installation says:
> 
> There is a MySQL server running, but we failed in our attempts to stop
> it.
> Stop it yourself and try again!
> 
> and fails.
> 
> When looking at:
> /var/lib/dpkg/info/mariadb-server-10.1.prerm
> one can see:
> invoke-rc.d mysql stop
> pidof -c /usr/sbin/mysqld
> 
> Executing those lines myself, I get:
> # invoke-rc.d mysql stop; pidof -c /usr/sbin/mysqld
> 3174
> 
> Similarly:
> # systemctl stop mariadb.service; pidof -c /usr/sbin/mysqld
> 3174
> 
> However I could stop the sever as a plain user:
> $ akonadictl stop
> 
> Verify it is stopped:
> # pidof -c /usr/sbin/mysqld
> 
> Then the upgrade worked flawlessly:
> # apt-get upgrade
> 
> A very verbose description can be found there:
> https://lists.debian.org/debian-kde/2017/05/msg00000.html
> 
> 
> Best,
> Chris
> 
> 
> 
> -- System Information:
> Debian Release: 9.0
>   APT prefers unstable
>   APT policy: (500, 'unstable'), (500, 'testing')
> Architecture: amd64
>  (x86_64)
> 
> Kernel: Linux 4.9.0-2-amd64 (SMP w/4 CPU cores)
> Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) (ignored:
> LC_ALL set to en_US.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.60
> ii  galera-3                  25.3.20-1
> 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-10
> ii  libdbi-perl               1.636-1+b1
> ii  libpam0g                  1.1.8-3.5
> ii  libstdc++6                6.3.0-16
> ii  lsb-base                  9.20161125
> ii  lsof                      4.89+dfsg-0.1
> ii  mariadb-client-10.1       10.1.22-4
> ii  mariadb-common            10.1.22-4
> ii  mariadb-server-core-10.1  10.1.22-4
> ii  passwd                    1:4.4-4
> ii  perl                      5.24.1-2
> ii  psmisc                    22.21-2.1+b2
> ii  rsync                     3.1.2-2
> ii  socat                     1.7.3.1-2+b1
> 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  bsd-mailx [mailx]  8.1.2-0.20160123cvs-4
> pn  mariadb-test       <none>
> pn  netcat-openbsd     <none>
> pn  tinyca             <none>
> 
> -- debconf information:
>   mariadb-server-10.1/postrm_remove_databases: false
>   mariadb-server-10.1/nis_warning:
>   mariadb-server-10.1/old_data_directory_saved:
>