Debian Codegraph @

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

raw
1 RESET MASTER;
2 CREATE TEMPORARY SEQUENCE seq_1;
3 XA START '3';
4 CREATE TEMPORARY TABLE tmp_1(c INT);
5 XA END '3';
6 XA PREPARE '3';
7 DROP TEMPORARY TABLE tmp_1;
8 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the PREPARED state
9 ALTER TABLE tmp_1 DROP COLUMN c;
10 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the PREPARED state
11 DROP TEMPORARY SEQUENCE seq_1;
12 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the PREPARED state
13 ALTER SEQUENCE seq_1 INCREMENT BY 1;
14 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the PREPARED state
15 CREATE TEMPORARY TABLE tmp_2(c INT);
16 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the PREPARED state
17 CREATE TEMPORARY SEQUENCE seq_2;
18 ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the PREPARED state
19 XA ROLLBACK '3';
20 # Proof of correct logging incl empty XA-PREPARE
21 include/show_binlog_events.inc
22 Log_name Pos Event_type Server_id End_log_pos Info
23 master-bin.000001 # Gtid # # GTID #-#-#
24 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY SEQUENCE seq_1
25 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
26 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tmp_1(c INT)
27 master-bin.000001 # Query # # COMMIT
28 master-bin.000001 # Gtid # # XA START X'33',X'',1 GTID #-#-#
29 master-bin.000001 # Query # # XA END X'33',X'',1
30 master-bin.000001 # XA_prepare # # XA PREPARE X'33',X'',1
31 master-bin.000001 # Gtid # # GTID #-#-#
32 master-bin.000001 # Query # # XA ROLLBACK X'33',X'',1
33 RESET MASTER;
34 CREATE TABLE t1 (a INT) ENGINE=MyISAM;
35 CREATE TABLE t2 (id INT PRIMARY KEY) ENGINE=InnoDB;
36 INSERT INTO t1 VALUES (1),(2);
37 INSERT INTO t2 VALUES (1),(2);
38 XA START '1';
39 REPLACE INTO t1 SELECT * FROM t1;
40 REPLACE INTO t2 SELECT * FROM t2;
41 XA END '1';
42 XA PREPARE '1';
43 XA ROLLBACK '1';
44 Warnings:
45 Warning 1196 Some non-transactional changed tables couldn't be rolled back
46 DROP TABLE t1, t2;
47 # Proof of correct logging incl empty XA-PREPARE
48 include/show_binlog_events.inc
49 Log_name Pos Event_type Server_id End_log_pos Info
50 master-bin.000001 # Gtid # # GTID #-#-#
51 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT) ENGINE=MyISAM
52 master-bin.000001 # Gtid # # GTID #-#-#
53 master-bin.000001 # Query # # use `test`; CREATE TABLE t2 (id INT PRIMARY KEY) ENGINE=InnoDB
54 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
55 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1),(2)
56 master-bin.000001 # Query # # COMMIT
57 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
58 master-bin.000001 # Query # # use `test`; INSERT INTO t2 VALUES (1),(2)
59 master-bin.000001 # Xid # # COMMIT /* XID */
60 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
61 master-bin.000001 # Annotate_rows # # REPLACE INTO t1 SELECT * FROM t1
62 master-bin.000001 # Table_map # # table_id: # (test.t1)
63 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
64 master-bin.000001 # Query # # COMMIT
65 master-bin.000001 # Gtid # # XA START X'31',X'',1 GTID #-#-#
66 master-bin.000001 # Query # # XA END X'31',X'',1
67 master-bin.000001 # XA_prepare # # XA PREPARE X'31',X'',1
68 master-bin.000001 # Gtid # # GTID #-#-#
69 master-bin.000001 # Query # # XA ROLLBACK X'31',X'',1
70 master-bin.000001 # Gtid # # GTID #-#-#
71 master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2` /* generated by server */
72 RESET MASTER;
73 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
74 INSERT INTO t1 VALUES (1);
75 CREATE SEQUENCE s ENGINE=InnoDB;
76 XA START '2';
77 SELECT NEXT VALUE FOR s;
78 NEXT VALUE FOR s
79 1
80 REPLACE INTO t1 SELECT * FROM t1;
81 XA END '2';
82 XA PREPARE '2';
83 XA ROLLBACK '2';
84 DROP SEQUENCE s;
85 DROP TABLE t1;
86 # Proof of correct logging incl empty XA-PREPARE
87 include/show_binlog_events.inc
88 Log_name Pos Event_type Server_id End_log_pos Info
89 master-bin.000001 # Gtid # # GTID #-#-#
90 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB
91 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
92 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
93 master-bin.000001 # Table_map # # table_id: # (test.t1)
94 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
95 master-bin.000001 # Xid # # COMMIT /* XID */
96 master-bin.000001 # Gtid # # GTID #-#-#
97 master-bin.000001 # Query # # use `test`; CREATE SEQUENCE s ENGINE=InnoDB
98 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
99 master-bin.000001 # Annotate_rows # # SELECT NEXT VALUE FOR s
100 master-bin.000001 # Table_map # # table_id: # (test.s)
101 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
102 master-bin.000001 # Query # # COMMIT
103 master-bin.000001 # Gtid # # XA START X'32',X'',1 GTID #-#-#
104 master-bin.000001 # Query # # XA END X'32',X'',1
105 master-bin.000001 # XA_prepare # # XA PREPARE X'32',X'',1
106 master-bin.000001 # Gtid # # GTID #-#-#
107 master-bin.000001 # Query # # XA ROLLBACK X'32',X'',1
108 master-bin.000001 # Gtid # # GTID #-#-#
109 master-bin.000001 # Query # # use `test`; DROP SEQUENCE `s` /* generated by server */
110 master-bin.000001 # Gtid # # GTID #-#-#
111 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
112 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
113 INSERT INTO t1 VALUES (1);
114 connect con1,localhost,root,,;
115 XA START '1';
116 INSERT INTO t1 VALUES (2),(1);
117 ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
118 SELECT * FROM t1 WHERE a = 2;
119 a
120 XA END '1';
121 XA PREPARE '1';
122 disconnect con1;
123 connection default;
124 XA RECOVER;
125 formatID gtrid_length bqual_length data
126 1 1 0 1
127 XA COMMIT '1';
128 ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back
129 Must be no XA PREPARE group nor XA completion one:
130 include/show_binlog_events.inc
131 Log_name Pos Event_type Server_id End_log_pos Info
132 master-bin.000001 # Gtid # # GTID #-#-#
133 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB
134 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
135 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
136 master-bin.000001 # Table_map # # table_id: # (test.t1)
137 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
138 master-bin.000001 # Xid # # COMMIT /* XID */
139 master-bin.000001 # Gtid # # GTID #-#-#
140 master-bin.000001 # Query # # use `test`; CREATE SEQUENCE s ENGINE=InnoDB
141 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
142 master-bin.000001 # Annotate_rows # # SELECT NEXT VALUE FOR s
143 master-bin.000001 # Table_map # # table_id: # (test.s)
144 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
145 master-bin.000001 # Query # # COMMIT
146 master-bin.000001 # Gtid # # XA START X'32',X'',1 GTID #-#-#
147 master-bin.000001 # Query # # XA END X'32',X'',1
148 master-bin.000001 # XA_prepare # # XA PREPARE X'32',X'',1
149 master-bin.000001 # Gtid # # GTID #-#-#
150 master-bin.000001 # Query # # XA ROLLBACK X'32',X'',1
151 master-bin.000001 # Gtid # # GTID #-#-#
152 master-bin.000001 # Query # # use `test`; DROP SEQUENCE `s` /* generated by server */
153 master-bin.000001 # Gtid # # GTID #-#-#
154 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
155 master-bin.000001 # Gtid # # GTID #-#-#
156 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB
157 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
158 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
159 master-bin.000001 # Table_map # # table_id: # (test.t1)
160 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
161 master-bin.000001 # Xid # # COMMIT /* XID */
162 DROP TABLE t1;
163 connect con2,localhost,root,,;
164 CREATE TABLE tm (a INT PRIMARY KEY) ENGINE=MyISAM;
165 XA START '1';
166 INSERT INTO tm VALUES (1),(1);
167 ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
168 SELECT * FROM tm WHERE a = 2;
169 a
170 XA END '1';
171 XA PREPARE '1';
172 disconnect con2;
173 connection default;
174 XA RECOVER;
175 formatID gtrid_length bqual_length data
176 1 1 0 1
177 XA ROLLBACK '1';
178 ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back
179 Must be no XA PREPARE group nor XA completion one:
180 include/show_binlog_events.inc
181 Log_name Pos Event_type Server_id End_log_pos Info
182 master-bin.000001 # Gtid # # GTID #-#-#
183 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB
184 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
185 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
186 master-bin.000001 # Table_map # # table_id: # (test.t1)
187 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
188 master-bin.000001 # Xid # # COMMIT /* XID */
189 master-bin.000001 # Gtid # # GTID #-#-#
190 master-bin.000001 # Query # # use `test`; CREATE SEQUENCE s ENGINE=InnoDB
191 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
192 master-bin.000001 # Annotate_rows # # SELECT NEXT VALUE FOR s
193 master-bin.000001 # Table_map # # table_id: # (test.s)
194 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
195 master-bin.000001 # Query # # COMMIT
196 master-bin.000001 # Gtid # # XA START X'32',X'',1 GTID #-#-#
197 master-bin.000001 # Query # # XA END X'32',X'',1
198 master-bin.000001 # XA_prepare # # XA PREPARE X'32',X'',1
199 master-bin.000001 # Gtid # # GTID #-#-#
200 master-bin.000001 # Query # # XA ROLLBACK X'32',X'',1
201 master-bin.000001 # Gtid # # GTID #-#-#
202 master-bin.000001 # Query # # use `test`; DROP SEQUENCE `s` /* generated by server */
203 master-bin.000001 # Gtid # # GTID #-#-#
204 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
205 master-bin.000001 # Gtid # # GTID #-#-#
206 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB
207 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
208 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
209 master-bin.000001 # Table_map # # table_id: # (test.t1)
210 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
211 master-bin.000001 # Xid # # COMMIT /* XID */
212 master-bin.000001 # Gtid # # GTID #-#-#
213 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
214 master-bin.000001 # Gtid # # GTID #-#-#
215 master-bin.000001 # Query # # use `test`; CREATE TABLE tm (a INT PRIMARY KEY) ENGINE=MyISAM
216 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
217 master-bin.000001 # Query # # use `test`; INSERT INTO tm VALUES (1),(1)
218 master-bin.000001 # Query # # COMMIT
219 DROP TABLE tm;
220 connection default;
221 SET pseudo_slave_mode=1;
222 XA START 'a';
223 XA END 'a';
224 XA PREPARE 'a';
225 XA ROLLBACK 'a';
226 ERROR XA100: XA_RBROLLBACK: Transaction branch was rolled back
227 include/show_binlog_events.inc