Debian Codegraph @

mysql-test/suite/clone/r/remote_basic_replace.result

raw
1 Install clone plugin on recipient server
2 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
3 CREATE TABLE t_recipient(col1 INT PRIMARY KEY, col2 int);
4 INSERT INTO t_recipient VALUES(1, 10);
5 CREATE UNDO TABLESPACE undo_005 ADD DATAFILE 'undo_005.ibu';
6 CREATE TABLESPACE tbs1_recipient ADD DATAFILE 'tbs1_data1.ibd';
7 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 char(64), FULLTEXT KEY fts_index(col2));
8 INSERT INTO t1 VALUES(10, 'clone row 1');
9 INSERT INTO t1 VALUES(20, 'clone row 2');
10 INSERT INTO t1 VALUES(30, 'clone row 3');
11 SELECT * from t1 ORDER BY col1;
12 col1 col2
13 10 clone row 1
14 20 clone row 2
15 30 clone row 3
16 SELECT count(*) FROM mysql.general_log;
17 count(*)
18 0
19 SELECT count(*) FROM mysql.slow_log;
20 count(*)
21 0
22 CREATE TABLE t_myisam(col1 INT PRIMARY KEY, col2 char(64)) ENGINE=MyISAM;
23 INSERT INTO t_myisam VALUES(10, 'myisam not cloned row 1');
24 SELECT * from t_myisam ORDER BY col1;
25 col1 col2
26 10 myisam not cloned row 1
27 CREATE TABLE t_csv(col1 INT NOT NULL, col2 char(64) NOT NULL) ENGINE=CSV;
28 INSERT INTO t_csv VALUES(10, 'csv not cloned row 1');
29 SELECT * from t_csv ORDER BY col1;
30 col1 col2
31 10 csv not cloned row 1
32 CREATE SCHEMA non_innodb;
33 CREATE TABLE non_innodb.t_myisam(col1 INT PRIMARY KEY, col2 char(64)) ENGINE=MyISAM;
34 INSERT INTO non_innodb.t_myisam VALUES(10, 'myisam not cloned row 1');
35 INSERT INTO non_innodb.t_myisam VALUES(20, 'myisam not cloned row 2');
36 INSERT INTO non_innodb.t_myisam VALUES(30, 'myisam not cloned row 3');
37 SELECT * from non_innodb.t_myisam ORDER BY col1;
38 col1 col2
39 10 myisam not cloned row 1
40 20 myisam not cloned row 2
41 30 myisam not cloned row 3
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 col1 col2
48 10 csv not cloned row 1
49 20 csv not cloned row 2
50 30 csv not cloned row 3
51 CREATE SCHEMA schema_read_only;
52 CREATE TABLE schema_read_only.t_myisam(col1 INT PRIMARY KEY, col2 char(64))
53 ENGINE=MyISAM;
54 INSERT INTO schema_read_only.t_myisam VALUES(10, 'myisam not cloned row 1');
55 INSERT INTO schema_read_only.t_myisam VALUES(20, 'myisam not cloned row 2');
56 INSERT INTO schema_read_only.t_myisam VALUES(30, 'myisam not cloned row 3');
57 SELECT * from schema_read_only.t_myisam ORDER BY col1;
58 col1 col2
59 10 myisam not cloned row 1
60 20 myisam not cloned row 2
61 30 myisam not cloned row 3
62 CREATE TABLE schema_read_only.t_csv(col1 INT NOT NULL, col2 char(64) NOT NULL)
63 ENGINE=CSV;
64 INSERT INTO schema_read_only.t_csv VALUES(10, 'csv not cloned row 1');
65 INSERT INTO schema_read_only.t_csv VALUES(20, 'csv not cloned row 2');
66 INSERT INTO schema_read_only.t_csv VALUES(30, 'csv not cloned row 3');
67 SELECT * from schema_read_only.t_csv ORDER BY col1;
68 col1 col2
69 10 csv not cloned row 1
70 20 csv not cloned row 2
71 30 csv not cloned row 3
72 CREATE TABLE schema_read_only.t_innodb(col1 INT PRIMARY KEY, col2 char(64))
73 ENGINE=InnoDB;
74 INSERT INTO schema_read_only.t_innodb VALUES(10, 'innodb cloned row 1');
75 INSERT INTO schema_read_only.t_innodb VALUES(20, 'innodb cloned row 2');
76 INSERT INTO schema_read_only.t_innodb VALUES(30, 'innodb cloned row 3');
77 SELECT * from schema_read_only.t_innodb ORDER BY col1;
78 col1 col2
79 10 innodb cloned row 1
80 20 innodb cloned row 2
81 30 innodb cloned row 3
82 ALTER SCHEMA schema_read_only READ ONLY=1;
83 #BEGIN Bug 32199611: CLONE PLUGIN INSTALLATION FAILS IN PFS TABLE CREATION
84 SET LOCAL explicit_defaults_for_timestamp = OFF;
85 Warnings:
86 Warning 1287 'explicit_defaults_for_timestamp' is deprecated and will be removed in a future release.
87 SHOW VARIABLES LIKE 'explicit_defaults_for_timestamp';
88 Variable_name Value
89 explicit_defaults_for_timestamp OFF
90 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
91 UNINSTALL PLUGIN clone;
92 SET LOCAL explicit_defaults_for_timestamp = default;
93 #End Bug 32199611: CLONE PLUGIN INSTALLATION FAILS IN PFS TABLE CREATION
94 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
95 INSTALL PLUGIN example SONAME 'EXAMPLE_PLUGIN';
96 SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS
97 WHERE PLUGIN_NAME LIKE '%clone%';
98 PLUGIN_NAME PLUGIN_STATUS
99 clone ACTIVE
100 SET GLOBAL clone_autotune_concurrency = OFF;
101 SET GLOBAL clone_max_concurrency = 8;
102 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
103 SET GLOBAL clone_delay_after_data_drop = 2;
104 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' ;
105 SET GLOBAL clone_delay_after_data_drop = 0;
106 select ID, STATE, ERROR_NO from performance_schema.clone_status;
107 ID STATE ERROR_NO
108 1 Completed 0
109 select ID, STAGE, STATE from performance_schema.clone_progress;
110 ID STAGE STATE
111 1 DROP DATA Completed
112 1 FILE COPY Completed
113 1 PAGE COPY Completed
114 1 REDO COPY Completed
115 1 FILE SYNC Completed
116 1 RESTART Completed
117 1 RECOVERY Completed
118 SELECT * from t1 ORDER BY col1;
119 col1 col2
120 10 clone row 1
121 20 clone row 2
122 30 clone row 3
123 INSERT INTO t1 VALUES(40, 'clone row 4');
124 SELECT * from t1 ORDER BY col1;
125 col1 col2
126 10 clone row 1
127 20 clone row 2
128 30 clone row 3
129 40 clone row 4
130 INSERT INTO t_myisam VALUES(40, 'myisam not cloned row 4');
131 SELECT * from t_myisam ORDER BY col1;
132 col1 col2
133 40 myisam not cloned row 4
134 INSERT INTO t_csv VALUES(40, 'csv not cloned row 4');
135 SELECT * from t_csv ORDER BY col1;
136 col1 col2
137 40 csv not cloned row 4
138 INSERT INTO non_innodb.t_myisam VALUES(40, 'myisam not cloned row 4');
139 SELECT * from non_innodb.t_myisam ORDER BY col1;
140 col1 col2
141 40 myisam not cloned row 4
142 INSERT INTO non_innodb.t_csv VALUES(40, 'csv not cloned row 4');
143 SELECT * from non_innodb.t_csv ORDER BY col1;
144 col1 col2
145 40 csv not cloned row 4
146 INSERT INTO schema_read_only.t_myisam VALUES(40, 'myisam not cloned row 4');
147 ERROR HY000: Schema 'schema_read_only' is in read only mode.
148 SELECT * from schema_read_only.t_myisam ORDER BY col1;
149 col1 col2
150 INSERT INTO schema_read_only.t_csv VALUES(40, 'csv not cloned row 4');
151 ERROR HY000: Schema 'schema_read_only' is in read only mode.
152 SELECT * from schema_read_only.t_csv ORDER BY col1;
153 col1 col2
154 INSERT INTO schema_read_only.t_innodb VALUES(40, 'innodb cloned row 4');
155 ERROR HY000: Schema 'schema_read_only' is in read only mode.
156 SELECT * from schema_read_only.t_innodb ORDER BY col1;
157 col1 col2
158 10 innodb cloned row 1
159 20 innodb cloned row 2
160 30 innodb cloned row 3
161 SHOW CREATE SCHEMA schema_read_only;
162 Database Create Database
163 schema_read_only CREATE DATABASE `schema_read_only` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */ /* READ ONLY = 1 */
164 SELECT count(*) FROM mysql.general_log;
165 count(*)
166 0
167 SELECT count(*) FROM mysql.slow_log;
168 count(*)
169 0
170 SET GLOBAL general_log = ON;
171 SET GLOBAL slow_query_log = ON;
172 SELECT * from t1 ORDER BY col1;
173 col1 col2
174 10 clone row 1
175 20 clone row 2
176 30 clone row 3
177 DROP TABLE t1;
178 DROP TABLE t_myisam;
179 DROP TABLE t_csv;
180 DROP TABLE non_innodb.t_myisam;
181 DROP TABLE non_innodb.t_csv;
182 DROP SCHEMA non_innodb;
183 ALTER SCHEMA schema_read_only READ ONLY=0;
184 DROP SCHEMA schema_read_only;
185 UNINSTALL PLUGIN example;
186 SET GLOBAL clone_autotune_concurrency = OFF;
187 SET GLOBAL clone_max_concurrency = 8;
188 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
189 SET GLOBAL clone_delay_after_data_drop = 2;
190 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' ;
191 ERROR HY000: Schema 'schema_read_only' is in read only mode.
192 SET GLOBAL clone_delay_after_data_drop = 0;
193 select ID, STATE, ERROR_NO from performance_schema.clone_status;
194 ID STATE ERROR_NO
195 1 Failed 3989
196 select ID, STAGE, STATE from performance_schema.clone_progress;
197 ID STAGE STATE
198 1 DROP DATA Failed
199 1 FILE COPY Not Started
200 1 PAGE COPY Not Started
201 1 REDO COPY Not Started
202 1 FILE SYNC Not Started
203 1 RESTART Not Started
204 1 RECOVERY Not Started
205 ALTER SCHEMA schema_read_only READ ONLY=0;
206 SET GLOBAL clone_autotune_concurrency = OFF;
207 SET GLOBAL clone_max_concurrency = 8;
208 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
209 SET GLOBAL clone_delay_after_data_drop = 2;
210 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' ;
211 SET GLOBAL clone_delay_after_data_drop = 0;
212 select ID, STATE, ERROR_NO from performance_schema.clone_status;
213 ID STATE ERROR_NO
214 1 Completed 0
215 select ID, STAGE, STATE from performance_schema.clone_progress;
216 ID STAGE STATE
217 1 DROP DATA Completed
218 1 FILE COPY Completed
219 1 PAGE COPY Completed
220 1 REDO COPY Completed
221 1 FILE SYNC Completed
222 1 RESTART Completed
223 1 RECOVERY Completed
224 Uninstall clone plugin on recipient server
225 UNINSTALL PLUGIN clone;
226 UNINSTALL PLUGIN clone;
227 #
228 # BUG#34828542: P_S.clone_status.gtid_executed does not have enough
229 # column size
230 #
231 # Install Plugin
232 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
233 # Test case set up.
234 SET @gtid_next_saved = @@SESSION.GTID_NEXT;
235 SET @gtid_mode_saved = @@GLOBAL.GTID_MODE;
236 SET @enforce_gtid_consistency_saved = @@GLOBAL.ENFORCE_GTID_CONSISTENCY;
237 SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY=ON;
238 SET @@GLOBAL.GTID_MODE=OFF_PERMISSIVE;
239 SET @@GLOBAL.GTID_MODE=ON_PERMISSIVE;
240 SET @@GLOBAL.GTID_MODE=ON;
241 CREATE PROCEDURE p1()
242 BEGIN
243 DECLARE x INT DEFAULT 0;
244 WHILE x <= 2000 DO
245 SET gtid_next=CONCAT(UUID(),':',4000);
246 COMMIT;
247 SET x = x + 1;
248 END WHILE;
249 END//
250 CALL p1();
251 # Restore GTID settings.
252 SET @@SESSION.GTID_NEXT= @gtid_next_saved;
253 SET @@GLOBAL.GTID_MODE=ON_PERMISSIVE;
254 SET @@GLOBAL.GTID_MODE=OFF_PERMISSIVE;
255 SET @@GLOBAL.GTID_MODE= @gtid_mode_saved;
256 SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY=@enforce_gtid_consistency_saved;
257 # Clone database.
258 SET GLOBAL clone_autotune_concurrency = OFF;
259 SET GLOBAL clone_max_concurrency = 8;
260 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
261 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
262 # Restart cloned database
263 # restart: --datadir=CLONE_DATADIR
264 # Check the length of gtid_executed > 4096 after bug fix.
265 SELECT length(gtid_executed) from performance_schema.clone_status;
266 length(gtid_executed)
267 86081
268 # restart:
269 DROP PROCEDURE p1;
270 RESET MASTER;
271 UNINSTALL PLUGIN clone;