Debian Codegraph @

mysql-test/suite/group_replication/r/gr_flush_logs.result

raw
1 include/group_replication.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6 [connection server1]
7 CREATE TABLE t1 (i INT PRIMARY KEY) engine= innodb;
8 include/rpl_sync.inc
9 [connection server1]
10 # Test if support 'flush error logs' statement.
11 flush error logs;
12 # Make sure binary logs was not flushed after execute 'flush error logs' statement.
13 # Make sure applier logs was not flushed after execute 'flush error logs' statement.
14 # Make sure recovery logs was not flushed after execute 'flush error logs' statement.
15 include/assert.inc [Binary log WAS NOT flushed nor rotated]
16 include/assert.inc [Applier relay log WAS NOT flushed nor rotated]
17 include/assert.inc [Recovery relay log WAS NOT flushed nor rotated]
18 include/rpl_sync.inc
19 [connection server2]
20 # Make sure recovery logs was not flushed after execute 'flush error logs' statement.
21 # Make sure applier logs was not flushed after execute 'flush error logs' statement.
22 # Make sure binary logs was not flushed after execute 'flush error logs' statement.
23 include/assert.inc [Binary log WAS NOT flushed nor rotated]
24 include/assert.inc [Applier relay log WAS NOT flushed nor rotated]
25 include/assert.inc [Recovery relay log WAS NOT flushed nor rotated]
26 include/rpl_sync.inc
27 [connection server1]
28 INSERT INTO t1 VALUES(1);
29 include/rpl_sync.inc
30 INSERT INTO t1 VALUES(2);
31 include/rpl_sync.inc
32 [connection server1]
33 include/diff_tables.inc [server1:t1, server2:t1]
34 [connection server1]
35 # Test if support 'flush local relay logs' statement.
36 flush local relay logs;
37 # Make sure binary logs was not flushed after execute 'flush local relay logs' statement.
38 # Make sure applier logs was flushed after execute 'flush local relay logs' statement.
39 # Make sure recovery logs was flushed after execute 'flush local relay logs' statement.
40 include/assert.inc [Binary log WAS NOT flushed nor rotated]
41 include/assert.inc [Applier relay log WAS flushed and rotated]
42 include/assert.inc [Recovery relay log WAS flushed and rotated]
43 include/rpl_sync.inc
44 [connection server2]
45 # Make sure recovery logs was not flushed after execute 'flush local relay logs' statement.
46 # Make sure applier logs was flushed after execute 'flush local relay logs' statement.
47 # Make sure binary logs was not flushed after execute 'flush local relay logs' statement.
48 include/assert.inc [Binary log WAS NOT flushed nor rotated]
49 include/assert.inc [Applier relay log WAS NOT flushed nor rotated]
50 include/assert.inc [Recovery relay log WAS NOT flushed nor rotated]
51 [connection server1]
52 INSERT INTO t1 VALUES(3);
53 include/rpl_sync.inc
54 INSERT INTO t1 VALUES(4);
55 include/rpl_sync.inc
56 [connection server1]
57 include/diff_tables.inc [server1:t1, server2:t1]
58 # Test if support 'flush slow logs' statement.
59 flush slow logs;
60 # Make sure binary logs was not flushed after execute 'flush slow logs' statement.
61 # Make sure applier logs was not flushed after execute 'flush slow logs' statement.
62 # Make sure recovery logs was not flushed after execute 'flush slow logs' statement.
63 include/assert.inc [Binary log WAS NOT flushed nor rotated]
64 include/assert.inc [Applier relay log WAS NOT flushed nor rotated]
65 include/assert.inc [Recovery relay log WAS NOT flushed nor rotated]
66 include/rpl_sync.inc
67 [connection server2]
68 # Make sure recovery logs was not flushed after execute 'flush slow logs' statement.
69 # Make sure applier logs was not flushed after execute 'flush slow logs' statement.
70 # Make sure binary logs was not flushed after execute 'flush slow logs' statement.
71 include/assert.inc [Binary log WAS NOT flushed nor rotated]
72 include/assert.inc [Applier relay log WAS NOT flushed nor rotated]
73 include/assert.inc [Recovery relay log WAS NOT flushed nor rotated]
74 include/rpl_sync.inc
75 [connection server1]
76 INSERT INTO t1 VALUES(5);
77 include/rpl_sync.inc
78 INSERT INTO t1 VALUES(6);
79 include/rpl_sync.inc
80 [connection server1]
81 include/diff_tables.inc [server1:t1, server2:t1]
82 [connection server1]
83 # Test if support 'flush general logs' statement.
84 flush general logs;
85 # Make sure binary logs was not flushed after execute 'flush general logs' statement.
86 # Make sure applier logs was not flushed after execute 'flush general logs' statement.
87 # Make sure recovery logs was not flushed after execute 'flush general logs' statement.
88 include/assert.inc [Binary log WAS NOT flushed nor rotated]
89 include/assert.inc [Applier relay log WAS NOT flushed nor rotated]
90 include/assert.inc [Recovery relay log WAS NOT flushed nor rotated]
91 include/rpl_sync.inc
92 [connection server2]
93 # Make sure recovery logs was not flushed after execute 'flush general logs' statement.
94 # Make sure applier logs was not flushed after execute 'flush general logs' statement.
95 # Make sure binary logs was not flushed after execute 'flush general logs' statement.
96 include/assert.inc [Binary log WAS NOT flushed nor rotated]
97 include/assert.inc [Applier relay log WAS NOT flushed nor rotated]
98 include/assert.inc [Recovery relay log WAS NOT flushed nor rotated]
99 [connection server1]
100 INSERT INTO t1 VALUES(7);
101 include/rpl_sync.inc
102 INSERT INTO t1 VALUES(8);
103 include/rpl_sync.inc
104 [connection server1]
105 include/diff_tables.inc [server1:t1, server2:t1]
106 # Test if support 'flush engine logs' statement.
107 flush engine logs;
108 # Make sure binary logs was not flushed after execute 'flush engine logs' statement.
109 # Make sure applier logs was not flushed after execute 'flush engine logs' statement.
110 # Make sure recovery logs was not flushed after execute 'flush engine logs' statement.
111 include/assert.inc [Binary log WAS NOT flushed nor rotated]
112 include/assert.inc [Applier relay log WAS NOT flushed nor rotated]
113 include/assert.inc [Recovery relay log WAS NOT flushed nor rotated]
114 include/rpl_sync.inc
115 [connection server2]
116 # Make sure recovery logs was not flushed after execute 'flush engine logs' statement.
117 # Make sure applier logs was not flushed after execute 'flush engine logs' statement.
118 # Make sure binary logs was not flushed after execute 'flush engine logs' statement.
119 include/assert.inc [Binary log WAS NOT flushed nor rotated]
120 include/assert.inc [Applier relay log WAS NOT flushed nor rotated]
121 include/assert.inc [Recovery relay log WAS NOT flushed nor rotated]
122 [connection server1]
123 INSERT INTO t1 VALUES(9);
124 include/rpl_sync.inc
125 INSERT INTO t1 VALUES(10);
126 include/rpl_sync.inc
127 [connection server1]
128 include/diff_tables.inc [server1:t1, server2:t1]
129 [connection server1]
130 # Test if support 'flush binary logs' statement.
131 flush binary logs;
132 # Make sure binary logs is flushed after execute 'flush binary logs' statement.
133 # Make sure applier logs was not flushed after execute 'flush binary logs' statement.
134 # Make sure recovery logs was not flushed after execute 'flush binary logs' statement.
135 include/assert.inc [Binary log WAS flushed and rotated]
136 include/assert.inc [Applier relay log WAS NOT flushed nor rotated]
137 include/assert.inc [Recovery relay log WAS NOT flushed nor rotated]
138 # Test if it supports 'show binary logs' statement and verify that it shows the correct data
139 include/assert.inc [assert that the first binary log name is server-binary-log.000001]
140 include/assert.inc [assert that the second binary log name is server-binary-log.000002]
141 include/rpl_sync.inc
142 [connection server2]
143 # Make sure recovery logs was not flushed after execute 'flush binary logs' statement.
144 # Make sure applier logs was not flushed after execute 'flush binary logs' statement.
145 # Make sure binary logs was not flushed after execute 'flush binary logs' statement.
146 include/assert.inc [Binary log WAS NOT flushed nor rotated]
147 include/assert.inc [Applier relay log WAS NOT flushed nor rotated]
148 include/assert.inc [Recovery relay log WAS NOT flushed nor rotated]
149 [connection server1]
150 INSERT INTO t1 VALUES(11);
151 include/rpl_sync.inc
152 INSERT INTO t1 VALUES(12);
153 include/rpl_sync.inc
154 [connection server1]
155 include/diff_tables.inc [server1:t1, server2:t1]
156 [connection server1]
157 # Test if support to combine all kinds of logs into one statement.
158 flush local error logs, relay logs;
159 # Make sure binary logs was not flushed after execute 'flush local error logs, relay logs' statement.
160 # Make sure applier logs was flushed after execute 'flush local error logs, relay logs' statement.
161 # Make sure recovery logs was flushed after execute 'flush local error logs, relay logs' statement.
162 include/assert.inc [Binary log WAS NOT flushed nor rotated]
163 include/assert.inc [Applier relay log WAS flushed and rotated]
164 include/assert.inc [Recovery relay log WAS flushed and rotated]
165 include/rpl_sync.inc
166 [connection server2]
167 # Make sure recovery logs was not flushed after execute 'flush local error logs, relay logs' statement.
168 # Make sure applier logs was flushed after execute 'flush local error logs, relay logs' statement.
169 # Make sure binary logs was not flushed after execute 'flush local error logs, relay logs' statement.
170 include/assert.inc [Binary log WAS NOT flushed nor rotated]
171 include/assert.inc [Applier relay log WAS NOT flushed nor rotated]
172 include/assert.inc [Recovery relay log WAS NOT flushed nor rotated]
173 include/rpl_sync.inc
174 [connection server1]
175 INSERT INTO t1 VALUES(13);
176 include/rpl_sync.inc
177 INSERT INTO t1 VALUES(14);
178 include/rpl_sync.inc
179 [connection server1]
180 include/diff_tables.inc [server1:t1, server2:t1]
181 [connection server2]
182 [connection server1]
183 # Test if 'flush logs' statement works fine and flush all the logs.
184 flush logs;
185 # Check 'server1-bin.000003' is created after execute 'flush logs' statement.
186 # Make sure applier logs was flushed after execute 'flush logs' statement.
187 # Make sure recovery logs was flushed after execute 'flush logs' statement.
188 include/assert.inc [Binary log WAS flushed and rotated]
189 include/assert.inc [Applier relay log WAS flushed and rotated]
190 include/assert.inc [Recovery relay log WAS flushed and rotated]
191 include/rpl_sync.inc
192 [connection server2]
193 # Make sure recovery logs was not flushed after execute 'flush logs' statement.
194 # Make sure applier logs was not flushed after execute 'flush logs' statement.
195 # Make sure binary logs was not flushed after execute 'flush logs' statement.
196 include/assert.inc [Binary log WAS NOT flushed nor rotated]
197 include/assert.inc [Applier relay log WAS NOT flushed nor rotated]
198 include/assert.inc [Recovery relay log WAS NOT flushed nor rotated]
199 # Checking the "flush logs" behavior executed from the server2 side
200 [connection server2]
201 flush logs;
202 # Check 'server2-bin.000002' is created after execute 'flush logs' statement.
203 # Make sure applier logs was flushed after execute 'flush logs' statement.
204 # Make sure recovery logs was flushed after execute 'flush logs' statement.
205 include/assert.inc [Binary log WAS flushed and rotated]
206 include/assert.inc [Applier relay log WAS flushed and rotated]
207 include/assert.inc [Recovery relay log WAS flushed and rotated]
208 include/rpl_sync.inc
209 [connection server1]
210 # Make sure recovery logs was not flushed after execute 'flush logs' statement.
211 # Make sure applier logs was not flushed after execute 'flush logs' statement.
212 # Make sure binary logs was not flushed after execute 'flush logs' statement.
213 include/assert.inc [Binary log WAS NOT flushed nor rotated]
214 include/assert.inc [Applier relay log WAS NOT flushed nor rotated]
215 include/assert.inc [Recovery relay log WAS NOT flushed nor rotated]
216 [connection server1]
217 INSERT INTO t1 VALUES(15);
218 include/rpl_sync.inc
219 INSERT INTO t1 VALUES(16);
220 include/rpl_sync.inc
221 include/diff_tables.inc [server1:t1, server2:t1]
222 [connection server1]
223 DROP TABLE t1;
224 include/group_replication_end.inc