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

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.1.21, 5.5.54-galera, 10.0.29-galera, 10.3.5
    • N/A
    • Galera

    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

            seppo Seppo Jaakola
            claudio.nanni Claudio Nanni
            Votes:
            2 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.