Fix breakage mariadb?

Question

MariaDB

Good afternoon, I didn’t touch the server for half a month, today I saw that the sites were sleeping. Rummaged in the logs, I saw - the database is not included, I turn it on and does not turn on. I got into the work log and I see -

Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
     Active: activating (auto-restart) (Result: signal) since Sat 2020-06-06 13:22:34 MSK; 4s ago
       Docs: man:mysqld(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 3987 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
    Process: 3988 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 3990 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=ex>
    Process: 4038 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=KILL)
   Main PID: 4038 (code=killed, signal=KILL)

Jun 06 13:22:34 scw-pedantic-leavitt systemd[1]: mariadb.service: Main process exited, code=killed, status=9/KILL
Jun 06 13:22:34 scw-pedantic-leavitt systemd[1]: mariadb.service: Failed with result 'signal'.
Jun 06 13:22:34 scw-pedantic-leavitt systemd[1]: Failed to start MariaDB 10.3.22 database server.

how to fix? or at least pick up the dumps, it doesn’t connect to the database at all

Answer 1

You need to look at the error logs: /var/log/mysql/error.logfor details.
Maybe there is a broken table.
Correction is not always possible. Then it remains only to restore from backups.