MariaDB Troubleshooting-- DB issue

DevOps
#1

Hi Team,

can you please help on on MariaDB Troubleshooting, as im not DB guy…

i dont have much knowledge on DB as im a devops in application side.

#2

Is this for a specific lab (in which case, a link would be pretty handy)? What problem do you have?

#3

Yes,

below the task, im not aware of DB tasks, please help me to reslove.

that the application is unable to connect to the database. After digging into the issue, the team found that mariadb service is down on the database server.

#4

Please, include a link to that lab so I can get a bit more context to what you’re asking.

#5

https://engineer.kodekloud.com/task?id=68066f695500bdf7ab9a7b27&status=redo

#6

This is NOT what I’m asking for. What I need for a KKE task is:

  • the type of task (ansible? linux? etc.)
  • The level of the task
  • the exact NAME of the task.

Then I can figure out what you’re talking about. Thanks!

#7

OK, after rooting around awhile, I’m guessing that you’re working on Day 9 of 100 Days of Devops, maybe. If so, you don’t need to know anything specific about mariadb, since this is a Systemd problem.

The log for mariadb on the stdb01 host is at tail /var/log/mariadb/mariadb.log. If you look there, you’ll see this message:

2025-10-31 22:47:00 0 [ERROR] mariadbd: Can’t create/write to file ‘/run/mariadb/mariadb.pid’ (Errcode: 13 “Permission denied”)
2025-10-31 22:47:00 0 [ERROR] Can’t start server: can’t create PID file: Permission denied

If you look at the directory /run/mariadb, you’ll see in turn that it belongs to root.mysql, but that the directory is not writeable by mysql. This is the problem; making the directory writable by group mysql allows the server to be restarted.