How to solve MariaDB memory issue
Hello,
Suddenly, MariaDB stopped working and was unable to start. The logs reffer to some memory issue related to InnoDB. After several hours trying to solve it reading some forums and sources of information, the mysql sever is still down, unable to start.
Maybe this terminal output can help.
mariadb.service - MariaDB 10.1.37 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─oom.conf
Active: failed (Result: exit-code) since Fri 2019-03-08 19:35:41 UTC; 18s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 14298 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION
Process: 14186 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bi
Process: 14182 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exi
Process: 14178 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exit
Main PID: 14298 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
Mar 08 19:35:40 blaudat-debian-s-3vcpu-1gb-fra1-01 systemd[1]: Starting MariaDB 10.1.37 database ser
Mar 08 19:35:41 blaudat-debian-s-3vcpu-1gb-fra1-01 mysqld[14298]: 2019-03-08 19:35:41 13967806592249
Mar 08 19:35:41 blaudat-debian-s-3vcpu-1gb-fra1-01 systemd[1]: mariadb.service: Main process exited,
Mar 08 19:35:41 blaudat-debian-s-3vcpu-1gb-fra1-01 systemd[1]: Failed to start MariaDB 10.1.37 datab
Mar 08 19:35:41 blaudat-debian-s-3vcpu-1gb-fra1-01 systemd[1]: mariadb.service: Unit entered failed
Mar 08 19:35:41 blaudat-debian-s-3vcpu-1gb-fra1-01 systemd[1]: mariadb.service: Failed with result
Thank you very much in advance.
Hola! It looks like the systemctl output is cut off. Try this to get the full output: