Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 SET @old_debug_slave= @@global.debug_dbug;
5 include/stop_slave.inc
6 SET GLOBAL slave_parallel_threads=4;
7 set global slave_parallel_mode=optimistic;
8 set global gtid_strict_mode=1;
9 set global debug_dbug="+d,rpl_slave_stop_CA_before_binlog";
10 include/start_slave.inc
11 connection master;
12 SET @old_debug_master= @@global.debug_dbug;
13 set global debug_dbug="+d,start_alter_delay_master";
14 set global binlog_alter_two_phase=true;
15 create table t1( a int primary key, b int) engine=myisam;
16 create table t2( a int primary key, b int) engine=myisam;
17 connect con1,localhost,root,,;
18 alter table t1 add column c int;;
19 connection master;
20 # Get into binlog first and wait
21 # master gtid state is 0-1-3
22 connect con2,localhost,root,,;
23 alter table t2 add column c int;;
24 connection master;
25 # Get into binlog next and wait as well
26 # master gtid state is 0-1-4
27 set DEBUG_SYNC= "now signal alter_cont";
28 connection con1;
29 connection con2;
30 create table t3( a int primary key, b int) engine=innodb;
31 # master gtid state is 0-1-7
32 show binlog events from <binlog_start>;
33 Log_name Pos Event_type Server_id End_log_pos Info
34 master-bin.000001 # Gtid_list 1 # []
35 master-bin.000001 # Binlog_checkpoint 1 # master-bin.000001
36 master-bin.000001 # Gtid 1 # GTID #-#-#
37 master-bin.000001 # Query 1 # use `test`; create table t1( a int primary key, b int) engine=myisam
38 master-bin.000001 # Gtid 1 # GTID #-#-#
39 master-bin.000001 # Query 1 # use `test`; create table t2( a int primary key, b int) engine=myisam
40 master-bin.000001 # Gtid 1 # GTID #-#-# START ALTER
41 master-bin.000001 # Query 1 # use `test`; alter table <t> add column c int
42 master-bin.000001 # Gtid 1 # GTID #-#-# START ALTER
43 master-bin.000001 # Query 1 # use `test`; alter table <t> add column c int
44 master-bin.000001 # Gtid 1 # GTID #-#-# COMMIT ALTER id=<seq_no>
45 master-bin.000001 # Query 1 # use `test`; alter table <t> add column c int
46 master-bin.000001 # Gtid 1 # GTID #-#-# COMMIT ALTER id=<seq_no>
47 master-bin.000001 # Query 1 # use `test`; alter table <t> add column c int
48 master-bin.000001 # Gtid 1 # GTID #-#-#
49 master-bin.000001 # Query 1 # use `test`; create table t3( a int primary key, b int) engine=innodb
50 # Stop Slave
51 # As master binlog is SA SA CA CA
52 # let's stop at first CA processing (in process_commit_alter)
53 connection slave;
54 include/sync_with_master_gtid.inc
55 # wait for CA_1 waiting itself
56 connect extra_slave,127.0.0.1,root,,test,$SLAVE_MYPORT;
57 stop slave;;
58 connection slave;
59 connection extra_slave;
60 SET GLOBAL debug_dbug= @old_debug_slave;
61 connection slave;
62 include/wait_for_slave_sql_to_stop.inc
63 # The list of events after the slave has stopped must have just one CA:
64 show binlog events from <binlog_start>;
65 Log_name Pos Event_type Server_id End_log_pos Info
66 slave-bin.000001 # Gtid_list 2 # []
67 slave-bin.000001 # Binlog_checkpoint 2 # slave-bin.000001
68 slave-bin.000001 # Gtid 1 # GTID #-#-#
69 slave-bin.000001 # Query 1 # use `test`; create table t1( a int primary key, b int) engine=myisam
70 slave-bin.000001 # Gtid 1 # GTID #-#-#
71 slave-bin.000001 # Query 1 # use `test`; create table t2( a int primary key, b int) engine=myisam
72 slave-bin.000001 # Gtid 1 # GTID #-#-# START ALTER
73 slave-bin.000001 # Query 1 # use `test`; alter table <t> add column c int
74 slave-bin.000001 # Gtid 1 # GTID #-#-# START ALTER
75 slave-bin.000001 # Query 1 # use `test`; alter table <t> add column c int
76 slave-bin.000001 # Gtid 1 # GTID #-#-# COMMIT ALTER id=<seq_no>
77 slave-bin.000001 # Query 1 # use `test`; alter table <t> add column c int
78 select domain_id, seq_no from mysql.gtid_slave_pos order by seq_no desc limit 1;
79 domain_id seq_no
80 0 5
81 include/start_slave.inc
82 connection master;
83 include/save_master_gtid.inc
84 connection slave;
85 include/sync_with_master_gtid.inc
86 # Everything from the master binlog must have been applied now:
87 select domain_id, seq_no from mysql.gtid_slave_pos order by seq_no desc limit 1;
88 domain_id seq_no
89 0 7
90 # slave gtid state is 0-1-7
91 # The list of events after the slave has synchronized must have both CA:
92 show binlog events from <binlog_start>;
93 Log_name Pos Event_type Server_id End_log_pos Info
94 slave-bin.000001 # Gtid_list 2 # []
95 slave-bin.000001 # Binlog_checkpoint 2 # slave-bin.000001
96 slave-bin.000001 # Gtid 1 # GTID #-#-#
97 slave-bin.000001 # Query 1 # use `test`; create table t1( a int primary key, b int) engine=myisam
98 slave-bin.000001 # Gtid 1 # GTID #-#-#
99 slave-bin.000001 # Query 1 # use `test`; create table t2( a int primary key, b int) engine=myisam
100 slave-bin.000001 # Gtid 1 # GTID #-#-# START ALTER
101 slave-bin.000001 # Query 1 # use `test`; alter table <t> add column c int
102 slave-bin.000001 # Gtid 1 # GTID #-#-# START ALTER
103 slave-bin.000001 # Query 1 # use `test`; alter table <t> add column c int
104 slave-bin.000001 # Gtid 1 # GTID #-#-# COMMIT ALTER id=<seq_no>
105 slave-bin.000001 # Query 1 # use `test`; alter table <t> add column c int
106 slave-bin.000001 # Gtid 1 # GTID #-#-# COMMIT ALTER id=<seq_no>
107 slave-bin.000001 # Query 1 # use `test`; alter table <t> add column c int
108 slave-bin.000001 # Gtid 1 # GTID #-#-#
109 slave-bin.000001 # Query 1 # use `test`; create table t3( a int primary key, b int) engine=innodb
110 connection master;
111 drop table t1,t2,t3;
112 set global binlog_alter_two_phase = 0;
113 SET GLOBAL debug_dbug= @old_debug_master;
114 set DEBUG_SYNC= 'RESET';
115 connection slave;
116 include/stop_slave.inc
117 set global slave_parallel_threads = 0;;
118 set global slave_parallel_mode = optimistic;;
119 set global gtid_strict_mode = 0;;
120 set DEBUG_SYNC= 'RESET';
121 include/start_slave.inc
122 include/rpl_end.inc