Debian Codegraph @

mysql-test/suite/wsrep/r/wsrep-recover.result

raw
1 # Kill the server
2 Expect seqno 1
3 1
4 CREATE TABLE t1 (f1 INT PRIMARY KEY) ENGINE=InnoDB;
5 # Kill the server
6 Expect seqno 3
7 3
8 INSERT INTO t1 VALUES (5);
9 # Kill the server
10 Expect seqno 5
11 5
12 SELECT VARIABLE_VALUE `expect 6` FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed';
13 expect 6
14 6
15 connect con1, localhost, root;
16 SET DEBUG_SYNC = "wsrep_after_certification SIGNAL after_certification_reached WAIT_FOR continue";
17 INSERT INTO t1 VALUES (7);
18 connect con_ctrl, localhost, root;
19 SET DEBUG_SYNC = "now WAIT_FOR after_certification_reached";
20 connect con2, localhost, root;
21 SET DEBUG_SYNC = "wsrep_before_commit_order_enter SIGNAL before_commit_order_reached WAIT_FOR continue";
22 INSERT INTO t1 VALUES (8);
23 connection con_ctrl;
24 SET DEBUG_SYNC = "now WAIT_FOR before_commit_order_reached";
25 connection default;
26 # Kill the server
27 Expect seqno 6
28 6
29 disconnect con1;
30 disconnect con2;
31 disconnect con_ctrl;
32 connection default;
33 SELECT VARIABLE_VALUE `expect 7` FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed';
34 expect 7
35 7
36 connect con1, localhost, root;
37 SET DEBUG_SYNC = "wsrep_after_certification SIGNAL after_certification_reached WAIT_FOR continue_after_certification";
38 SET DEBUG_SYNC = "wsrep_before_commit_order_enter SIGNAL before_commit_order_reached_1 WAIT_FOR continue_before_commit_order_1";
39 INSERT INTO t1 VALUES (9);
40 connect con_ctrl, localhost, root;
41 SET DEBUG_SYNC = "now WAIT_FOR after_certification_reached";
42 connect con2, localhost, root;
43 SET DEBUG_SYNC = "wsrep_before_commit_order_enter SIGNAL before_commit_order_reached_2 WAIT_FOR continue_before_commit_order_2";
44 INSERT INTO t1 VALUES (10);
45 connection con_ctrl;
46 SET DEBUG_SYNC = "now WAIT_FOR before_commit_order_reached_2";
47 SET DEBUG_SYNC = "now SIGNAL continue_after_certification";
48 SET DEBUG_SYNC = "now WAIT_FOR before_commit_order_reached_1";
49 connection default;
50 # Kill the server
51 Expect seqno 7
52 7
53 disconnect con1;
54 disconnect con2;
55 disconnect con_ctrl;
56 connection default;
57 SELECT VARIABLE_VALUE `expect 8` FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed';
58 expect 8
59 8
60 Expect row 5
61 SELECT * FROM t1;
62 f1
63 5
64 DROP TABLE t1;