1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
include/group_replication.inc
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
[connection server1]
############################################################
# 1. Bootstrap a group on server1.
# Setup a debug point that will block a future
# STOP GROUP_REPLICATION command
# after the plugin_running_lock is acquired.
[connection server1]
include/start_and_bootstrap_group_replication.inc
SET @@GLOBAL.DEBUG='+d,gr_plugin_gr_stop_after_holding_plugin_running_lock';
############################################################
# 2. Asynchronously execute STOP GROUP_REPLICATION command.
[connection server_1]
STOP GROUP_REPLICATION;
[connection server1]
SET DEBUG_SYNC= "now WAIT_FOR signal.reached_plugin_gr_stop_after_holding_plugin_running_lock";
SET @@GLOBAL.DEBUG='-d,gr_plugin_gr_stop_after_holding_plugin_running_lock';
############################################################
# 3. Try to change Group Replication member actions while a
# STOP GROUP_REPLICATION is ongoing, they must fail.
[connection server1]
SELECT group_replication_reset_member_actions();
ERROR HY000: The function 'group_replication_reset_member_actions' failed. It cannot be called while START or STOP GROUP_REPLICATION is ongoing.
SELECT group_replication_enable_member_action("mysql_disable_super_read_only_if_primary", "AFTER_PRIMARY_ELECTION");
ERROR HY000: The function 'group_replication_enable_member_action' failed. It cannot be called while START or STOP GROUP_REPLICATION is ongoing.
SELECT group_replication_disable_member_action("mysql_disable_super_read_only_if_primary", "AFTER_PRIMARY_ELECTION");
ERROR HY000: The function 'group_replication_disable_member_action' failed. It cannot be called while START or STOP GROUP_REPLICATION is ongoing.
include/assert.inc [The version of replication_group_member_actions must be 1]
############################################################
# 4. Resume the STOP GROUP_REPLICATION command.
[connection server1]
SET DEBUG_SYNC= "now SIGNAL signal.resume_plugin_gr_stop_after_holding_plugin_running_lock";
[connection server_1]
include/gr_wait_for_member_state.inc
############################################################
# 5. Clean up.
[connection server1]
SET DEBUG_SYNC= 'RESET';
SET @@GLOBAL.read_only= 0;
include/group_replication_end.inc
|
