Debian Codegraph @

mysql-test/suite/galera/r/MDEV-16509.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 INT PRIMARY KEY) ENGINE=InnoDB;
4 SET SESSION wsrep_sync_wait = 0;
5 connection node_1;
6 SET SESSION wsrep_sync_wait = 0;
7 SET DEBUG_SYNC = "wsrep_before_commit_order_leave SIGNAL bcol_reached WAIT_FOR bcol_continue";
8 SET DEBUG_SYNC = "wsrep_after_commit_order_leave SIGNAL acol_reached WAIT_FOR acol_continue";
9 SET DEBUG_SYNC = "after_group_after_commit SIGNAL after_group_reached WAIT_FOR after_group_continue";
10 INSERT INTO t1 VALUES (1);
11 connection ctrl;
12 SET DEBUG_SYNC = "now WAIT_FOR bcol_reached";
13 wsrep_last_seen_gtid_match
14 1
15 SELECT * FROM t1;
16 f1
17 1
18 SET DEBUG_SYNC = "now SIGNAL bcol_continue";
19 SET DEBUG_SYNC = "now WAIT_FOR acol_reached";
20 wsrep_last_seen_gtid_match
21 1
22 SELECT * FROM t1;
23 f1
24 1
25 SET DEBUG_SYNC = "now SIGNAL acol_continue";
26 SET DEBUG_SYNC = "now WAIT_FOR after_group_reached";
27 wsrep_last_seen_gtid_do_not_match
28 1
29 SET DEBUG_SYNC = "now SIGNAL after_group_continue";
30 connection node_1;
31 SELECT * from t1;
32 f1
33 1
34 connection ctrl;
35 SET DEBUG_SYNC = "RESET";
36 SET SESSION wsrep_sync_wait = 0;
37 connection ctrl;
38 connection node_1;
39 SET DEBUG_SYNC = "wsrep_before_commit_order_leave SIGNAL bcol_reached_1 WAIT_FOR bcol_continue_1";
40 SET DEBUG_SYNC = "wsrep_after_commit_order_leave SIGNAL acol_reached_1 WAIT_FOR acol_continue_1";
41 SET DEBUG_SYNC = "after_group_after_commit SIGNAL agac_reached_1 WAIT_FOR agac_continue_1";
42 INSERT INTO t1 VALUES (2);;
43 connection ctrl;
44 SET DEBUG_SYNC = "now WAIT_FOR bcol_reached_1";
45 wsrep_last_seen_gtid_match
46 1
47 connection node_1a;
48 SET DEBUG_SYNC = "wsrep_before_commit_order_leave SIGNAL bcol_reached_2 WAIT_FOR bcol_continue_2";
49 SET DEBUG_SYNC = "wsrep_after_commit_order_leave SIGNAL acol_reached_2 WAIT_FOR acol_continue_2";
50 SET DEBUG_SYNC = "after_group_after_commit SIGNAL agac_reached_2 WAIT_FOR agac_continue_2";
51 INSERT INTO t1 VALUES (3);;
52 connection ctrl;
53 SET DEBUG_SYNC = "now SIGNAL bcol_continue_1";
54 SET DEBUG_SYNC = "now WAIT_FOR acol_reached_1";
55 SET DEBUG_SYNC = "now WAIT_FOR bcol_reached_2";
56 wsrep_last_seen_gtid_match
57 1
58 SET DEBUG_SYNC = "now SIGNAL bcol_continue_2";
59 SET DEBUG_SYNC = "now WAIT_FOR acol_reached_2";
60 wsrep_last_seen_gtid_match
61 1
62 SET DEBUG_SYNC = "now SIGNAL acol_continue_1";
63 SET DEBUG_SYNC = "now WAIT_FOR agac_reached_1";
64 wsrep_last_seen_gtid_no_match
65 1
66 SET DEBUG_SYNC = "now SIGNAL acol_continue_2";
67 SET DEBUG_SYNC = "now WAIT_FOR agac_reached_2";
68 wsrep_last_seen_gtid_no_match
69 1
70 SET DEBUG_SYNC = "now SIGNAL agac_continue_1";
71 connection node_1;
72 connection ctrl;
73 SET DEBUG_SYNC = "now SIGNAL agac_continue_2";
74 connection node_1a;
75 connection ctrl;
76 SET DEBUG_SYNC = "RESET";
77 SELECT * from t1;
78 f1
79 1
80 2
81 3
82 DROP TABLE t1;
83 disconnect ctrl;
84 disconnect node_1a;
85 disconnect node_2;
86 disconnect node_1;