Debian Codegraph @

mysql-test/suite/binlog_gtid/r/binlog_gtid_binlog_recovery_errors.result

raw
1 include/suppress_messages.inc
2 # Connection 1 suppresses message <.*Found invalid event sequence while recovering from binary log file.*>.
3 # Connection 1 suppresses message <.*Found.*prepared XA transactions.*>.
4 # Connection 1 suppresses message <.*Can.t init tc log.*>.
5 # Connection 1 suppresses message <.*Aborting.*>.
6 CREATE TABLE t1 (c1 INT PRIMARY KEY);
7 RESET MASTER;
8 INSERT INTO t1 VALUES (1);
9 INSERT INTO t1 VALUES (2);
10 extra/binlog_tests/recovery/kill_copy_malformed_restart.inc [orphan_xid]
11 # Kill the server
12 # restart_abort: --debug=+d,eval_force_bin_log_recovery
13 include/wait_for_pattern_in_file.inc [.*between positions 430 and 540: Xid_log_event outside the boundary of a sequence of events representing an active transaction.*]
14 extra/binlog_tests/recovery/end_scenario.inc [orphan_xid]
15 # restart
16 DELETE FROM t1;
17 RESET MASTER;
18 INSERT INTO t1 VALUES (1);
19 INSERT INTO t1 VALUES (2);
20 extra/binlog_tests/recovery/kill_copy_malformed_restart.inc [duplicate_xid]
21 # Kill the server
22 # restart_abort: --debug=+d,eval_force_bin_log_recovery
23 include/wait_for_pattern_in_file.inc [.*between positions 430 and 703: Xid_log_event holds an invalid XID.*]
24 extra/binlog_tests/recovery/end_scenario.inc [duplicate_xid]
25 # restart
26 DELETE FROM t1;
27 RESET MASTER;
28 XA START 'x';
29 INSERT INTO t1 VALUES (1);
30 XA END 'x';
31 XA PREPARE 'x';
32 extra/binlog_tests/recovery/kill_copy_malformed_restart.inc [orphan_xa_prepare]
33 # Kill the server
34 # restart_abort: --debug=+d,eval_force_bin_log_recovery
35 include/wait_for_pattern_in_file.inc [.*between positions 157 and 273: XA_prepare_log_event outside the boundary of a sequence of events representing an active transaction.*]
36 extra/binlog_tests/recovery/end_scenario.inc [orphan_xa_prepare]
37 # restart
38 XA ROLLBACK 'x';
39 DELETE FROM t1;
40 RESET MASTER;
41 XA START 'x';
42 INSERT INTO t1 VALUES (1);
43 XA END 'x';
44 XA PREPARE 'x';
45 XA START 'y';
46 INSERT INTO t1 VALUES (2);
47 XA END 'y';
48 XA PREPARE 'y';
49 extra/binlog_tests/recovery/kill_copy_malformed_restart.inc [duplicate_xid_xa_prepare]
50 # Kill the server
51 # restart_abort: --debug=+d,eval_force_bin_log_recovery
52 include/wait_for_pattern_in_file.inc [.*between positions 539 and 921: XA_prepare_log_event holds an invalid XID.*]
53 extra/binlog_tests/recovery/end_scenario.inc [duplicate_xid_xa_prepare]
54 # restart
55 XA ROLLBACK 'x'; XA ROLLBACK 'y';
56 DELETE FROM t1;
57 RESET MASTER;
58 BEGIN;
59 INSERT INTO t1 VALUES (1);
60 INSERT INTO t1 VALUES (2);
61 COMMIT;
62 XA START 'x';
63 INSERT INTO t1 VALUES (3);
64 XA END 'x';
65 XA PREPARE 'x';
66 extra/binlog_tests/recovery/kill_copy_malformed_restart.inc [orphan_begin_start]
67 # Kill the server
68 # restart_abort: --debug=+d,eval_force_bin_log_recovery
69 include/wait_for_pattern_in_file.inc [.*between positions 157 and 656: Query_log_event containing `BEGIN/XA START` inside the boundary of a sequence of events representing an active transaction.*]
70 extra/binlog_tests/recovery/end_scenario.inc [orphan_begin_start]
71 # restart
72 XA ROLLBACK 'x';
73 DELETE FROM t1;
74 RESET MASTER;
75 CREATE TABLE tmp1 (i INT) ENGINE=MyISAM;
76 SET @@SESSION.binlog_format = STATEMENT;
77 Warnings:
78 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
79 BEGIN;
80 INSERT INTO tmp1 (SELECT c1 FROM t1);
81 COMMIT;
82 SET @@SESSION.binlog_format = ROW;
83 Warnings:
84 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
85 extra/binlog_tests/recovery/kill_copy_malformed_restart.inc [orphan_commit]
86 # Kill the server
87 # restart_abort: --debug=+d,eval_force_bin_log_recovery
88 include/wait_for_pattern_in_file.inc [.*between positions 352 and 514: Query_log_event containing `COMMIT` outside the boundary of a sequence of events representing an active transaction.*]
89 extra/binlog_tests/recovery/end_scenario.inc [orphan_commit]
90 # restart
91 DROP TABLE tmp1;
92 DELETE FROM t1;
93 RESET MASTER;
94 CREATE FUNCTION func1 () RETURNS INT
95 BEGIN
96 CREATE TEMPORARY TABLE tmp1(i INT) ENGINE=MyISAM;
97 DROP TEMPORARY TABLE IF EXISTS tmp1;
98 RETURN 0;
99 END|
100 SET @@SESSION.binlog_format = STATEMENT;
101 Warnings:
102 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
103 BEGIN;
104 SELECT func1();
105 func1()
106 0
107 ROLLBACK;
108 Warnings:
109 Warning 1751 The creation of some temporary tables could not be rolled back.
110 Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back.
111 SET @@SESSION.binlog_format = ROW;
112 Warnings:
113 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
114 extra/binlog_tests/recovery/kill_copy_malformed_restart.inc [orphan_rollback]
115 # Kill the server
116 # restart_abort: --debug=+d,eval_force_bin_log_recovery
117 include/wait_for_pattern_in_file.inc [.*between positions 510 and 667: Query_log_event containing `ROLLBACK` outside the boundary of a sequence of events representing an active transaction.*]
118 extra/binlog_tests/recovery/end_scenario.inc [orphan_rollback]
119 # restart
120 DROP FUNCTION func1;
121 DELETE FROM t1;
122 RESET MASTER;
123 INSERT INTO t1 VALUES (1);
124 CREATE TABLE tmp1 (i INT);
125 INSERT INTO tmp1 (SELECT c1 FROM t1);
126 extra/binlog_tests/recovery/kill_copy_malformed_restart.inc [ddl_in_transaction]
127 # Kill the server
128 # restart_abort: --debug=+d,eval_force_bin_log_recovery
129 include/wait_for_pattern_in_file.inc [.*between positions 157 and 589: Query_log event containing a DDL inside the boundary of a sequence of events representing an active transaction.*]
130 extra/binlog_tests/recovery/end_scenario.inc [ddl_in_transaction]
131 # restart
132 DROP TABLE tmp1;
133 DELETE FROM t1;
134 RESET MASTER;
135 INSERT INTO t1 VALUES (1);
136 CREATE TABLE tmp1 (i INT);
137 extra/binlog_tests/recovery/kill_copy_malformed_restart.inc [duplicate_xid_ddl]
138 # Kill the server
139 # restart_abort: --debug=+d,eval_force_bin_log_recovery
140 include/wait_for_pattern_in_file.inc [.*between positions 430 and 620: Query_log_event containing a DDL holds an invalid XID.*]
141 extra/binlog_tests/recovery/end_scenario.inc [duplicate_xid_ddl]
142 # restart
143 DROP TABLE tmp1;
144 DELETE FROM t1;
145 RESET MASTER;
146 INSERT INTO t1 VALUES (1);
147 XA START 'x';
148 INSERT INTO t1 VALUES (2);
149 XA END 'x';
150 XA PREPARE 'x';
151 XA COMMIT 'x' ;
152 extra/binlog_tests/recovery/kill_copy_malformed_restart.inc [orphan_xa_commit]
153 # Kill the server
154 # restart_abort: --debug=+d,eval_force_bin_log_recovery
155 include/wait_for_pattern_in_file.inc [.*between positions 430 and 943: Query_log_event containing `XA COMMIT` inside the boundary of a sequence of events representing a transaction not yet in prepared state.*]
156 extra/binlog_tests/recovery/end_scenario.inc [orphan_xa_commit]
157 # restart
158 DELETE FROM t1;
159 RESET MASTER;
160 INSERT INTO t1 VALUES (1);
161 XA START 'x';
162 INSERT INTO t1 VALUES (2);
163 XA END 'x';
164 XA PREPARE 'x';
165 XA COMMIT 'x' ;
166 extra/binlog_tests/recovery/kill_copy_malformed_restart.inc [malformed_xid_xa_commit]
167 # Kill the server
168 # restart_abort: --debug=+d,eval_force_bin_log_recovery
169 include/wait_for_pattern_in_file.inc [.*between positions 812 and 980: Query_log_event containing `XA COMMIT` holds an invalid XID.*]
170 extra/binlog_tests/recovery/end_scenario.inc [malformed_xid_xa_commit]
171 # restart
172 DELETE FROM t1;
173 RESET MASTER;
174 INSERT INTO t1 VALUES (1);
175 XA START 'x';
176 INSERT INTO t1 VALUES (2);
177 XA END 'x';
178 XA PREPARE 'x';
179 XA COMMIT 'x' ;
180 XA START 'x';
181 INSERT INTO t1 VALUES (3);
182 XA END 'x';
183 XA PREPARE 'x';
184 XA COMMIT 'x' ;
185 extra/binlog_tests/recovery/kill_copy_malformed_restart.inc [duplicate_xid_xa_commit]
186 # Kill the server
187 # restart_abort: --debug=+d,eval_force_bin_log_recovery
188 include/wait_for_pattern_in_file.inc [.*between positions 980 and 1148: Query_log_event containing `XA COMMIT` holds an invalid XID.*]
189 extra/binlog_tests/recovery/end_scenario.inc [duplicate_xid_xa_commit]
190 # restart
191 DELETE FROM t1;
192 RESET MASTER;
193 INSERT INTO t1 VALUES (1);
194 XA START 'x';
195 INSERT INTO t1 VALUES (2);
196 XA END 'x';
197 XA PREPARE 'x';
198 XA ROLLBACK 'x' ;
199 extra/binlog_tests/recovery/kill_copy_malformed_restart.inc [orphan_xa_rollback]
200 # Kill the server
201 # restart_abort: --debug=+d,eval_force_bin_log_recovery
202 include/wait_for_pattern_in_file.inc [.*between positions 430 and 945: Query_log_event containing `XA ROLLBACK` inside the boundary of a sequence of events representing a transaction not yet in prepared state.*]
203 extra/binlog_tests/recovery/end_scenario.inc [orphan_xa_rollback]
204 # restart
205 DELETE FROM t1;
206 RESET MASTER;
207 INSERT INTO t1 VALUES (1);
208 XA START 'x';
209 INSERT INTO t1 VALUES (2);
210 XA END 'x';
211 XA PREPARE 'x';
212 XA ROLLBACK 'x' ;
213 extra/binlog_tests/recovery/kill_copy_malformed_restart.inc [malformed_xid_xa_rollback]
214 # Kill the server
215 # restart_abort: --debug=+d,eval_force_bin_log_recovery
216 include/wait_for_pattern_in_file.inc [.*between positions 812 and 982: Query_log_event containing `XA ROLLBACK` holds an invalid XID.*]
217 extra/binlog_tests/recovery/end_scenario.inc [malformed_xid_xa_rollback]
218 # restart
219 DELETE FROM t1;
220 RESET MASTER;
221 INSERT INTO t1 VALUES (1);
222 XA START 'x';
223 INSERT INTO t1 VALUES (2);
224 XA END 'x';
225 XA PREPARE 'x';
226 XA COMMIT 'x' ;
227 XA START 'x';
228 INSERT INTO t1 VALUES (3);
229 XA END 'x';
230 XA PREPARE 'x';
231 XA ROLLBACK 'x' ;
232 extra/binlog_tests/recovery/kill_copy_malformed_restart.inc [duplicate_xid_xa_rollback]
233 # Kill the server
234 # restart_abort: --debug=+d,eval_force_bin_log_recovery
235 include/wait_for_pattern_in_file.inc [.*between positions 980 and 1150: Query_log_event containing `XA ROLLBACK` holds an invalid XID.*]
236 extra/binlog_tests/recovery/end_scenario.inc [duplicate_xid_xa_rollback]
237 # restart
238 DELETE FROM t1;
239 RESET MASTER;
240 DROP TABLE t1;