Debian Codegraph @

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

raw
1 #
2 # WL#5124
3 # This test verifies if the 'flush individual logs' statement
4 # works fine.
5 #
6
7 --source include/have_binlog_format_statement.inc
8 --source include/master-slave.inc
9 connection master;
10
11 # Test 'flush error logs' statement.
12
13 --echo # Test if support 'flush error logs' statement.
14 flush error logs;
15
16 file_exists $MYSQLTEST_VARDIR/tmp/master_log.err;
17
18 --echo # Make sure binary logs was not be flushed
19 --echo # after execute 'flush error logs' statement.
20 --error 1
21 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000002;
22
23 sync_slave_with_master;
24 --echo # Make sure relay logs was not be flushed
25 --echo # after execute 'flush error logs' statement.
26 --error 1
27 file_exists $MYSQLTEST_VARDIR/mysqld.2/data/slave-relay-bin.000003;
28
29 connection master;
30 --echo # Test if support 'flush relay logs' statement.
31 flush relay logs;
32
33 sync_slave_with_master;
34 --echo # Check the 'slave-relay-bin.000003' file is not created
35 --echo # after executed 'flush relay logs' statement.
36 --error 1
37 file_exists $MYSQLTEST_VARDIR/mysqld.2/data/slave-relay-bin.000003;
38
39 connection master;
40 --echo # Make sure binary logs was not be flushed
41 --echo # after execute 'flush relay logs' statement.
42 --error 1
43 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000002;
44
45
46 # Test 'flush slow logs' statement.
47 --echo # Test if support 'flush slow logs' statement.
48 flush slow logs;
49
50 --echo # Make sure binary logs was not be flushed
51 --echo # after execute 'flush slow logs' statement.
52 --error 1
53 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000002;
54
55
56 # Test 'flush general logs' statement.
57 --echo # Test if support 'flush general logs' statement.
58 flush general logs;
59
60 --echo # Make sure binary logs was not be flushed
61 --echo # after execute 'flush general logs' statement.
62 --error 1
63 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000002;
64
65
66 # Test 'flush engine logs' statement.
67 --echo # Test if support 'flush engine logs' statement.
68 flush engine logs;
69
70 --echo # Make sure binary logs was not be flushed
71 --echo # after execute 'flush engine logs' statement.
72 --error 1
73 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000002;
74
75
76 # Test 'flush binary logs' statement.
77 --echo # Make sure the 'master-bin.000002' file does not
78 --echo # exist before execute 'flush binary logs' statement.
79 --error 1
80 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000002;
81
82 --echo # Test if support 'flush binary logs' statement.
83 flush binary logs;
84
85 --echo # Check the 'master-bin.000002' file is created
86 --echo # after executed 'flush binary logs' statement.
87 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000002;
88 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000001;
89
90
91 # Test 'flush error logs, relay logs' statement
92 sync_slave_with_master;
93 --echo # Make sure the 'slave-relay-bin.000005' file does not exist
94 --echo # exist before execute 'flush error logs, relay logs' statement.
95 --error 1
96 file_exists $MYSQLTEST_VARDIR/mysqld.2/data/slave-relay-bin.000005;
97
98 connection master;
99
100 --echo # Test if support to combine all kinds of logs into one statement.
101 flush error logs, relay logs;
102
103 file_exists $MYSQLTEST_VARDIR/tmp/master_log.err;
104
105 --echo # Make sure binary logs was not be flushed
106 --echo # after execute 'flush error logs, relay logs' statement.
107 --error 1
108 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000003;
109
110 sync_slave_with_master;
111 --echo # Check the 'slave-relay-bin.000004' file is created after
112 --echo # execute 'flush error logs, relay logs' statement.
113 file_exists $MYSQLTEST_VARDIR/mysqld.2/data/slave-relay-bin.000004;
114
115 # Test 'flush logs' statement
116 --echo # Make sure the 'slave-relay-bin.000005' and 'slave-relay-bin.000006'
117 --echo # files do not exist before execute 'flush error logs, relay logs'
118 --echo # statement.
119 --error 1
120 file_exists $MYSQLTEST_VARDIR/mysqld.2/data/slave-relay-bin.000005;
121 --error 1
122 file_exists $MYSQLTEST_VARDIR/mysqld.2/data/slave-relay-bin.000006;
123
124 connection master;
125
126 --echo # Test if 'flush logs' statement works fine and flush all the logs.
127 flush logs;
128
129 file_exists $MYSQLTEST_VARDIR/tmp/master_log.err;
130
131 --echo # Check 'master-bin.000003' is created
132 --echo # after execute 'flush logs' statement.
133 file_exists $MYSQLTEST_VARDIR/mysqld.1/data/master-bin.000003;
134
135 sync_slave_with_master;
136 --echo # Check the 'slave-relay-bin.000005' and 'slave-relay-bin.000006'
137 --echo # files are created after execute 'flush logs' statement.
138 file_exists $MYSQLTEST_VARDIR/mysqld.2/data/slave-relay-bin.000005;
139 file_exists $MYSQLTEST_VARDIR/mysqld.2/data/slave-relay-bin.000006;
140
141 --source include/rpl_end.inc