Mysql fail to load

ERPNext
1

This is the third time I am facing this error. I have downloaded the latest VM and have been using on virtual box with the normal specs (but I increase the RAM to 2 GB)

? mariadb.service - MariaDB 10.2.14 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
mqmigrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Tue 2018-04-10 21:17:25 UTC; 5s ago
Docs: man:mysqld(8)
systemd - MariaDB Knowledge Base
Process: 3854 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 3568 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=/usr/bin/galera_recovery; [ $? -eq 0 ] && systemctl set-environment _WSRE
Process: 3564 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 3560 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 3854 (code=exited, status=1/FAILURE)
Status: “MariaDB server is down”

Apr 10 21:17:22 ubuntu systemd[1]: Starting MariaDB 10.2.14 database server…
Apr 10 21:17:23 ubuntu mysqld[3854]: 2018-04-10 21:17:23 140038350092480 [Note] /usr/sbin/mysqld (mysqld 10.2.14-MariaDB-10.2.14+maria~xenial-log) starting as process 3
Apr 10 21:17:25 ubuntu systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Apr 10 21:17:25 ubuntu systemd[1]: Failed to start MariaDB 10.2.14 database server.
Apr 10 21:17:25 ubuntu systemd[1]: mariadb.service: Unit entered failed state.
Apr 10 21:17:25 ubuntu systemd[1]: mariadb.service: Failed with result ‘exit-code’.
lines 1-20/20 (END)

Everything I have turned off the VM normally (sudo shutdown ) but thats the 3rd time my DB has crashed. I also have an old VM (version 9 of erpnext) and it never faces this issue.

Now I see Internal Server Error when I open in browser. Im very very worried as I have to deploy that in my environment. And if this fails, when I start adding my data, ill be doomed.

please help :frowning:

2

ok a similar report here Failed to start MariaDB 10.2.13 database server - #8 by clarkej

To troubleshoot and diagnose the problem please check the logs for the nature of the error.

edit: Possibly a database config issue - these are suspicious?

mqmigrated-from-my.cnf-settings.conf
_WSREP_NEW_CLUSTER

3

Fortunately this was a test VM, I have deleted the new VMs.

I had an old VM, which was using ubuntu 14, i updated ERPnext on that. Everything is working fine. I will try and make this error appear again and then post back.

Many thanks for this.