[debian-mysql] Bug#874370: mariadb-server-10.1: mariadb server does not write pid

[Faustin Lammler]

file on location specified in config
Reply-To: faustin at 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-common                10.1.26-0+deb9u1             all          MariaDB common metapackage
ii  mariadb-server                10.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