Edit File: rpl_gtid_mode.result
include/master-slave.inc [connection master] call mtr.add_suppression("Slave I/O: The slave IO thread stops because the master has @@GLOBAL.GTID_MODE"); call mtr.add_suppression("Error reading packet from server: Lost connection to MySQL"); call mtr.add_suppression("Aborting"); call mtr.add_suppression(".* Found a Gtid_log_event or Previous_gtids_log_event when @@GLOBAL.GTID_MODE = OFF."); call mtr.add_suppression("MASTER_AUTO_POSITION in the master info file was 1 but server is started with @@GLOBAL.GTID_MODE = OFF. Forcing MASTER_AUTO_POSITION to 0."); include/sync_slave_sql_with_master.inc include/stop_slave.inc ==== Master and slave have GTID_MODE = OFF ==== ---- Default value for GTID_MODE ---- include/assert.inc [Default value for GTID_MODE should be OFF] ---- GTID_MODE is read-only ---- SET GTID_MODE = OFF; ERROR HY000: Variable 'gtid_mode' is a read only variable SET GTID_MODE = UPGRADE_STEP_1; ERROR HY000: Variable 'gtid_mode' is a read only variable SET GTID_MODE = UPGRADE_STEP_2; ERROR HY000: Variable 'gtid_mode' is a read only variable SET GTID_MODE = OFF_PERMISSIVE; ERROR HY000: Variable 'gtid_mode' is a read only variable SET GTID_MODE = ON_PERMISSIVE; ERROR HY000: Variable 'gtid_mode' is a read only variable SET GTID_MODE = ON; ERROR HY000: Variable 'gtid_mode' is a read only variable ---- GTID_NEXT must be ANONYMOUS or AUTOMATIC ---- SET GTID_NEXT = 'AUTOMATIC'; SET GTID_NEXT = 'ANONYMOUS'; SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1'; ERROR HY000: @@SESSION.GTID_NEXT cannot be set to UUID:NUMBER when @@GLOBAL.GTID_MODE = OFF. ---- CHANGE MASTER TO MASTER_AUTO_POSITION not supported ---- CHANGE MASTER TO MASTER_AUTO_POSITION = 1; ERROR HY000: CHANGE MASTER TO MASTER_AUTO_POSITION = 1 can only be executed when @@GLOBAL.GTID_MODE = ON. CHANGE MASTER TO MASTER_AUTO_POSITION = 0; ---- No GTIDs in binlog ---- include/start_slave.inc SET GTID_NEXT = 'AUTOMATIC'; CREATE TABLE t1 (a INT) ENGINE = InnoDB; SET GTID_NEXT = 'ANONYMOUS'; INSERT INTO t1 VALUES (1); include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN include/sync_slave_sql_with_master.inc include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 # Query # # BEGIN include/show_relaylog_events.inc Log_name Pos Event_type Server_id End_log_pos Info slave-relay-bin.000002 # Rotate # # master-bin.000001;pos=POS ==== Checks performed at server start when GTID_MODE = ON ==== include/rpl_stop_server.inc [server_number=2] ---- GTID_MODE = UPGRADE_STEP_[1|2] not supported ---- include/assert_command_output.inc include/assert_command_output.inc ---- GTID_MODE=ON requires --enforce-gtid-consistency ---- include/assert_command_output.inc ==== Master has GTID_MODE = OFF, slave has GTID_MODE = ON ==== include/rpl_start_server.inc [server_number=2 gtids=on] ---- Slave can't connect ---- START SLAVE; include/wait_for_slave_io_error.inc [errno=1593 # ER_SLAVE_FATAL_ERROR] include/stop_slave_sql.inc ==== Master and slave have GTID_MODE = ON ==== include/rpl_stop_server.inc [server_number=1] ---- GTID_MODE = ON requires --log-bin --log-slave-updates ---- include/assert_command_output.inc include/rpl_start_server.inc [server_number=1 gtids=on] include/start_slave.inc include/assert.inc [GTID_MODE should be ON now.] ---- GTID_NEXT must be SID:GNO or AUTOMATIC ----- SET GTID_NEXT = 'AUTOMATIC'; SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1'; SET GTID_NEXT = 'ANONYMOUS'; ERROR HY000: @@SESSION.GTID_NEXT cannot be set to ANONYMOUS when @@GLOBAL.GTID_MODE = ON. ROLLBACK; SET SESSION GTID_NEXT='7805be8e-51ab-11e1-bacc-6706c20ad7ba:1'; SET SESSION GTID_NEXT='7805be8e-51ab-11e1-bacc-6706c20ad7ba:1'; ERROR HY000: @@SESSION.GTID_NEXT cannot be changed by a client that owns a GTID. The client owns 7805be8e-51ab-11e1-bacc-6706c20ad7ba:1. Ownership is released on COMMIT or ROLLBACK. ROLLBACK; SET SESSION GTID_NEXT='7805be8e-51ab-11e1-bacc-6706c20ad7ba:1'; SET SESSION GTID_NEXT='7805be8e-51ab-11e1-bacc-6706c20ad7ba:1'; ROLLBACK; ---- GTIDs are in binlog ---- SET GTID_NEXT = 'AUTOMATIC'; INSERT INTO t1 VALUES (2); include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000002 # Previous_gtids # # include/sync_slave_sql_with_master.inc include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000002 # Previous_gtids # # include/show_relaylog_events.inc Log_name Pos Event_type Server_id End_log_pos Info slave-relay-bin.000005 # Previous_gtids # # ---- CHANGE MASTER TO MASTER_AUTO_POSITION = 1 works ---- include/stop_slave.inc CHANGE MASTER TO MASTER_AUTO_POSITION = 1; include/start_slave.inc INSERT INTO t1 VALUES (3); include/sync_slave_sql_with_master.inc include/stop_slave.inc ==== Checks performed at server start when GTID_MODE = OFF ==== include/rpl_stop_server.inc [server_number=2] ---- Fail to start replication with GTID_MODE = OFF and GTIDs in binlog/relay log ---- include/rpl_start_server.inc [server_number=2] START SLAVE; include/rpl_restart_server.inc [server_number=2 gtids=on] RESET SLAVE; RESET MASTER; ==== Master has GTID_MODE = ON, slave has GTID_MODE = OFF ==== include/rpl_stop_server.inc [server_number=2] include/rpl_start_server.inc [server_number=2 parameters: --log-slave-updates] CHANGE MASTER TO MASTER_HOST = '127.0.0.1', MASTER_PORT = PORT, MASTER_USER = 'root', MASTER_LOG_FILE = 'FILE', MASTER_LOG_POS = POS, MASTER_CONNECT_RETRY = 1; Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. ---- Slave can't connect ---- START SLAVE; include/wait_for_slave_io_error.inc [errno=1593 # ER_SLAVE_FATAL_ERROR] include/stop_slave_sql.inc RESET SLAVE; include/rpl_end.inc