Bug#874370: mariadb-server-10.1: mariadb server does not write pid

[Faustin Lammler]

file on location specified in config
Reply-To: faus...@fala.red

Hi Stefan,
thank you for your help!

I have just installed mariadb-server on a fresh stable debian 9 (KVM
platform) and I can not reproduce this (I am able to change path of pid
file):

$ sudo apt install mariadb-server
$ sudo rep -r pid /etc/mysql/
/etc/mysql/mariadb.conf.d/50-server.cnf:pid-file
=/var/run/mysqld/mysqld.pid
$ ls -l /var/run/mysqld/mysqld.pid 
-rw-rw 1 mysql mysql 5 Aug 16 15:05 /var/run/mysqld/mysqld.pid

Change pid path for '/tmp/mysql.pid':
$ sudo grep -r pid /etc/mysql
/etc/mysql/mariadb.conf.d/50-server.cnf:pid-file=/tmp/mysqld.pid
$ sudo systemctl restart mysql
$ ls -l /tmp/mysqld.pid
-rw-rw 1 mysql mysql 5 Aug 16 15:07 /tmp/mysqld.pid

Some info on system:
$ uname -r
4.9.0-7-amd64
$ dpkg -l | grep mariadb
ii  libmariadbclient18:amd64  10.1.26-0+deb9u1 amd64
MariaDB database client library
ii  mariadb-client-10.1   10.1.26-0+deb9u1 amd64
MariaDB database client binaries
ii  mariadb-client-core-10.1  10.1.26-0+deb9u1 amd64
MariaDB database core client binaries
ii  mariadb-common10.1.26-0+deb9u1 all  
MariaDB common metapackage
ii  mariadb-server10.1.26-0+deb9u1 all  
MariaDB database server (metapackage depending on the latest version)
ii  mariadb-server-10.1   10.1.26-0+deb9u1 amd64
MariaDB database server binaries
ii  mariadb-server-core-10.1  10.1.26-0+deb9u1 amd64
MariaDB database core server files
$ cat /etc/debian_version
9.5

Could you verify again if the issue is still present on your system?
What command do you use to restart mysql?

Please also take a look at this open issue, I have just linked your bug
report there:
https://jira.mariadb.org/browse/MDEV-8168

Regards,
Faustin

Bug#874370: mariadb-server-10.1: mariadb server does not write pid file on location specified in config

[S. Seide]

Package: mariadb-server-10.1
Version: 10.1.26-1
Severity: normal

Dear Maintainer,

the mariadb server does not write a pid file on the location set in the 
configuration files.


The package provided file /etc/mysql/mariadb.conf.d/50-server.cnf, 
included in /etc/mysql.conf (resp. /etc/mariadb.conf)
sets the config parameter to write the pid file into the /var/run/mysql 
directory:


  pid-file  = /var/run/mysqld/mysqld.pid

The server does not write a file into this directory, only the 
mysql.sock socket is there.
Instead a pid file is written into the mariadb data dir unter the 
hostname of the server:


The pidfile (incorectly) created is:

  /var/lib/mysql/.pid

This is reproducable with just installing the mariadb-server package, no 
further configuration needed.


The problem exists in the stable package (10.1.26-deb9u1) as well as the 
testing one (10.1.26-1).


Best regards,
Stefan Seide



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

Kernel: Linux 4.9.0-3-amd64 (SMP w/1 CPU core)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), 
LANGUAGE=en_US.UTF-8 (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++66.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-1
ii  mariadb-common10.1.26-1
ii  mariadb-server-core-10.1  10.1.26-1
ii  passwd1:4.4-4.1
ii  perl  5.24.1-3+deb9u1
ii  psmisc22.21-2.1+b2
ii  rsync 3.1.2-1
ii  socat 1.7.3.1-2+deb9u1
ii  zlib1g1: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   
pn  netcat-openbsd 
pn  tinyca 

-- debconf information excluded