Debian Codegraph @

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

raw
1 ################################################################################
2 # === Purpose ===
3 # This test verifies that no transaction prepared ack being sent by a member for
4 # transactions received during recovery.
5 #
6 # === Implementation ===
7 # 00. The test requires three servers: server1 and 2
8 # 01. Boot start server1
9 # 02. Start server2
10 # 03. Stop GR on server1
11 # 04. Execute transactions on the new primary
12 # 05. Add debug points in server1
13 # 06. Start GR on server1, let it waits after
14 # after_wait_for_applier_module_recovery
15 # 07. Add debug points in server1, server waits
16 # before_commit_hook_wait
17 # 08. Commit a transaction on server2 while server1 is
18 # in recovery
19 # 09. On server1, wait for the transaction to reach debug
20 # sync point
21 # 10. Resume recovery on server1, verify that server1 is
22 # online
23 # 11. Resume transaction recived during recovery, verify all
24 # members are still online and server1 executed the
25 # transaction
26 # 12. Verify that all members are still online and server1
27 # executed the transaction
28 # 13. Verify that all members have same data
29 # 14. Cleaning up
30 ################################################################################
31
32 --source include/have_debug_sync.inc
33 --source include/big_test.inc
34 --source include/have_group_replication_plugin.inc
35 --let $rpl_skip_group_replication_start= 1
36 --let $rpl_group_replication_single_primary_mode=1
37 --let $rpl_server_count= 2
38 --source include/group_replication.inc
39
40 --echo
41 --echo ############################################################
42 --echo # 01. Boot start server1
43 --let $rpl_connection_name= server1
44 --source include/rpl_connection.inc
45 --let $sysvars_to_save = [ "GLOBAL.group_replication_consistency" ]
46 --source include/save_sysvars.inc
47 SET GLOBAL group_replication_consistency= 'AFTER';
48 --source include/start_and_bootstrap_group_replication.inc
49
50 --echo
51 --echo ############################################################
52 --echo # 2. Start server2
53 --let $rpl_connection_name= server2
54 --source include/rpl_connection.inc
55 --let $sysvars_to_save = [ "GLOBAL.group_replication_consistency" ]
56 --source include/save_sysvars.inc
57 SET GLOBAL group_replication_consistency= 'AFTER';
58 --source include/start_group_replication.inc
59
60 --echo
61 --echo ############################################################
62 --echo # 3. Stop GR on server1
63 --let $rpl_connection_name= server1
64 --source include/rpl_connection.inc
65 --source include/stop_group_replication.inc
66
67 --echo
68 --echo ############################################################
69 --echo # 4. Execute transactions on the new primary
70 --let $rpl_connection_name= server2
71 --source include/rpl_connection.inc
72
73 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
74 INSERT INTO t1 VALUES (1);
75 INSERT INTO t1 VALUES (2);
76 INSERT INTO t1 VALUES (3);
77
78 --echo
79 --echo ############################################################
80 --echo # 5. Add debug points in server1
81 --let $rpl_connection_name= server1
82 --source include/rpl_connection.inc
83 SET @@GLOBAL.DEBUG= '+d,recovery_thread_wait_after_wait_for_applier_module_recovery';
84
85 --echo
86 --echo ############################################################
87 --echo # 6. Start GR on server1, let it waits after
88 --echo # after_wait_for_applier_module_recovery
89 --let $group_replication_start_member_state= RECOVERING
90 --source include/start_group_replication.inc
91
92 SET DEBUG_SYNC = "now WAIT_FOR signal.recovery_thread_wait_after_wait_for_applier_module_recovery";
93
94 --let $assert_text= Verify MEMBER_STATE is RECOVERING
95 --let $assert_cond= "[SELECT MEMBER_STATE FROM performance_schema.replication_group_members WHERE MEMBER_ID= @@server_uuid, MEMBER_STATE, 1]" = "RECOVERING"
96 --source include/assert.inc
97
98 --echo
99 --echo ############################################################
100 --echo # 7. Add debug points in server1, server waits
101 --echo # before_commit_hook_wait
102 SET @@GLOBAL.DEBUG= '+d,group_replication_before_commit_hook_wait';
103
104 --echo
105 --echo ############################################################
106 --echo # 8. Commit a transaction on server2 while server1 is
107 --echo # in recovery
108 --let $rpl_connection_name= server2
109 --source include/rpl_connection.inc
110
111 INSERT INTO t1 VALUES (4);
112
113 --echo ############################################################
114 --echo # 9. On server1, wait for the transaction to reach debug
115 --echo # sync point
116 --let $rpl_connection_name= server1
117 --source include/rpl_connection.inc
118 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_before_commit_hook_wait_reached";
119
120 --echo ############################################################
121 --echo # 10. Resume recovery on server1, verify that server1 is
122 --echo # online
123 SET @@GLOBAL.DEBUG= '-d,recovery_thread_wait_after_wait_for_applier_module_recovery';
124 SET DEBUG_SYNC= "now SIGNAL signal.recovery_thread_resume_after_wait_for_applier_module_recovery";
125
126 --let $group_replication_member_state = ONLINE
127 --source include/gr_wait_for_member_state.inc
128
129 --echo ############################################################
130 --echo # 11. Resume transaction recived during recovery, verify all
131 --echo # members are still online and server1 executed the
132 --echo # transaction
133 SET @@GLOBAL.DEBUG= '-d,group_replication_before_commit_hook_wait';
134 SET DEBUG_SYNC= "now SIGNAL continue_commit";
135
136 --echo ############################################################
137 --echo # 12. Verify that all members are still online and server1
138 --echo # executed the transaction
139 --let $assert_text= There are three members in the group
140 --let $assert_cond= "[SELECT COUNT(*) from performance_schema.replication_group_members WHERE MEMBER_STATE=\"ONLINE\"]" = 2
141 --source include/assert.inc
142
143 --let $assert_text= On the recovered member, the table should contain 4 elements
144 --let $assert_cond= [select count(*) as count from t1] = 4;
145 --source include/assert.inc
146
147 --echo ############################################################
148 --echo # 13. Verify that all members have same data
149 --let $diff_tables= server1:test.t1, server2:test.t1
150 --source include/diff_tables.inc
151
152 --echo ############################################################
153 --echo # 14. Cleaning up
154 SET DEBUG_SYNC= 'RESET';
155 --source include/restore_sysvars.inc
156
157 --let $rpl_connection_name= server2
158 --source include/rpl_connection.inc
159 --source include/restore_sysvars.inc
160 DROP TABLE t1;
161
162 --source include/group_replication_end.inc