| 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 |