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