Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11959

SET GLOBAL wsrep_provider_options='pc.weight=<n>' not set properly, always one behind. Needs to be set twice.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: In Progress (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.1.21, 5.5.54-galera, 10.0.29-galera, 10.3.5
    • Fix Version/s: 10.1
    • Component/s: Galera
    • Labels:

      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.

        Attachments

          Activity

            People

            Assignee:
            seppo Seppo Jaakola
            Reporter:
            claudio.nanni Claudio Nanni (Inactive)
            Votes:
            2 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration