Comment 5 for bug 1260283

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

@Yan,

It works but I noticed this:

MySQL [(none)]> set global wsrep_provider='none';
Query OK, 0 rows affected (2.02 sec)

MySQL [(none)]> set global wsrep_provider='/usr/lib64/libgalera_smm.so';
Query OK, 0 rows affected (2.03 sec)

MySQL [(none)]> set global wsrep_provider_options="gmcast.listen_addr=tcp://127.0.0.1:4010"; -- Fails due to no cluster address, this is OK
ERROR 1210 (HY000): Incorrect arguments to SET
MySQL [(none)]>
MySQL [(none)]> set global wsrep_cluster_address='gcomm://127.0.0.1:5010,127.0.0.1:6010'; --- Fails (in log), but lets ignore that for now.
Query OK, 0 rows affected (35.02 sec)

MySQL [(none)]> set global wsrep_cluster_address='gcomm://';
Query OK, 0 rows affected (2.00 sec)

MySQL [(none)]> set global wsrep_provider_options="gmcast.listen_addr=tcp://127.0.0.1:4010"; ------ This fails.
ERROR 1210 (HY000): Incorrect arguments to SET

It fails with:
================

2014-04-30 10:04:30 13562 [Note] WSREP: Nobody is waiting for SST.
2014-04-30 10:04:34 13562 [Warning] WSREP: error setting param gmcast.listen_addr to value tcp://127.0.0.1:4010: can't change value for 'gmcast.listen_addr' during runtime: 1 (Operation not permitted)
         at gcomm/src/gmcast.cpp:set_param():1640
2014-04-30 10:04:34 13562 [Warning] WSREP: Setting parameter 'gmcast.listen_addr' to 'tcp://127.0.0.1:4010' failed: Setting 'gmcast.listen_addr' to 'tcp://127.0.0.1:4010' failed: 1 (Operation not permitted)
         at galera/src/gcs.hpp:param_set():206
2014-04-30 10:04:34 13562 [ERROR] WSREP: Set options returned 7
2014-04-30 10:04:34 13562 [Note] WSREP: refresh_provider_options: gmcast.listen_addr=tcp://127.0.0.1:4010

The problem is that, without ability to set listen_addr before it
actually listens, it ends up listening on default addr:port.

wsrep_provider_options - http://paste.wnohang.net/5368df