set gcs.fc_master_slave=YES gives error

[Jay Janssen]

mysql> set global wsrep_provider_options="gcs.fc_master_slave=YES";
ERROR 1210 (HY000): Incorrect arguments to SET
mysql> show variables like 'wsrep_provider_options';
+------------------------+-------------------------+
| Variable_name | Value |
+------------------------+-------------------------+
| wsrep_provider_options | gcs.fc_master_slave=YES |
+------------------------+-------------------------+
1 row in set (0.00 sec)

Two issues here:
- The 'incorrect arguments' error
- When I set an invalid parameter in wsrep_provider_options, SHOW VARIABLES incorrectly shows me the bad setting, and not all the settings within wsrep_provider_options

[Jay Janssen (jay-janssen)]

I believe this is simply a non-dynamic variable. However, the behavior of SHOW VARIABLES should be addressed.

[Raghavendra D Prabhu (raghavendra-prabhu)]

Confirmed.

gcs.c seems to be missing something similar to:

    else if (!strcmp (key, GCS_PARAMS_SYNC_DONOR)) {
        return _set_sync_donor (conn, value);
    }

well, it may be that this is indeed a non-dynamic variable (though I see conn->params.fc_master_slave ), but having a dummy method in that case may help.

[Alex Yurchenko (ayurchen)]

lp:1066864 and lp:1069271 are duplicates

[Seppo Jaakola (seppo-jaakola)]

The fix reads back the effective provider options from wsrep provider plugin, after a failed attempt to change options.
set gcs.fc_master_slave is not dynamic option, hence the failure in the SET command in the first place.

The fix is pushed in revision: http://bazaar.launchpad.net/~codership/codership-mysql/5.5-23/revision/3869

[Raghavendra D Prabhu (raghavendra-prabhu)]

This issue is there in 5.6 too, hence the fix https://bazaar.launchpad.net/~codership/codership-mysql/5.5-23/revision/3869#sql/wsrep_var.cc needs to be ported to 5.6 tree.

[Seppo Jaakola (seppo-jaakola)]

Right, will merge this to wsrep-5.6 branch as well

[Seppo Jaakola (seppo-jaakola)]

Merged fix from wsrep-5.5-23 in revision: http://bazaar.launchpad.net/~codership/codership-mysql/5.6/revision/3975

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1223