How do I figure out why my MariaDB Database crashed?

Linode Staff

When I got up this morning, I found that my MariaDB installation on Ubuntu 18.04 LTS had crashed. Can you tell me how to determine what caused it?

I get the following error:

Nov 15 12:41:00 new-host systemd[1]: mariadb.service: Main process exited, code=dumped, status=6/ABRT
Nov 15 12:41:00 systemd[1]: mariadb.service: Failed with result 'core-dump'.
Nov 15 12:41:00 systemd[1]: Failed to start MariaDB 10.1.41 database server.

I already tried increasing memory.

1 Reply

Common causes for database crashes include:

If you are not a root user you may have to do:

sudo cat /var/log/mysql/error.log

in order to see the contents of the log. You may also wish to look for configuration settings related to memory in your my.cnf file.

The following link will help you locate the file:

This also may be helpful:

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct