Cannot start mariadb service

Install / Update Setup
1

Today when I open erpnext production it says Internal Server Error. Yesterday is just working fine.
I have already trace the error log and stuck at mariadb service cannot be start

Here the error I got

image
image815×227 5.04 KB

How I can solve this problem?

2

Try
sudo service mysql start

3

There is an error after I run “sudo service mysql start”

4

check mysql error log

5

Where I can check mysql error log does you mean?

/var/lib/mysql/error.log ?

If it is there is no error created

6

Try this
sudo mysqld --tc-heuristic-recover=ROLLBACK

sudo service mysqld start

1 Like
7

Thank you for the help. Can you explain why this is happen?

8

if your DB Shutdown abnormally, you have to recover it first before you start it.

1 Like