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

Last Updated on 18 February 2024 by tommy

Leave a comment

Your email address will not be published. Required fields are marked *