summaryrefslogtreecommitdiff
path: root/mysql-test/suite/rpl/r/rpl_gtid_reconnect.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_gtid_reconnect.result')
-rw-r--r--mysql-test/suite/rpl/r/rpl_gtid_reconnect.result20
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