Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_gtid_while_super_read_only.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 include/suppress_messages.inc
7 # Connection 1 suppresses message <.*InnoDB redo logging is disabled.* All data could be lost in case of a server crash.*>.
8 # Connection 2 suppresses message <.*InnoDB redo logging is disabled.* All data could be lost in case of a server crash.*>.
9 #### 1. Run START REPLICA and replicate from some server.
10 [connection slave]
11 SET GLOBAL SUPER_READ_ONLY = ON;
12 include/start_slave.inc
13 [connection master]
14 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
15 include/sync_slave_sql_with_master.inc
16 include/gtid_step_assert.inc [count=1, only_count=1]
17 #### 2. Restart a replica while there is any MEMORY table defined.
18 [connection slave]
19 include/gtid_step_reset.inc
20 [connection master]
21 include/gtid_step_reset.inc
22 CREATE TABLE m1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=Memory;
23 include/sync_slave_sql_with_master.inc
24 include/assert.inc [Table m1 must exists]
25 include/stop_slave.inc
26 [connection slave]
27 include/start_slave.inc
28 [connection slave]
29 include/gtid_step_assert.inc [count=1, only_count=1]
30 include/rpl_restart_server.inc [server_number=2]
31 include/start_slave.inc
32 [connection master]
33 SELECT COUNT(*) FROM m1;
34 COUNT(*)
35 0
36 include/gtid_step_assert.inc [count=0, only_count=1]
37 INSERT INTO m1 values(1);
38 include/sync_slave_sql_with_master.inc
39 include/gtid_step_assert.inc [count=2, only_count=1]
40 #### 3. Restart a replica server while replica_open_temp_tables > 0
41 [connection slave]
42 include/stop_slave.inc
43 SET @@global.binlog_format = STATEMENT;
44 Warnings:
45 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
46 include/start_slave.inc
47 [connection master]
48 SET SESSION BINLOG_FORMAT = STATEMENT;
49 Warnings:
50 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
51 CREATE TEMPORARY TABLE t2(i INT);
52 include/sync_slave_sql_with_master.inc
53 [connection slave]
54 include/gtid_step_reset.inc
55 include/assert.inc [Replica_open_temp_tables shall be 1]
56 include/stop_slave.inc
57 Warnings:
58 Warning 3022 This operation may not be safe when the replica has temporary tables. The tables will be kept open until the server restarts or until the tables are deleted by any replicated DROP statement. Suggest to wait until replica_open_temp_tables = 0.
59 [connection slave]
60 include/start_slave.inc
61 [connection slave]
62 include/gtid_step_assert.inc [count=0, only_count=0]
63 include/rpl_restart_server.inc [server_number=2 gtids=on]
64 include/gtid_step_reset.inc
65 include/start_slave.inc
66 [connection slave]
67 include/assert.inc [Replica_open_temp_tables shall be 0]
68 include/gtid_step_assert.inc [count=0, only_count=0]
69 #### 3 (b). when replica has open temp tables and we restart the
70 #### source server and reconnect replica. Replica generate extra
71 #### DROP TEMPORARY TABLE statements in this case
72 [connection slave]
73 include/stop_slave.inc
74 SET @@global.binlog_format = STATEMENT;
75 Warnings:
76 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
77 include/start_slave.inc
78 [connection master]
79 CREATE TEMPORARY TABLE t3(i INT);
80 include/sync_slave_sql_with_master.inc
81 include/save_binlog_position.inc
82 [connection slave]
83 include/stop_slave_io.inc
84 Warnings:
85 Warning 3022 This operation may not be safe when the replica has temporary tables. The tables will be kept open until the server restarts or until the tables are deleted by any replicated DROP statement. Suggest to wait until replica_open_temp_tables = 0.
86 include/rpl_restart_server.inc [server_number=1 gtids=on]
87 [connection slave]
88 include/gtid_step_reset.inc
89 include/start_slave.inc
90 [connection master]
91 CREATE TABLE aux_table_to_sync (a INT);
92 DROP TABLE aux_table_to_sync;
93 include/sync_slave_sql_with_master.inc
94 [connection slave]
95 include/assert_binlog_events.inc [Gtid # Query/.*DROP.*t3.* # Gtid # Query/.*CREATE.*aux.* # Gtid # Query/.*DROP.*aux.*]
96 include/gtid_step_assert.inc [count=3, only_count=1]
97 [connection master]
98 #### 4. Using statement-based replication, create a temporary table
99 #### while not in super_read_only mode, and then disconnect while
100 #### in super_read_only mode.
101 SET @@global.super_read_only = 0;
102 SET @@session.binlog_format = STATEMENT;
103 Warnings:
104 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
105 CREATE TEMPORARY TABLE t1 (a INT);
106 include/gtid_step_reset.inc
107 include/save_binlog_position.inc
108 SET @@global.super_read_only = 1;
109 [connection slave]
110 include/assert_binlog_events.inc [Gtid # Query(.*DROP.*)]
111 include/gtid_step_assert.inc [count=1, only_count=0]
112 #### 5. ALTER INSTANCE AND CHECK GTID_EXCECUTED
113 [connection slave]
114 SET GLOBAL SUPER_READ_ONLY = ON;
115 include/gtid_step_reset.inc
116 ALTER INSTANCE ENABLE INNODB REDO_LOG;
117 ALTER INSTANCE DISABLE INNODB REDO_LOG;
118 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
119 ALTER INSTANCE RELOAD TLS;
120 include/gtid_step_assert.inc [count=0, only_count=0]
121 ALTER INSTANCE ROTATE INNODB MASTER KEY;
122 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
123 #### 6(a) FLUSH STATEMENTS AND CHECK GTID EXCECUTED
124 [connection slave]
125 FLUSH LOGS;
126 include/gtid_step_assert.inc [count=0, only_count=0]
127 FLUSH BINARY LOGS;
128 include/gtid_step_assert.inc [count=0, only_count=0]
129 FLUSH TABLES;
130 include/gtid_step_assert.inc [count=1, only_count=0]
131 FLUSH TABLES t1;
132 include/gtid_step_assert.inc [count=1, only_count=0]
133 FLUSH ENGINE LOGS;
134 include/gtid_step_assert.inc [count=1, only_count=0]
135 FLUSH ERROR LOGS;
136 include/gtid_step_assert.inc [count=1, only_count=0]
137 FLUSH GENERAL LOGS;
138 include/gtid_step_assert.inc [count=1, only_count=0]
139 FLUSH HOSTS;
140 Warnings:
141 Warning 1287 'FLUSH HOSTS' is deprecated and will be removed in a future release. Please use TRUNCATE TABLE performance_schema.host_cache instead
142 include/gtid_step_assert.inc [count=1, only_count=0]
143 FLUSH PRIVILEGES;
144 include/gtid_step_assert.inc [count=1, only_count=0]
145 FLUSH OPTIMIZER_COSTS;
146 include/gtid_step_assert.inc [count=1, only_count=0]
147 FLUSH RELAY LOGS;
148 include/gtid_step_assert.inc [count=1, only_count=0]
149 FLUSH SLOW LOGS;
150 include/gtid_step_assert.inc [count=1, only_count=0]
151 FLUSH STATUS;
152 include/gtid_step_assert.inc [count=1, only_count=0]
153 FLUSH USER_RESOURCES;
154 include/gtid_step_assert.inc [count=1, only_count=0]
155 #### 6(b) FLUSH STATEMENTS UNDER NO_WRITE_TO_BINLOG AND CHECK GTID EXCECUTED
156 [connection slave]
157 include/gtid_step_reset.inc
158 FLUSH LOCAL ENGINE LOGS;
159 include/gtid_step_assert.inc [count=0, only_count=0]
160 FLUSH NO_WRITE_TO_BINLOG ERROR LOGS;
161 include/gtid_step_assert.inc [count=0, only_count=0]
162 FLUSH NO_WRITE_TO_BINLOG GENERAL LOGS;
163 include/gtid_step_assert.inc [count=0, only_count=0]
164 FLUSH NO_WRITE_TO_BINLOG HOSTS;
165 Warnings:
166 Warning 1287 'FLUSH HOSTS' is deprecated and will be removed in a future release. Please use TRUNCATE TABLE performance_schema.host_cache instead
167 include/gtid_step_assert.inc [count=0, only_count=0]
168 FLUSH NO_WRITE_TO_BINLOG LOGS;
169 include/gtid_step_assert.inc [count=0, only_count=0]
170 FLUSH NO_WRITE_TO_BINLOG PRIVILEGES;
171 include/gtid_step_assert.inc [count=0, only_count=0]
172 FLUSH NO_WRITE_TO_BINLOG OPTIMIZER_COSTS;
173 include/gtid_step_assert.inc [count=0, only_count=0]
174 FLUSH NO_WRITE_TO_BINLOG RELAY LOGS;
175 include/gtid_step_assert.inc [count=0, only_count=0]
176 FLUSH NO_WRITE_TO_BINLOG SLOW LOGS;
177 include/gtid_step_assert.inc [count=0, only_count=0]
178 FLUSH NO_WRITE_TO_BINLOG STATUS;
179 include/gtid_step_assert.inc [count=0, only_count=0]
180 FLUSH NO_WRITE_TO_BINLOG USER_RESOURCES;
181 include/gtid_step_assert.inc [count=0, only_count=0]
182 FLUSH NO_WRITE_TO_BINLOG TABLES;
183 include/gtid_step_assert.inc [count=0, only_count=0]
184 FLUSH NO_WRITE_TO_BINLOG TABLES t1;
185 include/gtid_step_assert.inc [count=0, only_count=0]
186 FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS;
187 include/gtid_step_assert.inc [count=0, only_count=0]
188 FLUSH NO_WRITE_TO_BINLOG BINARY LOGS;
189 include/gtid_step_assert.inc [count=0, only_count=0]
190 #### 7. SET gtid_purged.
191 [connection slave]
192 SET @@GLOBAL.GTID_PURGED = '00000000-0000-0000-0000-000000000000:1-1000000000000000000';
193 include/assert.inc [Assert the GTID_PURGED value]
194 #### 8. SET gtid_next to a GTID, and then execute any of:
195 #### COMMIT
196 #### XA START
197 #### SET autocommit = 1
198 #### SET autocommit = 0
199 #### START TRANSACTION READ_ONLY; COMMIT;
200 include/gtid_step_reset.inc
201 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
202 XA START 'xa1';
203 XA END 'xa1';
204 XA PREPARE 'xa1';
205 SET GTID_NEXT = 'AUTOMATIC';
206 include/gtid_step_assert.inc [count=1, only_count=1]
207 SET @@SESSION.AUTOCOMMIT = ON;
208 include/gtid_step_assert.inc [count=0, only_count=1]
209 SET @@SESSION.AUTOCOMMIT = OFF;
210 include/gtid_step_assert.inc [count=0, only_count=1]
211 [connection slave]
212 SET GLOBAL SUPER_READ_ONLY = ON;
213 include/gtid_step_reset.inc
214 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2';
215 START TRANSACTION WITH CONSISTENT SNAPSHOT;
216 COMMIT;
217 SET GTID_NEXT = 'AUTOMATIC';
218 include/gtid_step_assert.inc [count=1, only_count=1]
219 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:3';
220 START TRANSACTION READ WRITE;
221 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
222 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:4';
223 START TRANSACTION READ ONLY;
224 COMMIT;
225 SET GTID_NEXT = 'AUTOMATIC';
226 include/gtid_step_assert.inc [count=1, only_count=1]
227 #### 9. The unusual DDL statements:
228 #### [CREATE | ALTER] [SPATIAL REFERENCE SYTEM | SERVER | LOGFILE GROUP].
229 [connection slave]
230 SET GLOBAL SUPER_READ_ONLY = OFF;
231 CREATE TABLE t_part(c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB
232 PARTITION BY RANGE(c1)
233 (PARTITION p0 VALUES LESS THAN (2),
234 PARTITION p1 VALUES LESS THAN (5),
235 PARTITION p3 VALUES LESS THAN (10),
236 PARTITION sp00 VALUES LESS THAN (15));
237 CREATE TABLE t_hash(c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
238 CREATE TABLE t_nopart1(c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
239 CREATE TABLE t_part1(c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB
240 PARTITION BY RANGE(c1)
241 (PARTITION p1 VALUES LESS THAN (5),
242 PARTITION p2 VALUES LESS THAN (10));
243 SET GLOBAL SUPER_READ_ONLY = ON;
244 CREATE TABLE t_test(c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
245 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
246 CREATE SPATIAL REFERENCE SYSTEM 13001000 NAME 'TEST13001000 Long-Lat WGS 84' DEFINITION 'GEOGCS["Long-Lat WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lon",EAST],AXIS["Lat",NORTH],AUTHORITY["EPSG","4326"]]';
247 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
248 CREATE SERVER s1 FOREIGN DATA WRAPPER mysql
249 OPTIONS (USER 'Remote', HOST '198.51.100.106', DATABASE 'test');
250 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
251 CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undo.dat' INITIAL_SIZE = 10M;
252 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
253 ALTER TABLE t_part TRUNCATE PARTITION p0, p1;
254 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
255 ALTER TABLE t_hash DISCARD TABLESPACE;
256 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
257 ALTER TABLE t_hash IMPORT TABLESPACE;
258 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
259 ALTER TABLE t_hash COALESCE PARTITION 1;
260 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
261 ALTER TABLE t_nopart1 REMOVE PARTITIONING;
262 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
263 ALTER TABLE t_part EXCHANGE PARTITION sp00 WITH TABLE t_nopart1;
264 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
265 ALTER TABLE t_part REBUILD PARTITION p0;
266 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
267 ALTER TABLE t_part1 REORGANIZE PARTITION p1,p2 INTO (PARTITION p3 VALUES LESS THAN (300));
268 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
269 ALTER TABLE t_part ADD PARTITION (PARTITION p3 VALUES LESS THAN (300));
270 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
271 ALTER TABLE t_part DROP PARTITION p3;
272 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
273 #### 10. [UN]INSTALL [PLUGIN | COMPONENT]
274 include/gtid_step_reset.inc
275 INSTALL PLUGIN keyring_file SONAME 'keyring_file.so';
276 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
277 UNINSTALL PLUGIN keyring_file;
278 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
279 include/gtid_step_assert.inc [count=0, only_count=0]
280 #### 11. [OPTIMIZE | ANALYZE | REPAIR] TABLE
281 REPAIR TABLE t1;
282 Table Op Msg_type Msg_text
283 test.t1 repair Error The MySQL server is running with the --super-read-only option so it cannot execute this statement
284 test.t1 repair error Corrupt
285 include/gtid_step_assert.inc [count=1, only_count=0]
286 ANALYZE TABLE t1;
287 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
288 OPTIMIZE TABLE t1;
289 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
290 #### 12. ALTER TABLE ... [OPTIMIZE | ANALYZE | REPAIR] PARTITION.
291 include/gtid_step_reset.inc
292 ALTER TABLE t_part OPTIMIZE PARTITION p0, p1;
293 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
294 include/gtid_step_assert.inc [count=0, only_count=0]
295 ALTER TABLE t_part ANALYZE PARTITION p0;
296 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
297 include/gtid_step_assert.inc [count=0, only_count=0]
298 ALTER TABLE t_part REPAIR PARTITION p0, p1;
299 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
300 include/gtid_step_assert.inc [count=0, only_count=0]
301 #### 13. Run GRANT, REVOKE, CREATE USER, DROP USER in a way that it
302 #### fails, e.g., create two users where the second already exists.
303 SET @@global.super_read_only = 0;
304 CREATE USER 'u1'@localhost IDENTIFIED BY '';
305 SET @@global.super_read_only = 1;
306 include/gtid_step_reset.inc
307 CREATE USER u1,u2;
308 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
309 include/gtid_step_assert.inc [count=0, only_count=0]
310 GRANT ALL ON *.* To u1,u2;
311 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
312 include/gtid_step_assert.inc [count=0, only_count=0]
313 REVOKE ALL ON *.* from u1;
314 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
315 include/gtid_step_assert.inc [count=0, only_count=0]
316 DROP USER u1;
317 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
318 include/gtid_step_assert.inc [count=0, only_count=0]
319 DROP USER u1,u2;
320 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
321 include/gtid_step_assert.inc [count=0, only_count=0]
322 #### 14. Run DML on mysql.gtid_executed, slave_master_info,
323 #### slave_relay_log_info, and slave_worker_info tables.
324 UPDATE mysql.slave_master_info SET Retry_count = Retry_count + 1;
325 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
326 include/gtid_step_assert.inc [count=0, only_count=0]
327 UPDATE mysql.slave_relay_log_info SET Sql_delay = Sql_delay + 1;
328 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
329 include/gtid_step_assert.inc [count=0, only_count=0]
330 UPDATE mysql.slave_worker_info SET Relay_log_pos = Relay_log_pos + 1;
331 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
332 include/gtid_step_assert.inc [count=0, only_count=0]
333 UPDATE mysql.gtid_executed SET interval_end = interval_end + 1;
334 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
335 include/gtid_step_assert.inc [count=0, only_count=0]
336 #### 15. Cleanup
337 SET GLOBAL READ_ONLY = OFF;
338 SET GTID_NEXT = 'AUTOMATIC';
339 [connection master]
340 SET GLOBAL SUPER_READ_ONLY = OFF;
341 SET GLOBAL READ_ONLY = OFF;
342 DROP TABLE t1, m1;
343 include/rpl_end.inc