Unknown storage engine 'Aria'

[Jakubauskas]

Hello,

updated Mariadb via custombuild to latest version and it has crashed

root@dev:/usr/local/directadmin/custombuild# service mysqld status
× mysqld.service - MySQL database server
Loaded: loaded (/etc/systemd/system/mysqld.service; enabled; preset: enabled)
Active: failed (Result: exit-code) since Tue 2024-03-05 09:07:54 UTC; 23s ago
Process: 305461 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 305463 ExecStartPre=/bin/sh -c [ ! -e /usr/local/mysql/bin/galera_recovery ] && VAR= || VAR=`cd /usr/local/mysql/bin/..; /usr/local/mysql/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-enviro>
Process: 305480 ExecStart=/usr/local/mysql/bin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock (code=exited, status=1/FAILURE)
Main PID: 305480 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
CPU: 81ms

Mar 05 09:07:54 dev.kobioki.lt mysqld[305480]: 2024-03-05 9:07:54 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Mar 05 09:07:54 dev.kobioki.lt mysqld[305480]: 2024-03-05 9:07:54 0 [Note] InnoDB: 10.6.17 started; log sequence number 153013; transaction id 88
Mar 05 09:07:54 dev.kobioki.lt mysqld[305480]: 2024-03-05 9:07:54 0 [Note] Plugin 'FEEDBACK' is disabled.
Mar 05 09:07:54 dev.kobioki.lt mysqld[305480]: 2024-03-05 9:07:54 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Mar 05 09:07:54 dev.kobioki.lt mysqld[305480]: 2024-03-05 9:07:54 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded
Mar 05 09:07:54 dev.kobioki.lt mysqld[305480]: 2024-03-05 9:07:54 0 [ERROR] Failed to initialize plugins.
Mar 05 09:07:54 dev.kobioki.lt mysqld[305480]: 2024-03-05 9:07:54 0 [ERROR] Aborting
Mar 05 09:07:54 dev.kobioki.lt systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE
Mar 05 09:07:54 dev.kobioki.lt systemd[1]: mysqld.service: Failed with result 'exit-code'.
Mar 05 09:07:54 dev.kobioki.lt systemd[1]: Failed to start mysqld.service - MySQL database server.

What could be the issue?

root@dev:/usr/local/directadmin/custombuild# cat /etc/my.cnf
[mysqld]
max_allowed_packet=64M
local-infile=0
innodb_file_per_table

[client]
socket=/usr/local/mysql/data/mysql.sock

 

[Richard G]

Be sure to have a backup.

You can try this and see if it fixes things.

1.) Shutdown mysql service from Directadmin. Do not via SSH because DA will restart the service again automatically!! Check via SSH via the status command if it's indeed down.
2.) Issue this command as root via SSH: mv /var/lib/mysql/aria_log_control /var/lib/mysql/aria_log_control.orig so you have a backup of that file
3.) Start mysql again, systemctl start mysqld and check if it works now without errors.
4.) Check if a new /var/lib/mysql/aria_log_control file is created.