Stop service MariaD‌

[unique2world]

Yesterday, my virtual machine was restarted due to a power outage, and after that the MariaDB service was stopped and could not be started, nor could it be built.
What should be done?

 

[Zhenyapan]

check logs, maybe it crashed and must be started in recovery mode. Of if you have backups and dataloss from last backup not critical you can reinstall mariadb and restore all from backups. Depends on what you have and what want to get

 

[unique2world]

check logs, maybe it crashed and must be started in recovery mode. Of if you have backups and dataloss from last backup not critical you can reinstall mariadb and restore all from backups. Depends on what you have and what want to get

How do I recover?

 

[unique2world]

mysqlcheck --defaults-extra-file=/usr/local/directadmin/conf/my.cnf --auto-repair --optimize --all-databases

mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when trying to connect

rpm -qa | grep -i ^mariadb

MariaDB-client-10.4.28-1.el7.centos.x86_64
MariaDB-backup-10.4.28-1.el7.centos.x86_64
MariaDB-common-10.4.28-1.el7.centos.x86_64
MariaDB-shared-10.4.28-1.el7.centos.x86_64
MariaDB-server-10.4.28-1.el7.centos.x86_64
MariaDB-compat-10.4.28-1.el7.centos.x86_64
MariaDB-devel-10.4.28-1.el7.centos.x86_64

systemctl status mariadb.service

● mariadb.service - MariaDB database server
Loaded: loaded (/etc/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 Thu 2024-01-18 11:00:45 +0330; 1s ago
Process: 30904 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=SEGV)
Process: 30797 ExecStartPre=/bin/sh -c [ -x /usr/bin/galera_recovery ] || exit 0; VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 30795 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 30904 (code=killed, signal=SEGV)
Tasks: 0
Memory: 288.0K
CGroup: /system.slice/mariadb.service

Jan 18 11:00:45 server.xxxxxxx.com systemd[1]: Failed to start MariaDB database server.
Jan 18 11:00:45 server.xxxxxxx.com systemd[1]: mariadb.service failed.

 

[Zhenyapan]

what you see in mysql logs after you try restart it?

 

[Ohm J]

Something like inno_db currupted. Hire some engineer or create support ticket to let's DA Team help you.