MariaDB: Unknown storage engine 'Aria'

Symptoms

MariaDB is unable to start, and the error log contains messages similar to the following.

CONFIG_TEXT: [ERROR] Plugin 'Aria' init function returned error.
[ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.

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

Cause

This issue occurs due to corrupt data in the aria_log files. Moving the files out of the way will allow MariaDB to start and regenerate the files.

Resolution

1. Access the server's command line as the root user via SSH or Terminal in WHM.

2. Move the aria_log files out of the way:

   # find /var/lib/mysql/ -name 'aria_log*' -exec mv -v {}{,.$(date +%s)} \;

   Note: If MariaDB is configured with a custom "datadir," then "/var/lib/mysql/" must be replaced with the custom "datadir" path.
    

3. Restart MariaDB:

   # /scripts/restartsrv_mysql

Note: If you need further assistance with MariaDB, you should contact a qualified system or database administrator for further review:
System Administration Services