Debian Codegraph @

mysql-test/suite/galera/t/galera_sst_mariabackup_table_options.test

raw
1 --source include/big_test.inc
2 --source include/galera_cluster.inc
3 --source include/have_file_key_management.inc
4 --source include/innodb_encrypt_tables.inc
5 --source include/innodb_page_size_small.inc
6 --source include/have_mariabackup.inc
7
8 # Save original auto_increment_offset values.
9 --let $node_1=node_1
10 --let $node_2=node_2
11 --source include/auto_increment_offset_save.inc
12
13 --echo Performing State Transfer on a server that starts from a clean var directory
14 --echo This is accomplished by shutting down node #2 and removing its var directory before restarting it
15
16 --connection node_1
17 CREATE TABLE t1 (f1 CHAR(255)) ENGINE=InnoDB;
18 CREATE TABLE t2 (f1 CHAR(255)) ENGINE=InnoDB PAGE_COMPRESSED=1;
19 CREATE TABLE t3 (f1 CHAR(255)) ENGINE=InnoDB PAGE_COMPRESSED=1 ENCRYPTED=NO;
20 CREATE TABLE t4 (f1 CHAR(255)) ENGINE=InnoDB PAGE_COMPRESSED=1 ENCRYPTED=YES;
21 CREATE TABLE t5 (f1 CHAR(255)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
22 CREATE TABLE t6 (f1 CHAR(255)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED ENCRYPTED=NO;
23 CREATE TABLE t7 (f1 CHAR(255)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED ENCRYPTED=YES;
24 CREATE TABLE t8 (f1 CHAR(255)) ENGINE=InnoDB ENCRYPTED=NO;
25 CREATE TABLE t9 (f1 CHAR(255)) ENGINE=InnoDB ENCRYPTED=YES;
26
27 SET AUTOCOMMIT=OFF;
28 START TRANSACTION;
29 let $tables = 9;
30 while ($tables)
31 {
32 let $rows = 5;
33 while($rows)
34 {
35 eval insert into t$tables values ('node1_committed_before');
36 dec $rows;
37 }
38 dec $tables;
39 }
40 COMMIT;
41
42 --connection node_2
43 --let $wait_condition = SELECT COUNT(*) = 5 FROM t7;
44 --source include/wait_condition.inc
45
46 SET AUTOCOMMIT=OFF;
47 START TRANSACTION;
48 let $tables = 9;
49 while ($tables)
50 {
51 let $rows = 5;
52 while($rows)
53 {
54 eval insert into t$tables values ('node2_committed_before');
55 dec $rows;
56 }
57 dec $tables;
58 }
59 COMMIT;
60
61 --echo Shutting down server ...
62 --source include/shutdown_mysqld.inc
63
64 --connection node_1
65 --let $wait_condition = SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
66 --source include/wait_condition.inc
67
68 --echo Cleaning var directory ...
69 --remove_file $MYSQLTEST_VARDIR/mysqld.2/data/grastate.dat
70 --remove_files_wildcard $MYSQLTEST_VARDIR/mysqld.2/data/mtr
71 --remove_files_wildcard $MYSQLTEST_VARDIR/mysqld.2/data/performance_schema
72 --remove_files_wildcard $MYSQLTEST_VARDIR/mysqld.2/data/test
73 --remove_files_wildcard $MYSQLTEST_VARDIR/mysqld.2/data/mysql
74 --remove_files_wildcard $MYSQLTEST_VARDIR/mysqld.2/data
75
76 SET AUTOCOMMIT=OFF;
77 START TRANSACTION;
78 let $tables = 9;
79 while ($tables)
80 {
81 let $rows = 5;
82 while($rows)
83 {
84 eval insert into t$tables values ('node1_committed_during');
85 dec $rows;
86 }
87 dec $tables;
88 }
89 COMMIT;
90
91 START TRANSACTION;
92 let $tables = 9;
93 while ($tables)
94 {
95 let $rows = 5;
96 while($rows)
97 {
98 eval insert into t$tables values ('node1_to_be_committed_after');
99 dec $rows;
100 }
101 dec $tables;
102 }
103
104 --connect node_1a_galera_st_clean_slave, 127.0.0.1, root, , test, $NODE_MYPORT_1
105 SET AUTOCOMMIT=OFF;
106 START TRANSACTION;
107 let $tables = 9;
108 while ($tables)
109 {
110 let $rows = 5;
111 while($rows)
112 {
113 eval insert into t$tables values ('node1_to_be_rollbacked_after');
114 dec $rows;
115 }
116 dec $tables;
117 }
118
119 --connection node_2
120 --echo Starting server ...
121 --source include/start_mysqld.inc
122
123 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
124 --source include/wait_condition.inc
125
126 SET AUTOCOMMIT=OFF;
127 START TRANSACTION;
128 while ($tables)
129 {
130 let $rows = 5;
131 while($rows)
132 {
133 eval insert into t$tables values ('node2_committed_after');
134 dec $rows;
135 }
136 dec $tables;
137 }
138 COMMIT;
139
140 --connection node_1
141 let $tables = 9;
142 while ($tables)
143 {
144 let $rows = 5;
145 while($rows)
146 {
147 eval insert into t$tables values ('node1_to_be_committed_after');
148 dec $rows;
149 }
150 dec $tables;
151 }
152 COMMIT;
153
154 SET AUTOCOMMIT=OFF;
155 START TRANSACTION;
156 let $tables = 9;
157 while ($tables)
158 {
159 let $rows = 5;
160 while($rows)
161 {
162 eval insert into t$tables values ('node1_committed_after');
163 dec $rows;
164 }
165 dec $tables;
166 }
167 COMMIT;
168
169 --connection node_1a_galera_st_clean_slave
170 while ($tables)
171 {
172 let $rows = 5;
173 while($rows)
174 {
175 eval insert into t$tables values ('node1_to_be_rollbacked_after');
176 dec $rows;
177 }
178 dec $tables;
179 }
180 ROLLBACK;
181
182 SELECT COUNT(*) FROM t1;
183 SELECT COUNT(*) FROM t2;
184 SELECT COUNT(*) FROM t3;
185 SELECT COUNT(*) FROM t4;
186 SELECT COUNT(*) FROM t5;
187 SELECT COUNT(*) FROM t6;
188 SELECT COUNT(*) FROM t7;
189 SELECT COUNT(*) FROM t8;
190 SELECT COUNT(*) FROM t9;
191 SELECT * FROM t1;
192 SELECT * FROM t2;
193 SELECT * FROM t3;
194 SELECT * FROM t4;
195 SELECT * FROM t5;
196 SELECT * FROM t6;
197 SELECT * FROM t7;
198 SELECT * FROM t8;
199 SELECT * FROM t9;
200 COMMIT;
201 SET AUTOCOMMIT=ON;
202
203 --connection node_1
204 SELECT COUNT(*) FROM t1;
205 SELECT COUNT(*) FROM t2;
206 SELECT COUNT(*) FROM t3;
207 SELECT COUNT(*) FROM t4;
208 SELECT COUNT(*) FROM t5;
209 SELECT COUNT(*) FROM t6;
210 SELECT COUNT(*) FROM t7;
211 SELECT COUNT(*) FROM t8;
212 SELECT COUNT(*) FROM t9;
213 SELECT * FROM t1;
214 SELECT * FROM t2;
215 SELECT * FROM t3;
216 SELECT * FROM t4;
217 SELECT * FROM t5;
218 SELECT * FROM t6;
219 SELECT * FROM t7;
220 SELECT * FROM t8;
221 SELECT * FROM t9;
222 COMMIT;
223
224 DROP TABLE t1,t2,t3,t4,t5,t6,t7,t8,t9;
225 COMMIT;
226 SET AUTOCOMMIT=ON;
227
228 # Restore original auto_increment_offset values.
229 --source include/auto_increment_offset_restore.inc
230 --source include/galera_end.inc