linux : [ERROR] mariadb: Aria recovery failed. Hint

# systemctl status mariadb

× mariadb.service - MariaDB 10.5.16 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: failed (Result: exit-code) since ......; 28s ago

Docs: man:mariadbd(8)

https://mariadb.com/kb/en/library/systemd/

Process: 2645 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)

Process: 2697 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: 3046 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)

Main PID: 3046 (code=exited, status=1/FAILURE)

Status: "MariaDB server is down"

CPU: 2.493s

systemd[1]: Starting MariaDB 10.5.16 database server...

mariadbd[3046]: [Note] /usr/sbin/mariadbd (mysqld 10.5.16-MariaDB-log) starting as process 3046 ...

systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE

systemd[1]: mariadb.service: Failed with result 'exit-code'.

systemd[1]: Failed to start MariaDB 10.5.16 database server.

systemd[1]: mariadb.service: Consumed 2.493s CPU time.

# vi /var/lib/mysql/error.log

[ERROR] mariadbd: Aria recovery failed. Please run aria_chk -r on all Aria tables (*.MAI) and delete all aria_log.######## files

[ERROR] Plugin 'Aria' init function returned error.

[ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.

# mkdir /var/lib/mysql/.out

# mv /var/lib/mysql/aria_log_control /var/lib/mysql/.out/

# mv /var/lib/mysql/aria_log.* /var/lib/mysql/.out/

# systemctl start mariadb

# systemctl status mariadb

● mariadb.service - MariaDB 10.5.16 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: active (running) since Sat ....; 6s ago

Docs: man:mariadbd(8)

https://mariadb.com/kb/en/library/systemd/

Process: 5269 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)

Process: 5271 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: 5533 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)

Main PID: 5481 (mariadbd)

Status: "Taking your SQL requests now..."

Tasks: 28 (limit: 38474)

Memory: 1.0G

CPU: 1.275s

CGroup: /system.slice/mariadb.service

└─5481 /usr/sbin/mariadbd

systemd[1]: Starting MariaDB 10.5.16 database server...

mariadbd[5481]: .... [Note] /usr/sbin/mariadbd (mysqld 10.5.16-MariaDB-log) starting as process 5481 ...

systemd[1]: Started MariaDB 10.5.16 database server.

by owl