Debian Codegraph @

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

raw
1 ## Test case to verify immediate_commit_timestamp is correct on all servers.
2 #
3 ## SETUP
4 #
5 # S4 -> (S1 - S2) -> S3
6 # i.e. S4 is SOURCE FOR S1
7 # S1 and S2 are GR members
8 # S1 is SOURCE FOR S3
9 # Transactions from S1 and S4 are tested.
10 #
11 ## Test:
12 #
13 # 0. The test requires 4 servers
14 # 1. Start GR on S1 & S2
15 # 2. Add some data to S1 and S4
16 # 3. Create and start new channel ch1_3: S3(REPLICA), S1(SOURCE)
17 # 4. Assert IMMEDIATE_COMMIT_TIMESTAMP is correct on S2 and S3.
18 # On S1 transaction `CREATE TABLE test.t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB`
19 # is committed through a client session, as such it is not queued on
20 # S1 `group_replication_applier` relay log.
21 # 5. Run a transaction while complete setup is ON.
22 # 6. Assert IMMEDIATE_COMMIT_TIMESTAMP is correct on S1 and S3.
23 # On S2 transaction `INSERT INTO test.t1 values (1)`
24 # is committed through a client session, as such it is not queued on
25 # S2 `group_replication_applier` relay log.
26 # 7. Create and start new channel ch4_1: server1(REPLICA), server4(SOURCE)
27 # Existing transactions will be replicated.
28 # 8. Assert IMMEDIATE_COMMIT_TIMESTAMP is correct on S2 and S3.
29 # On S1 transaction `CREATE TABLE test.t2 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB`
30 # is committed through channel `ch4_1`, as such it is not queued on
31 # S1 `group_replication_applier` relay log.
32 # 9. Clean Up
33 #
34
35 --source include/big_test.inc
36 --source include/have_group_replication_plugin.inc
37 --let $rpl_skip_group_replication_start= 1
38 --let $rpl_server_count= 4
39 --source include/group_replication.inc
40
41 --echo ############################################################
42 --echo # 1. Start GR on S1 & S2
43
44 # Boostrap start GR on server1 (Primary)
45 --let $rpl_connection_name= server1
46 --source include/rpl_connection.inc
47 --source include/start_and_bootstrap_group_replication.inc
48
49 # Start GR on server2 (Secondary)
50 --let $rpl_connection_name= server2
51 --source include/rpl_connection.inc
52 --source include/start_group_replication.inc
53
54 --echo ############################################################
55 --echo # 2. Add some data to S1 and S4
56
57 --let $rpl_connection_name= server1
58 --source include/rpl_connection.inc
59
60 CREATE TABLE test.t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
61 --source include/rpl_sync.inc
62
63 --let $rpl_connection_name= server4
64 --source include/rpl_connection.inc
65
66 CREATE TABLE test.t2 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
67
68 --echo ############################################################
69 --echo # 3. Create and start new channel ch1_3: S3(REPLICA), S1(SOURCE)
70
71 --let $rpl_connection_name= server3
72 --source include/rpl_connection.inc
73
74 --replace_result $SERVER_MYPORT_1 SERVER_1_PORT
75 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='localhost', SOURCE_USER='root', SOURCE_PORT=$SERVER_MYPORT_1 for channel 'ch1_3'
76
77 --let $rpl_channel_name='ch1_3'
78 --source include/start_slave.inc
79 --let $rpl_channel_name=
80
81 --let $rpl_connection_name= server1
82 --source include/rpl_connection.inc
83
84 --let $rpl_channel_name='ch1_3'
85 --let $sync_slave_connection=server3
86 --source include/sync_slave_sql_with_master.inc
87 --let $rpl_channel_name=
88
89 --echo ############################################################
90 --echo # 4. Assert IMMEDIATE_COMMIT_TIMESTAMP is correct on S2 and S3.
91 --echo # On S1 transaction `CREATE TABLE test.t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB`
92 --echo # is committed through a client session, as such it is not queued on
93 --echo # S1 `group_replication_applier` relay log.
94
95 --let $rpl_connection_name= server2
96 --source include/rpl_connection.inc
97
98 --let $assert_text= 'LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP is not 0.'
99 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME="group_replication_applier" AND UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP) > 0 AND UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP) > 0, count, 1] = 1
100 --source include/assert.inc
101
102 --let $assert_text= 'LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP = LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP.'
103 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME="group_replication_applier" AND (UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP) - UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP)) = 0, count, 1] = 1
104 --source include/assert.inc
105
106 --let $rpl_connection_name= server3
107 --source include/rpl_connection.inc
108
109 --let $assert_text= 'LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP is not 0.'
110 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME="ch1_3" AND UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP) > 0 AND UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP) > 0, count, 1] = 1
111 --source include/assert.inc
112
113 --let $assert_text= 'LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP is greater then LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP.'
114 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME="ch1_3" AND (UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP) - UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP)) > 0, count, 1] = 1
115 --source include/assert.inc
116
117 --echo ############################################################
118 --echo # 5. Run a transaction while complete setup is ON.
119
120 --let $rpl_connection_name= server2
121 --source include/rpl_connection.inc
122
123 INSERT INTO test.t1 values (1);
124 --source include/rpl_sync.inc
125
126 --let $rpl_connection_name= server1
127 --source include/rpl_connection.inc
128
129 --let $rpl_channel_name='ch1_3'
130 --let $sync_slave_connection=server3
131 --source include/sync_slave_sql_with_master.inc
132 --let $rpl_channel_name=
133
134 --echo ############################################################
135 --echo # 6. Assert IMMEDIATE_COMMIT_TIMESTAMP is correct on S1 and S3.
136 --echo # On S2 transaction `INSERT INTO test.t1 values (1)`
137 --echo # is committed through a client session, as such it is not queued on
138 --echo # S2 `group_replication_applier` relay log.
139
140 --let $rpl_connection_name= server1
141 --source include/rpl_connection.inc
142
143 --let $assert_text= 'LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP is not 0.'
144 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME="group_replication_applier" AND UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP) > 0 AND UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP) > 0, count, 1] = 1
145 --source include/assert.inc
146
147 --let $assert_text= 'LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP = LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP.'
148 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME="group_replication_applier" AND (UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP) - UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP)) = 0, count, 1] = 1
149 --source include/assert.inc
150
151 --let $rpl_connection_name= server3
152 --source include/rpl_connection.inc
153
154 --let $assert_text= 'LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP is not 0.'
155 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME="ch1_3" AND UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP) > 0 AND UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP) > 0, count, 1] = 1
156 --source include/assert.inc
157
158 --let $assert_text= 'LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP is greater then LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP.'
159 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME="ch1_3" AND (UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP) - UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP)) >= 0, count, 1] = 1
160 --source include/assert.inc
161
162 --echo ############################################################
163 --echo # 7. Create and start new channel ch4_1: server1(REPLICA), server4(SOURCE)
164 --echo # Existing transactions will be replicated.
165
166 --let $rpl_connection_name= server1
167 --source include/rpl_connection.inc
168
169 --replace_result $SERVER_MYPORT_4 SERVER_4_PORT
170 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='localhost', SOURCE_USER='root', SOURCE_PORT=$SERVER_MYPORT_4 for channel 'ch4_1'
171
172 --let $rpl_channel_name='ch4_1'
173 --source include/start_slave.inc
174 --let $rpl_channel_name=
175
176 --let $rpl_connection_name= server4
177 --source include/rpl_connection.inc
178
179 --let $rpl_channel_name='ch4_1'
180 --let $sync_slave_connection=server1
181 --source include/sync_slave_sql_with_master.inc
182 --let $rpl_channel_name=
183
184 --let $rpl_connection_name= server1
185 --source include/rpl_connection.inc
186
187 --let $rpl_channel_name='ch1_3'
188 --let $sync_slave_connection=server3
189 --source include/sync_slave_sql_with_master.inc
190 --let $rpl_channel_name=
191
192 --echo ############################################################
193 --echo # 8. Assert IMMEDIATE_COMMIT_TIMESTAMP is correct on S2 and S3.
194 --echo # On S1 transaction `CREATE TABLE test.t2 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB`
195 --echo # is committed through channel `ch4_1`, as such it is not queued on
196 --echo # S1 `group_replication_applier` relay log.
197
198 --let $rpl_connection_name= server2
199 --source include/rpl_connection.inc
200
201 --let $assert_text= 'LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP is not 0.'
202 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME="group_replication_applier" AND UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP) > 0 AND UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP) > 0, count, 1] = 1
203 --source include/assert.inc
204
205 --let $assert_text= 'LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP is greater then LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP.'
206 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME="group_replication_applier" AND (UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP) - UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP)) > 0, count, 1] = 1
207 --source include/assert.inc
208
209 --let $rpl_connection_name= server3
210 --source include/rpl_connection.inc
211
212 --let $assert_text= 'LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP is not 0.'
213 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME="ch1_3" AND UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP) > 0 AND UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP) > 0, count, 1] = 1
214 --source include/assert.inc
215
216 --let $assert_text= 'LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP is greater then LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP.'
217 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME="ch1_3" AND (UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP) - UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP)) > 0, count, 1] = 1
218 --source include/assert.inc
219
220
221 --echo ############################################################
222 --echo # 9. Clean Up
223
224 --let $rpl_connection_name= server3
225 --source include/rpl_connection.inc
226 STOP REPLICA FOR CHANNEL 'ch1_3';
227 RESET REPLICA ALL FOR CHANNEL 'ch1_3';
228
229 DROP TABLE test.t1;
230 DROP TABLE test.t2;
231
232 --let $rpl_connection_name= server1
233 --source include/rpl_connection.inc
234
235 DROP TABLE test.t1;
236 DROP TABLE test.t2;
237 STOP REPLICA FOR CHANNEL 'ch4_1';
238 RESET REPLICA ALL FOR CHANNEL 'ch4_1';
239
240 --let $rpl_connection_name= server4
241 --source include/rpl_connection.inc
242
243 DROP TABLE test.t2;
244
245 --source include/group_replication_end.inc