The Ultimate Guide to High Availability with MariaDB

Comments - MariaDB errors after OpenSUSE Leap update

 
3 years, 2 months ago Erik Gordon Bainbridge
Re: MariaDB errors after OpenSUSE Leap update [Answer]

In case it helps someone, here is how I solved the problem. This is on OpenSUSE Leap 15.2.

1. Renamed /var/lib/mysql and /etc/my.cnf to temporary names 2. Completely uninstalled mariadb 3. Created a file in /etc/systemd/system/mariadb.service.d to increase the open files limit and then reload the systemd manager configuration with the following code

tee /etc/systemd/system/mariadb.service.d/limitnofile.conf <<EOF
[Service]

LimitNOFILE=1048576
EOF
systemctl daemon-reload

4. Installed mariadb and mariadb-tools 5. Deleted /var/mysql and /etc/my.cnf created by mariadb and renamed my old ones to these names

My system is fine now. Renaming /var/lib/mysql and /etc/my.cnf were essential steps. I still don't know why an OpenSUSE update triggered the problem. I dudn't see comments about it in OpenSUSE forums, so there must have been something in my configuration that caused it, but I don't know what. I have a pretty standard installation.

 
3 years, 2 months ago Daniel Black
Re: MariaDB errors after OpenSUSE Leap update

I cannot tell from this output. The error is somewhere earlier in mysql-systemd-helper and its output seems to relate to a mysql-install-db invokation.

Look at journalctl -n 400 -u mariadb.service to see what the beginnings of the error message say.

Could it be you have the datadir on /home somewhere? If so - https://mariadb.com/kb/en/systemd/#configuring-access-to-home-directories .

The source for this script I found is:

https://build.opensuse.org/package/view_file/server:database/mariadb/mysql-systemd-helper?expand=1

As this is an OpenSuSE specific bug I'd suggest if nothing works out it gets raised in their bug tracker - https://bugzilla.opensuse.org

 
3 years, 2 months ago Erik Gordon Bainbridge
Re: MariaDB errors after OpenSUSE Leap update

Thanks for your reply, Daniel. While they didn't lead to a solution, they were good suggestions. I appreciate you taking the time to offer them.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.