Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_mts_xa_retry.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 [connection master]
7 SET @@session.binlog_transaction_compression = ON;
8 [connection slave]
9 include/stop_slave_sql.inc
10 SET @@global.replica_transaction_retries= 200;
11 SET @@global.innodb_lock_wait_timeout= 5;
12 SET @@global.binlog_transaction_compression = ON;
13 SET @@global.replica_parallel_workers = 4;
14 SET @@global.replica_preserve_commit_order = OFF;
15 include/start_slave_sql.inc
16 include/stop_slave_sql.inc
17 SET @@global.replica_parallel_workers = 8;
18 include/start_slave_sql.inc
19 [connection master]
20 include/rpl_reset.inc
21 CREATE TABLE t1 (a INT PRIMARY KEY, b INT);
22 include/sync_slave_sql_with_master.inc
23 include/stop_slave_sql.inc
24 SET @@global.replica_parallel_type = 'DATABASE';
25 Warnings:
26 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
27 include/start_slave_sql.inc
28 [connection slave1]
29 BEGIN;
30 INSERT INTO t1 SET a = 10, b = 11;
31 [connection master]
32 INSERT INTO t1 SET a = 22, b = 22;
33 XA START 'xa1';
34 INSERT INTO t1 SET a = 10, b = 1;
35 XA END 'xa1';
36 XA PREPARE 'xa1';
37 include/assert_binlog_events.inc [Gtid # Query # Gtid # Transaction_payload # Query # Table_map # Write_rows # Xid # Gtid # Transaction_payload # Query/XA START.* # Table_map # Write_rows # Query/XA END.* # XA_prepare]
38 [connection slave]
39 [connection slave1]
40 ROLLBACK;
41 [connection master]
42 XA COMMIT 'xa1';
43 include/sync_slave_sql_with_master.inc
44 include/assert_binlog_events.inc [Gtid # Query # Gtid # Transaction_payload # Query # Table_map # Write_rows # Xid # Gtid # Transaction_payload # Query/XA START.* # Table_map # Write_rows # Query/XA END.* # XA_prepare # Gtid # Query/XA COMMIT.*]
45 include/diff_tables.inc [master:test.t1,slave:test.t1]
46 [connection master]
47 DROP TABLE t1;
48 include/sync_slave_sql_with_master.inc
49 [connection master]
50 include/rpl_reset.inc
51 CREATE TABLE t1 (a INT PRIMARY KEY, b INT);
52 include/sync_slave_sql_with_master.inc
53 include/stop_slave_sql.inc
54 SET @@global.replica_parallel_type = 'LOGICAL_CLOCK';
55 Warnings:
56 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
57 include/start_slave_sql.inc
58 [connection slave1]
59 BEGIN;
60 INSERT INTO t1 SET a = 10, b = 11;
61 [connection master]
62 INSERT INTO t1 SET a = 22, b = 22;
63 XA START 'xa1';
64 INSERT INTO t1 SET a = 10, b = 1;
65 XA END 'xa1';
66 XA PREPARE 'xa1';
67 include/assert_binlog_events.inc [Gtid # Query # Gtid # Transaction_payload # Query # Table_map # Write_rows # Xid # Gtid # Transaction_payload # Query/XA START.* # Table_map # Write_rows # Query/XA END.* # XA_prepare]
68 [connection slave]
69 [connection slave1]
70 ROLLBACK;
71 [connection master]
72 XA COMMIT 'xa1';
73 include/sync_slave_sql_with_master.inc
74 include/assert_binlog_events.inc [Gtid # Query # Gtid # Transaction_payload # Query # Table_map # Write_rows # Xid # Gtid # Transaction_payload # Query/XA START.* # Table_map # Write_rows # Query/XA END.* # XA_prepare # Gtid # Query/XA COMMIT.*]
75 include/diff_tables.inc [master:test.t1,slave:test.t1]
76 [connection master]
77 DROP TABLE t1;
78 include/sync_slave_sql_with_master.inc
79 include/stop_slave_sql.inc
80 SET @@global.replica_parallel_workers = 1;
81 include/start_slave_sql.inc
82 [connection master]
83 include/rpl_reset.inc
84 CREATE TABLE t1 (a INT PRIMARY KEY, b INT);
85 include/sync_slave_sql_with_master.inc
86 include/stop_slave_sql.inc
87 SET @@global.replica_parallel_type = 'DATABASE';
88 Warnings:
89 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
90 include/start_slave_sql.inc
91 [connection slave1]
92 BEGIN;
93 INSERT INTO t1 SET a = 10, b = 11;
94 [connection master]
95 INSERT INTO t1 SET a = 22, b = 22;
96 XA START 'xa1';
97 INSERT INTO t1 SET a = 10, b = 1;
98 XA END 'xa1';
99 XA PREPARE 'xa1';
100 include/assert_binlog_events.inc [Gtid # Query # Gtid # Transaction_payload # Query # Table_map # Write_rows # Xid # Gtid # Transaction_payload # Query/XA START.* # Table_map # Write_rows # Query/XA END.* # XA_prepare]
101 [connection slave]
102 [connection slave1]
103 ROLLBACK;
104 [connection master]
105 XA COMMIT 'xa1';
106 include/sync_slave_sql_with_master.inc
107 include/assert_binlog_events.inc [Gtid # Query # Gtid # Transaction_payload # Query # Table_map # Write_rows # Xid # Gtid # Transaction_payload # Query/XA START.* # Table_map # Write_rows # Query/XA END.* # XA_prepare # Gtid # Query/XA COMMIT.*]
108 include/diff_tables.inc [master:test.t1,slave:test.t1]
109 [connection master]
110 DROP TABLE t1;
111 include/sync_slave_sql_with_master.inc
112 [connection master]
113 include/rpl_reset.inc
114 CREATE TABLE t1 (a INT PRIMARY KEY, b INT);
115 include/sync_slave_sql_with_master.inc
116 include/stop_slave_sql.inc
117 SET @@global.replica_parallel_type = 'LOGICAL_CLOCK';
118 Warnings:
119 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
120 include/start_slave_sql.inc
121 [connection slave1]
122 BEGIN;
123 INSERT INTO t1 SET a = 10, b = 11;
124 [connection master]
125 INSERT INTO t1 SET a = 22, b = 22;
126 XA START 'xa1';
127 INSERT INTO t1 SET a = 10, b = 1;
128 XA END 'xa1';
129 XA PREPARE 'xa1';
130 include/assert_binlog_events.inc [Gtid # Query # Gtid # Transaction_payload # Query # Table_map # Write_rows # Xid # Gtid # Transaction_payload # Query/XA START.* # Table_map # Write_rows # Query/XA END.* # XA_prepare]
131 [connection slave]
132 [connection slave1]
133 ROLLBACK;
134 [connection master]
135 XA COMMIT 'xa1';
136 include/sync_slave_sql_with_master.inc
137 include/assert_binlog_events.inc [Gtid # Query # Gtid # Transaction_payload # Query # Table_map # Write_rows # Xid # Gtid # Transaction_payload # Query/XA START.* # Table_map # Write_rows # Query/XA END.* # XA_prepare # Gtid # Query/XA COMMIT.*]
138 include/diff_tables.inc [master:test.t1,slave:test.t1]
139 [connection master]
140 DROP TABLE t1;
141 include/sync_slave_sql_with_master.inc
142 include/stop_slave_sql.inc
143 SET @@global.replica_parallel_workers = 0;
144 Warnings:
145 Warning 1287 '0' is deprecated and will be removed in a future release. Please use 1 instead
146 include/start_slave_sql.inc
147 [connection master]
148 include/rpl_reset.inc
149 CREATE TABLE t1 (a INT PRIMARY KEY, b INT);
150 include/sync_slave_sql_with_master.inc
151 include/stop_slave_sql.inc
152 SET @@global.replica_parallel_type = 'DATABASE';
153 Warnings:
154 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
155 include/start_slave_sql.inc
156 [connection slave1]
157 BEGIN;
158 INSERT INTO t1 SET a = 10, b = 11;
159 [connection master]
160 INSERT INTO t1 SET a = 22, b = 22;
161 XA START 'xa1';
162 INSERT INTO t1 SET a = 10, b = 1;
163 XA END 'xa1';
164 XA PREPARE 'xa1';
165 include/assert_binlog_events.inc [Gtid # Query # Gtid # Transaction_payload # Query # Table_map # Write_rows # Xid # Gtid # Transaction_payload # Query/XA START.* # Table_map # Write_rows # Query/XA END.* # XA_prepare]
166 [connection slave]
167 [connection slave1]
168 ROLLBACK;
169 [connection master]
170 XA COMMIT 'xa1';
171 include/sync_slave_sql_with_master.inc
172 include/assert_binlog_events.inc [Gtid # Query # Gtid # Transaction_payload # Query # Table_map # Write_rows # Xid # Gtid # Transaction_payload # Query/XA START.* # Table_map # Write_rows # Query/XA END.* # XA_prepare # Gtid # Query/XA COMMIT.*]
173 include/diff_tables.inc [master:test.t1,slave:test.t1]
174 [connection master]
175 DROP TABLE t1;
176 include/sync_slave_sql_with_master.inc
177 [connection master]
178 include/rpl_reset.inc
179 CREATE TABLE t1 (a INT PRIMARY KEY, b INT);
180 include/sync_slave_sql_with_master.inc
181 include/stop_slave_sql.inc
182 SET @@global.replica_parallel_type = 'LOGICAL_CLOCK';
183 Warnings:
184 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
185 include/start_slave_sql.inc
186 [connection slave1]
187 BEGIN;
188 INSERT INTO t1 SET a = 10, b = 11;
189 [connection master]
190 INSERT INTO t1 SET a = 22, b = 22;
191 XA START 'xa1';
192 INSERT INTO t1 SET a = 10, b = 1;
193 XA END 'xa1';
194 XA PREPARE 'xa1';
195 include/assert_binlog_events.inc [Gtid # Query # Gtid # Transaction_payload # Query # Table_map # Write_rows # Xid # Gtid # Transaction_payload # Query/XA START.* # Table_map # Write_rows # Query/XA END.* # XA_prepare]
196 [connection slave]
197 [connection slave1]
198 ROLLBACK;
199 [connection master]
200 XA COMMIT 'xa1';
201 include/sync_slave_sql_with_master.inc
202 include/assert_binlog_events.inc [Gtid # Query # Gtid # Transaction_payload # Query # Table_map # Write_rows # Xid # Gtid # Transaction_payload # Query/XA START.* # Table_map # Write_rows # Query/XA END.* # XA_prepare # Gtid # Query/XA COMMIT.*]
203 include/diff_tables.inc [master:test.t1,slave:test.t1]
204 [connection master]
205 DROP TABLE t1;
206 include/sync_slave_sql_with_master.inc
207 include/stop_slave.inc
208 SET @@global.replica_transaction_retries= SAVED;
209 SET @@global.innodb_lock_wait_timeout= SAVED;
210 SET @@global.binlog_transaction_compression = SAVED;
211 SET @@global.replica_parallel_workers = SAVED;
212 SET @@global.replica_parallel_type = 'SAVED';
213 Warnings:
214 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
215 SET @@global.replica_preserve_commit_order = SAVED;
216 include/start_slave.inc
217 [connection master]
218 SET @@session.binlog_transaction_compression = SAVED;
219 include/rpl_end.inc