Resolved MariaDB suddenly broken (CentOs7)

[wakabayashi]

Hello! Since yesterday our MariaDB is no more working on my Server. I haven't make any change at all.

Plesk Login states:

DB query failed: SQLSTATE[HY000] [2002] Connection refused

When using the Repair Kit it states that MariaDB Service "stopped". Using "Restart Processes" button makes it to green, but it's not really working. After refreshing the same problem exits. What could be the issue?

My server knowledge is limited, but here are at least some informations that might be needed for help.
Plesk: Plesk Obsidian 18.0.42.1
OS version: centos-release-7-9.2009.1.el7.centos.x86_64
MariaDB: mariadb Ver 15.1 Distrib 10.5.15-MariaDB, for Linux (x86_64) using readline 5.1


# service mysql status

Redirecting to /bin/systemctl status mysql.service
● mariadb.service - MariaDB 10.5.15 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: activating (auto-restart) (Result: signal) since Sat 2022-04-16 10:13:51 CEST; 1s ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 4317 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 4289 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=ABRT)
  Process: 4275 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 4273 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 4289 (code=killed, signal=ABRT)
   Status: "Taking your SQL requests now..."

Apr 16 10:13:51 plesk.spielezar.ch systemd[1]: Unit mariadb.service entered failed state.
Apr 16 10:13:51 plesk.spielezar.ch systemd[1]: mariadb.service failed.

I tried already:

• systemctl restart mariadb
• systemctl start mariadb

Thanks for any help!

 

[Kaspar]

Try running systemctl start mariadb again and look run journalctl -xn afterwards for more details why mariadb failed.

 

[wakabayashi]

Thanks for your anwer! Unfortunately the Database turned out to be corrupted. There was no other way than to use a backup and reset things.