Debian Codegraph @

mysql-test/suite/clone/r/remote_basic.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 SET GLOBAL clone_autotune_concurrency = OFF;
95 SET GLOBAL clone_max_concurrency = 8;
96 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
97 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
98 select ID, STATE, ERROR_NO from performance_schema.clone_status;
99 ID STATE ERROR_NO
100 1 Completed 0
101 select ID, STAGE, STATE from performance_schema.clone_progress;
102 ID STAGE STATE
103 1 DROP DATA Completed
104 1 FILE COPY Completed
105 1 PAGE COPY Completed
106 1 REDO COPY Completed
107 1 FILE SYNC Completed
108 1 RESTART Not Started
109 1 RECOVERY Not Started
110 # restart: --datadir=CLONE_DATADIR
111 SELECT * from t1 ORDER BY col1;
112 col1 col2
113 10 clone row 1
114 20 clone row 2
115 30 clone row 3
116 INSERT INTO t1 VALUES(40, 'clone row 4');
117 SELECT * from t1 ORDER BY col1;
118 col1 col2
119 10 clone row 1
120 20 clone row 2
121 30 clone row 3
122 40 clone row 4
123 INSERT INTO t_myisam VALUES(40, 'myisam not cloned row 4');
124 SELECT * from t_myisam ORDER BY col1;
125 col1 col2
126 40 myisam not cloned row 4
127 INSERT INTO t_csv VALUES(40, 'csv not cloned row 4');
128 SELECT * from t_csv ORDER BY col1;
129 col1 col2
130 40 csv not cloned row 4
131 INSERT INTO non_innodb.t_myisam VALUES(40, 'myisam not cloned row 4');
132 SELECT * from non_innodb.t_myisam ORDER BY col1;
133 col1 col2
134 40 myisam not cloned row 4
135 INSERT INTO non_innodb.t_csv VALUES(40, 'csv not cloned row 4');
136 SELECT * from non_innodb.t_csv ORDER BY col1;
137 col1 col2
138 40 csv not cloned row 4
139 INSERT INTO schema_read_only.t_myisam VALUES(40, 'myisam not cloned row 4');
140 ERROR HY000: Schema 'schema_read_only' is in read only mode.
141 SELECT * from schema_read_only.t_myisam ORDER BY col1;
142 col1 col2
143 INSERT INTO schema_read_only.t_csv VALUES(40, 'csv not cloned row 4');
144 ERROR HY000: Schema 'schema_read_only' is in read only mode.
145 SELECT * from schema_read_only.t_csv ORDER BY col1;
146 col1 col2
147 INSERT INTO schema_read_only.t_innodb VALUES(40, 'innodb cloned row 4');
148 ERROR HY000: Schema 'schema_read_only' is in read only mode.
149 SELECT * from schema_read_only.t_innodb ORDER BY col1;
150 col1 col2
151 10 innodb cloned row 1
152 20 innodb cloned row 2
153 30 innodb cloned row 3
154 SHOW CREATE SCHEMA schema_read_only;
155 Database Create Database
156 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 */
157 SELECT count(*) FROM mysql.general_log;
158 count(*)
159 0
160 SELECT count(*) FROM mysql.slow_log;
161 count(*)
162 0
163 SET GLOBAL general_log = ON;
164 SET GLOBAL slow_query_log = ON;
165 # restart:
166 SELECT * from t1 ORDER BY col1;
167 col1 col2
168 10 clone row 1
169 20 clone row 2
170 30 clone row 3
171 DROP TABLE t1;
172 DROP TABLE t_myisam;
173 DROP TABLE t_csv;
174 DROP TABLE non_innodb.t_myisam;
175 DROP TABLE non_innodb.t_csv;
176 DROP SCHEMA non_innodb;
177 ALTER SCHEMA schema_read_only READ ONLY=0;
178 DROP SCHEMA schema_read_only;
179 UNINSTALL PLUGIN example;
180 UNINSTALL PLUGIN clone;
181 #
182 # BUG#34828542: P_S.clone_status.gtid_executed does not have enough
183 # column size
184 #
185 # Install Plugin
186 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
187 # Test case set up.
188 SET @gtid_next_saved = @@SESSION.GTID_NEXT;
189 SET @gtid_mode_saved = @@GLOBAL.GTID_MODE;
190 SET @enforce_gtid_consistency_saved = @@GLOBAL.ENFORCE_GTID_CONSISTENCY;
191 SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY=ON;
192 SET @@GLOBAL.GTID_MODE=OFF_PERMISSIVE;
193 SET @@GLOBAL.GTID_MODE=ON_PERMISSIVE;
194 SET @@GLOBAL.GTID_MODE=ON;
195 CREATE PROCEDURE p1()
196 BEGIN
197 DECLARE x INT DEFAULT 0;
198 WHILE x <= 2000 DO
199 SET gtid_next=CONCAT(UUID(),':',4000);
200 COMMIT;
201 SET x = x + 1;
202 END WHILE;
203 END//
204 CALL p1();
205 # Restore GTID settings.
206 SET @@SESSION.GTID_NEXT= @gtid_next_saved;
207 SET @@GLOBAL.GTID_MODE=ON_PERMISSIVE;
208 SET @@GLOBAL.GTID_MODE=OFF_PERMISSIVE;
209 SET @@GLOBAL.GTID_MODE= @gtid_mode_saved;
210 SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY=@enforce_gtid_consistency_saved;
211 # Clone database.
212 SET GLOBAL clone_autotune_concurrency = OFF;
213 SET GLOBAL clone_max_concurrency = 8;
214 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
215 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
216 # Restart cloned database
217 # restart: --datadir=CLONE_DATADIR
218 # Check the length of gtid_executed > 4096 after bug fix.
219 SELECT length(gtid_executed) from performance_schema.clone_status;
220 length(gtid_executed)
221 86081
222 # restart:
223 DROP PROCEDURE p1;
224 RESET MASTER;
225 UNINSTALL PLUGIN clone;