Debian Codegraph @

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

raw
1 # This test checks if the option replica-preserve-commit-order
2 # ensures that the transactions commit order is the same as
3 # transactions are logged on relay log.
4 #
5 # We will do some inserts of continious integers into t1 table
6 # ensuring that all these transactions can be applied in parallel
7 # on remote server.
8 #
9 # After being applied on both remote servers, we re-apply
10 # the transactions on those servers on another table which contains
11 # an additional auto increment column (id).
12 # If the trasactions are written in order into the remote server
13 # binary log, then after reapplying there will be no rows where
14 # t.id != t.a.
15 #
16 --source include/only_mts_replica_parallel_workers.inc
17 --source include/have_group_replication_plugin.inc
18
19 --echo
20 --echo ############################################################
21 --echo # 1. Setup a new group with three members.
22 --echo #
23 --let $rpl_server_count= 3
24 --source include/group_replication.inc
25
26 --echo
27 --echo # Create four connections to server 1 so that transactions executed
28 --echo # on server 1 can be parallel, what would not happen if we only use
29 --echo # one client.
30 --echo #
31 --connect(server1_1, localhost,root,,,$MASTER_MYPORT)
32 --connect(server1_2, localhost,root,,,$MASTER_MYPORT)
33 --connect(server1_3, localhost,root,,,$MASTER_MYPORT)
34 --connect(server1_4, localhost,root,,,$MASTER_MYPORT)
35
36 --echo
37 --echo # Suppress auto increment warnings, we want the same configuration
38 --echo # on all servers.
39 --echo #
40 --let $rpl_connection_name= server1
41 --source include/rpl_connection.inc
42 SET SESSION sql_log_bin= 0;
43 call mtr.add_suppression("Plugin group_replication reported: 'Group contains 3 members which is greater than group_replication_auto_increment_increment value of 1. This can lead to a higher transactional abort rate.");
44 SET SESSION sql_log_bin= 1;
45
46 --let $rpl_connection_name= server2
47 --source include/rpl_connection.inc
48 SET SESSION sql_log_bin= 0;
49 call mtr.add_suppression("Plugin group_replication reported: 'Group contains 2 members which is greater than group_replication_auto_increment_increment value of 1. This can lead to a higher transactional abort rate.");
50 SET SESSION sql_log_bin= 1;
51
52 --echo
53 --echo # Create a table on all members.
54 --echo #
55 --let $rpl_connection_name= server1
56 --source include/rpl_connection.inc
57 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
58 --source include/rpl_sync.inc
59
60 --echo
61 --echo # Force a binary log rotate on remote servers: 2 and 3.
62 --echo #
63 --let $rpl_connection_name= server2
64 --source include/rpl_connection.inc
65 FLUSH BINARY LOGS;
66
67 --let $rpl_connection_name= server3
68 --source include/rpl_connection.inc
69 FLUSH BINARY LOGS;
70
71 --echo
72 --echo ############################################################
73 --echo # 2. Commit 4 groups of 4 transactions, we have 4 configured
74 --echo # parallel workers.
75 --echo # All these transactions will be able to execute in parallel.
76 --echo #
77 # In each iteration, server 1 generates some transactions which can
78 # be applied in parallel. Server 2 and 3 have 4 parallel workers.
79 # To guarantee that all transactions are put into the queue together,
80 # LOCK TABLES is used to block workers. After all transactions are
81 # on the queue, then UNLOCK TABLES is called and all workers can resume.
82 --let $iteration= 0
83 --let $value= 0
84 while ($iteration < 4)
85 {
86 # Block parallel appliers workers so that all 4 transactions
87 # are applied in parallel on server 2 and 3.
88 --let $rpl_connection_name= server2
89 --source include/rpl_connection.inc
90 LOCK TABLE t1 WRITE;
91
92 --let $rpl_connection_name= server3
93 --source include/rpl_connection.inc
94 LOCK TABLE t1 WRITE;
95
96 # Execute 4 transactions on 4 different clients on server 1.
97 --let $rpl_connection_name= server1_1
98 --source include/rpl_connection.inc
99 --inc $value
100 --eval INSERT INTO t1 VALUES ($value)
101
102 --let $rpl_connection_name= server1_2
103 --source include/rpl_connection.inc
104 --inc $value
105 --eval INSERT INTO t1 VALUES ($value)
106
107 --let $rpl_connection_name= server1_3
108 --source include/rpl_connection.inc
109 --inc $value
110 --eval INSERT INTO t1 VALUES ($value)
111
112 --let $rpl_connection_name= server1_4
113 --source include/rpl_connection.inc
114 --inc $value
115 --eval INSERT INTO t1 VALUES ($value)
116
117 # Wait until all workers are blocked by LOCK TABLE t1 WRITE.
118 # It implies all transactions are registered into the order
119 # commit queue.
120 --let $rpl_connection_name= server2
121 --source include/rpl_connection.inc
122 --let $wait_condition= SELECT count(*) = 4 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE State = 'Waiting for table metadata lock'
123 --source include/wait_condition.inc
124 UNLOCK TABLES;
125
126 --let $rpl_connection_name= server3
127 --source include/rpl_connection.inc
128 --let $wait_condition= SELECT count(*) = 4 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE State = 'Waiting for table metadata lock'
129 --source include/wait_condition.inc
130 UNLOCK TABLES;
131
132 --inc $iteration
133 }
134
135 --echo
136 --echo # Wait for group synchronization.
137 --echo #
138 --let $rpl_connection_name= server1
139 --source include/rpl_connection.inc
140 --source include/rpl_sync.inc
141
142
143 --echo
144 --echo ############################################################
145 --echo # 3. Verify that above transactions are committed on server
146 --echo # 2 and 3 on the same order they were on server 1.
147 --echo #
148 --let $server_number= 2
149 --let $logical_timestamps= 0 0;1 2;2 3;2 4;2 5;2 6;2 7;2 8;2 9;2 10;2 11;2 12;2 13;2 14;2 15;2 16;2 17;2 18
150 --source ../include/gr_mts_indexes_commit_order_validation.inc
151
152 --let $server_number= 3
153 --let $logical_timestamps= 0 0;0 0;1 2;2 3;2 4;2 5;2 6;2 7;2 8;2 9;2 10;2 11;2 12;2 13;2 14;2 15;2 16;2 17;2 18
154 --source ../include/gr_mts_indexes_commit_order_validation.inc
155
156
157 --echo
158 --echo ############################################################
159 --echo # 4. Clean up.
160 --echo #
161 --disconnect server1_1
162 --disconnect server1_2
163 --disconnect server1_3
164 --disconnect server1_4
165
166 --let $rpl_connection_name= server1
167 --source include/rpl_connection.inc
168 DROP TABLE t1;
169
170 --source include/group_replication_end.inc