Debian Codegraph @

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

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