Hello Team ,

Mariadb service is stopped. can you please help me to find out the reason why mariadb service is stopped. please help me to troubleshoot why the DB service is stopped and what could be the reason why the service is stopped.

Please note that I have checked the following :

1.checked the /var/log/messages. No proper trace is found.
2.check the /var/log/mariadb/error.log --> nothing is found.
3.Checked the journalctl -u mariadb.service -> nothing found.

First thing to check, is /var/lib full? If /var/ is full, then you won't see anything AND mariadb won't start.

See if a pid file is left in /var/run and grep for this pid in logs. The proper way to troubleshoot (or to use) anything is NOT to start it as a service obscured by layers of systemd crud. Start it as a process from a script capturing all output including stderr into a file.

You don't tell us anything that could help us try to help you; we don't know what version/distro of Linux you're using, version of MariaDB, if this is a new install or existing, if this database instance was ever working or not, or anything that you've seen. Saying "nothing is found" tells us exactly that...nothing. Have you tried restarting the service??? Can you post ANYTHING from the logs??

Check the output of the below then use a search engine to research your problem:

Hello Team ,

Thanks for the reply.
[root@azrnelnx00562 ~]# df -TH /var/lib
Filesystem Type Size Used Avail Use% Mounted on
/dev/mapper/vg01-var ext4 11G 4.1G 6.0G 41% /var

/var is not full.

Check the various log files usually found in /var/log, and follow the preceding advice to try to start the process from the command-line.

Also: review your "captain's log" of recent changes.

Incidentally: I routinely use the "git" version-control system in all of my "configuration directories." This system is entirely file-based, creating an (invisible) ".git" subdirectory as its "repository." You simply make your changes and then "git commit -a". Create a brief log-entry describing your change. This allows you to not only record your changes, but to selectively reverse them, and to detect(!) changes that have not yet been committed. Since the repository directory is hidden, it won't impact anything. "What's a life-saver for a computer programmer" is also a life-saver for you!

We are not on your 'team'...we are volunteers here trying to help you. And you either ignored or didn't answer the other questions asked, like "did you check the service to see if it's running?" or "post anything from your logs". We can't guess; either answer questions or there's not much point in posting.

2 members found this post helpful.

Just skimmed through this user's other threads and it seems they are just a leech, working for a company - who are using RHEL or SLES on vmware VMs and coming here with poorly researched questions instead of using the paid support, those distributions provide.

Essentially he's getting paid to do a job, which he's bluffing his way through, by becoming a drain on the unpaid volunteers here.

I suggest ignoring...

1 members found this post helpful.

Hello Blackhole,

I'm from a OS admin support team. The DB which is stopped , we may not find the exact reason why the DB service. Also , I suspect the
issue could be with the /var/lib/mysql but not able to determine anything related to the logs under /var/log.

Also , through these forums , I'm trying to understand the other methods of troubleshooting beyond my knowledge. I have enough research before reaching the forums and do not have an answer that's why reaching here again.

Remember , I also explore and try to answer based on my knowledge though am not getting paid for. This is a forum for discussion and sharing knowledge one amongst others.

So you're getting paid to do this job, and it seems like you don't know how to do it. Further, you've been asked pointed questions and told how to check things, but you haven't answered or seemingly used the advice you've been given. In most of your other threads, you don't come back to share anything or put the solution down, and don't even follow up at all.

• You were handed commands to run to check the service: did you run them???
• You were asked to post relevant things from your logs...you have not.
• You haven't told us about version/distro of Linux, MariaDB, or if this is a new install or old, or even answered the basic question of "Did this ever work?"

Yet you somehow want us to do your job for you??? You claim to have 'enough research before' coming here, yet a simple search for "how to check a linux service" would bring up a LOT, so it's hard to believe you did such research.

You are claiming to have a job on a OS support team...but don't know basics like how to check a service?? And you say you've try to answer based on your knowledge but I've not seen any threads where you've posted suggestions or a solution. And be aware that NONE OF US GET PAID to volunteer here. This isn't a help desk, so if you want assistance, I suggest you show your efforts, do the things suggested and answer the questions asked.

Otherwise...ask YOUR TEAM for help doing your job.

Essentially he's getting paid to do a job, which he's bluffing his way through, by becoming a drain on the unpaid volunteers here.

-----------------------------------------------------------------------------------------------------------------------------
I'm really unhappy with the way your response on the item. I'm not simply making use of the volunteers here and pasting the same on the other end. Infact, I'm trying to learn and understand how to look into an issue and looking for people's opinion. Incase if you feel doing a pasting job , I will leave that to you.

And also I knew the basic stuff like how to check the service status but since this is DB service I will have no idea how to check why the DB related services are down. Ofcourse , I have checked the /var/lib/mysql mount point using the above suggestions and that helped a bit why the service is down but the root cause is not determined yet. I'm waiting for the Apps/DB owner to respond back and this thread is still not closed yet.

I gave you the commands to start the service, check its status and what should be the location of the log .err file, a few posts back...

Have you tried those yet? You stop/start/enable/disable and check status as you would for any othet systemd service.

Again - try to start the service, check its status, examine the log file and the journal, to see what's going on.

If you still haven't done that by your next post in this thread, then I am going to stick to my assessment - i.e. that you're utterly clueless, unwilling to learn and just hoping for a quick bail out. Right at this moment in time, it looks like you want others to do the job you're being paid to do for you.

1 members found this post helpful.

And are you for some reason ignoring what I've told you??? You claim to be trying to understand how to do very basic troubleshooting, when you also claim to have a PAID JOB being an OS admin. So either you can't do the job you're getting paid to do (and bluffed your way into it), or you CAN do it and just want us to do it for you, for free. This pattern has taken place before, hasn't it??

https://www.linuxquestions.org/quest...5/#post6484787
https://www.linuxquestions.org/quest...rs-4175733804/
https://www.linuxquestions.org/quest...gh-4175732631/
https://www.linuxquestions.org/quest...pd-4175732216/
https://www.linuxquestions.org/quest...in-4175731951/
Really??? You knew the 'basic stuff'...but didn't bother to do it??? Checking a database service is *EXACTLY THE SAME* as checking any other service. Running the commands you've been spoon-fed a few times already would probably give you some messages, if you bothered to run it. And the 'basic stuff' about checking disk space on /var/lib/mysql (which COULD BE MOUNTED on its own partition), but you only checked /var/lib. Did you check /var?? Where are these things mounted???

And you *STILL* don't answer the other questions asked, do you???
And the apps/db owner is waiting for someone who can fix their problem...and they're PAYING YOU to do it, not us. Either answer the questions asked and actually perform some tasks that an admin would, or get someone else to do this job.

Hello blackhole,

please let me know what you are expecting from me .