LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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


Reply
  Search this Thread
Old 11-10-2016, 02:46 PM   #1
sadiq106
LQ Newbie
 
Registered: Jun 2014
Posts: 9

Rep: Reputation: Disabled
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 ...
 
Old 11-10-2016, 03:01 PM   #2
keefaz
LQ Guru
 
Registered: Mar 2004
Distribution: Slackware
Posts: 6,541

Rep: Reputation: 866Reputation: 866Reputation: 866Reputation: 866Reputation: 866Reputation: 866Reputation: 866
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
 
Old 11-10-2016, 03:05 PM   #3
sadiq106
LQ Newbie
 
Registered: Jun 2014
Posts: 9

Original Poster
Rep: Reputation: Disabled
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 ...
 
Old 11-10-2016, 05:50 PM   #4
keefaz
LQ Guru
 
Registered: Mar 2004
Distribution: Slackware
Posts: 6,541

Rep: Reputation: 866Reputation: 866Reputation: 866Reputation: 866Reputation: 866Reputation: 866Reputation: 866
Maybe a problem with selinux

see SELinux and MariaDB Path Changes part of this document:
https://mariadb.com/kb/en/mariadb/wh...-doesnt-start/
 
Old 11-10-2016, 05:57 PM   #5
sadiq106
LQ Newbie
 
Registered: Jun 2014
Posts: 9

Original Poster
Rep: Reputation: Disabled
Hi

getenforce return the Permissive
 
Old 11-10-2016, 06:03 PM   #6
sadiq106
LQ Newbie
 
Registered: Jun 2014
Posts: 9

Original Poster
Rep: Reputation: Disabled
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.
 
Old 11-10-2016, 08:18 PM   #7
keefaz
LQ Guru
 
Registered: Mar 2004
Distribution: Slackware
Posts: 6,541

Rep: Reputation: 866Reputation: 866Reputation: 866Reputation: 866Reputation: 866Reputation: 866Reputation: 866
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?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] MariaDB server refuses to start UltrasonicMadness Linux - Software 5 09-29-2015 07:49 PM
[SOLVED] Linux running MariaDB database psuutari Linux - Newbie 1 04-15-2015 03:16 PM
HTTPD won't start NSS_Initialize failed. Certificate database Winanjaya Linux - Server 1 08-02-2013 07:03 AM
Failed to start MySQL database server - Fedora 19. pradeepontheline Linux - Server 11 07-29-2013 02:36 PM
mysql failed to start database tarak420 Linux - Server 3 09-19-2008 06:41 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 07:16 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration