Debian Codegraph @

mysql-test/suite/galera/r/galera_vote_joined_skip.result

raw
1 connection node_4;
2 connection node_3;
3 connection node_2;
4 connection node_1;
5 # Correct Galera library found
6 connection node_1;
7 connection node_2;
8 connection node_3;
9 connection node_4;
10 connection node_1;
11 CREATE TABLE t1(pk INT AUTO_INCREMENT PRIMARY KEY);
12 CREATE PROCEDURE p1(IN max INT)
13 BEGIN
14 DECLARE i INT;
15 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
16 SET i = 0;
17 WHILE i < max DO
18 INSERT IGNORE INTO t1 VALUES (DEFAULT);
19 SET i = i + 1;
20 END WHILE;
21 END|
22 CALL p1(130);
23 connection node_4;
24 Shutting down server 4...
25 connection node_1;
26 SET SESSION wsrep_on = ON;
27 SET SESSION wsrep_sync_wait = 15;
28 SET GLOBAL debug = "+d,sync.wsrep_donor_state";
29 connection node_4;
30 Restarting server 4...
31 connection node_1;
32 SET SESSION DEBUG_SYNC = "now WAIT_FOR sync.wsrep_donor_state_reached";
33 Tables on server 1 flushed and locked for SST to server 4
34 SET SESSION DEBUG_SYNC = "now SIGNAL signal.wsrep_donor_state";
35 SET GLOBAL debug = "";
36 SET DEBUG_SYNC='RESET';
37 Wait for the state snapshot to be copied to server 4
38 SST script unlocked server 1
39 connection node_1;
40 CALL p1(130);
41 connection node_3;
42 SET SESSION wsrep_on = OFF;
43 CREATE TABLE t2(pk INT AUTO_INCREMENT PRIMARY KEY);
44 SET SESSION wsrep_on = ON;
45 INSERT INTO t2 VALUES (DEFAULT);
46 SET SESSION wsrep_on = OFF;
47 connection node_1;
48 CALL p1(130);
49 Waiting for server 3 to leave the cluster
50 connection node_1;
51 SET SESSION wsrep_on = ON;
52 SET SESSION wsrep_sync_wait = 15;
53 connection node_2;
54 SET SESSION wsrep_on = ON;
55 SET SESSION wsrep_sync_wait = 15;
56 connection node_4;
57 SET SESSION wsrep_on = ON;
58 SET SESSION wsrep_sync_wait = 15;
59 connection node_3;
60 Server 3 left the cluster, killing it...
61 Killed server 3.
62 Restarting server 3...
63 Waiting for server 3 to rejoin the cluster
64 connection node_1;
65 SET SESSION wsrep_on = ON;
66 SET SESSION wsrep_sync_wait = 15;
67 connection node_3;
68 sleeping for 20
69 Waiting ready
70 Server 3 restarted.
71 connection node_1;
72 SET SESSION wsrep_on = ON;
73 SET SESSION wsrep_sync_wait = 15;
74 connection node_1;
75 SELECT count(*) AS expect1_390 FROM t1;
76 expect1_390
77 390
78 connection node_2;
79 SELECT count(*) AS expect2_390 FROM t1;
80 expect2_390
81 390
82 connection node_3;
83 SELECT count(*) AS expect3_390 FROM t1;
84 expect3_390
85 390
86 connection node_4;
87 SELECT count(*) AS expect4_390 FROM t1;
88 expect4_390
89 390
90 DROP TABLE t1;
91 DROP PROCEDURE p1;
92 connection node_1;
93 CALL mtr.add_suppression("BF applier thread=.+ failed to open_and_lock_tables for Table ");
94 CALL mtr.add_suppression("Event 3 Write_rows_v1 apply failed: 1146");
95 connection node_2;
96 CALL mtr.add_suppression("BF applier thread=.+ failed to open_and_lock_tables for Table ");
97 CALL mtr.add_suppression("Event 3 Write_rows_v1 apply failed: 1146");
98 connection node_3;
99 CALL mtr.add_suppression("Vote 0 \\(success\\) on .+ is inconsistent with group");
100 connection node_4;
101 CALL mtr.add_suppression("BF applier thread=.+ failed to open_and_lock_tables for Table ");
102 CALL mtr.add_suppression("Event 3 Write_rows_v1 apply failed: 1146");