Debian Codegraph @

mysql-test/extra/xa_crash_safe_tests/setup.inc

raw
1 # ==== Purpose ====
2 #
3 # Used by scripts testing XA crash recovery, it sets up the scenario
4 # requirements, for instance, creates table and inserts records, sets up
5 # GR, initializes constants used in the tests, etc.
6 #
7 # ==== Parameters ====
8 #
9 # $xid
10 # The XID of the XA transaction that is going to be used in the test.
11 #
12 # ==== References ====
13 #
14 # Related tests:
15 #
16 # - mysql-test/t/xa_commit_failure_before_commit_engines.test
17 # - mysql-test/t/xa_commit_failure_before_commit_tc.test
18 # - mysql-test/t/xa_commit_failure_before_gtid_externalization.test
19 # - mysql-test/t/xa_commit_one_phase_failure_before_commit_engines.test
20 # - mysql-test/t/xa_commit_one_phase_failure_before_commit_tc.test
21 # - mysql-test/t/xa_commit_one_phase_failure_before_gtid_externalization.test
22 # - mysql-test/t/xa_prepare_failure_before_gtid_externalization.test
23 # - mysql-test/t/xa_prepare_failure_before_prepare_2nd_phase.test
24 # - mysql-test/t/xa_prepare_failure_before_prepare_in_engines.test
25 # - mysql-test/t/xa_prepare_failure_before_prepare_tc.test
26 # - mysql-test/t/xa_rollback_failure_before_gtid_externalization.test
27 # - mysql-test/t/xa_rollback_failure_before_rollback_engines.test
28 # - mysql-test/t/xa_rollback_failure_before_rollback_tc.test
29 #
30 # - mysql-test/suite/binlog/t/binlog_xa_recovery_errors.test
31 #
32 # - mysql-test/suite/binlog_gtid/t/binlog_gtid_xa_multiple_failures.test
33 # - mysql-test/suite/binlog_gtid/t/binlog_gtid_binlog_recovery_errors.test
34 # - mysql-test/suite/binlog_gtid/t/binlog_gtid_xa_commit_failure_after_rotate.test
35 # - mysql-test/suite/binlog_gtid/t/binlog_gtid_xa_commit_failure_before_commit_engines.test
36 # - mysql-test/suite/binlog_gtid/t/binlog_gtid_xa_commit_failure_before_gtid_externalization.test
37 # - mysql-test/suite/binlog_gtid/t/binlog_gtid_xa_commit_failure_before_write_binlog.test
38 # - mysql-test/suite/binlog_gtid/t/binlog_gtid_xa_commit_one_phase_failure_before_commit_engines.test
39 # - mysql-test/suite/binlog_gtid/t/binlog_gtid_xa_commit_one_phase_failure_before_gtid_externalizatio .test
40 # - mysql-test/suite/binlog_gtid/t/binlog_gtid_xa_commit_one_phase_failure_before_prepare_in_engines.test
41 # - mysql-test/suite/binlog_gtid/t/binlog_gtid_xa_commit_one_phase_failure_before_write_binlog.test
42 # - mysql-test/suite/binlog_gtid/t/binlog_gtid_xa_prepare_failure_before_gtid_externalization.test
43 # - mysql-test/suite/binlog_gtid/t/binlog_gtid_xa_prepare_failure_before_prepare_2nd_phase.test
44 # - mysql-test/suite/binlog_gtid/t/binlog_gtid_xa_prepare_failure_before_prepare_in_engines.test
45 # - mysql-test/suite/binlog_gtid/t/binlog_gtid_xa_prepare_failure_before_write_binlog.test
46 # - mysql-test/suite/binlog_gtid/t/binlog_gtid_xa_rollback_failure_after_rotate.test
47 # - mysql-test/suite/binlog_gtid/t/binlog_gtid_xa_rollback_failure_before_gtid_externalization.test
48 # - mysql-test/suite/binlog_gtid/t/binlog_gtid_xa_rollback_failure_before_rollback_engines.test
49 # - mysql-test/suite/binlog_gtid/t/binlog_gtid_xa_rollback_failure_before_write_binlog.test
50 #
51 # - mysql-test/suite/group_replication/t/gr_xa_commit_failure_after_rotate.test
52 # - mysql-test/suite/group_replication/t/gr_xa_commit_failure_before_broadcast.test
53 # - mysql-test/suite/group_replication/t/gr_xa_commit_failure_before_commit_engines.test
54 # - mysql-test/suite/group_replication/t/gr_xa_commit_failure_before_gtid_externalization.test
55 # - mysql-test/suite/group_replication/t/gr_xa_commit_failure_before_write_binlog.test
56 # - mysql-test/suite/group_replication/t/gr_xa_commit_one_phase_failure_before_broadcast.test
57 # - mysql-test/suite/group_replication/t/gr_xa_commit_one_phase_failure_before_commit_engines.test
58 # - mysql-test/suite/group_replication/t/gr_xa_commit_one_phase_failure_before_gtid_externalization.test
59 # - mysql-test/suite/group_replication/t/gr_xa_commit_one_phase_failure_before_prepare_in_engines.tes
60 # - mysql-test/suite/group_replication/t/gr_xa_commit_one_phase_failure_before_write_binlog.test
61 # - mysql-test/suite/group_replication/t/gr_xa_prepare_failure_before_broadcast.test
62 # - mysql-test/suite/group_replication/t/gr_xa_prepare_failure_before_gtid_externalization.test
63 # - mysql-test/suite/group_replication/t/gr_xa_prepare_failure_before_prepare_2nd_phase.test
64 # - mysql-test/suite/group_replication/t/gr_xa_prepare_failure_before_prepare_in_engines.test
65 # - mysql-test/suite/group_replication/t/gr_xa_prepare_failure_before_write_binlog.test
66 # - mysql-test/suite/group_replication/t/gr_xa_rollback_failure_after_rotate.test
67 # - mysql-test/suite/group_replication/t/gr_xa_rollback_failure_before_broadcast.test
68 # - mysql-test/suite/group_replication/t/gr_xa_rollback_failure_before_gtid_externalization.test
69 # - mysql-test/suite/group_replication/t/gr_xa_rollback_failure_before_rollback_engines.test
70 # - mysql-test/suite/group_replication/t/gr_xa_rollback_failure_before_write_binlog.test
71 #
72 # - mysql-test/suite/rpl_gtid/t/rpl_gtid_xa_multiple_failures.test
73 # - mysql-test/suite/rpl_gtid/t/rpl_gtid_xa_commit_failure_after_rotate.test
74 # - mysql-test/suite/rpl_gtid/t/rpl_gtid_xa_commit_failure_before_commit_engines.test
75 # - mysql-test/suite/rpl_gtid/t/rpl_gtid_xa_commit_failure_before_gtid_externalization.test
76 # - mysql-test/suite/rpl_gtid/t/rpl_gtid_xa_commit_failure_before_write_binlog.test
77 # - mysql-test/suite/rpl_gtid/t/rpl_gtid_xa_commit_one_phase_failure_before_commit_engines.test
78 # - mysql-test/suite/rpl_gtid/t/rpl_gtid_xa_commit_one_phase_failure_before_gtid_externalization.test
79 # - mysql-test/suite/rpl_gtid/t/rpl_gtid_xa_commit_one_phase_failure_before_prepare_in_engines.test
80 # - mysql-test/suite/rpl_gtid/t/rpl_gtid_xa_commit_one_phase_failure_before_write_binlog.test
81 # - mysql-test/suite/rpl_gtid/t/rpl_gtid_xa_prepare_failure_before_gtid_externalization.test
82 # - mysql-test/suite/rpl_gtid/t/rpl_gtid_xa_prepare_failure_before_prepare_2nd_phase.test
83 # - mysql-test/suite/rpl_gtid/t/rpl_gtid_xa_prepare_failure_before_prepare_in_engines.test
84 # - mysql-test/suite/rpl_gtid/t/rpl_gtid_xa_prepare_failure_before_write_binlog.test
85 # - mysql-test/suite/rpl_gtid/t/rpl_gtid_xa_rollback_failure_after_rotate.test
86 # - mysql-test/suite/rpl_gtid/t/rpl_gtid_xa_rollback_failure_before_gtid_externalization.test
87 # - mysql-test/suite/rpl_gtid/t/rpl_gtid_xa_rollback_failure_before_rollback_engines.test
88 # - mysql-test/suite/rpl_gtid/t/rpl_gtid_xa_rollback_failure_before_write_binlog.test
89 #
90
91 if ($xid == '') {
92 --die ERROR IN TEST: You must set $xid before sourcing xa_crash_safe_testing_setup.inc
93 }
94
95 # Add suppression for XA transaction related warning
96 let $messages = Found .* prepared XA transactions
97 .*Checksum mismatch in datafile.*;
98 --source include/suppress_messages.inc
99
100 # If in the GR setup
101 if ($rpl_group_replication == 1) {
102 --let $rpl_connection_name = server1
103 --source include/rpl_connection.inc
104
105 --source include/start_and_bootstrap_group_replication.inc
106 --let $_group_replication_local_address = `SELECT @@GLOBAL.group_replication_local_address`
107 --let $_group_replication_group_seeds = `SELECT @@GLOBAL.group_replication_group_seeds`
108 --let $_group_replication_group_name = `SELECT @@GLOBAL.group_replication_group_name`
109 }
110
111 # Create the table and insert records
112 CREATE TABLE t1 (c1 INT PRIMARY KEY);
113
114 --eval XA START $xid
115 INSERT INTO t1 VALUES (2);
116 --eval XA END $xid
117 --eval XA PREPARE $xid
118 --eval XA COMMIT $xid
119
120 # Allow for `save_binlog_position.inc` to save the binlog info in the
121 # connection session in order for the tests to be able to use
122 # `assert_binlog_events.inc` for more than one server.
123 --let $save_binlog_position_in_sql = 1
124
125 if ($rpl_group_replication == 1) {
126 # Bootstrap server 2
127 --let $rpl_connection_name = server2
128 --source include/rpl_connection.inc
129 --let $sysvars_to_save = [ "GLOBAL.group_replication_member_expel_timeout" ]
130 --source include/save_sysvars.inc
131 SET GLOBAL group_replication_member_expel_timeout = 0;
132 --source include/start_group_replication.inc
133 # Save binlog position for server 2
134 --source include/save_binlog_position.inc
135
136 # Bootstrap server 2
137 --let $rpl_connection_name = server3
138 --source include/rpl_connection.inc
139 --let $sysvars_to_save = [ "GLOBAL.group_replication_member_expel_timeout" ]
140 --source include/save_sysvars.inc
141 SET GLOBAL group_replication_member_expel_timeout = 0;
142 --source include/start_group_replication.inc
143
144 # Save binlog position for server 1
145 --let $rpl_connection_name = server1
146 --source include/rpl_connection.inc
147 --source include/save_binlog_position.inc
148 }
149
150 # If not in GR mode
151 if ($rpl_group_replication != 1) {
152 # If not in source->replica mode
153 if ($rpl_inited) {
154 --source include/sync_slave_sql_with_master.inc
155 }
156 if (`SELECT @@GLOBAL.log_bin != 0`) {
157 # Save binlog position for the current server
158 --source include/save_binlog_position.inc
159 }
160 if ($rpl_inited) {
161 --source include/rpl_connection_master.inc
162 }
163 }
164
165 # Initialize constants to be used with `assert_binlog_events.inc`
166 --let $empty_event_sequence = ()
167 --let $view_change = Gtid # Query/BEGIN # View_change # Query/COMMIT
168 --let $xa_start_end = Query/XA START $xid # Table_map # Write_rows # Query/XA END $xid