Debian Codegraph @

mysql-test/suite/rpl/r/rpl_xa_survive_disconnect.result

raw
1 include/master-slave.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 master]
6 call mtr.add_suppression("Found 2 prepared XA transactions");
7 CALL mtr.add_suppression("Statement is unsafe because it is being used inside a XA transaction");
8 CREATE VIEW v_processlist as SELECT * FROM performance_schema.threads where type = 'FOREGROUND';
9 CREATE DATABASE d1;
10 CREATE DATABASE d2;
11 CREATE TABLE d1.t (a INT) ENGINE=innodb;
12 CREATE TABLE d2.t (a INT) ENGINE=innodb;
13 SET @@session.binlog_format= statement;
14 Warnings:
15 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
16 XA START '1-stmt';
17 INSERT INTO d1.t VALUES (1);
18 Warnings:
19 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
20 XA END '1-stmt';
21 XA PREPARE '1-stmt';
22 SET @@session.binlog_format= 'row';
23 Warnings:
24 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
25 XA START '1-row';
26 INSERT INTO d2.t VALUES (1);
27 XA END '1-row';
28 XA PREPARE '1-row';
29 XA START '2';
30 INSERT INTO d1.t VALUES (2);
31 XA END '2';
32 XA PREPARE '2';
33 XA COMMIT '2';
34 XA COMMIT '1-row';
35 XA COMMIT '1-stmt';
36 include/show_binlog_events.inc
37 Log_name Pos Event_type Server_id End_log_pos Info
38 master-bin.000001 # Query # # BEGIN
39 master-bin.000001 # Query # # use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_utf8mb4'Found 2 prepared XA transactions' COLLATE 'utf8mb4_0900_ai_ci'))
40 master-bin.000001 # Xid # # COMMIT /* XID */
41 master-bin.000001 # Query # # BEGIN
42 master-bin.000001 # Query # # use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_utf8mb4'Statement is unsafe because it is being used inside a XA transaction' COLLATE 'utf8mb4_0900_ai_ci'))
43 master-bin.000001 # Xid # # COMMIT /* XID */
44 master-bin.000001 # Query # # use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_processlist` AS SELECT * FROM performance_schema.threads where type = 'FOREGROUND'
45 master-bin.000001 # Query # # CREATE DATABASE d1
46 master-bin.000001 # Query # # CREATE DATABASE d2
47 master-bin.000001 # Query # # use `test`; CREATE TABLE d1.t (a INT) ENGINE=innodb
48 master-bin.000001 # Query # # use `test`; CREATE TABLE d2.t (a INT) ENGINE=innodb
49 master-bin.000001 # Query # # XA START X'312d73746d74',X'',1
50 master-bin.000001 # Query # # use `test`; INSERT INTO d1.t VALUES (1)
51 master-bin.000001 # Query # # XA END X'312d73746d74',X'',1
52 master-bin.000001 # XA_prepare # # XA PREPARE X'312d73746d74',X'',1
53 master-bin.000001 # Query # # XA START X'312d726f77',X'',1
54 master-bin.000001 # Table_map # # table_id: # (d2.t)
55 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
56 master-bin.000001 # Query # # XA END X'312d726f77',X'',1
57 master-bin.000001 # XA_prepare # # XA PREPARE X'312d726f77',X'',1
58 master-bin.000001 # Query # # XA START X'32',X'',1
59 master-bin.000001 # Table_map # # table_id: # (d1.t)
60 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
61 master-bin.000001 # Query # # XA END X'32',X'',1
62 master-bin.000001 # XA_prepare # # XA PREPARE X'32',X'',1
63 master-bin.000001 # Query # # XA COMMIT X'32',X'',1
64 master-bin.000001 # Query # # XA COMMIT X'312d726f77',X'',1
65 master-bin.000001 # Query # # XA COMMIT X'312d73746d74',X'',1
66 include/sync_slave_sql_with_master.inc
67 include/stop_slave.inc
68 SET @@session.binlog_format= statement;
69 Warnings:
70 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
71 XA START '3-stmt';
72 INSERT INTO d1.t VALUES (3);
73 Warnings:
74 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
75 XA END '3-stmt';
76 XA PREPARE '3-stmt';
77 SET @@session.binlog_format= 'row';
78 Warnings:
79 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
80 XA START '3-row';
81 INSERT INTO d2.t VALUES (4);
82 XA END '3-row';
83 XA PREPARE '3-row';
84 XA START '4';
85 SELECT * FROM d1.t;
86 a
87 1
88 2
89 XA END '4';
90 XA PREPARE '4';
91 XA START 'bulk_trx_10';
92 INSERT INTO d1.t VALUES (10);
93 INSERT INTO d2.t VALUES (10);
94 XA END 'bulk_trx_10';
95 XA PREPARE 'bulk_trx_10';
96 XA START 'bulk_trx_9';
97 INSERT INTO d1.t VALUES (9);
98 INSERT INTO d2.t VALUES (9);
99 XA END 'bulk_trx_9';
100 XA PREPARE 'bulk_trx_9';
101 XA START 'bulk_trx_8';
102 INSERT INTO d1.t VALUES (8);
103 INSERT INTO d2.t VALUES (8);
104 XA END 'bulk_trx_8';
105 XA PREPARE 'bulk_trx_8';
106 XA START 'bulk_trx_7';
107 INSERT INTO d1.t VALUES (7);
108 INSERT INTO d2.t VALUES (7);
109 XA END 'bulk_trx_7';
110 XA PREPARE 'bulk_trx_7';
111 XA START 'bulk_trx_6';
112 INSERT INTO d1.t VALUES (6);
113 INSERT INTO d2.t VALUES (6);
114 XA END 'bulk_trx_6';
115 XA PREPARE 'bulk_trx_6';
116 XA START 'bulk_trx_5';
117 INSERT INTO d1.t VALUES (5);
118 INSERT INTO d2.t VALUES (5);
119 XA END 'bulk_trx_5';
120 XA PREPARE 'bulk_trx_5';
121 XA START 'bulk_trx_4';
122 INSERT INTO d1.t VALUES (4);
123 INSERT INTO d2.t VALUES (4);
124 XA END 'bulk_trx_4';
125 XA PREPARE 'bulk_trx_4';
126 XA START 'bulk_trx_3';
127 INSERT INTO d1.t VALUES (3);
128 INSERT INTO d2.t VALUES (3);
129 XA END 'bulk_trx_3';
130 XA PREPARE 'bulk_trx_3';
131 XA START 'bulk_trx_2';
132 INSERT INTO d1.t VALUES (2);
133 INSERT INTO d2.t VALUES (2);
134 XA END 'bulk_trx_2';
135 XA PREPARE 'bulk_trx_2';
136 XA START 'bulk_trx_1';
137 INSERT INTO d1.t VALUES (1);
138 INSERT INTO d2.t VALUES (1);
139 XA END 'bulk_trx_1';
140 XA PREPARE 'bulk_trx_1';
141 include/start_slave.inc
142 include/sync_slave_sql_with_master.inc
143 include/stop_slave.inc
144 XA COMMIT 'bulk_trx_10';
145 XA ROLLBACK 'bulk_trx_9';
146 XA COMMIT 'bulk_trx_8';
147 XA ROLLBACK 'bulk_trx_7';
148 XA COMMIT 'bulk_trx_6';
149 XA ROLLBACK 'bulk_trx_5';
150 XA COMMIT 'bulk_trx_4';
151 XA ROLLBACK 'bulk_trx_3';
152 XA COMMIT 'bulk_trx_2';
153 XA ROLLBACK 'bulk_trx_1';
154 include/rpl_restart_server.inc [server_number=1]
155 include/start_slave.inc
156 *** '3-stmt','3-row' xa-transactions must be in the list ***
157 XA RECOVER;
158 formatID gtrid_length bqual_length data
159 1 5 0 3-row
160 1 6 0 3-stmt
161 XA COMMIT '3-stmt';
162 XA ROLLBACK '3-row';
163 include/sync_slave_sql_with_master.inc
164 XA START '';
165 INSERT INTO d1.t VALUES (4);
166 XA END '';
167 XA PREPARE '';
168 XA START '0123456789012345678901234567890123456789012345678901234567890124','0123456789012345678901234567890123456789012345678901234567890124',64;
169 INSERT INTO d1.t VALUES (64);
170 XA END '0123456789012345678901234567890123456789012345678901234567890124','0123456789012345678901234567890123456789012345678901234567890124',64;
171 XA PREPARE '0123456789012345678901234567890123456789012345678901234567890124','0123456789012345678901234567890123456789012345678901234567890124',64;
172 XA START X'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF',X'00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',0;
173 INSERT INTO d1.t VALUES (0);
174 XA END X'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF',X'00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',0;
175 XA PREPARE X'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF',X'00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',0;
176 XA COMMIT '';
177 XA COMMIT '0123456789012345678901234567890123456789012345678901234567890124','0123456789012345678901234567890123456789012345678901234567890124',64;
178 XA COMMIT X'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF',X'00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',0;
179 XA COMMIT 'RANDOM XID'
180 include/sync_slave_sql_with_master.inc
181 XA START 'one_phase_10';
182 INSERT INTO d1.t VALUES (10);
183 INSERT INTO d2.t VALUES (10);
184 XA END 'one_phase_10';
185 XA COMMIT 'one_phase_10' ONE PHASE;
186 XA START 'one_phase_9';
187 INSERT INTO d1.t VALUES (9);
188 INSERT INTO d2.t VALUES (9);
189 XA END 'one_phase_9';
190 XA COMMIT 'one_phase_9' ONE PHASE;
191 XA START 'one_phase_8';
192 INSERT INTO d1.t VALUES (8);
193 INSERT INTO d2.t VALUES (8);
194 XA END 'one_phase_8';
195 XA COMMIT 'one_phase_8' ONE PHASE;
196 XA START 'one_phase_7';
197 INSERT INTO d1.t VALUES (7);
198 INSERT INTO d2.t VALUES (7);
199 XA END 'one_phase_7';
200 XA COMMIT 'one_phase_7' ONE PHASE;
201 XA START 'one_phase_6';
202 INSERT INTO d1.t VALUES (6);
203 INSERT INTO d2.t VALUES (6);
204 XA END 'one_phase_6';
205 XA COMMIT 'one_phase_6' ONE PHASE;
206 XA START 'one_phase_5';
207 INSERT INTO d1.t VALUES (5);
208 INSERT INTO d2.t VALUES (5);
209 XA END 'one_phase_5';
210 XA COMMIT 'one_phase_5' ONE PHASE;
211 XA START 'one_phase_4';
212 INSERT INTO d1.t VALUES (4);
213 INSERT INTO d2.t VALUES (4);
214 XA END 'one_phase_4';
215 XA COMMIT 'one_phase_4' ONE PHASE;
216 XA START 'one_phase_3';
217 INSERT INTO d1.t VALUES (3);
218 INSERT INTO d2.t VALUES (3);
219 XA END 'one_phase_3';
220 XA COMMIT 'one_phase_3' ONE PHASE;
221 XA START 'one_phase_2';
222 INSERT INTO d1.t VALUES (2);
223 INSERT INTO d2.t VALUES (2);
224 XA END 'one_phase_2';
225 XA COMMIT 'one_phase_2' ONE PHASE;
226 XA START 'one_phase_1';
227 INSERT INTO d1.t VALUES (1);
228 INSERT INTO d2.t VALUES (1);
229 XA END 'one_phase_1';
230 XA COMMIT 'one_phase_1' ONE PHASE;
231 include/sync_slave_sql_with_master.inc
232 include/diff_tables.inc [master:d1.t, slave:d1.t]
233 include/diff_tables.inc [master:d2.t, slave:d2.t]
234 DELETE FROM d1.t;
235 DELETE FROM d2.t;
236 DROP TABLE d1.t, d2.t;
237 DROP DATABASE d1;
238 DROP DATABASE d2;
239 DROP VIEW v_processlist;
240 include/sync_slave_sql_with_master.inc
241 include/rpl_end.inc