Morning,
Can anyone help me straighten out MariaDB?
Background: I let the disk get completely full on my VPS (oops!). Bought
another 5GB but the system was pretty unresponsive due to lack of disk
space. Rebooted, thinking to dump some old kernels to free space, had to do
this in Xen and it took an absolute age to shut down. Booted and resized
disk successfully, but...
*The issue: *MariaDB will not start.Presumably did not shut down happily.
Returns:
Job for mariadb.service failed because the control process exited with
error code.
See "systemctl status mariadb.service" and "journalctl -xe" for
details.
Looking at systemctl status mariadb.service:
mariadb.service - MariaDB 10.1.47 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor
preset: enabled)
Active: failed (Result: exit-code) since Fri 2021-03-12 10:17:53 UTC;
10min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 11875 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS
$_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 11801 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ]
&& VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -
Process: 11799 ExecStartPre=/bin/sh -c systemctl unset-environment
_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 11798 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d
/var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 11875 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
Webmin also returns this fault code when prompted to start the DB:
DBI connect failed : Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock'
Running Ubuntu 18.04. User skill level: probably just about enough
knowledge to be dangerous.
Cheers,
Andy