diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_gtid_errorhandling.result')
-rw-r--r-- | mysql-test/suite/rpl/r/rpl_gtid_errorhandling.result | 38 |
1 files changed, 33 insertions, 5 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_gtid_errorhandling.result b/mysql-test/suite/rpl/r/rpl_gtid_errorhandling.result index a2bf8b567e8..47ba3c956b1 100644 --- a/mysql-test/suite/rpl/r/rpl_gtid_errorhandling.result +++ b/mysql-test/suite/rpl/r/rpl_gtid_errorhandling.result @@ -1,11 +1,16 @@ include/master-slave.inc [connection master] *** Test that we check against incorrect table definition for mysql.gtid_slave_pos *** +connection master; CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=InnoDB; +connection slave; +connection slave; include/stop_slave.inc ALTER TABLE mysql.gtid_slave_pos CHANGE seq_no seq_no VARCHAR(20); START SLAVE; +connection master; INSERT INTO t1 VALUES (1); +connection slave; CALL mtr.add_suppression("Slave: Failed to open mysql.gtid_slave_pos"); include/wait_for_slave_sql_error.inc [errno=1942] include/stop_slave.inc @@ -26,6 +31,9 @@ include/stop_slave.inc ALTER TABLE mysql.gtid_slave_pos DROP PRIMARY KEY; ALTER TABLE mysql.gtid_slave_pos ADD PRIMARY KEY (domain_id, sub_id); include/start_slave.inc +connection master; +connection slave; +connection slave; SELECT * FROM t1; a 1 @@ -53,11 +61,14 @@ SELECT * FROM t1 ORDER BY a; a 1 *** Test requesting an explicit GTID position that conflicts with newer GTIDs of our own in the binlog. *** +connection slave; include/stop_slave.inc +connection master; RESET MASTER; INSERT INTO t1 VALUES (2); INSERT INTO t1 VALUES (4); include/save_master_gtid.inc +connection slave; SET sql_log_bin = 0; INSERT INTO t1 VALUES (2); SET sql_log_bin = 1; @@ -72,16 +83,16 @@ ERROR 25000: You are not allowed to execute this command in a transaction ROLLBACK; SET GLOBAL gtid_strict_mode= 1; SET GLOBAL gtid_slave_pos = "0-1-1"; -ERROR HY000: Specified GTID 0-1-1 conflicts with the binary log which contains a more recent GTID 0-2-11. If MASTER_GTID_POS=CURRENT_POS is used, the binlog position will override the new value of @@gtid_slave_pos. +ERROR HY000: Specified GTID 0-1-1 conflicts with the binary log which contains a more recent GTID 0-2-11. If MASTER_GTID_POS=CURRENT_POS is used, the binlog position will override the new value of @@gtid_slave_pos SET GLOBAL gtid_slave_pos = ""; -ERROR HY000: Specified value for @@gtid_slave_pos contains no value for replication domain 0. This conflicts with the binary log which contains GTID 0-2-11. If MASTER_GTID_POS=CURRENT_POS is used, the binlog position will override the new value of @@gtid_slave_pos. +ERROR HY000: Specified value for @@gtid_slave_pos contains no value for replication domain 0. This conflicts with the binary log which contains GTID 0-2-11. If MASTER_GTID_POS=CURRENT_POS is used, the binlog position will override the new value of @@gtid_slave_pos SET GLOBAL gtid_strict_mode= 0; SET GLOBAL gtid_slave_pos = "0-1-1"; Warnings: -Warning 1947 Specified GTID 0-1-1 conflicts with the binary log which contains a more recent GTID 0-2-11. If MASTER_GTID_POS=CURRENT_POS is used, the binlog position will override the new value of @@gtid_slave_pos. +Warning 1947 Specified GTID 0-1-1 conflicts with the binary log which contains a more recent GTID 0-2-11. If MASTER_GTID_POS=CURRENT_POS is used, the binlog position will override the new value of @@gtid_slave_pos SET GLOBAL gtid_slave_pos = ""; Warnings: -Warning 1948 Specified value for @@gtid_slave_pos contains no value for replication domain 0. This conflicts with the binary log which contains GTID 0-2-11. If MASTER_GTID_POS=CURRENT_POS is used, the binlog position will override the new value of @@gtid_slave_pos. +Warning 1948 Specified value for @@gtid_slave_pos contains no value for replication domain 0. This conflicts with the binary log which contains GTID 0-2-11. If MASTER_GTID_POS=CURRENT_POS is used, the binlog position will override the new value of @@gtid_slave_pos RESET MASTER; SET GLOBAL gtid_slave_pos = "0-1-1"; START SLAVE; @@ -94,13 +105,15 @@ a 4 *** MDEV-4688: Empty value of @@GLOBAL.gtid_slave_pos *** include/stop_slave.inc +connection master; INSERT INTO t1 VALUES (5); include/save_master_gtid.inc +connection slave; SET @old_dbug= @@GLOBAL.debug_dbug; SET GLOBAL debug_dbug="+d,dummy_disable_default_dbug_output"; SET GLOBAL debug_dbug="+d,gtid_fail_after_record_gtid"; SET sql_log_bin=0; -CALL mtr.add_suppression('Got error 131 "Command not supported by database" during COMMIT'); +CALL mtr.add_suppression('Got error 131 "Command not supported by the engine" during COMMIT'); SET sql_log_bin=1; START SLAVE; include/wait_for_slave_sql_error.inc [errno=1180] @@ -139,8 +152,10 @@ include/stop_slave.inc SET GLOBAL gtid_slave_pos = "0-1-3"; START SLAVE; include/wait_for_slave_to_start.inc +connection master; INSERT INTO t1 VALUES (6); include/save_master_gtid.inc +connection slave; include/sync_with_master_gtid.inc SELECT * FROM t1 ORDER BY a; a @@ -151,21 +166,29 @@ a 5 6 *** MDEV-4278: Slave does not detect that master is not GTID-aware *** +connection slave; include/stop_slave.inc +connection master; SET @old_dbug= @@global.DEBUG_DBUG; SET GLOBAL debug_dbug="+d,simulate_non_gtid_aware_master"; +connection slave; START SLAVE; include/wait_for_slave_io_error.inc [errno=1233] +connection master; SET GLOBAL debug_dbug= @old_dbug; INSERT INTO t1 VALUES (7); +connection slave; START SLAVE; SET sql_log_bin=0; CALL mtr.add_suppression("The slave I/O thread stops because master does not support MariaDB global transaction id"); SET sql_log_bin=1; *** Test error during record_gtid() (non-xid cases) *** +connection slave; include/stop_slave.inc +connection master; CREATE TABLE t2 (a INT) ENGINE=MyISAM; INSERT INTO t2 VALUES (1); +connection slave; SET @old_dbug= @@global.DEBUG_DBUG; SET GLOBAL debug_dbug="+d,gtid_inject_record_gtid"; START SLAVE; @@ -180,6 +203,7 @@ SET sql_log_bin=0; CALL mtr.add_suppression("Slave: Could not update replication slave gtid state"); SET sql_log_bin=1; *** MDEV-4906: When event apply fails, next SQL thread start erroneously commits the failing GTID to gtid_slave_pos *** +connection slave; include/stop_slave.inc SET sql_log_bin=0; DELETE FROM t2; @@ -187,10 +211,12 @@ SET sql_log_bin=1; SET @old_format=@@binlog_format; SET GLOBAL binlog_format='row'; include/start_slave.inc +connection master; SET @old_format=@@binlog_format; SET binlog_format='row'; DELETE FROM t2; SET binlog_format=@old_format; +connection slave; include/wait_for_slave_sql_error.inc [errno=1032] result OK @@ -206,6 +232,8 @@ CALL mtr.add_suppression("Slave: Can't find record in 't2' Error_code: 1032"); SET sql_log_bin=1; include/start_slave.inc SET GLOBAL binlog_format=@old_format; +connection master; DROP TABLE t1; DROP TABLE t2; +call mtr.add_suppression("Can't find record in 't2'"); include/rpl_end.inc |