How do I figure out why my MariaDB Database crashed?
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: mariadb.service: Main process exited, code=dumped, status=6/ABRT Nov 15 12:41:00 systemd: mariadb.service: Failed with result 'core-dump'. Nov 15 12:41:00 systemd: Failed to start MariaDB 10.1.41 database server.
I already tried increasing memory.
Common causes for database crashes include:
- Database Corruption (https://mariadb.com/kb/en/library/mysqlcheck/)
- Changes to the configuration files made prior to a reboot, but never tested by restarting the service (https://www.linode.com/docs/uptime/reboot-survival-guide/)
- Either not enough memory in the system, or you database's memory has been limited by configuration (https://mariadb.com/kb/en/library/mariadb-memory-allocation/)
- Filesystem Corruption (https://www.linode.com/docs/troubleshooting/rescue-and-rebuild/#performing-a-file-system-check)
The best place to start looking would be in your database's log files. You may wish to try looking in /var/log/mysql/error.log.
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: