Debian Codegraph @

mysql-test/suite/group_replication/r/gr_start_fail_restore_read_mode.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
7 # 1. Change for server 2 and stop it
8 #############################################################
9 [connection server2]
10 SET SESSION sql_log_bin=0;
11 call mtr.add_suppression("Server id not set, will not start replica for channel 'group_replication_applier'");
12 call mtr.add_suppression("Error while starting the group replication applier thread");
13 call mtr.add_suppression("Unable to initialize the Group Replication applier module.");
14 SET SESSION sql_log_bin=1;
15 include/stop_group_replication.inc
16
17 # 2. Set READ_ONLY= ON and SUPER_READ_ONLY= ON, configure
18 # server with and invalid id an start it
19 #############################################################
20 SET GLOBAL super_read_only = 1;
21 SET GLOBAL server_id=0;
22 START GROUP_REPLICATION;
23 Got one of the listed errors
24
25 # 3. Confirm that server is configured with READ_ONLY= ON
26 # and SUPER_READ_ONLY= ON
27 #############################################################
28 include/assert_and_disable_read_only.inc
29
30 # 4. Set READ_ONLY= ON configure server with a invalid
31 # server id an start it
32 #############################################################
33 SET GLOBAL read_only = 1;
34 SET GLOBAL server_id=0;
35 START GROUP_REPLICATION;
36 Got one of the listed errors
37
38 # 5. Confirm that server is configured with READ_ONLY= ON
39 # and SUPER_READ_ONLY= OFF
40 #############################################################
41 include/assert.inc [The read_only mode must be 1]
42 include/assert.inc [The super_read_only mode must be 0]
43
44 # 6. Set READ_ONLY= OFF and SUPER_READ_ONLY= OFF, configure
45 # server with and invalid id an start it
46 #############################################################
47 SET GLOBAL read_only = 0;
48 SET GLOBAL server_id=0;
49 START GROUP_REPLICATION;
50 Got one of the listed errors
51
52 # 7. Confirm that server is configured with READ_ONLY= OFF
53 # and SUPER_READ_ONLY= OFF
54 #############################################################
55 include/assert.inc [The read_only mode must be 0]
56 include/assert.inc [The super_read_only mode must be 0]
57
58 # 8. Clean up
59 #############################################################
60 SET GLOBAL server_id= 2;
61 include/group_replication_end.inc