| 1 |
include/only_with_option.inc [GLOBAL.replica_parallel_type = 'LOGICAL_CLOCK'] |
| 2 |
include/only_with_option.inc [GLOBAL.replica_parallel_workers != 0] |
| 3 |
include/only_with_option.inc [GLOBAL.binlog_order_commits = 1] |
| 4 |
include/master-slave.inc |
| 5 |
Warnings: |
| 6 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 7 |
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. |
| 8 |
[connection master] |
| 9 |
[connection slave] |
| 10 |
include/save_sysvars.inc [ |
| 11 |
"GLOBAL.replica_preserve_commit_order", |
| 12 |
"GLOBAL.replica_parallel_workers" |
| 13 |
] |
| 14 |
SET @@GLOBAL.replica_preserve_commit_order = 0; |
| 15 |
SET @@GLOBAL.replica_parallel_workers = 4; |
| 16 |
include/start_slave.inc |
| 17 |
[connection master] |
| 18 |
include/suppress_messages.inc |
| 19 |
# Connection 1 suppresses message <Found .* prepared XA transactions>. |
| 20 |
# Connection 1 suppresses message <.*Checksum mismatch in datafile.*>. |
| 21 |
# Connection 2 suppresses message <Found .* prepared XA transactions>. |
| 22 |
# Connection 2 suppresses message <.*Checksum mismatch in datafile.*>. |
| 23 |
CREATE TABLE t1 (c1 INT PRIMARY KEY); |
| 24 |
XA START 'xid0'; |
| 25 |
INSERT INTO t1 VALUES (2); |
| 26 |
XA END 'xid0'; |
| 27 |
XA PREPARE 'xid0'; |
| 28 |
XA COMMIT 'xid0'; |
| 29 |
include/sync_slave_sql_with_master.inc |
| 30 |
include/save_binlog_position.inc |
| 31 |
[connection master] |
| 32 |
# Adding debug point 'set_commit_parent_100' to @@GLOBAL.debug |
| 33 |
XA START 'xid1'; |
| 34 |
INSERT INTO t1 VALUES (3); |
| 35 |
XA END 'xid1'; |
| 36 |
include/execute_to_conditional_timestamp_sync_point.inc [before_prepare_in_engines] |
| 37 |
XA PREPARE 'xid1'; |
| 38 |
XA START 'xid2'; |
| 39 |
INSERT INTO t1 VALUES (4); |
| 40 |
XA END 'xid2'; |
| 41 |
include/execute_to_conditional_timestamp_sync_point.inc [after_ha_prepare_low] |
| 42 |
XA PREPARE 'xid2'; |
| 43 |
XA START 'xid3'; |
| 44 |
INSERT INTO t1 VALUES (5); |
| 45 |
XA END 'xid3'; |
| 46 |
include/execute_to_conditional_timestamp_sync_point.inc [before_set_prepared_in_tc] |
| 47 |
XA PREPARE 'xid3'; |
| 48 |
XA START 'xid4'; |
| 49 |
INSERT INTO t1 VALUES (6); |
| 50 |
XA END 'xid4'; |
| 51 |
include/execute_to_conditional_timestamp_sync_point.inc [after_writing_to_tc_log] |
| 52 |
XA PREPARE 'xid4'; |
| 53 |
[connection slave] |
| 54 |
# Kill the server |
| 55 |
# restart:--replica-preserve-commit-order=0 |
| 56 |
include/rpl_reconnect.inc |
| 57 |
include/assert.inc [Found log message(s) for "Rolling back trx with id %, 1 rows to undo"] |
| 58 |
include/assert.inc [Found 1 log message(s) for "Successfully rolled back 1, prepared 2 XA transaction"] |
| 59 |
include/assert.inc [2 XA transaction(s) in PREPARED state] |
| 60 |
include/start_slave.inc |
| 61 |
[connection master] |
| 62 |
include/sync_slave_sql_with_master.inc |
| 63 |
[connection master] |
| 64 |
XA ROLLBACK 'xid1'; |
| 65 |
XA ROLLBACK 'xid2'; |
| 66 |
XA ROLLBACK 'xid3'; |
| 67 |
XA ROLLBACK 'xid4'; |
| 68 |
include/sync_slave_sql_with_master.inc |
| 69 |
[connection master] |
| 70 |
XA START 'xid5'; |
| 71 |
INSERT INTO t1 VALUES (7); |
| 72 |
XA END 'xid5'; |
| 73 |
XA PREPARE 'xid5'; |
| 74 |
XA START 'xid6'; |
| 75 |
INSERT INTO t1 VALUES (8); |
| 76 |
XA END 'xid6'; |
| 77 |
XA PREPARE 'xid6'; |
| 78 |
XA START 'xid7'; |
| 79 |
INSERT INTO t1 VALUES (9); |
| 80 |
XA END 'xid7'; |
| 81 |
XA PREPARE 'xid7'; |
| 82 |
include/sync_slave_sql_with_master.inc |
| 83 |
include/execute_to_conditional_timestamp_sync_point.inc [before_commit_xa_trx] |
| 84 |
XA COMMIT 'xid5'; |
| 85 |
include/execute_to_conditional_timestamp_sync_point.inc [before_invoke_before_commit_hook] |
| 86 |
XA COMMIT 'xid6'; |
| 87 |
include/execute_to_conditional_timestamp_sync_point.inc [before_commit_in_engines] |
| 88 |
XA COMMIT 'xid7'; |
| 89 |
[connection slave] |
| 90 |
# Kill the server |
| 91 |
# restart:--replica-preserve-commit-order=0 |
| 92 |
include/rpl_reconnect.inc |
| 93 |
include/assert.inc [Found 1 log message(s) for "Successfully committed 1, prepared 2 XA transaction"] |
| 94 |
include/assert.inc [2 XA transaction(s) in PREPARED state] |
| 95 |
include/start_slave.inc |
| 96 |
[connection master] |
| 97 |
include/sync_slave_sql_with_master.inc |
| 98 |
XA START 'xid8'; |
| 99 |
INSERT INTO t1 VALUES (10); |
| 100 |
XA END 'xid8'; |
| 101 |
XA PREPARE 'xid8'; |
| 102 |
XA START 'xid9'; |
| 103 |
INSERT INTO t1 VALUES (11); |
| 104 |
XA END 'xid9'; |
| 105 |
XA PREPARE 'xid9'; |
| 106 |
XA START 'xid10'; |
| 107 |
INSERT INTO t1 VALUES (12); |
| 108 |
XA END 'xid10'; |
| 109 |
XA PREPARE 'xid10'; |
| 110 |
include/sync_slave_sql_with_master.inc |
| 111 |
include/execute_to_conditional_timestamp_sync_point.inc [before_rollback_xa_trx] |
| 112 |
XA ROLLBACK 'xid8'; |
| 113 |
include/execute_to_conditional_timestamp_sync_point.inc [before_invoke_before_commit_hook] |
| 114 |
XA ROLLBACK 'xid9'; |
| 115 |
include/execute_to_conditional_timestamp_sync_point.inc [before_rollback_in_engines] |
| 116 |
XA ROLLBACK 'xid10'; |
| 117 |
[connection slave] |
| 118 |
# Kill the server |
| 119 |
# restart:--replica-preserve-commit-order=0 |
| 120 |
include/rpl_reconnect.inc |
| 121 |
include/assert.inc [Found 1 log message(s) for "Successfully rolled back 1, prepared 2 XA transaction"] |
| 122 |
include/assert.inc [2 XA transaction(s) in PREPARED state] |
| 123 |
include/start_slave.inc |
| 124 |
[connection master] |
| 125 |
UPDATE t1 SET c1 = 200 WHERE c1 = 2; |
| 126 |
include/sync_slave_sql_with_master.inc |
| 127 |
XA START 'xid11'; |
| 128 |
INSERT INTO t1 VALUES (13); |
| 129 |
XA END 'xid11'; |
| 130 |
include/execute_to_conditional_timestamp_sync_point.inc [before_prepare_in_engines] |
| 131 |
XA COMMIT 'xid11' ONE PHASE; |
| 132 |
XA START 'xid12'; |
| 133 |
INSERT INTO t1 VALUES (14); |
| 134 |
XA END 'xid12'; |
| 135 |
include/execute_to_conditional_timestamp_sync_point.inc [before_invoke_before_commit_hook] |
| 136 |
XA COMMIT 'xid12' ONE PHASE; |
| 137 |
XA START 'xid13'; |
| 138 |
INSERT INTO t1 VALUES (15); |
| 139 |
XA END 'xid13'; |
| 140 |
include/execute_to_conditional_timestamp_sync_point.inc [before_commit_in_engines] |
| 141 |
XA COMMIT 'xid13' ONE PHASE; |
| 142 |
[connection slave] |
| 143 |
# Kill the server |
| 144 |
# restart:--replica-preserve-commit-order=0 |
| 145 |
include/rpl_reconnect.inc |
| 146 |
include/assert.inc [Found log message(s) for "Rolling back trx with id %, 1 rows to undo"] |
| 147 |
include/assert.inc [Found 1 log message(s) for "Successfully committed 1, rolled back 1 XA transaction"] |
| 148 |
include/assert.inc [No XA transactions in PREPARED state] |
| 149 |
include/restore_sysvars.inc |
| 150 |
include/start_slave.inc |
| 151 |
[connection master] |
| 152 |
# Removing debug point 'set_commit_parent_100' from @@GLOBAL.debug |
| 153 |
DROP TABLE t1; |
| 154 |
include/rpl_end.inc |