Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question?
If it is not in the man pages or the how-to's this is the place! |
Notices |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
 |
11-10-2016, 02:46 PM
|
#1
|
LQ Newbie
Registered: Jun 2014
Posts: 9
Rep: 
|
Failed to start MariaDB database server.
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 ...
|
|
|
11-10-2016, 03:01 PM
|
#2
|
LQ Guru
Registered: Mar 2004
Distribution: Slackware
Posts: 6,858
|
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
|
|
|
11-10-2016, 03:05 PM
|
#3
|
LQ Newbie
Registered: Jun 2014
Posts: 9
Original Poster
Rep: 
|
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 ...
|
|
|
11-10-2016, 05:57 PM
|
#5
|
LQ Newbie
Registered: Jun 2014
Posts: 9
Original Poster
Rep: 
|
Hi
getenforce return the Permissive
|
|
|
11-10-2016, 06:03 PM
|
#6
|
LQ Newbie
Registered: Jun 2014
Posts: 9
Original Poster
Rep: 
|
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.
|
|
|
11-10-2016, 08:18 PM
|
#7
|
LQ Guru
Registered: Mar 2004
Distribution: Slackware
Posts: 6,858
|
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?
|
|
|
All times are GMT -5. The time now is 11:02 AM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|