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

[Ondřej Surý]

And output of:

pgrep mysqld

does it return the same pid as pidof command?

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 04:40, Ondřej Surý wrote:
> 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:
> > 
>