Debian Codegraph @

mysql-test/suite/binlog/r/binlog_error_action.result

raw
1 call mtr.add_suppression("MYSQL_BIN_LOG::add_log_to_index failed to copy index file to crash safe index file.");
2 call mtr.add_suppression("Disk is full writing *");
3 call mtr.add_suppression("Retry in 60 secs. *");
4 call mtr.add_suppression("Error writing file*");
5 call mtr.add_suppression("Could not open .*");
6 call mtr.add_suppression("Could not use .*");
7 call mtr.add_suppression("The server was unable to create a new log file *");
8 call mtr.add_suppression("An error occurred during flush stage of the commit");
9 call mtr.add_suppression("An error occurred during sync stage of the commit");
10 call mtr.add_suppression("Either disk is full or file system is read only");
11 call mtr.add_suppression("Can't open file:*");
12 call mtr.add_suppression("Can't generate a unique log-filename*");
13 call mtr.add_suppression("Attempting backtrace. You can use the following information to find out");
14 RESET MASTER;
15 Test case1
16 SET GLOBAL binlog_error_action= ABORT_SERVER;
17 flush logs;
18 ERROR HY000: Binary logging not possible. Message: Can't open file: 'binlog.index' (errno: 1 - Operation not permitted), while rotating the binlog. Aborting the server
19 Test case2
20 SET SESSION debug="+d,fault_injection_updating_index";
21 SET GLOBAL binlog_error_action= ABORT_SERVER;
22 flush logs;
23 ERROR HY000: Binary logging not possible. Message: Either disk is full, file system is read only or there was an encryption error while opening the binlog. Aborting the server.
24 Test case3
25 SET SESSION debug="+d,simulate_disk_full_on_open_binlog";
26 SET GLOBAL binlog_error_action= ABORT_SERVER;
27 flush logs;
28 ERROR HY000: Binary logging not possible. Message: Either disk is full, file system is read only or there was an encryption error while opening the binlog. Aborting the server.
29 Test case4
30 SET SESSION debug="+d,fault_injection_init_name";
31 SET GLOBAL binlog_error_action= ABORT_SERVER;
32 flush logs;
33 ERROR HY000: Binary logging not possible. Message: Either disk is full, file system is read only or there was an encryption error while opening the binlog. Aborting the server.
34 Test case5
35 SET GLOBAL binlog_error_action= IGNORE_ERROR;
36 flush logs;
37 ERROR HY000: File 'binlog.index' not found (OS errno 13 - Permission denied)
38 CREATE TABLE t1 ( f int );
39 SHOW TABLES;
40 Tables_in_test
41 t1
42 DROP TABLE t1;
43 # restart
44 Test case6
45 SET SESSION debug="+d,fault_injection_updating_index";
46 SET GLOBAL binlog_error_action= IGNORE_ERROR;
47 flush logs;
48 ERROR HY000: Can't open file: 'binlog.000007' (errno: 1 - Operation not permitted)
49 CREATE TABLE t2 (f int );
50 SHOW TABLES;
51 Tables_in_test
52 t2
53 DROP TABLE t2;
54 SET SESSION debug="-d,fault_injection_updating_index";
55 # restart
56 Test case7
57 SET GLOBAL binlog_error_action= IGNORE_ERROR;
58 SET SESSION debug="+d,simulate_disk_full_on_open_binlog";
59 flush logs;
60 ERROR HY000: Error writing file 'binlog.index_crash_safe' (OS errno 28 - No space left on device)
61 SET SESSION debug="-d,simulate_disk_full_on_open_binlog";
62 # restart
63 Test case8
64 SET GLOBAL binlog_error_action= IGNORE_ERROR;
65 SET SESSION debug="+d,fault_injection_init_name";
66 flush logs;
67 ERROR HY000: Can't open file: 'binlog.000009' (errno: 1 - Operation not permitted)
68 CREATE TABLE t2 (f int );
69 SHOW TABLES;
70 Tables_in_test
71 t2
72 DROP TABLE t2;
73 SET SESSION debug="-d,fault_injection_init_name";
74 # restart
75 Test case09
76 SET GLOBAL binlog_error_action= IGNORE_ERROR;
77 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
78 SET SESSION debug='+d,error_unique_log_filename';
79 FLUSH LOGS;
80 ERROR HY000: Can't generate a unique log-filename binlog.(1-999)
81
82 DROP TABLE t1;
83 SET SESSION debug="";
84 SHOW BINARY LOGS;
85 ERROR HY000: You are not using binary logging
86 # restart
87 Test case10
88 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
89 SET GLOBAL binlog_error_action=ABORT_SERVER;
90 SET SESSION debug='+d,error_unique_log_filename';
91 FLUSH LOGS;
92 ERROR HY000: Binary logging not possible. Message: Can't generate a unique log-filename binlog.(1-999), while rotating the binlog. Aborting the server
93 DROP TABLE t1;
94 Test case11
95 # restart
96 RESET MASTER;
97 CREATE TABLE t1(i INT);
98 SET SESSION debug = "+d,simulate_error_during_flush_cache_to_file";
99 SET GLOBAL binlog_error_action = ABORT_SERVER;
100 INSERT INTO t1 VALUES (1);
101 ERROR HY000: Binary logging not possible. Message: An error occurred during flush stage of the commit. 'binlog_error_action' is set to 'ABORT_SERVER'. Server is being stopped.
102 Pattern "An error occurred during flush stage of the commit. 'binlog_error_action' is set to 'ABORT_SERVER'." found
103 include/assert.inc [Count of elements in t1 should be 0.]
104 include/assert.inc [Query is not binlogged as expected.]
105 RESET MASTER;
106 SET SESSION debug ="+d,simulate_error_during_flush_cache_to_file";
107 SET GLOBAL binlog_error_action= IGNORE_ERROR;
108 INSERT INTO t1 VALUES (2);
109 include/assert.inc [Count of elements in t1 should be 1.]
110 # restart
111 include/assert.inc [Query is not binlogged as expected.]
112 Pattern "An error occurred during flush stage of the commit. 'binlog_error_action' is set to 'IGNORE_ERROR'." found
113 DROP TABLE t1;
114 RESET MASTER;
115 Test case12
116 SET GLOBAL sync_binlog = 1;
117 CREATE TABLE t1(i INT);
118 SET SESSION debug = "+d,simulate_error_during_sync_binlog_file";
119 SET GLOBAL binlog_error_action = ABORT_SERVER;
120 INSERT INTO t1 VALUES (1);
121 ERROR HY000: Binary logging not possible. Message: An error occurred during sync stage of the commit. 'binlog_error_action' is set to 'ABORT_SERVER'. Server is being stopped.
122 DELETE FROM t1;
123 RESET MASTER;
124 SET SESSION debug = "+d,simulate_error_during_sync_binlog_file";
125 SET GLOBAL binlog_error_action = IGNORE_ERROR;
126 INSERT INTO t1 VALUES (2);
127 include/assert.inc [Count of elements in t1 should be 1.]
128 DROP table t1;
129 SET SESSION debug = "-d,simulate_error_during_sync_binlog_file";
130 # restart
131 RESET MASTER;
132 Test case13
133 CREATE TABLE t1(i INT);
134 SET SESSION debug = "+d,simulate_do_write_cache_failure";
135 SET GLOBAL binlog_error_action = ABORT_SERVER;
136 INSERT INTO t1 VALUES (1);
137 ERROR HY000: Binary logging not possible. Message: An error occurred during flush stage of the commit. 'binlog_error_action' is set to 'ABORT_SERVER'. Server is being stopped.
138 include/assert.inc [Count of elements in t1 should be 0.]
139 include/assert.inc [Query is not binlogged as expected.]
140 RESET MASTER;
141 SET SESSION debug = "+d,simulate_do_write_cache_failure";
142 SET GLOBAL binlog_error_action = IGNORE_ERROR;
143 INSERT INTO t1 VALUES (2);
144 include/assert.inc [Count of elements in t1 should be 1.]
145 DROP table t1;
146 # restart
147 RESET MASTER;
148 Test case14
149 SET GLOBAL binlog_error_action = IGNORE_ERROR;
150 SET GLOBAL sync_binlog = 1;
151 CREATE TABLE t1(i INT);
152 CREATE TABLE t2(i INT);
153 SET DEBUG_SYNC = "bgc_before_flush_stage SIGNAL about_to_enter_flush_stage WAIT_FOR binlog_closed";
154 INSERT INTO t1 values (1);;
155 SET DEBUG_SYNC = "now wait_for about_to_enter_flush_stage";
156 SET DEBUG_SYNC = "after_binlog_closed_due_to_error SIGNAL binlog_closed";
157 SET SESSION debug = "+d,simulate_error_during_sync_binlog_file";
158 INSERT INTO t2 values (2);;
159 DROP table t1, t2;
160 # restart
161 Test case15
162 SET GLOBAL binlog_error_action = IGNORE_ERROR;
163 SET GLOBAL sync_binlog = 1;
164 CREATE TABLE t1(i INT);
165 CREATE TABLE t2(i INT);
166 SET DEBUG_SYNC = "before_binlog_closed_due_to_error SIGNAL binlog_about_to_be_closed WAIT_FOR in_the_middle_of_flush_stage";
167 SET SESSION debug = "+d,simulate_error_during_sync_binlog_file";
168 INSERT INTO t1 values (1);;
169 SET DEBUG_SYNC = "now wait_for binlog_about_to_be_closed";
170 SET DEBUG_SYNC = "waiting_in_the_middle_of_flush_stage SIGNAL in_the_middle_of_flush_stage";
171 INSERT INTO t2 values (2);;
172 DROP table t1, t2;
173 # restart
174 Test case16
175 SET GLOBAL binlog_error_action = IGNORE_ERROR;
176 SET GLOBAL sync_binlog = 1;
177 CREATE TABLE t1(i INT);
178 CREATE TABLE t2(i INT);
179 SET DEBUG_SYNC = "before_binlog_closed_due_to_error SIGNAL binlog_about_to_be_closed WAIT_FOR another_group_encountered_flush_error";
180 SET SESSION debug = "+d,simulate_error_during_sync_binlog_file";
181 INSERT INTO t1 values (1);;
182 SET DEBUG_SYNC = "now wait_for binlog_about_to_be_closed";
183 SET DEBUG_SYNC = "before_binlog_closed_due_to_error SIGNAL another_group_encountered_flush_error";
184 SET SESSION debug ="+d,simulate_error_during_flush_cache_to_file";
185 INSERT INTO t2 values (2);;
186 Matching lines are:
187 --TIME-- [ERROR] [MY-010861] [Server] An error occurred during flush_or_sync stage stage of the commit. 'binlog_error_action' is set to 'IGNORE_ERROR'. Hence turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
188 Occurrences of 'An error occurred during' in the input file: 1
189 DROP table t1, t2;
190 # restart
191 Test case17
192 # restart: KEYRING_PLUGIN_OPT KEYRING_PLUGIN_LOAD --keyring_file_data=keyring_data --binlog_encryption=ON
193 # Adding debug point 'fail_to_serialize_encryption_header' to @@GLOBAL.debug
194 FLUSH LOGS;
195 ERROR HY000: Binary logging not possible. Message: Either disk is full, file system is read only or there was an encryption error while opening the binlog. Aborting the server.
196 SET @@GLOBAL.binlog_encryption=OFF;
197 RESET MASTER;
198 UNINSTALL PLUGIN keyring_file;
199 # restart
200 Test case18
201 # restart: KEYRING_PLUGIN_OPT KEYRING_PLUGIN_LOAD --keyring_file_data=keyring_data --binlog_encryption=ON
202 # Adding debug point 'fail_to_generate_new_file_password' to @@GLOBAL.debug
203 FLUSH LOGS;
204 ERROR HY000: Binary logging not possible. Message: Either disk is full, file system is read only or there was an encryption error while opening the binlog. Aborting the server.
205 SET @@GLOBAL.binlog_encryption=OFF;
206 RESET MASTER;
207 UNINSTALL PLUGIN keyring_file;
208 # restart