diff options
author | Sergey Vojtovich <svoj@mariadb.org> | 2016-03-25 20:51:22 +0400 |
---|---|---|
committer | Sergey Vojtovich <svoj@mariadb.org> | 2016-03-31 10:11:16 +0400 |
commit | 282497dd6d1049b4fb963641504c2733752845a7 (patch) | |
tree | 7288d17c29fbbe9ac47ec51f6988fb954f59a361 /mysql-test/suite/rpl/r/rpl_gtid_mdev4820.result | |
parent | 5052e2479e873461bebfcedbc674bbaf57d3c968 (diff) | |
download | mariadb-git-282497dd6d1049b4fb963641504c2733752845a7.tar.gz |
MDEV-6720 - enable connection log in mysqltest by default
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_gtid_mdev4820.result')
-rw-r--r-- | mysql-test/suite/rpl/r/rpl_gtid_mdev4820.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_gtid_mdev4820.result b/mysql-test/suite/rpl/r/rpl_gtid_mdev4820.result index be420cb021b..02018b3a59c 100644 --- a/mysql-test/suite/rpl/r/rpl_gtid_mdev4820.result +++ b/mysql-test/suite/rpl/r/rpl_gtid_mdev4820.result @@ -1,24 +1,31 @@ include/rpl_init.inc [topology=1->2] +connection server_2; include/stop_slave.inc SET @slave_old_strict= @@GLOBAL.gtid_strict_mode; SET GLOBAL gtid_strict_mode= 1; CHANGE MASTER TO master_use_gtid=slave_pos; include/start_slave.inc +connection server_1; SET @master_old_strict= @@GLOBAL.gtid_strict_mode; SET GLOBAL gtid_strict_mode= 1; CREATE TABLE t1 (a INT PRIMARY KEY); INSERT INTO t1 VALUES (1); +connection server_2; SELECT * FROM t1 ORDER BY a; a 1 include/stop_slave.inc +connection server_1; INSERT INTO t1 VALUES (2); INSERT INTO t1 VALUES (3); RESET MASTER; SET GLOBAL gtid_slave_pos= 'OLD_GTID_POS'; +connection server_2; include/start_slave.inc +connection server_1; INSERT INTO t1 VALUES (4); include/save_master_gtid.inc +connection server_2; SET sql_log_bin= 0; CALL mtr.add_suppression("The binlog on the master is missing the GTID"); SET sql_log_bin= 1; @@ -35,14 +42,18 @@ include/stop_slave.inc RESET SLAVE ALL; RESET MASTER; SET GLOBAL gtid_slave_pos= '0-2-10'; +connection server_1; CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_2, master_user= 'root', master_use_gtid=CURRENT_POS; START SLAVE; +connection server_2; INSERT INTO t1 VALUES (11); +connection server_1; SET sql_log_bin= 0; CALL mtr.add_suppression("which is not in the master's binlog. Since the master's binlog contains GTIDs with higher sequence numbers, it probably means that the slave has diverged"); SET sql_log_bin= 1; include/wait_for_slave_io_error.inc [errno=1236] +connection server_1; STOP SLAVE SQL_THREAD; SET GLOBAL gtid_slave_pos= '0-2-10'; SET GLOBAL gtid_strict_mode= 0; @@ -57,6 +68,7 @@ a include/stop_slave.inc RESET SLAVE ALL; INSERT INTO t1 VALUES (12); +connection server_2; INSERT INTO t1 VALUES (22); CHANGE MASTER TO master_host = '127.0.0.1', master_port = SERVER_MYPORT_1, master_user= 'root', master_use_gtid=CURRENT_POS; @@ -79,7 +91,9 @@ a 11 12 22 +connection server_2; SET GLOBAL gtid_strict_mode= @slave_old_strict; +connection server_1; DROP TABLE t1; SET GLOBAL gtid_strict_mode= @master_old_strict; include/rpl_end.inc |