Upgrade to MariaDB 10.11.3 problem

Upgrade to MariaDB 10.11.3 problem

- Erik Frangež の投稿
返信数: 2

Hello, 

During the last days we have tried to upgrade our Galera cluster (MariaDB 10.8.3) to latest LTS version 10.11.3.

Upgrade was successfull:

Package MariaDB-client-10.11.3-1.el7.centos.x86_64 already installed and latest version

Package MariaDB-common-10.11.3-1.el7.centos.x86_64 already installed and latest version

Package MariaDB-compat-10.11.3-1.el7.centos.x86_64 already installed and latest version

Package MariaDB-server-10.11.3-1.el7.centos.x86_64 already installed and latest version

Package galera-4-26.4.14-1.el7.centos.x86_64 already installed and latest version

but on the Moodle side we have noticed some problems. After upgrade Moodle starts reporting:

            This version of MariaDB doesn't yet support 'GET_LOCK in cluster (WSREP_ON=ON)'

If we check on cluster side everything is working well, databases are in sync.

Our environment, temporary, is CentOS7 with MariaDB Galera cluster (10.8.3, which we would like to upgrade to latest LTS version 10.11.3). Moodle version is 3.11., in future we are planing to upgrade to 4.1.

We are wondering if there is anything to do to »bypass« this error. On out DEV/QA environment we are having also Galera cluster, MariaDB is upgraded to 10.11.3, and is working well. There is one difference, on DEV/QA environment we are having different operating system – Ubuntu 22.04.2 (LTS).

Thank you for your help.

Best,

Erik

Erik Frangež への返信

Re: Upgrade to MariaDB 10.11.3 problem

- Visvanath Ratnaweera の投稿
画像 Particularly helpful Moodlers 画像 Translators
Do you know what Moodle release(s) will run on MariaDB 10.11? I know, documents like https://moodledev.io/general/releases/4.2 say "Latest", but that is a moving target. May be you can contribute to http://www.syndrega.ch/blog/#php-and-dbms-compatibility-of-major-moodle-releases - the final column, specifically. (I am the author.)
Visvanath Ratnaweera への返信

Re: Upgrade to MariaDB 10.11.3 problem

- Ryan Smith の投稿
Is anybody actively running MariaDB 10.11 with Moodle 4.3?

Since 10.11 is LTS we are considering upgrading from 10.6 to 10.11.