Debian Codegraph @

mysql-test/suite/rpl_nogtid/t/rpl_circular_for_4_hosts.test

raw
1 # ==== Purpose ====
2 #
3 # Setup: circular replication on four hosts, i.e., topology
4 # server_1 -> server_2 -> server_3 -> server_4 -> server_1
5 #
6 # Tested properties:
7 # - Correctly configured autoinc works.
8 # - Manual failover works.
9 #
10 # ==== Related bugs and worklogs ====
11 #
12 # WL#3754
13 # BUG#49978
14
15 --source include/not_group_replication_plugin.inc
16
17 # Use wait_for_slave_to_(start|stop) for current connections
18 let $keep_connection= 1;
19
20 # Set up circular ring and new names for servers
21 --echo *** Set up circular replication on four servers ***
22 --let $rpl_topology= 1->2->3->4->1
23 --source include/rpl_init.inc
24 --echo
25
26 #set auto inc variables at each server
27 --let $_rpl_server= $rpl_server_count
28 while ($_rpl_server)
29 {
30 --let $rpl_connection_name= server_$_rpl_server
31 --source include/rpl_connection.inc
32 eval SET auto_increment_increment= $rpl_server_count;
33 eval SET auto_increment_offset= $_rpl_server;
34
35 --dec $_rpl_server
36 }
37
38 # Preparing data.
39 --echo *** Preparing data ***
40 --connection server_1
41 CREATE TABLE t2 (a INT NOT NULL AUTO_INCREMENT, b VARCHAR(100), c INT NOT NULL, PRIMARY KEY(a)) ENGINE=InnoDB;
42 --source include/rpl_sync.inc
43 --connection server_4
44 call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
45 call mtr.add_suppression("Replica SQL: Coordinator thread of multi-threaded replica is exiting seeing a failed Worker to apply an event");
46 call mtr.add_suppression("Replica worker thread has failed to apply an event");
47 --connection server_3
48 call mtr.add_suppression("Replica SQL.*Duplicate entry .6. for key t1.PRIMARY.* Error_code: MY-001062");
49 --echo
50
51 #
52 # Testing
53 #
54
55 --echo * Transactions with commits *
56 # Testing mixing of transactions and regular inserts
57 --connection server_1
58 BEGIN;
59 --connection server_3
60 BEGIN;
61 let $counter= 100;
62 --connection server_1
63 --disable_query_log
64 while ($counter) {
65 --connection server_1
66 INSERT INTO t2(b,c) VALUES('A',1);
67 --connection server_2
68 INSERT INTO t2(b,c) VALUES('B',1);
69 --connection server_3
70 INSERT INTO t2(b,c) VALUES('C',1);
71 --connection server_4
72 INSERT INTO t2(b,c) VALUES('D',1);
73 dec $counter;
74 }
75 --connection server_1
76 COMMIT;
77 --connection server_3
78 COMMIT;
79 --connection server_1
80 --enable_query_log
81
82 --source include/rpl_sync.inc
83
84 --connection server_1
85 SELECT 'Master A',b,COUNT(*) FROM t2 WHERE c = 1 GROUP BY b ORDER BY b;
86 --connection server_2
87 SELECT 'Master B',b,COUNT(*) FROM t2 WHERE c = 1 GROUP BY b ORDER BY b;
88 --connection server_3
89 SELECT 'Master C',b,COUNT(*) FROM t2 WHERE c = 1 GROUP BY b ORDER BY b;
90 --connection server_4
91 SELECT 'Master D',b,COUNT(*) FROM t2 WHERE c = 1 GROUP BY b ORDER BY b;
92 --connection server_1
93 --echo
94
95 --echo * Transactions with rollbacks *
96 # Testing mixing of transactions with rollback and regular inserts
97 --connection server_1
98 BEGIN;
99 --connection server_3
100 BEGIN;
101 let $counter= 100;
102 --connection server_1
103 --disable_query_log
104 while ($counter) {
105 --connection server_1
106 INSERT INTO t2(b,c) VALUES('A',2);
107 --connection server_2
108 INSERT INTO t2(b,c) VALUES('B',2);
109 --connection server_3
110 INSERT INTO t2(b,c) VALUES('C',2);
111 --connection server_4
112 INSERT INTO t2(b,c) VALUES('D',2);
113 dec $counter;
114 }
115 --connection server_1
116 ROLLBACK;
117 --connection server_3
118 ROLLBACK;
119 --connection server_1
120 --enable_query_log
121
122 --source include/rpl_sync.inc
123
124 --connection server_1
125 SELECT 'Master A',b,COUNT(*) FROM t2 WHERE c = 2 GROUP BY b ORDER BY b;
126 --connection server_2
127 SELECT 'Master B',b,COUNT(*) FROM t2 WHERE c = 2 GROUP BY b ORDER BY b;
128 --connection server_3
129 SELECT 'Master C',b,COUNT(*) FROM t2 WHERE c = 2 GROUP BY b ORDER BY b;
130 --connection server_4
131 SELECT 'Master D',b,COUNT(*) FROM t2 WHERE c = 2 GROUP BY b ORDER BY b;
132 --connection server_1
133
134 --echo
135
136 # Clean up
137 --echo *** Clean up ***
138 --connection server_1
139 DROP TABLE t2;
140
141 --source include/rpl_end.inc