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.