CyberKeeda In Social Media

MariaDB Startup error Fix : mysqld: Can't create/write to file '/var/run/mariadb/mariadb.pid' (Errcode: 2)





170529 15:34:47 [ERROR] mysqld: Can't create/write to file '/var/run/mariadb/mariadb.pid' (Errcode: 2)
170529 15:34:47 [ERROR] Can't start server: can't create PID file: No such file or directory
170529 15:34:47 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended


Description of problem:
When I restart my RHEL 7 box, the mariadb service will not start, due to /var/run/mariadb not existing.

Version : mariadb-server-5.5.52-1.el7.x86_64


MariaDB isn't running, and you can't start it manually:

$ systemctl start mariadb

Error Lines.

170529 15:34:47 [Note] Server socket created on IP: '0.0.0.0'.
170529 15:34:47 [ERROR] mysqld: Can't create/write to file '/var/run/mariadb/mariadb.pid' (Errcode: 2)
170529 15:34:47 [ERROR] Can't start server: can't create PID file: No such file or directory
170529 15:34:47 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
Additional info:
Fix this by creating the missing folder in the tmpfs and setting permission to mariadb:

# install -dpm770 -o mysql -g mysql /var/run/mariadb
# systemctl start mariadb  

No comments:

Post a Comment

Designed By Kunal Saha