MariaDB fails to start: Aria engine is not enabled or did not start

Symptoms

• Plesk update process fails with the following error message:

  ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
  ...
  Trying to start service mysql... failed
  ...
  server.example.com systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
  server.example.com systemd[1]: Failed to start MariaDB 10.2.13 database server.
  server.example.com systemd[1]: Unit mariadb.service entered failed state.
  server.example.com systemd[1]: mariadb.service failed.

• MariaDB service fails to start. The following error message is logged in /var/log/messages:

  [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables

  ---

  [Note] mysqld: Aria engine: starting recovery
  recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80%201210 16:07:56 [ERROR] mysqld got signal 11 ;

  ---

  [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'"

Cause

Unclear.

Resolution

1. Connect to the Plesk server via SSH.

2. Shut down MariaDB database server:

   # mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` -h127.0.0.1 --protocol=tcp shutdown

3. Rename the aria_log_control file:

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

4. Start MariaDB service:

   # service mariadb start

5. Run Plesk Update:

   # plesk installer update