Debian Codegraph @

mysql-test/suite/group_replication/r/gr_force_peer_addresses_option_parallel.result

raw
1 include/group_replication.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 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.
5 [connection server1]
6 SET SESSION sql_log_bin= 0;
7 call mtr.add_suppression("There is one group_replication_force_members operation already ongoing");
8 SET SESSION sql_log_bin= 1;
9
10 ############################################################
11 # 1. Block during set value to
12 # group_replication_force_members (server_1).
13 [connection server_1]
14 SET @debug_save= @@GLOBAL.DEBUG;
15 SET @@GLOBAL.DEBUG='d,group_replication_wait_on_check_force_members';
16 SET GLOBAL group_replication_force_members= "";
17 [connection server1]
18
19 ############################################################
20 # 2. Try set group_replication_force_members in a
21 # parallel session (server1), it will fail.
22 [connection server1]
23 SET GLOBAL group_replication_force_members= "";
24 ERROR HY000: The 'SET GLOBAL group_replication_force_members=value' command encountered a failure. There is one group_replication_force_members operation already ongoing.
25
26 ############################################################
27 # 3. Resume set value to
28 # group_replication_force_members on server_1.
29 [connection server1]
30 SET DEBUG_SYNC='now SIGNAL waiting';
31 SET @@GLOBAL.DEBUG= @debug_save;
32 [connection server_1]
33 include/assert.inc [group_replication_force_members is empty]
34
35 ############################################################
36 # 4. Try set group_replication_force_members on
37 # server1 again, it will succeed.
38 [connection server1]
39 SET GLOBAL group_replication_force_members= "";
40 include/assert.inc [group_replication_force_members is empty]
41
42 ############################################################
43 # 5. Clean up.
44 include/group_replication_end.inc