1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
CREATE TABLE t1 (f1 INT PRIMARY KEY) ENGINE=InnoDB;
connect con1, localhost, root;
SET DEBUG_SYNC = "wsrep_after_certification SIGNAL after_certification_reached WAIT_FOR continue_after_certification";
SET DEBUG_SYNC = "wsrep_before_commit_order_enter SIGNAL before_commit_order_reached_1 WAIT_FOR continue_before_commit_order_1";
INSERT INTO t1 VALUES (9);
connect con_ctrl, localhost, root;
SET DEBUG_SYNC = "now WAIT_FOR after_certification_reached";
connect con2, localhost, root;
SET DEBUG_SYNC = "wsrep_before_commit_order_enter SIGNAL before_commit_order_reached_2 WAIT_FOR continue_before_commit_order_2";
INSERT INTO t1 VALUES (10);
connection con_ctrl;
SET DEBUG_SYNC = "now WAIT_FOR before_commit_order_reached_2";
SET DEBUG_SYNC = "now SIGNAL continue_after_certification";
SET DEBUG_SYNC = "now WAIT_FOR before_commit_order_reached_1";
connection default;
# Kill the server
XA RECOVER;
formatID gtrid_length bqual_length data
disconnect con1;
disconnect con2;
disconnect con_ctrl;
connection default;
DROP TABLE t1;
CALL mtr.add_suppression("You need to use --log-bin to make --binlog-format work");
|
