Debian Codegraph @

mysql-test/suite/group_replication/t/gr_reset_master.test

raw
1 ################################################################################
2 # This test intends to prove that members can survive reset master commands.
3 # These commands end up causing the members to purge their relay logs
4 #
5 # Test:
6 # 0. The test requires two servers: M1 and M2.
7 # 1. On M1, test a reset master command before start GR. It MUST be successful.
8 # 2. Bootstrap start a group on M1. Start GR on M2.
9 # 3. Create a table and insert some data.
10 # 4. Validate both members must have the same GTID set.
11 # 5. Stop GR and reset master on both members.
12 # 6. Restart both members (Bootstrap start a group on M2. Start GR on M1).
13 # 7. Insert some data to test that the group is still running.
14 # 8. Run RESET MASTER while GR is running. It must fail.
15 # 9. Clean up.
16 ################################################################################
17 --source include/have_group_replication_gtid_assignment_block_size_1.inc
18 --let $group_replication_group_name= c90c3c80-fde4-11e3-a3ac-0800200c9a66
19 --source include/have_group_replication_plugin.inc
20
21 --let $rpl_skip_group_replication_start= 1
22 --source include/group_replication.inc
23
24 --connection server1
25 --echo #Test a reset command before start.
26 RESET MASTER;
27
28 --source include/start_and_bootstrap_group_replication.inc
29
30 --connection server2
31 --source include/start_group_replication.inc
32
33 --echo #Create a table and insert some data
34 --connection server1
35 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
36
37 --let $sync_slave_connection= server2
38 --source include/sync_slave_sql_with_master.inc
39
40 --connection server2
41 INSERT INTO t1 VALUES (1);
42
43 --connection server1
44 INSERT INTO t1 VALUES (2);
45
46 --let $sync_slave_connection=server2
47 --source include/sync_slave_sql_with_master.inc
48
49 --connection server2
50 INSERT INTO t1 VALUES (3);
51
52 --let $sync_slave_connection=server1
53 --source include/sync_slave_sql_with_master.inc
54
55 --echo #Both members must have the same GTID set
56 --let $server_count=2
57 while ($server_count)
58 {
59 --connection server$server_count
60 --let $assert_text= On member $server_count, all executed GTID should belong to the group
61 --let $assert_cond= "[SELECT @@GLOBAL.GTID_EXECUTED]" = "c90c3c80-fde4-11e3-a3ac-0800200c9a66:1-6";
62 --source include/assert.inc
63 --dec $server_count
64 }
65
66 --echo #Stop and reset both members
67
68 --connection server1
69 --source include/stop_group_replication.inc
70 RESET MASTER;
71
72 --connection server2
73 --source include/stop_group_replication.inc
74 RESET MASTER;
75
76 --echo #Restart both members
77
78 --source include/start_and_bootstrap_group_replication.inc
79
80 --connection server1
81
82 --source include/start_group_replication.inc
83
84 --echo #Both members must have an empty gtid set
85 --let $server_count=2
86 while ($server_count)
87 {
88 --connection server$server_count
89 --let $assert_text= On member $server_count, there should only 2 transactions from view changes
90 --let $assert_cond= "[SELECT @@GLOBAL.GTID_EXECUTED]" = "c90c3c80-fde4-11e3-a3ac-0800200c9a66:1-2";
91 --source include/assert.inc
92 --dec $server_count
93 }
94
95 --echo #Insert some data to test that the group is still running
96
97 INSERT INTO t1 VALUES (4);
98 --let $sync_slave_connection=server2
99 --source include/sync_slave_sql_with_master.inc
100
101 INSERT INTO t1 VALUES (5);
102 --let $sync_slave_connection=server1
103 --source include/sync_slave_sql_with_master.inc
104
105 --let $server_count=2
106 while ($server_count)
107 {
108 --connection server$server_count
109 --let $assert_text= On member $server_count, the table should exist and have 5 elements
110 --let $assert_cond= [select count(*) from t1] = 5;
111 --source include/assert.inc
112 --dec $server_count
113 }
114
115 --echo # Run RESET MASTER while Group Replication is running must fail
116 --error ER_CANT_RESET_SOURCE
117 RESET MASTER;
118
119 --echo # Clean up
120 DROP TABLE t1;
121 --source include/group_replication_end.inc