Debian Codegraph @

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

raw
1 ################################################################################
2 # Validate group_replication_consistency= 'BEFORE_AND_AFTER' behaviour.
3 #
4 # Test:
5 # 00. The test requires two servers: M1 and M2.
6 # 01. Create two tables on the group.
7 # 02. Lock table t1 on server2 to block a future update.
8 # 03. Execute transaction T1, the transaction will block on
9 # server2 due to the table lock.
10 # 04. Wait until T1 is delivered to server2.
11 # 05. Execute a write transaction T2 on server2 with
12 # group_replication_consistency= 'BEFORE_AND_AFTER' , it
13 # will wait for T1 commit and will make new transactions
14 # wait for T2.
15 # 06. Force server1 to block between T2 prepare and commit.
16 # 07. Unblock T1 on server2.
17 # 08. Wait until T2 reaches prepare on server1.
18 # 09. Now that T2 is prepared on server1 but it is not yet
19 # committed, new transactions are hold on server1.
20 # 10. Unblock T2 prepare on server1.
21 # 11. Validate data.
22 # 12. Clean up.
23 ################################################################################
24 --source include/have_debug_sync.inc
25 --source include/have_group_replication_plugin.inc
26 --source include/group_replication.inc
27
28 --echo
29 --echo ############################################################
30 --echo # 01. Create two tables on the group.
31 --let $rpl_connection_name= server1
32 --source include/rpl_connection.inc
33 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY);
34 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY);
35 --source include/rpl_sync.inc
36
37
38 --echo
39 --echo ############################################################
40 --echo # 02. Lock table t1 on server2 to block a future update.
41 --let $rpl_connection_name= server_2
42 --source include/rpl_connection.inc
43 LOCK table t1 READ;
44
45
46 --echo
47 --echo ############################################################
48 --echo # 03. Execute transaction T1, the transaction will block on
49 --echo # server2 due to the table lock.
50 --let $rpl_connection_name= server1
51 --source include/rpl_connection.inc
52 BEGIN;
53 INSERT INTO t1 VALUES (1);
54 INSERT INTO t2 VALUES (1);
55 COMMIT;
56
57
58 --echo
59 --echo ############################################################
60 --echo # 04. Wait until T1 is delivered to server2.
61 --let $rpl_connection_name= server2
62 --source include/rpl_connection.inc
63 --let $member2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
64 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_member_stats WHERE member_id='$member2_uuid' AND count_transactions_checked=3 AND count_transactions_remote_in_applier_queue=1
65 --source include/wait_condition.inc
66
67
68 --echo
69 --echo ############################################################
70 --echo # 05. Execute a write transaction T2 on server2 with
71 --echo # group_replication_consistency= 'BEFORE_AND_AFTER' , it
72 --echo # will wait for T1 commit and will make new transactions
73 --echo # wait for T2.
74 --let $rpl_connection_name= server_2_1
75 --source include/rpl_connection.inc
76 SET @@SESSION.group_replication_consistency= 'BEFORE_AND_AFTER';
77 --send UPDATE t2 SET c1=99 WHERE c1=1
78
79 --let $rpl_connection_name= server2
80 --source include/rpl_connection.inc
81 --let $wait_condition=SELECT COUNT(*)=1 FROM information_schema.processlist WHERE state='Executing hook on transaction begin.' AND info='UPDATE t2 SET c1=99 WHERE c1=1'
82 --source include/wait_condition.inc
83
84
85 --echo
86 --echo ############################################################
87 --echo # 06. Force server1 to block between T2 prepare and commit.
88 --let $rpl_connection_name= server_1
89 --source include/rpl_connection.inc
90 SET @@GLOBAL.DEBUG= '+d,group_replication_wait_on_after_applier_prepare';
91
92
93 --echo
94 --echo ############################################################
95 --echo # 07. Unblock T1 on server2.
96 --let $rpl_connection_name= server_2
97 --source include/rpl_connection.inc
98 UNLOCK TABLES;
99
100 --let $rpl_connection_name= server_2_1
101 --source include/rpl_connection.inc
102 # Get transaction T1 outcome.
103 --reap
104 SET @@SESSION.group_replication_consistency= DEFAULT;
105
106
107 --echo
108 --echo ############################################################
109 --echo # 08. Wait until T2 reaches prepare on server1.
110 --let $rpl_connection_name= server_1
111 --source include/rpl_connection.inc
112 SET DEBUG_SYNC= "now WAIT_FOR signal.after_applier_prepare_waiting";
113
114
115 --echo
116 --echo ############################################################
117 --echo # 09. Now that T2 is prepared on server1 but it is not yet
118 --echo # committed, new transactions (T3) are hold on server1.
119 --let $rpl_connection_name= server_1_1
120 --source include/rpl_connection.inc
121 --send SELECT COUNT(*) AS count FROM t2 WHERE c1=99
122
123 # server1 is waiting for T2 to commit
124 --let $rpl_connection_name= server1
125 --source include/rpl_connection.inc
126 --let $wait_condition=SELECT COUNT(*)=1 FROM information_schema.processlist WHERE user='root' AND state='Executing hook on transaction begin.' AND info="SELECT COUNT(*) AS count FROM t2 WHERE c1=99"
127 --source include/wait_condition.inc
128
129
130 --echo
131 --echo ############################################################
132 --echo # 10. Unblock T2 prepare on server1.
133 --let $rpl_connection_name= server_1
134 --source include/rpl_connection.inc
135 # Signal debug sync to continue.
136 SET DEBUG_SYNC= 'now SIGNAL signal.after_applier_prepare_continue';
137 SET @@GLOBAL.DEBUG= '-d,group_replication_wait_on_after_applier_prepare';
138
139 --let $rpl_connection_name= server_1_1
140 --source include/rpl_connection.inc
141 # Get transaction T3 outcome.
142 --reap
143
144
145 --echo
146 --echo ############################################################
147 --echo # 11. Validate data.
148 --let $rpl_connection_name= server1
149 --source include/rpl_connection.inc
150 --let $assert_text= 'There is 1 value in table t1'
151 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE c1=1, count, 1] = 1
152 --source include/assert.inc
153
154 --let $assert_text= 'There is 1 value in table t2'
155 --let $assert_cond= [SELECT COUNT(*) AS count FROM t2 WHERE c1=99, count, 1] = 1
156 --source include/assert.inc
157
158 --let $rpl_connection_name= server2
159 --source include/rpl_connection.inc
160 --let $assert_text= 'There is 1 value in table t1'
161 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE c1=1, count, 1] = 1
162 --source include/assert.inc
163
164 --let $assert_text= 'There is 1 value in table t2'
165 --let $assert_cond= [SELECT COUNT(*) AS count FROM t2 WHERE c1=99, count, 1] = 1
166 --source include/assert.inc
167
168 --let $diff_tables=server1:t1, server2:t1
169 --source include/diff_tables.inc
170
171 --let $diff_tables=server1:t2, server2:t2
172 --source include/diff_tables.inc
173
174
175 --echo
176 --echo ############################################################
177 --echo # 12. Clean up.
178 --let $rpl_connection_name= server1
179 --source include/rpl_connection.inc
180 DROP TABLE t1;
181 DROP TABLE t2;
182
183 --source include/group_replication_end.inc