Debian Codegraph @

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

raw
1 #
2 # WL#5142
3 # This test verifies if the 'flush individual logs' statement
4 # works fine.
5 #
6
7 # "Flush" commands are logged as rotate events in the binary
8 # log without gtid events. So it is correct to check master
9 # and slave sync logic with positions instead gtids numbers.
10 # Hence for this test script, making use_gtids to false
11 # in all the cases (GTID_MODE ON or OFF).
12 --let $use_gtids=0
13
14 --source include/master-slave.inc
15 --source include/have_binlog_format_statement.inc
16 connection master;
17
18 # Test 'flush error logs' statement.
19
20 --echo # Test if support 'flush error logs' statement.
21 flush error logs;
22
23 file_exists $MYSQLTEST_VARDIR/tmp/master_log.err;
24
25 --echo # Make sure binary logs was not be flushed
26 --echo # after execute 'flush error logs' statement.
27 --error 1
28 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000002;
29
30 --source include/sync_slave_sql_with_master.inc
31 --echo # Make sure relay logs was not be flushed
32 --echo # after execute 'flush error logs' statement.
33 --error 1
34 file_exists $MYSQLTEST_VARDIR/mysqld.2/data/slave-relay-bin.000003;
35
36 connection master;
37 --echo # Test if support 'flush relay logs' statement.
38 flush relay logs;
39
40 --source include/sync_slave_sql_with_master.inc
41 --echo # Check the 'slave-relay-bin.000003' file is created
42 --echo # after executed 'flush relay logs' statement.
43 file_exists $MYSQLTEST_VARDIR/mysqld.2/data/slave-relay-bin.000003;
44
45 connection master;
46 --echo # Make sure binary logs was not be flushed
47 --echo # after execute 'flush relay logs' statement.
48 --error 1
49 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000002;
50
51
52 # Test 'flush slow logs' statement.
53 --echo # Test if support 'flush slow logs' statement.
54 flush slow logs;
55
56 --echo # Make sure binary logs was not be flushed
57 --echo # after execute 'flush slow logs' statement.
58 --error 1
59 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000002;
60
61
62 # Test 'flush general logs' statement.
63 --echo # Test if support 'flush general logs' statement.
64 flush general logs;
65
66 --echo # Make sure binary logs was not be flushed
67 --echo # after execute 'flush general logs' statement.
68 --error 1
69 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000002;
70
71
72 # Test 'flush engine logs' statement.
73 --echo # Test if support 'flush engine logs' statement.
74 flush engine logs;
75
76 --echo # Make sure binary logs was not be flushed
77 --echo # after execute 'flush engine logs' statement.
78 --error 1
79 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000002;
80
81
82 # Test 'flush binary logs' statement.
83 --echo # Make sure the 'master-bin.000002' file does not
84 --echo # exist before execute 'flush binary logs' statement.
85 --error 1
86 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000002;
87
88 --echo # Test if support 'flush binary logs' statement.
89 flush binary logs;
90
91 --echo # Check the 'master-bin.000002' file is created
92 --echo # after executed 'flush binary logs' statement.
93 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000002;
94 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000001;
95
96
97 # Test 'flush error logs, relay logs' statement
98 --source include/sync_slave_sql_with_master.inc
99 --echo # Make sure the 'slave-relay-bin.000006' file does not exist
100 --echo # exist before execute 'flush error logs, relay logs' statement.
101 --error 1
102 file_exists $MYSQLTEST_VARDIR/mysqld.2/data/slave-relay-bin.000006;
103
104 connection master;
105
106 --echo # Test if support to combine all kinds of logs into one statement.
107 flush error logs, relay logs;
108
109 file_exists $MYSQLTEST_VARDIR/tmp/master_log.err;
110
111 --echo # Make sure binary logs was not be flushed
112 --echo # after execute 'flush error logs, relay logs' statement.
113 --error 1
114 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000003;
115
116 --source include/sync_slave_sql_with_master.inc
117 --echo # Check the 'slave-relay-bin.000006' file is created after
118 --echo # execute 'flush error logs, relay logs' statement.
119 file_exists $MYSQLTEST_VARDIR/mysqld.2/data/slave-relay-bin.000006;
120
121
122 # Test 'flush logs' statement
123 --echo # Make sure the 'slave-relay-bin.000007' and 'slave-relay-bin.000008'
124 --echo # files do not exist before execute 'flush error logs, relay logs'
125 --echo # statement.
126 --error 1
127 file_exists $MYSQLTEST_VARDIR/mysqld.2/data/slave-relay-bin.000007;
128 --error 1
129 file_exists $MYSQLTEST_VARDIR/mysqld.2/data/slave-relay-bin.000008;
130
131 --source include/stop_slave_sql.inc
132
133 connection master;
134
135 --echo # Test if 'flush logs' statement works fine and flush all the logs.
136 flush logs;
137
138 file_exists $MYSQLTEST_VARDIR/tmp/master_log.err;
139
140 --echo # Check 'master-bin.000003' is created
141 --echo # after execute 'flush logs' statement.
142 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000003;
143
144 --source include/sync_slave_io_with_master.inc
145 --echo # Check the 'slave-relay-bin.000007' and 'slave-relay-bin.000008'
146 --echo # files are created after execute 'flush logs' statement.
147 file_exists $MYSQLTEST_VARDIR/mysqld.2/data/slave-relay-bin.000007;
148 file_exists $MYSQLTEST_VARDIR/mysqld.2/data/slave-relay-bin.000008;
149
150 #
151 # Bug #24786290: REPLICATION BREAKS AFTER BUG #74145 HAPPENS IN MASTER
152 #
153 # === Purpose ===
154 #
155 # This test verifies that failed FLUSH <individual> LOGS statements
156 # are not written to binary log.
157
158 --connection master
159 --let $binlog_file= query_get_value(SHOW MASTER STATUS,File,1)
160 --let $binlog_start= query_get_value(SHOW MASTER STATUS,Position,1)
161 --let $master_pos_before_flush_logs= $binlog_start
162
163 # Make FLUSH <individual> LOGS fail by changing
164 # the permissions of the slow log and general log.
165 --let $slow_log= `SELECT @@global.slow_query_log_file`
166 --chmod 0000 $slow_log
167 --replace_regex /.*File .* not found .*/File not found (Errcode: ##)/
168 --error 29
169 FLUSH SLOW LOGS;
170
171 --let $general_log= `SELECT @@global.general_log_file`
172 --chmod 0000 $general_log
173 --replace_regex /.*File .* not found .*/File not found (Errcode: ##)/
174 --error 29
175 FLUSH GENERAL LOGS;
176
177 # Assert that the above statements are not written to the binlog.
178 --let $master_pos_after_flush_logs= query_get_value(SHOW MASTER STATUS,Position,1)
179 --let $assert_text= assert that the above events are not written to binlog
180 --let $assert_cond= $master_pos_before_flush_logs = $master_pos_after_flush_logs
181 --source include/assert.inc
182 --source include/show_binlog_events.inc
183
184 # Restore permissions
185 --chmod 0644 $slow_log
186 --chmod 0644 $general_log
187
188 --source include/sync_slave_io_with_master.inc
189 --source include/start_slave_sql.inc
190 --source include/rpl_end.inc