Cannot start mariadb service

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

How I can solve this problem?

sudo service mysql start

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

check mysql error log

Where I can check mysql error log does you mean?

/var/lib/mysql/error.log ?

If it is there is no error created

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

sudo service mysqld start

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

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

1 Like