Bug 1373006

This issue appears to be resolved after a dnf upgrade I performed on the machine that was experiencing it. I'm not sure which package resolved the problem, but I am thankful that it is fixed!

This is happening to me in Fedora 27. I'm fully updated, so that hasn't helped. Creating the "/run/mariadb/" directory lets me start MariaDB - however, the directory does not persist across reboots.

I am having this problem after updating Fedora 26.  The directory /run/mariadb is not being created.  By adding custom configuration for mariadb.service I was able to get the /run/mariadb directory created at boot:

In /etc/systemd/system/mariadb.service.d/ create a file, tempfs.conf, containing the following:

[Service]
PermissionsStartOnly=true
ExecStartPre=/usr/bin/install -dpm770 -o mysql -g mysql /run/mariadb

Also seen today in Fedora 26.  I posted on the Fedora-users and mythtv-users lists and have a report that in Rawhide 

/usr/lib/tmpfiles.d/mariadb.conf 

looks like this:

# Do not edit this file.
# To override this, put /etc/tmpfiles.d/mariadb.conf instead.
d /run/mariadb 0755 mysql mysql -
d /run/mariadb 0755 mysql mysql -

In F26 I downgraded to 10.1.21-5, which is now running.

The last two lines there refer to /var/run/mariadb

It seems worth saying that the instructions here, from Scientific Linux 7.4, are very much clearer and easier to understand - although I suppose they may soon need an update too.

/usr/lib/tmpfiles.d/mariadb.conf 

# Do not edit this file; it will be overwritten on upgrades.
# If you want to override the settings here, you can copy this file
# to /etc/tmpfiles.d/mariadb.conf and make your changes there.

d /var/run/mariadb 0755 mysql mysql -

Can you, guys, please refer to bug:
https://bugzilla.redhat.com/show_bug.cgi?id=1538066

I'm working on it there and I already made fix and put it into testing repository.

Using Fedora 26, I was able to make mariadb running again, when creating the file /etc/systemd/system/mariadb.service containing:

.include /usr/lib/systemd/system/mariadb.service

[Service]
RuntimeDirectory=mariadb

Still an issue on Centos 7 latest and MariaDB 10.2 and 10.3.9-1.el7 from mariadb repository.

comment #5 fixed it for me

(In reply to Stuart James from comment #8)
> Still an issue on Centos 7 latest and MariaDB 10.2 and 10.3.9-1.el7 from
> mariadb repository.
> 
> comment #5 fixed it for me

For CentOS please refer to CentOS own bug tracker.
I made an entry there for you:
https://bugs.centos.org/view.php?id=15326

Fedora 34 (clean install)
Mariadb Version: 10.5.10

Issue is [ERROR] mariadbd: Can't create/write to file '/run/mariadb/mariadb.pid' (Errcode: 2 "No such file or directory")

Checking settings that was proposed in comment #5

cat /usr/lib/tmpfiles.d/mariadb.conf 
# Do not edit this file.
# To override this, put /etc/tmpfiles.d/mariadb.conf instead.
d /run/mariadb 0755 mysql mysql -
d /run/mariadb 0755 mysql mysql -

Looks like it has duplicate
 
What helped me fix this issue:

# vim /etc/tmpfiles.d/mariadb.conf

d /run/mariadb 0755 mysql mysql -

:wq

# systemctl start mariadb

Works

I had this problem, resolved updating to mariadb-3:10.5.11-1.fc34.x86_64

Regards.