this version of MariaDB doesn't yet support 'GET_LOCK in cluster (WSREP_ON=ON)
Affected version
Version: %2.16.2 ( maybe previous)
Platform: Apache and galera cluster
Summary
After uprade our SSO stack with the following upgrade MariaDB-server.x86_64 0:10.5.18-1.el7.centos => MariaDB-server.x86_64 0:10.5.20-1.el7.centos (Galera cluster) LL::NG 2.0.15 to LL:NG 2.16.2 We always connect on our SSO but writing configuration isn't possible anymore
Logs
On the manager interface we get an error message :
Get remote configuration (localStorage unavailable). Get configuration 494. DBD::mysql::db selectrow_array failed: This version of MariaDB doesn't yet support 'GET_LOCK in cluster (WSREP_ON=ON)'
Backends used
- Our storage backend is a Galera cluster 10.5.20 on centos with 5 nodes
- A limitation appears in mariadb 10.5.20 : GET_LOCK() / RELEASE_LOCK() are dropped in galera cluster mode since 10.5.20
Possible fixes
It could be possible to insert an exception in code see : https://gitlab.ow2.org/lemonldap-ng/lemonldap-ng/-/blob/v2.0/lemonldap-ng-common/lib/Lemonldap/NG/Common/Conf/Backends/_DBI.pm#L82
In order to test if MariadB is in cluster mode or not It could be a request like "show status like 'wsrep_cluster_conf_id"' which implies the use of a cluster.