[MariaDB] Unknown storage engine 'Aria'

Symptoms

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

2022-05-04  5:43:30 0 [ERROR] Plugin 'Aria' init function returned error.
2022-05-04  5:43:30 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.

Description

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.

Workaround

1. Access the server's command line as the 'root' user via SSH or "Terminal" in WHM.
2. Move the arai_log files out of the way.

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

   Please note if MariaDB is configured with a custom "datadir," "/var/lib/mysql/" must be replaced with the "datadir" path.
   
3. Restart MariaDB.

   /scripts/restartsrv_mysql

Please note that if you need further assistance, you should contact a qualified system or database administrator for further review.

System Administration Services