Debian Codegraph @

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

raw
1 #
2 # Statement specific tests for master_last_event_time
3 #
4 --source include/have_binlog_format_statement.inc
5 --source include/have_innodb.inc
6 --let $rpl_topology=1->2->3
7 --source include/rpl_init.inc
8
9 # Server_3 state is maintained by master_last_event_time.inc
10 --connection server_3
11 --source include/stop_slave.inc
12
13 --connection server_1
14 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
15 alter table mysql.gtid_slave_pos engine=innodb;
16 create table t1 (a int) engine=aria;
17 create table t2 (a int) engine=innodb;
18 --source include/save_master_gtid.inc
19
20 --echo # Sleep 1 to ensure setup DDL and test statements have different binlog timestamps
21 --sleep 1
22
23 --connection server_2
24 set @old_par_thds= @@global.slave_parallel_threads;
25
26
27 --echo #
28 --echo # Ensure that the slave doesn't overwrite exec_time when binlogging
29 --echo #
30
31 --let $slave_delay= 3
32
33 --connection server_2
34 --source include/sync_with_master_gtid.inc
35 --source include/stop_slave.inc
36 --replace_result $slave_delay SLAVE_DELAY
37 --eval change master to master_delay=$slave_delay
38 --source include/start_slave.inc
39
40 --let $serial_slave_const=2
41 --let $parallel_slave_const=1
42 --let $mode_ctr= 2
43 while ($mode_ctr)
44 {
45 --connection server_2
46 --source include/stop_slave.inc
47 if ($mode_ctr == $parallel_slave_const)
48 {
49 --let $mode_name= parallel
50 set @@global.slave_parallel_threads= 1;
51 }
52 if ($mode_ctr == $serial_slave_const)
53 {
54 --let $mode_name= serial
55 set @@global.slave_parallel_threads= 0;
56 }
57 --source include/start_slave.inc
58
59 --connection server_2
60 flush logs;
61 --connection server_1
62 --disable_warnings
63 --echo # Only sleep on master so the real execution time on the slave is less
64 insert into t1 values (sleep(if(@@global.server_id=1, 2, 0)));
65 --source include/save_master_gtid.inc
66 --enable_warnings
67
68 --echo # Waiting for slave to delay and commit transaction..
69 --connection server_2
70 --source include/sync_with_master_gtid.inc
71
72 --let $datadir= `select @@datadir`
73 --let $filename= query_get_value(SHOW MASTER STATUS, File, 1)
74 --let $slave_local_binlog=$datadir/$filename
75 --let $slave_outfile=$MYSQLTEST_VARDIR/tmp/slave_binlog.sql
76 --echo # MYSQL_BINLOG slave_local_binlog > slave_outfile
77 --exec $MYSQL_BINLOG $slave_local_binlog > $slave_outfile
78 --let $assert_count=0
79 --let $assert_text= Ensure $mode_name slave doesn't overwrite exec_time in the binlog event (0s)
80 --let $assert_select=exec_time=0
81 --let $assert_file= $slave_outfile
82 --source include/assert_grep.inc
83
84 # Double-check in the unlikely case execution time could be rounded to 1
85 --let $assert_text= Ensure $mode_name slave doesn't overwrite exec_time in the binlog event (1s)
86 --let $assert_select=exec_time=1
87 --let $assert_file= $slave_outfile
88 --source include/assert_grep.inc
89
90 --source master_last_event_time.inc
91
92 --connection server_2
93 --source include/stop_slave.inc
94 set @@global.slave_parallel_threads= @old_par_thds;
95 --source include/start_slave.inc
96
97 --dec $mode_ctr
98 }
99
100 --echo #
101 --echo # Cleanup
102
103 --connection server_2
104 --source include/stop_slave.inc
105 change master to master_delay=0;
106 --source include/start_slave.inc
107 --connection server_3
108 --source include/start_slave.inc
109
110 --connection server_1
111 drop table t1;
112 drop table t2;
113
114 --source include/rpl_end.inc
115 --remove_file $slave_outfile
116 --echo # End of master_last_event_time_stmt