@Alex,
Ah yes, that could be the reason. But I tried to bootstrap it, it doesn't work.
"" SET GLOBAL wsrep_provider_options="pc.bootstrap=1"; ERROR 1210 (HY000): Incorrect arguments to SET ""
This may be because after setting the provider again (from 'none') I see following in error log (and in variables)
131212 15:51:50 [Note] WSREP: Passing config to GCS: base_host = 127.0.0.1; base_port = 4567; cert.log_conflicts = no; gcache.dir = /pxc/datadir/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /pxc/datadir//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.proto_max = 5
There are two issues here:
a) The config set in my.cnf is lost, it is not refreshed to provider.
b) There are no pc, protonet, ist etc. parameters above. So they are also lost. Hence bootstrapping is not possible.
Full log: =================================================================================
131212 15:51:48 [Note] WSREP: wsrep_provider_update: /pxc56/lib/libgalera_smm.so 131212 15:51:48 [Note] WSREP: Stop replication 131212 15:51:48 [Note] WSREP: Provider disconnect 131212 15:51:50 [Note] WSREP: waiting for client connections to close: 1 131212 15:51:50 [Note] WSREP: Setting wsrep_ready to 0 131212 15:51:50 [Note] WSREP: Read WSREPXid from InnoDB: 5805bbc4-3038-11e3-937d-aa946afe7370:15933 131212 15:51:50 [Note] WSREP: Initial position: 5805bbc4-3038-11e3-937d-aa946afe7370:15933 131212 15:51:50 [Note] WSREP: wsrep_load(): loading provider library '/pxc56/lib/libgalera_smm.so' 131212 15:51:50 [Note] WSREP: wsrep_load(): Galera 3.2(rXXXX) by Codership Oy <email address hidden> loaded successfully. 131212 15:51:50 [Note] WSREP: CRC-32C: using hardware acceleration. 131212 15:51:50 [Note] WSREP: Found saved state: 5805bbc4-3038-11e3-937d-aa946afe7370:15933 131212 15:51:50 [Note] WSREP: Passing config to GCS: base_host = 127.0.0.1; base_port = 4567; cert.log_conflicts = no; gcache.dir = /pxc/datadir/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /pxc/datadir//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.proto_max = 5 131212 15:51:50 [Note] WSREP: Assign initial position for certification: 15933, protocol version: -1 131212 15:51:50 [Note] WSREP: wsrep_cluster_address_init: null -> null 131212 15:51:50 [Note] WSREP: refresh_provider_options: null 131212 15:53:20 [Warning] WSREP: Unknown parameter 'pc.bootstrap' 131212 15:53:20 [ERROR] WSREP: Set options returned 7 131212 15:53:20 [Note] WSREP: refresh_provider_options: pc.bootstrap=1; 131212 15:53:22 [Warning] WSREP: Unknown parameter 'pc.bootstrap' 131212 15:53:22 [ERROR] WSREP: Set options returned 7 131212 15:53:22 [Note] WSREP: refresh_provider_options: pc.bootstrap=1 131212 15:53:41 [Warning] WSREP: Unknown parameter 'pc.bootstrap' 131212 15:53:41 [ERROR] WSREP: Set options returned 7 131212 15:53:41 [Note] WSREP: refresh_provider_options: pc.bootstrap=1 131212 15:54:23 [Warning] WSREP: Unknown parameter 'pc.bootstrap' 131212 15:54:23 [ERROR] WSREP: Set options returned 7 131212 15:54:23 [Note] WSREP: refresh_provider_options: pc.bootstrap=1 =========================================================================================
Noticed another thing during this:
131212 15:51:41 [Note] WSREP: wsrep_load(): loading provider library 'none' 131212 15:51:41 [Note] WSREP: Setting wsrep_ready to 1 131212 15:51:41 [Note] WSREP: wsrep_cluster_address_init: gcomm://?pc.ignore_sb=true -> null 131212 15:51:41 [Note] WSREP: refresh_provider_options: null 131212 15:51:41 [ERROR] WSREP: Failed to get provider options
Is the error above a false positive or a bug?
@Alex,
Ah yes, that could be the reason.
But I tried to bootstrap it, it doesn't work.
"" options= "pc.bootstrap= 1";
SET GLOBAL wsrep_provider_
ERROR 1210 (HY000): Incorrect arguments to SET
""
This may be because after setting the provider again (from
'none') I see following in error log (and in variables)
131212 15:51:50 [Note] WSREP: Passing config to GCS: base_host = 127.0.0.1; base_port = 4567; cert.log_conflicts = no; gcache.dir = /pxc/datadir/; gcache. keep_pages_ size = 0; gcache.mem_size = 0; gcache.name = /pxc/datadir/ /galera. cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_ q_hard_ limit = 922337203685477 5807; gcs.recv_ q_soft_ limit = 0.25; gcs.sync_donor = NO; repl.causal_ read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.proto_max = 5
There are two issues here:
a) The config set in my.cnf is lost, it is not refreshed to
provider.
b) There are no pc, protonet, ist etc. parameters above. So they
are also lost. Hence bootstrapping is not possible.
Full log: ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ====
=======
131212 15:51:48 [Note] WSREP: wsrep_provider_ update: /pxc56/ lib/libgalera_ smm.so 3038-11e3- 937d-aa946afe73 70:15933 3038-11e3- 937d-aa946afe73 70:15933 lib/libgalera_ smm.so' 3038-11e3- 937d-aa946afe73 70:15933 keep_pages_ size = 0; gcache.mem_size = 0; gcache.name = /pxc/datadir/ /galera. cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_ q_hard_ limit = 922337203685477 5807; gcs.recv_ q_soft_ limit = 0.25; gcs.sync_donor = NO; repl.causal_ read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.proto_max = 5 address_ init: null -> null provider_ options: null provider_ options: pc.bootstrap=1; provider_ options: pc.bootstrap=1 provider_ options: pc.bootstrap=1 provider_ options: pc.bootstrap=1 ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= =====
131212 15:51:48 [Note] WSREP: Stop replication
131212 15:51:48 [Note] WSREP: Provider disconnect
131212 15:51:50 [Note] WSREP: waiting for client connections to close: 1
131212 15:51:50 [Note] WSREP: Setting wsrep_ready to 0
131212 15:51:50 [Note] WSREP: Read WSREPXid from InnoDB: 5805bbc4-
131212 15:51:50 [Note] WSREP: Initial position: 5805bbc4-
131212 15:51:50 [Note] WSREP: wsrep_load(): loading provider library '/pxc56/
131212 15:51:50 [Note] WSREP: wsrep_load(): Galera 3.2(rXXXX) by Codership Oy <email address hidden> loaded successfully.
131212 15:51:50 [Note] WSREP: CRC-32C: using hardware acceleration.
131212 15:51:50 [Note] WSREP: Found saved state: 5805bbc4-
131212 15:51:50 [Note] WSREP: Passing config to GCS: base_host = 127.0.0.1; base_port = 4567; cert.log_conflicts = no; gcache.dir = /pxc/datadir/; gcache.
131212 15:51:50 [Note] WSREP: Assign initial position for certification: 15933, protocol version: -1
131212 15:51:50 [Note] WSREP: wsrep_cluster_
131212 15:51:50 [Note] WSREP: refresh_
131212 15:53:20 [Warning] WSREP: Unknown parameter 'pc.bootstrap'
131212 15:53:20 [ERROR] WSREP: Set options returned 7
131212 15:53:20 [Note] WSREP: refresh_
131212 15:53:22 [Warning] WSREP: Unknown parameter 'pc.bootstrap'
131212 15:53:22 [ERROR] WSREP: Set options returned 7
131212 15:53:22 [Note] WSREP: refresh_
131212 15:53:41 [Warning] WSREP: Unknown parameter 'pc.bootstrap'
131212 15:53:41 [ERROR] WSREP: Set options returned 7
131212 15:53:41 [Note] WSREP: refresh_
131212 15:54:23 [Warning] WSREP: Unknown parameter 'pc.bootstrap'
131212 15:54:23 [ERROR] WSREP: Set options returned 7
131212 15:54:23 [Note] WSREP: refresh_
=======
Noticed another thing during this:
131212 15:51:41 [Note] WSREP: wsrep_load(): loading provider library 'none' address_ init: gcomm:/ /?pc.ignore_ sb=true -> null provider_ options: null
131212 15:51:41 [Note] WSREP: Setting wsrep_ready to 1
131212 15:51:41 [Note] WSREP: wsrep_cluster_
131212 15:51:41 [Note] WSREP: refresh_
131212 15:51:41 [ERROR] WSREP: Failed to get provider options
Is the error above a false positive or a bug?