Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.1.21, 5.5.54-galera, 10.0.29-galera, 10.3.5
Description
Upstream: https://github.com/codership/galera/issues/446
On multiple MariaDB Server versions (5.5.x & 10.0.x).
If I try to set SET GLOBAL wsrep_provider_options='pc.weight=' on a cluster with more than one running node the value is not picked up immediately, it looks like it is always one behind.
SHOW GLOBAL VARIABLES like 'wsrep_provider%';
....pc.weight = 1; ....
SET GLOBAL wsrep_provider_options='pc.weight=5';
SHOW GLOBAL VARIABLES like 'wsrep_provider%';
....pc.weight = 1; ....
SET GLOBAL wsrep_provider_options='pc.weight=9';
SHOW GLOBAL VARIABLES like 'wsrep_provider%';
....pc.weight = 5; ....
SET GLOBAL wsrep_provider_options='pc.weight=22';
SHOW GLOBAL VARIABLES like 'wsrep_provider%';
....pc.weight = 9; ....
So basically to set the parameter I have to set it twice to the same value:
SET GLOBAL wsrep_provider_options='pc.weight=45';
SET GLOBAL wsrep_provider_options='pc.weight=45';
SHOW GLOBAL VARIABLES like 'wsrep_provider%';
....pc.weight = 45; ....
Please note: This does not happen if only one Galera node is running.