During normal periodic patching sudo apt-get update & upgrade produces an upgrade failure which has me stumped. MariaDB errors out with the following:
“Setting up mariadb-server-10.1 Job for mariadb.service failed because the control process exited with error code. See “systemctl status mariadb.service” and journalctl -xe” for details.
Drop-In" /etc/systemd/system/mariadb.service.d migrated-from-my.cnf-settings.conf, service.conf Active: FAILED (result: exit-code)
It then says “Status: MariaDB Server is down” and further down it indicated that Package mariadb-server-10.1 is not configured yet. Error processing package mariadb-server - leaving unconfigured.
Every night MariaDB now crashes and it appears to be a memory leak perhaps due to a nightly backup which may not be completing.
I have tried removing MariaDB and reinstalling and it does not seem to be the issue. I can restart the service and it will keep working for another day but I would like to figure out what is holding back the upgrade to 10.1.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Hello there,
I’ll recommend to use the MySQL tuner script to optimize the performance and also add SWAP space to the droplet.
The MySQL Tuner is a script written in Perl and allows you to quickly test your MySQL configuration and it gives you suggestions for adjustments to increase performance and stability.
https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-20-04
Hope that this helps!
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.