Debian Codegraph @

mysql-test/suite/rpl/t/rpl_start_alter_restart_master.test

raw
1 # Test crashing of master after writing start alter into binary log.
2 # And the doing the same alter again, to test on slave if that is successful
3 # ====> SA Crash SA CA Case
4 #
5 --source include/have_log_bin.inc
6 --source include/have_binlog_format_mixed.inc
7 --source include/have_innodb.inc
8 --source include/master-slave.inc
9 --source include/have_debug.inc
10 --source include/no_valgrind_without_big.inc
11
12 --connection slave
13 --source include/stop_slave.inc
14 CHANGE MASTER TO MASTER_USE_GTID=NO;
15 --source include/start_slave.inc
16
17 --connection slave
18 SET @old_debug_slave= @@global.debug_dbug;
19 stop slave;
20 --let $gtid_strict_mode= `select @@gtid_strict_mode`
21 --let $slave_parallel_threads= `select @@slave_parallel_threads`
22 --let $slave_parallel_mode= `select @@slave_parallel_mode`
23 SET GLOBAL slave_parallel_threads=4;
24 set global slave_parallel_mode=optimistic;
25 set global gtid_strict_mode=1;
26 start slave;
27
28 --connection master
29 call mtr.add_suppression("ALTER query started at .+ could not be completed");
30
31 SET @old_debug_master= @@global.debug_dbug;
32 --let $binlog_alter_two_phase= `select @@binlog_alter_two_phase`
33 set binlog_alter_two_phase=true;
34 create table t3( a int primary key, b int) engine=innodb;
35
36 --connection master
37 --sync_slave_with_master
38 --source include/stop_slave.inc
39
40
41 --connection master
42 --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
43 SET SESSION debug_dbug="d,start_alter_kill_after_binlog";
44 --error 2013
45 alter table t3 add column d int;
46
47 --let $rpl_server_number= 1
48 --source include/rpl_reconnect.inc
49 set binlog_alter_two_phase= true;
50 alter table t3 add column d int;
51 show create table t3;
52 --source include/show_binlog_events.inc
53 --let $binlog_file=master-bin.000002
54 --source include/show_binlog_events.inc
55 --let $binlog_file=
56
57 --connection slave
58 --source include/start_slave.inc
59
60 --connection master
61 --sync_slave_with_master
62 --source include/show_binlog_events.inc
63 show create table t3;
64
65
66 --connection master
67 SET GLOBAL debug_dbug= @old_debug_master;
68 drop table t3;
69 --eval set global binlog_alter_two_phase = $binlog_alter_two_phase
70
71 --sync_slave_with_master
72 SET GLOBAL debug_dbug= @old_debug_slave;
73 stop slave;
74 --eval set global slave_parallel_threads = $slave_parallel_threads;
75 --eval set global slave_parallel_mode = $slave_parallel_mode;
76 --eval set global gtid_strict_mode = $gtid_strict_mode;
77 start slave;
78 --connection master
79 let MYSQLD_DATADIR= `select @@datadir;`;
80 --remove_files_wildcard $MYSQLD_DATADIR/test #sql*.frm
81 --source include/rpl_end.inc