Debian Codegraph @

mysql-test/suite/rpl/r/rpl_start_alter_restart_master.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 include/stop_slave.inc
5 CHANGE MASTER TO MASTER_USE_GTID=NO;
6 include/start_slave.inc
7 connection slave;
8 SET @old_debug_slave= @@global.debug_dbug;
9 stop slave;
10 SET GLOBAL slave_parallel_threads=4;
11 set global slave_parallel_mode=optimistic;
12 set global gtid_strict_mode=1;
13 start slave;
14 connection master;
15 call mtr.add_suppression("ALTER query started at .+ could not be completed");
16 SET @old_debug_master= @@global.debug_dbug;
17 set binlog_alter_two_phase=true;
18 create table t3( a int primary key, b int) engine=innodb;
19 connection master;
20 connection slave;
21 include/stop_slave.inc
22 connection master;
23 SET SESSION debug_dbug="d,start_alter_kill_after_binlog";
24 alter table t3 add column d int;
25 ERROR HY000: Lost connection to server during query
26 include/rpl_reconnect.inc
27 set binlog_alter_two_phase= true;
28 alter table t3 add column d int;
29 show create table t3;
30 Table Create Table
31 t3 CREATE TABLE `t3` (
32 `a` int(11) NOT NULL,
33 `b` int(11) DEFAULT NULL,
34 `d` int(11) DEFAULT NULL,
35 PRIMARY KEY (`a`)
36 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
37 include/show_binlog_events.inc
38 Log_name Pos Event_type Server_id End_log_pos Info
39 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
40 master-bin.000001 # Query # # use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_utf8mb4'ALTER query started at .+ could not be completed' COLLATE 'utf8mb4_uca1400_ai_ci'))
41 master-bin.000001 # Query # # COMMIT
42 master-bin.000001 # Gtid # # GTID #-#-#
43 master-bin.000001 # Query # # use `test`; create table t3( a int primary key, b int) engine=innodb
44 master-bin.000001 # Gtid # # GTID #-#-# START ALTER
45 master-bin.000001 # Query # # use `test`; alter table t3 add column d int
46 include/show_binlog_events.inc
47 Log_name Pos Event_type Server_id End_log_pos Info
48 master-bin.000002 # Gtid # # GTID #-#-# START ALTER
49 master-bin.000002 # Query # # use `test`; alter table t3 add column d int
50 master-bin.000002 # Gtid # # GTID #-#-# COMMIT ALTER id=#
51 master-bin.000002 # Query # # use `test`; alter table t3 add column d int
52 connection slave;
53 include/start_slave.inc
54 connection master;
55 connection slave;
56 include/show_binlog_events.inc
57 Log_name Pos Event_type Server_id End_log_pos Info
58 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
59 slave-bin.000001 # Query # # use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_utf8mb4'ALTER query started at .+ could not be completed' COLLATE 'utf8mb4_uca1400_ai_ci'))
60 slave-bin.000001 # Query # # COMMIT
61 slave-bin.000001 # Gtid # # GTID #-#-#
62 slave-bin.000001 # Query # # use `test`; create table t3( a int primary key, b int) engine=innodb
63 slave-bin.000001 # Gtid # # GTID #-#-# START ALTER
64 slave-bin.000001 # Query # # use `test`; alter table t3 add column d int
65 slave-bin.000001 # Gtid # # GTID #-#-# START ALTER
66 slave-bin.000001 # Query # # use `test`; alter table t3 add column d int
67 slave-bin.000001 # Gtid # # GTID #-#-# COMMIT ALTER id=#
68 slave-bin.000001 # Query # # use `test`; alter table t3 add column d int
69 show create table t3;
70 Table Create Table
71 t3 CREATE TABLE `t3` (
72 `a` int(11) NOT NULL,
73 `b` int(11) DEFAULT NULL,
74 `d` int(11) DEFAULT NULL,
75 PRIMARY KEY (`a`)
76 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
77 connection master;
78 SET GLOBAL debug_dbug= @old_debug_master;
79 drop table t3;
80 set global binlog_alter_two_phase = 0;
81 connection slave;
82 SET GLOBAL debug_dbug= @old_debug_slave;
83 stop slave;
84 set global slave_parallel_threads = 0;;
85 set global slave_parallel_mode = optimistic;;
86 set global gtid_strict_mode = 0;;
87 start slave;
88 connection master;
89 include/rpl_end.inc