Debian Codegraph @

mysql-test/suite/binlog_encryption/binlog_index.result

raw
1 call mtr.add_suppression('Attempting backtrace');
2 call mtr.add_suppression('MYSQL_BIN_LOG::purge_logs failed to process registered files that would be purged.');
3 call mtr.add_suppression('MYSQL_BIN_LOG::open failed to sync the index file');
4 call mtr.add_suppression('Turning logging off for the whole duration of the MariaDB server process.');
5 call mtr.add_suppression('Could not use .*');
6 call mtr.add_suppression('MYSQL_BIN_LOG::purge_logs failed to clean registers before purging logs.');
7 flush tables;
8 SET @saved_dbug = @@SESSION.debug_dbug;
9 RESET MASTER;
10 flush logs;
11 flush logs;
12 flush logs;
13 show binary logs;
14 Log_name File_size
15 master-bin.000001 #
16 master-bin.000002 #
17 master-bin.000003 #
18 master-bin.000004 #
19 flush tables;
20 purge binary logs TO 'master-bin.000004';
21 Warnings:
22 Warning 1612 Being purged log master-bin.000001 was not found
23 *** must show a list starting from the 'TO' argument of PURGE ***
24 show binary logs;
25 Log_name File_size
26 master-bin.000004 #
27 reset master;
28 flush logs;
29 flush logs;
30 flush logs;
31 *** must be a warning master-bin.000001 was not found ***
32 Warnings:
33 Note 1375 Binary log 'master-bin.000004' is not purged because it is the current active binlog
34 Warning 1612 Being purged log master-bin.000001 was not found
35 *** must show one record, of the active binlog, left in the index file after PURGE ***
36 show binary logs;
37 Log_name File_size
38 master-bin.000004 #
39 reset master;
40 flush logs;
41 flush logs;
42 flush logs;
43 purge binary logs TO 'master-bin.000002';
44 ERROR HY000: Fatal error during log purge
45 show warnings;
46 Level Code Message
47 Warning 1377 a problem with deleting master-bin.000001; consider examining correspondence of your binlog index file to the actual binlog files
48 Error 1377 Fatal error during log purge
49 reset master;
50 # crash_purge_before_update_index
51 flush logs;
52 SET SESSION debug_dbug="+d,crash_purge_before_update_index";
53 purge binary logs TO 'master-bin.000002';
54 ERROR HY000: Lost connection to server during query
55 SET @index=LOAD_FILE('MYSQLTEST_VARDIR/mysqld.1/data//master-bin.index');
56 SELECT @index;
57 @index
58 master-bin.000001
59 master-bin.000002
60 master-bin.000003
61
62 # crash_purge_non_critical_after_update_index
63 flush logs;
64 SET SESSION debug_dbug="+d,crash_purge_non_critical_after_update_index";
65 purge binary logs TO 'master-bin.000004';
66 ERROR HY000: Lost connection to server during query
67 SET @index=LOAD_FILE('MYSQLTEST_VARDIR/mysqld.1/data//master-bin.index');
68 SELECT @index;
69 @index
70 master-bin.000004
71 master-bin.000005
72
73 # crash_purge_critical_after_update_index
74 flush logs;
75 SET SESSION debug_dbug="+d,crash_purge_critical_after_update_index";
76 purge binary logs TO 'master-bin.000006';
77 ERROR HY000: Lost connection to server during query
78 SET @index=LOAD_FILE('MYSQLTEST_VARDIR/mysqld.1/data//master-bin.index');
79 SELECT @index;
80 @index
81 master-bin.000006
82 master-bin.000007
83
84 # crash_create_non_critical_before_update_index
85 SET SESSION debug_dbug="+d,crash_create_non_critical_before_update_index";
86 flush logs;
87 ERROR HY000: Lost connection to server during query
88 SET @index=LOAD_FILE('MYSQLTEST_VARDIR/mysqld.1/data//master-bin.index');
89 SELECT @index;
90 @index
91 master-bin.000006
92 master-bin.000007
93 master-bin.000008
94
95 # crash_create_critical_before_update_index
96 SET SESSION debug_dbug="+d,crash_create_critical_before_update_index";
97 flush logs;
98 ERROR HY000: Lost connection to server during query
99 SET @index=LOAD_FILE('MYSQLTEST_VARDIR/mysqld.1/data//master-bin.index');
100 SELECT @index;
101 @index
102 master-bin.000006
103 master-bin.000007
104 master-bin.000008
105 master-bin.000009
106
107 # crash_create_after_update_index
108 SET SESSION debug_dbug="+d,crash_create_after_update_index";
109 flush logs;
110 ERROR HY000: Lost connection to server during query
111 SET @index=LOAD_FILE('MYSQLTEST_VARDIR/mysqld.1/data//master-bin.index');
112 SELECT @index;
113 @index
114 master-bin.000006
115 master-bin.000007
116 master-bin.000008
117 master-bin.000009
118 master-bin.000010
119 master-bin.000011
120
121 #
122 # This should put the server in unsafe state and stop
123 # accepting any command. If we inject a fault at this
124 # point and continue the execution the server crashes.
125 #
126 SET @index=LOAD_FILE('MYSQLTEST_VARDIR/mysqld.1/data//master-bin.index');
127 SELECT @index;
128 @index
129 master-bin.000006
130 master-bin.000007
131 master-bin.000008
132 master-bin.000009
133 master-bin.000010
134 master-bin.000011
135
136 # fault_injection_registering_index
137 SET SESSION debug_dbug="+d,fault_injection_registering_index";
138 flush logs;
139 ERROR HY000: Can't open file: 'master-bin.000012' (errno: 1 "Operation not permitted")
140 SET @index=LOAD_FILE('MYSQLTEST_VARDIR/mysqld.1/data//master-bin.index');
141 SELECT @index;
142 @index
143 master-bin.000006
144 master-bin.000007
145 master-bin.000008
146 master-bin.000009
147 master-bin.000010
148 master-bin.000011
149
150 # restart
151 SET @index=LOAD_FILE('MYSQLTEST_VARDIR/mysqld.1/data//master-bin.index');
152 SELECT @index;
153 @index
154 master-bin.000006
155 master-bin.000007
156 master-bin.000008
157 master-bin.000009
158 master-bin.000010
159 master-bin.000011
160 master-bin.000012
161
162 # fault_injection_updating_index
163 SET SESSION debug_dbug="+d,fault_injection_updating_index";
164 flush logs;
165 ERROR HY000: Can't open file: 'master-bin.000013' (errno: 1 "Operation not permitted")
166 SET @index=LOAD_FILE('MYSQLTEST_VARDIR/mysqld.1/data//master-bin.index');
167 SELECT @index;
168 @index
169 master-bin.000006
170 master-bin.000007
171 master-bin.000008
172 master-bin.000009
173 master-bin.000010
174 master-bin.000011
175 master-bin.000012
176
177 # restart
178 SET @index=LOAD_FILE('MYSQLTEST_VARDIR/mysqld.1/data//master-bin.index');
179 SELECT @index;
180 @index
181 master-bin.000006
182 master-bin.000007
183 master-bin.000008
184 master-bin.000009
185 master-bin.000010
186 master-bin.000011
187 master-bin.000012
188 master-bin.000013
189
190 SET @@SESSION.debug_dbug = @saved_dbug;
191 End of tests