Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-2230

making gcs fclimit check consistent (during server start and dynamic setting)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.7.24-31.33, 5.6.42-28.30
    • Component/s: None
    • Labels:
      None
    • Environment:

      Description

      It seems correct behavior to avoid setting "0" as gcs.fc_limit variable.

       

      mysql> SET GLOBAL wsrep_provider_options = "gcs.fc_limit = 0;";
      ERROR 1210 (HY000): Incorrect arguments to SET
      

      But we could set its value by adding setting to my.cnf.

       

      $ sudo vi /etc/my.cnf
      ### add below setting
      wsrep_provider_options = "gcs.fc_limit=0;"
      
      $ sudo systemctl restart mysql
      
      mysql> show global variables like "wsrep_provider_options"\G
      *************************** 1. row ***************************
      Variable_name: wsrep_provider_options
      Value: base_dir = /var/lib/mysql/; base_host = 192.168.10.10; base_port = 4567; 
      ...(cut)...
      gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 0; gcs.fc_master_slave = no;
      ...(cut)...

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                krunal.bauskar Krunal Bauskar
                Reporter:
                y-taka Yoshimi Takahashi
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Time Spent - 4 hours Remaining Estimate - 4 hours
                  4h
                  Logged:
                  Time Spent - 4 hours Remaining Estimate - 4 hours
                  4h