hi

Failed to start MariaDB database server.


Service Error
(XID jdygud) The “mysql” service failed to start.

Startup Log
Nov 11 01:36:28 exportleftovers-com systemd[1]: Starting MariaDB database server...
Nov 11 01:36:28 exportleftovers-com mysqld[8055]: 2016-11-11 1:36:28 139763749849280 [Note] /usr/sbin/mysqld (mysqld 10.1.19-MariaDB) starting as process 8055 ...
Nov 11 01:36:28 exportleftovers-com systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Nov 11 01:36:28 exportleftovers-com systemd[1]: Failed to start MariaDB database server.
Nov 11 01:36:28 exportleftovers-com systemd[1]: Unit mariadb.service entered failed state.
Nov 11 01:36:28 exportleftovers-com systemd[1]: mariadb.service failed.

Log Messages
2016-11-11 1:36:28 139763749849280 [ERROR] mysqld: Can't create/write to file '/dev/shm/mysql/ib0pdIJi' (Errcode: 2 "No such file or directory")
2016-11-11 1:36:23 139771664853184 [ERROR] mysqld: Can't create/write to file '/dev/shm/mysql/ibufQ6Qx' (Errcode: 2 "No such file or directory")
2016-11-11 1:36:17 140358575917248 [ERROR] mysqld: Can't create/write to file '/dev/shm/mysql/ibHPfciZ' (Errcode: 2 "No such file or directory")
2016-11-11 1:35:09 140478562506944 [ERROR] mysqld: Can't create/write to file '/dev/shm/mysql/ibRUYbLt' (Errcode: 2 "No such file or directory")
2016-11-11 1:28:01 140592600885440 [ERROR] mysqld: Can't create/write to file '/dev/shm/mysql/ibawY4HS' (Errcode: 2 "No such file or directory")
2016-11-11 1:27:54 139982938810560 [ERROR] mysqld: Can't create/write to file '/dev/shm/mysql/ibPcitKC' (Errcode: 2 "No such file or directory")
Nov 11 01:36:28 exportleftovers-com mysqld: 2016-11-11 1:36:28 139763749849280 [Note] /usr/sbin/mysqld (mysqld 10.1.19-MariaDB) starting as process 8055 ...

What is the OS / Linux distribution?

/dev/shm/mysql ownership should be set to mysql:mysql
But as /dev/shm content is deleted on each reboot, you should make sure /dev/shm/mysql exists and set to mysql:mysql ownership before mysqld start, maybe in an init script

Thanks Buddy.

CentOS 7

I have done this
mkdir /dev/shm/mysql
chown mysql:mysql /dev/shm/mysql

Now status is

Service Error
(XID h63kzu) The “mysql” service failed to start.

Startup Log
Nov 11 01:59:32 exportleftovers-com systemd[1]: Starting MariaDB database server...
Nov 11 01:59:32 exportleftovers-com mysqld[12120]: 2016-11-11 1:59:32 140663385061568 [Note] /usr/sbin/mysqld (mysqld 10.1.19-MariaDB) starting as process 12120 ...
Nov 11 01:59:36 exportleftovers-com systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Nov 11 01:59:36 exportleftovers-com systemd[1]: Failed to start MariaDB database server.
Nov 11 01:59:36 exportleftovers-com systemd[1]: Unit mariadb.service entered failed state.
Nov 11 01:59:36 exportleftovers-com systemd[1]: mariadb.service failed.

Log Messages
Nov 11 01:59:32 exportleftovers-com mysqld: 2016-11-11 1:59:32 140663385061568 [Note] /usr/sbin/mysqld (mysqld 10.1.19-MariaDB) starting as process 12120 ...

Maybe a problem with selinux

see SELinux and MariaDB Path Changes part of this document:
https://mariadb.com/kb/en/mariadb/wh...-doesnt-start/

Hi

getenforce return the Permissive

Hi keefaz

Thanks for your support. can you give me favor by quick answer as I'm stuck here and want to resolve this issue asap.

thanks in advance.

Hey, can't help without more informations, sorry.
In your first post you showed some errors in log that were helpful, can you show more?