Debian Codegraph @

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

raw
1 # Setup the tables
2 Install clone plugin on recipient server
3 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
4 CREATE TABLE t_recipient(col1 INT PRIMARY KEY, col2 int);
5 INSERT INTO t_recipient VALUES(1, 10);
6 CREATE UNDO TABLESPACE undo_005 ADD DATAFILE 'undo_005.ibu';
7 CREATE TABLESPACE tbs1_recipient ADD DATAFILE 'tbs1_data1.ibd';
8 # Setup the tables
9 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 char(64), FULLTEXT KEY fts_index(col2));
10 INSERT INTO t1 VALUES(10, 'clone row 1');
11 INSERT INTO t1 VALUES(20, 'clone row 2');
12 INSERT INTO t1 VALUES(30, 'clone row 3');
13 SELECT * from t1 ORDER BY col1;
14 col1 col2
15 10 clone row 1
16 20 clone row 2
17 30 clone row 3
18 CREATE TABLE t_myisam(col1 INT PRIMARY KEY, col2 char(64)) ENGINE=MyISAM;
19 INSERT INTO t_myisam VALUES(10, 'myisam not cloned row 1');
20 SELECT * from t_myisam ORDER BY col1;
21 col1 col2
22 10 myisam not cloned row 1
23 CREATE TABLE t_csv(col1 INT NOT NULL, col2 char(64) NOT NULL) ENGINE=CSV;
24 INSERT INTO t_csv VALUES(10, 'csv not cloned row 1');
25 SELECT * from t_csv ORDER BY col1;
26 col1 col2
27 10 csv not cloned row 1
28 CREATE SCHEMA non_innodb;
29 CREATE TABLE non_innodb.t_myisam(col1 INT PRIMARY KEY, col2 char(64)) ENGINE=MyISAM;
30 INSERT INTO non_innodb.t_myisam VALUES(10, 'myisam not cloned row 1');
31 INSERT INTO non_innodb.t_myisam VALUES(20, 'myisam not cloned row 2');
32 INSERT INTO non_innodb.t_myisam VALUES(30, 'myisam not cloned row 3');
33 SELECT * from non_innodb.t_myisam ORDER BY col1;
34 col1 col2
35 10 myisam not cloned row 1
36 20 myisam not cloned row 2
37 30 myisam not cloned row 3
38 CREATE TABLE non_innodb.t_csv(col1 INT NOT NULL, col2 char(64) NOT NULL) ENGINE=CSV;
39 INSERT INTO non_innodb.t_csv VALUES(10, 'csv not cloned row 1');
40 INSERT INTO non_innodb.t_csv VALUES(20, 'csv not cloned row 2');
41 INSERT INTO non_innodb.t_csv VALUES(30, 'csv not cloned row 3');
42 SELECT * from non_innodb.t_csv ORDER BY col1;
43 col1 col2
44 10 csv not cloned row 1
45 20 csv not cloned row 2
46 30 csv not cloned row 3
47 CREATE SCHEMA schema_read_only;
48 CREATE TABLE schema_read_only.t_myisam(col1 INT PRIMARY KEY, col2 char(64))
49 ENGINE=MyISAM;
50 INSERT INTO schema_read_only.t_myisam VALUES(10, 'myisam not cloned row 1');
51 INSERT INTO schema_read_only.t_myisam VALUES(20, 'myisam not cloned row 2');
52 INSERT INTO schema_read_only.t_myisam VALUES(30, 'myisam not cloned row 3');
53 SELECT * from schema_read_only.t_myisam ORDER BY col1;
54 col1 col2
55 10 myisam not cloned row 1
56 20 myisam not cloned row 2
57 30 myisam not cloned row 3
58 CREATE TABLE schema_read_only.t_csv(col1 INT NOT NULL, col2 char(64) NOT NULL)
59 ENGINE=CSV;
60 INSERT INTO schema_read_only.t_csv VALUES(10, 'csv not cloned row 1');
61 INSERT INTO schema_read_only.t_csv VALUES(20, 'csv not cloned row 2');
62 INSERT INTO schema_read_only.t_csv VALUES(30, 'csv not cloned row 3');
63 SELECT * from schema_read_only.t_csv ORDER BY col1;
64 col1 col2
65 10 csv not cloned row 1
66 20 csv not cloned row 2
67 30 csv not cloned row 3
68 CREATE TABLE schema_read_only.t_innodb(col1 INT PRIMARY KEY, col2 char(64))
69 ENGINE=InnoDB;
70 INSERT INTO schema_read_only.t_innodb VALUES(10, 'innodb cloned row 1');
71 INSERT INTO schema_read_only.t_innodb VALUES(20, 'innodb cloned row 2');
72 INSERT INTO schema_read_only.t_innodb VALUES(30, 'innodb cloned row 3');
73 SELECT * from schema_read_only.t_innodb ORDER BY col1;
74 col1 col2
75 10 innodb cloned row 1
76 20 innodb cloned row 2
77 30 innodb cloned row 3
78 ALTER SCHEMA schema_read_only READ ONLY=1;
79 # Install clone plugin
80 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
81 # In connection default - Cloning database
82 SET DEBUG="+d,clone_across_lts_compare_versions";
83 SET DEBUG="+d,clone_across_lts_8_0_before_backport_patch_mismatch";
84 SET GLOBAL clone_autotune_concurrency = OFF;
85 SET GLOBAL clone_max_concurrency = 8;
86 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
87 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' ;
88 ERROR HY000: Clone Donor MySQL version: 8.0.35 is different from Recipient MySQL version 8.0.34.
89 select ID, STATE, ERROR_NO from performance_schema.clone_status;
90 ID STATE ERROR_NO
91 1 Failed 3864
92 select ID, STAGE, STATE from performance_schema.clone_progress;
93 ID STAGE STATE
94 SET DEBUG="-d,clone_across_lts_8_0_before_backport_patch_mismatch";
95 SET DEBUG="+d,clone_across_lts_non_8_0_patch_mismatch";
96 SET GLOBAL clone_autotune_concurrency = OFF;
97 SET GLOBAL clone_max_concurrency = 8;
98 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
99 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' ;
100 select ID, STATE, ERROR_NO from performance_schema.clone_status;
101 ID STATE ERROR_NO
102 1 Completed 0
103 select ID, STAGE, STATE from performance_schema.clone_progress;
104 ID STAGE STATE
105 1 DROP DATA Completed
106 1 FILE COPY Completed
107 1 PAGE COPY Completed
108 1 REDO COPY Completed
109 1 FILE SYNC Completed
110 1 RESTART Completed
111 1 RECOVERY Completed
112 SET DEBUG="-d,clone_across_lts_non_8_0_patch_mismatch";
113 SET DEBUG="-d,clone_across_lts_compare_versions";
114 # In connection default - Finished Cloning
115 # Validate the tables and cleanup the test
116 SELECT * from t1 ORDER BY col1;
117 col1 col2
118 10 clone row 1
119 20 clone row 2
120 30 clone row 3
121 INSERT INTO t1 VALUES(40, 'clone row 4');
122 SELECT * from t1 ORDER BY col1;
123 col1 col2
124 10 clone row 1
125 20 clone row 2
126 30 clone row 3
127 40 clone row 4
128 INSERT INTO t_myisam VALUES(40, 'myisam not cloned row 4');
129 SELECT * from t_myisam ORDER BY col1;
130 col1 col2
131 40 myisam not cloned row 4
132 INSERT INTO t_csv VALUES(40, 'csv not cloned row 4');
133 SELECT * from t_csv ORDER BY col1;
134 col1 col2
135 40 csv not cloned row 4
136 INSERT INTO non_innodb.t_myisam VALUES(40, 'myisam not cloned row 4');
137 SELECT * from non_innodb.t_myisam ORDER BY col1;
138 col1 col2
139 40 myisam not cloned row 4
140 INSERT INTO non_innodb.t_csv VALUES(40, 'csv not cloned row 4');
141 SELECT * from non_innodb.t_csv ORDER BY col1;
142 col1 col2
143 40 csv not cloned row 4
144 INSERT INTO schema_read_only.t_myisam VALUES(40, 'myisam not cloned row 4');
145 ERROR HY000: Schema 'schema_read_only' is in read only mode.
146 SELECT * from schema_read_only.t_myisam ORDER BY col1;
147 col1 col2
148 INSERT INTO schema_read_only.t_csv VALUES(40, 'csv not cloned row 4');
149 ERROR HY000: Schema 'schema_read_only' is in read only mode.
150 SELECT * from schema_read_only.t_csv ORDER BY col1;
151 col1 col2
152 INSERT INTO schema_read_only.t_innodb VALUES(40, 'innodb cloned row 4');
153 ERROR HY000: Schema 'schema_read_only' is in read only mode.
154 SELECT * from schema_read_only.t_innodb ORDER BY col1;
155 col1 col2
156 10 innodb cloned row 1
157 20 innodb cloned row 2
158 30 innodb cloned row 3
159 SHOW CREATE SCHEMA schema_read_only;
160 Database Create Database
161 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 */
162 # Cleanup
163 SELECT * from t1 ORDER BY col1;
164 col1 col2
165 10 clone row 1
166 20 clone row 2
167 30 clone row 3
168 DROP TABLE t1;
169 DROP TABLE t_myisam;
170 DROP TABLE t_csv;
171 DROP TABLE non_innodb.t_myisam;
172 DROP TABLE non_innodb.t_csv;
173 DROP SCHEMA non_innodb;
174 ALTER SCHEMA schema_read_only READ ONLY=0;
175 DROP SCHEMA schema_read_only;
176 # Clean recipient by cloning the cleaned up donor
177 SET GLOBAL clone_autotune_concurrency = OFF;
178 SET GLOBAL clone_max_concurrency = 8;
179 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
180 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' ;
181 ERROR HY000: Schema 'schema_read_only' is in read only mode.
182 select ID, STATE, ERROR_NO from performance_schema.clone_status;
183 ID STATE ERROR_NO
184 1 Failed 3989
185 select ID, STAGE, STATE from performance_schema.clone_progress;
186 ID STAGE STATE
187 1 DROP DATA Failed
188 1 FILE COPY Not Started
189 1 PAGE COPY Not Started
190 1 REDO COPY Not Started
191 1 FILE SYNC Not Started
192 1 RESTART Not Started
193 1 RECOVERY Not Started
194 ALTER SCHEMA schema_read_only READ ONLY=0;
195 SET GLOBAL clone_autotune_concurrency = OFF;
196 SET GLOBAL clone_max_concurrency = 8;
197 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
198 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' ;
199 select ID, STATE, ERROR_NO from performance_schema.clone_status;
200 ID STATE ERROR_NO
201 1 Completed 0
202 select ID, STAGE, STATE from performance_schema.clone_progress;
203 ID STAGE STATE
204 1 DROP DATA Completed
205 1 FILE COPY Completed
206 1 PAGE COPY Completed
207 1 REDO COPY Completed
208 1 FILE SYNC Completed
209 1 RESTART Completed
210 1 RECOVERY Completed
211 Uninstall clone plugin on recipient server
212 UNINSTALL PLUGIN clone;
213 UNINSTALL PLUGIN clone;