Comments - MariaDb Crashing after some wordpress posts

5 years, 11 months ago Daniel Black

Look like you are using 5.5.40 which had some lockup issues. I'd upgrade to the latest 5.5 version.

 
5 years, 11 months ago Nuno Carapito

"yum update" updates MariaDb ? Couldn't find it on the update list sadly.

 
5 years, 11 months ago C Manns

Use https://downloads.mariadb.org/mariadb/repositories/

Get the repo file for your OS, since you mention yum.

Since I don't know whether you installed via yum or rpm.

1) mysqldump --all-databases > /path/to/storage/for/db/backup.sql

2) rpm -qa | grep MariaDB

3) Once the Mariadb repo is installed try yum upgrade && yum update mariadb-server - you'll see the packages with yum search mariadb.

4) If that errors because of the 5.5.40 packages then rpm -e <name of mariadb packages from step 2) then re-install those packages from the "yum search mariadb" list.

Lastly you may need to run mysql_upgrade

 
5 years, 11 months ago Elena Stepanova

An additional note: if you upgrade to 5.5.43, please make sure you are not affected by this issue: MDEV-8115 (the known way to be affected is having views over tables with BLOB or TEXT columns). If you do have those, but not too many, the easiest way to work around the problem is the one that people mentioned in the comments to the issue: drop the views, run mysql_upgrade, then re-create the views.

 
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.