Dilihat dari output log journal -f
-- Logs begin at Fri 2017-04-28 09:50:50 WIB. -- Apr 28 14:44:06 rengit systemd[1]: mariadb.service: Unit entered failed state. Apr 28 14:44:06 rengit systemd[1]: mariadb.service: Failed with result 'exit-code'. Apr 28 14:45:28 rengit systemd[1]: Starting MariaDB 10.1 database server... Apr 28 14:45:28 rengit systemd[4508]: mariadb.service: Failed at step NAMESPACE spawning /usr/libexec/mysql-check-socket: No such file or directory Apr 28 14:45:28 rengit systemd[1]: mariadb.service: Control process exited, code=exited status=226 Apr 28 14:45:28 rengit systemd[1]: Failed to start MariaDB 10.1 database server. Apr 28 14:45:28 rengit systemd[1]: mariadb.service: Unit entered failed state. Apr 28 14:45:28 rengit systemd[1]: mariadb.service: Failed with result 'exit-code'. Apr 28 14:45:28 rengit audit[1]: SERVICE_START pid=1 uid=0 auid=4294967295 ses=4294967295 msg='unit=mariadb comm="systemd" exe="/usr/lib/systemd/systemd" hostname=? addr=? terminal=? res=failed' Apr 28 14:45:28 rengit kernel: audit: type=1130 audit(1493365528.351:474): pid=1 uid=0 auid=4294967295 ses=4294967295 msg='unit=mariadb comm="systemd" exe="/usr/lib/systemd/systemd" hostname=? addr=? terminal=? res=failed'
dari systemctl status mariadb.service
● mariadb.service - MariaDB 10.1 database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled) Active: failed (Result: exit-code) since Fri 2017-04-28 14:45:28 WIB; 2s ago Process: 4508 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=226/NAMESPACE) Apr 28 14:45:28 rengit systemd[1]: Starting MariaDB 10.1 database server... Apr 28 14:45:28 rengit systemd[1]: mariadb.service: Control process exited, code=exited status=226 Apr 28 14:45:28 rengit systemd[1]: Failed to start MariaDB 10.1 database server. Apr 28 14:45:28 rengit systemd[1]: mariadb.service: Unit entered failed state. Apr 28 14:45:28 rengit systemd[1]: mariadb.service: Failed with result 'exit-code'.
Solusi
Error tersebut karena symbolic link antara /tmp dan /var/tmp. Hapus /var/tmp lalu buat baru
rm -f /var/tmp mkdir /var/tmp chmod 1777 /var/tmp
Restart MariaDB
Setelah perubahan diatas, jalankan MariaDB
systemctl start mariadb.service systemctl status mariadb.service