In this article, we will discuss MariaDB crashing as MariaDB is open-source software and is one of the most popular database servers. Its latest update (published on 5th November 2019) has caused the database to fail when started with WHM and cPanel servers.
Recent MariaDB (MDEV-19073) Issue
If you run the following MariaDB versions, the chances are your website will keep crashing. The MDEV-19073 issue is found in:
You will see the following error message in the MariaDB startup output on affected systems:
InnoDB: Failing assertion:table->can_be_evicted
Solution For The Crash
MariaDB knows the issue and is working towards it. Till then you can perform a downgrade of the MariaDB RPM packages.
How can you perform a downgrade? There are no supported methods of downgrading MariaDB using WHM and cPanel, you can manually perform this downgrade using this command:
yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel
This is only a temporary fix to the problem. You will continue to face crashes if your server is configured to automatically update the system packages. You need to pause the MariaDB RPMs upgrades until they publish a fix for this error.
In fact, we also use MariaDB in our stacks and encountered the crashing issue today. We immediately assessed the issue and fixed it by
Got issues? Contact our experts!
Sakshi takes care of everything related to Marketing at Webscoot.io. She has knowledge about Magento, WordPress, and Dogs.
Thanks! This solution helped fix my mariadb error on cpanel.