Debian Codegraph @

mysql-test/suite/clone/t/local_basic.test

raw
1 # Test clone command
2
3 --source include/not_asan_mac.inc
4 --source include/have_example_plugin.inc
5 --source include/have_log_bin.inc
6 --source ../include/clone_connection_begin.inc
7 --let $CLONE_DATADIR = $MYSQL_TMP_DIR/data_new
8
9 --disable_query_log
10 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Non innodb table: .* is not cloned and is empty.");
11 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Clone removing all user data for provisioning: .*");
12 --enable_query_log
13
14 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 char(64), FULLTEXT KEY fts_index(col2));
15
16 INSERT INTO t1 VALUES(10, 'clone row 1');
17 INSERT INTO t1 VALUES(20, 'clone row 2');
18 INSERT INTO t1 VALUES(30, 'clone row 3');
19
20 SELECT * from t1 ORDER BY col1;
21
22 SELECT count(*) FROM mysql.general_log;
23 SELECT count(*) FROM mysql.slow_log;
24
25 # Create MyIsam and CSV tables in common schema
26 CREATE TABLE t_myisam(col1 INT PRIMARY KEY, col2 char(64)) ENGINE=MyISAM;
27 INSERT INTO t_myisam VALUES(10, 'myisam not cloned row 1');
28 SELECT * from t_myisam ORDER BY col1;
29
30 CREATE TABLE t_csv(col1 INT NOT NULL, col2 char(64) NOT NULL) ENGINE=CSV;
31 INSERT INTO t_csv VALUES(10, 'csv not cloned row 1');
32 SELECT * from t_csv ORDER BY col1;
33
34 # Create MyIsam and CSV tables in separate schema
35 CREATE SCHEMA non_innodb;
36 CREATE TABLE non_innodb.t_myisam(col1 INT PRIMARY KEY, col2 char(64)) ENGINE=MyISAM;
37 INSERT INTO non_innodb.t_myisam VALUES(10, 'myisam not cloned row 1');
38 INSERT INTO non_innodb.t_myisam VALUES(20, 'myisam not cloned row 2');
39 INSERT INTO non_innodb.t_myisam VALUES(30, 'myisam not cloned row 3');
40 SELECT * from non_innodb.t_myisam ORDER BY col1;
41
42 CREATE TABLE non_innodb.t_csv(col1 INT NOT NULL, col2 char(64) NOT NULL) ENGINE=CSV;
43 INSERT INTO non_innodb.t_csv VALUES(10, 'csv not cloned row 1');
44 INSERT INTO non_innodb.t_csv VALUES(20, 'csv not cloned row 2');
45 INSERT INTO non_innodb.t_csv VALUES(30, 'csv not cloned row 3');
46 SELECT * from non_innodb.t_csv ORDER BY col1;
47
48 # Create MyIsam, CSV and InnoDB tables in separate schema, set it to read only
49 CREATE SCHEMA schema_read_only;
50 CREATE TABLE schema_read_only.t_myisam(col1 INT PRIMARY KEY, col2 char(64))
51 ENGINE=MyISAM;
52 INSERT INTO schema_read_only.t_myisam VALUES(10, 'myisam not cloned row 1');
53 INSERT INTO schema_read_only.t_myisam VALUES(20, 'myisam not cloned row 2');
54 INSERT INTO schema_read_only.t_myisam VALUES(30, 'myisam not cloned row 3');
55 SELECT * from schema_read_only.t_myisam ORDER BY col1;
56
57 CREATE TABLE schema_read_only.t_csv(col1 INT NOT NULL, col2 char(64) NOT NULL)
58 ENGINE=CSV;
59 INSERT INTO schema_read_only.t_csv VALUES(10, 'csv not cloned row 1');
60 INSERT INTO schema_read_only.t_csv VALUES(20, 'csv not cloned row 2');
61 INSERT INTO schema_read_only.t_csv VALUES(30, 'csv not cloned row 3');
62 SELECT * from schema_read_only.t_csv ORDER BY col1;
63
64 CREATE TABLE schema_read_only.t_innodb(col1 INT PRIMARY KEY, col2 char(64))
65 ENGINE=InnoDB;
66 INSERT INTO schema_read_only.t_innodb VALUES(10, 'innodb cloned row 1');
67 INSERT INTO schema_read_only.t_innodb VALUES(20, 'innodb cloned row 2');
68 INSERT INTO schema_read_only.t_innodb VALUES(30, 'innodb cloned row 3');
69 SELECT * from schema_read_only.t_innodb ORDER BY col1;
70
71 ALTER SCHEMA schema_read_only READ ONLY=1;
72
73 --echo #BEGIN Bug 32199611: CLONE PLUGIN INSTALLATION FAILS IN PFS TABLE CREATION
74 # We would need to remove it once this deprecated variable is removed. Currently
75 # it is required for clone to work with this variable as some users are using it.
76 SET LOCAL explicit_defaults_for_timestamp = OFF;
77 SHOW VARIABLES LIKE 'explicit_defaults_for_timestamp';
78
79 --replace_result $CLONE_PLUGIN CLONE_PLUGIN
80 --eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN'
81
82 UNINSTALL PLUGIN clone;
83 SET LOCAL explicit_defaults_for_timestamp = default;
84 --echo #End Bug 32199611: CLONE PLUGIN INSTALLATION FAILS IN PFS TABLE CREATION
85
86 # Install Clone Plugin
87 --replace_result $CLONE_PLUGIN CLONE_PLUGIN
88 --eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN'
89
90 # Install optional dynamic example plugin
91 --replace_result $EXAMPLE_PLUGIN EXAMPLE_PLUGIN
92 --eval INSTALL PLUGIN example SONAME '$EXAMPLE_PLUGIN'
93
94 SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS
95 WHERE PLUGIN_NAME LIKE '%clone%';
96
97 if ($skip_space_validation) {
98 # Bug#32354908 CLONE DONOR'S INNODB_VALIDATE_TABLESPACE_PATHS=OFF LEADS ER_TABLESPACE_MISSING
99 # Restart DB with tablespace validation skipped.
100 --source ../include/clone_connection_end.inc
101 --let restart_parameters="restart: --skip-innodb-validate-tablespace-paths"
102 --source include/restart_mysqld.inc
103 --source ../include/clone_connection_begin.inc
104 }
105
106 # Clone data
107 --connection clone_conn_1
108 --source ../include/clone_command.inc
109
110 if (!$clone_remote_replace) {
111 --connection default
112 # Restart server on cloned data directory
113 --replace_result $CLONE_DATADIR CLONE_DATADIR
114 --let restart_parameters="restart: --datadir=$CLONE_DATADIR"
115 --source include/restart_mysqld.inc
116 }
117
118 # Validate data
119 SELECT * from t1 ORDER BY col1;
120 INSERT INTO t1 VALUES(40, 'clone row 4');
121 SELECT * from t1 ORDER BY col1;
122
123 # Check MyISAM and CSV table data
124 INSERT INTO t_myisam VALUES(40, 'myisam not cloned row 4');
125 SELECT * from t_myisam ORDER BY col1;
126
127 INSERT INTO t_csv VALUES(40, 'csv not cloned row 4');
128 SELECT * from t_csv ORDER BY col1;
129
130 INSERT INTO non_innodb.t_myisam VALUES(40, 'myisam not cloned row 4');
131 SELECT * from non_innodb.t_myisam ORDER BY col1;
132
133 INSERT INTO non_innodb.t_csv VALUES(40, 'csv not cloned row 4');
134 SELECT * from non_innodb.t_csv ORDER BY col1;
135
136 # Check tables in read only schema
137 --error ER_SCHEMA_READ_ONLY
138 INSERT INTO schema_read_only.t_myisam VALUES(40, 'myisam not cloned row 4');
139 SELECT * from schema_read_only.t_myisam ORDER BY col1;
140
141 --error ER_SCHEMA_READ_ONLY
142 INSERT INTO schema_read_only.t_csv VALUES(40, 'csv not cloned row 4');
143 SELECT * from schema_read_only.t_csv ORDER BY col1;
144
145 --error ER_SCHEMA_READ_ONLY
146 INSERT INTO schema_read_only.t_innodb VALUES(40, 'innodb cloned row 4');
147 SELECT * from schema_read_only.t_innodb ORDER BY col1;
148
149 SHOW CREATE SCHEMA schema_read_only;
150
151 # Validate query log tables;
152 SELECT count(*) FROM mysql.general_log;
153 SELECT count(*) FROM mysql.slow_log;
154
155 SET GLOBAL general_log = ON;
156 SET GLOBAL slow_query_log = ON;
157
158 #Cleanup
159 if (!$clone_remote_replace) {
160 --let restart_parameters="restart:"
161 --source include/restart_mysqld.inc
162 }
163 --connection default
164
165 SELECT * from t1 ORDER BY col1;
166
167 DROP TABLE t1;
168
169 DROP TABLE t_myisam;
170 DROP TABLE t_csv;
171
172 DROP TABLE non_innodb.t_myisam;
173 DROP TABLE non_innodb.t_csv;
174
175 DROP SCHEMA non_innodb;
176
177 ALTER SCHEMA schema_read_only READ ONLY=0;
178 DROP SCHEMA schema_read_only;
179
180 if (!$clone_remote_replace) {
181 --force-rmdir $CLONE_DATADIR
182 }
183
184 UNINSTALL PLUGIN example;
185
186 # Clean recipient by cloning the cleaned up donor
187 if ($clone_remote_replace) {
188 --connection clone_conn_1
189 --let $clone_err = ER_SCHEMA_READ_ONLY
190 --source ../include/clone_command.inc
191 --let $clone_err = 0
192
193 ALTER SCHEMA schema_read_only READ ONLY=0;
194 --source ../include/clone_command.inc
195 }
196 --source ../include/clone_connection_end.inc
197
198 UNINSTALL PLUGIN clone;
199
200 --echo #
201 --echo # BUG#34828542: P_S.clone_status.gtid_executed does not have enough
202 --echo # column size
203 --echo #
204
205 --echo # Install Plugin
206 --replace_result $CLONE_PLUGIN CLONE_PLUGIN
207 --eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN'
208
209 --echo # Test case set up.
210 SET @gtid_next_saved = @@SESSION.GTID_NEXT;
211 SET @gtid_mode_saved = @@GLOBAL.GTID_MODE;
212 SET @enforce_gtid_consistency_saved = @@GLOBAL.ENFORCE_GTID_CONSISTENCY;
213
214 SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY=ON;
215 SET @@GLOBAL.GTID_MODE=OFF_PERMISSIVE;
216 SET @@GLOBAL.GTID_MODE=ON_PERMISSIVE;
217 SET @@GLOBAL.GTID_MODE=ON;
218
219 delimiter //;
220 CREATE PROCEDURE p1()
221 BEGIN
222 DECLARE x INT DEFAULT 0;
223 WHILE x <= 2000 DO
224 SET gtid_next=CONCAT(UUID(),':',4000);
225 COMMIT;
226 SET x = x + 1;
227 END WHILE;
228 END//
229
230 DELIMITER ;//
231 CALL p1();
232
233 --echo # Restore GTID settings.
234 SET @@SESSION.GTID_NEXT= @gtid_next_saved;
235 SET @@GLOBAL.GTID_MODE=ON_PERMISSIVE;
236 SET @@GLOBAL.GTID_MODE=OFF_PERMISSIVE;
237 SET @@GLOBAL.GTID_MODE= @gtid_mode_saved;
238 SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY=@enforce_gtid_consistency_saved;
239
240 --echo # Clone database.
241 --source ../include/clone_command_send.inc
242 --reap
243
244 --echo # Restart cloned database
245 --replace_result $CLONE_DATADIR CLONE_DATADIR
246 --let restart_parameters="restart: --datadir=$CLONE_DATADIR"
247 --source include/restart_mysqld.inc
248
249 --echo # Check the length of gtid_executed > 4096 after bug fix.
250 SELECT length(gtid_executed) from performance_schema.clone_status;
251
252 #Cleanup
253 --let restart_parameters="restart:"
254 --source include/restart_mysqld.inc
255
256 DROP PROCEDURE p1;
257 RESET MASTER;
258
259 UNINSTALL PLUGIN clone;
260
261 --force-rmdir $CLONE_DATADIR