diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_gtid_reconnect.result')
-rw-r--r-- | mysql-test/suite/rpl/r/rpl_gtid_reconnect.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_gtid_reconnect.result b/mysql-test/suite/rpl/r/rpl_gtid_reconnect.result index 001362825f9..d5037f8cf94 100644 --- a/mysql-test/suite/rpl/r/rpl_gtid_reconnect.result +++ b/mysql-test/suite/rpl/r/rpl_gtid_reconnect.result @@ -1,9 +1,13 @@ include/rpl_init.inc [topology=1->2] +connection server_2; include/stop_slave.inc CHANGE MASTER TO master_use_gtid= current_pos; include/start_slave.inc +connection server_1; CREATE TABLE t1 (a INT); FLUSH LOGS; +connection server_2; +connection server_1; SET gtid_domain_id=10; INSERT INTO t1 VALUES (1); INSERT INTO t1 VALUES (2); @@ -11,6 +15,7 @@ SET gtid_seq_no=100; INSERT INTO t1 VALUES (3); INSERT INTO t1 VALUES (4); INSERT INTO t1 VALUES (5); +connection server_2; include/stop_slave.inc SELECT * FROM t1 ORDER BY a; a @@ -19,11 +24,13 @@ a 3 4 5 +connection server_1; include/kill_binlog_dump_threads.inc INSERT INTO t1 VALUES (10); SET @old_dbug= @@GLOBAL.debug_dbug; SET GLOBAL debug_dbug="+d,dummy_disable_default_dbug_output"; SET GLOBAL debug_dbug="+d,gtid_force_reconnect_at_10_1_100"; +connection server_2; include/start_slave.inc SELECT * FROM t1 ORDER BY a; a @@ -37,6 +44,7 @@ include/stop_slave.inc TRUNCATE t1; RESET MASTER; SET GLOBAL gtid_slave_pos= ""; +connection server_1; SET GLOBAL debug_dbug= @old_debug; TRUNCATE t1; RESET MASTER; @@ -55,6 +63,7 @@ INSERT INTO t1 VALUES (3); SET gtid_domain_id=11; SET gtid_seq_no=200; INSERT INTO t1 VALUES (13); +connection server_2; START SLAVE UNTIL master_gtid_pos="10-1-50,11-1-200"; include/wait_for_slave_to_stop.inc SELECT * FROM t1 ORDER BY a; @@ -63,10 +72,12 @@ a 11 12 13 +connection server_1; include/kill_binlog_dump_threads.inc INSERT INTO t1 VALUES (20); SET GLOBAL debug_dbug="+d,dummy_disable_default_dbug_output"; SET GLOBAL debug_dbug="+d,gtid_force_reconnect_at_10_1_100"; +connection server_2; include/start_slave.inc SELECT * FROM t1 ORDER BY a; a @@ -81,6 +92,7 @@ include/stop_slave.inc TRUNCATE t1; RESET MASTER; SET GLOBAL gtid_slave_pos= ""; +connection server_1; SET GLOBAL debug_dbug= @old_debug; TRUNCATE t1; RESET MASTER; @@ -103,6 +115,7 @@ INSERT INTO t1 VALUES (13); SET gtid_domain_id= 10; SET GLOBAL debug_dbug="+d,dummy_disable_default_dbug_output"; SET GLOBAL debug_dbug="+d,gtid_force_reconnect_at_10_1_100"; +connection server_2; START SLAVE UNTIL master_gtid_pos="9-1-50,10-1-200"; include/wait_for_slave_to_stop.inc SELECT * FROM t1 ORDER BY a; @@ -111,8 +124,10 @@ a 11 12 13 +connection server_1; SET GLOBAL debug_dbug= @old_debug; INSERT INTO t1 VALUES (20); +connection server_2; include/start_slave.inc SELECT * FROM t1 ORDER BY a; a @@ -124,10 +139,12 @@ a 13 20 *** Test when slave IO thread needs to reconnect in the middle of an event group. *** +connection server_2; include/stop_slave.inc TRUNCATE t1; RESET MASTER; SET GLOBAL gtid_slave_pos= ""; +connection server_1; SET GLOBAL debug_dbug= @old_debug; TRUNCATE t1; RESET MASTER; @@ -152,6 +169,7 @@ INSERT INTO t2 VALUES (27); INSERT INTO t2 VALUES (28); INSERT INTO t2 VALUES (29); COMMIT; +connection server_2; include/start_slave.inc SELECT * FROM t2 ORDER BY a; a @@ -168,6 +186,8 @@ a 27 28 29 +connection server_1; SET GLOBAL debug_dbug= @old_debug; +connection server_1; DROP TABLE t1, t2; include/rpl_end.inc |