Debian Codegraph @

mysql-test/suite/galera/r/galera_vote_during_ist.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 SET SESSION wsrep_on = ON;
12 SET SESSION wsrep_sync_wait = 15;
13 CREATE TABLE t1(pk INT AUTO_INCREMENT PRIMARY KEY);
14 CREATE PROCEDURE p1(IN max INT)
15 BEGIN
16 DECLARE i INT;
17 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
18 SET i = 0;
19 WHILE i < max DO
20 INSERT IGNORE INTO t1 VALUES (DEFAULT);
21 SET i = i + 1;
22 END WHILE;
23 END|
24 CALL p1(130);
25 connection node_4;
26 Shutting down server 4...
27 connection node_1;
28 SET SESSION wsrep_on = ON;
29 SET SESSION wsrep_sync_wait = 15;
30 connection node_2;
31 SET SESSION wsrep_on = ON;
32 SET SESSION wsrep_sync_wait = 15;
33 connection node_3;
34 SET SESSION wsrep_on = ON;
35 SET SESSION wsrep_sync_wait = 15;
36 Server 4 left the cluster
37 connection node_1;
38 CALL p1(130);
39 connection node_1;
40 SET SESSION wsrep_on = OFF;
41 CREATE TABLE t2(pk INT AUTO_INCREMENT PRIMARY KEY);
42 SET SESSION wsrep_on = ON;
43 connection node_2;
44 SET SESSION wsrep_on = OFF;
45 CREATE TABLE t2(pk INT AUTO_INCREMENT PRIMARY KEY);
46 SET SESSION wsrep_on = ON;
47 connection node_3;
48 SET SESSION wsrep_on = OFF;
49 CREATE TABLE t2(pk INT AUTO_INCREMENT PRIMARY KEY);
50 SET SESSION wsrep_on = ON;
51 INSERT INTO t2 VALUES (DEFAULT);
52 CALL p1(130);
53 connection node_2;
54 connection node_3;
55 connection node_1;
56 SET GLOBAL debug = "+d,sync.wsrep_sst_donor_after_donation";
57 Restarting server 4
58 Wait for server 1 to become a donor
59 SET SESSION DEBUG_SYNC = "now WAIT_FOR sync.wsrep_sst_donor_after_donation_reached";
60 Server 1 got SST request from server 4
61 SET SESSION DEBUG_SYNC = "now SIGNAL signal.wsrep_sst_donor_after_donation_continue";
62 SET GLOBAL debug = "";
63 SET DEBUG_SYNC='RESET';
64 Waiting for server 4 to leave the cluster
65 connection node_2;
66 SET SESSION wsrep_on = ON;
67 SET SESSION wsrep_sync_wait = 15;
68 connection node_3;
69 SET SESSION wsrep_on = ON;
70 SET SESSION wsrep_sync_wait = 15;
71 connection node_4;
72 Server 4 left the cluster, killing it...
73 Killed server 4...
74 connection node_1;
75 connection node_4;
76 Restarting server 4...
77 connection node_1;
78 SET SESSION wsrep_on = ON;
79 SET SESSION wsrep_sync_wait = 15;
80 connection node_2;
81 SET SESSION wsrep_on = ON;
82 SET SESSION wsrep_sync_wait = 15;
83 connection node_3;
84 SET SESSION wsrep_on = ON;
85 SET SESSION wsrep_sync_wait = 15;
86 connection node_1;
87 SELECT count(*) AS expect1_390 FROM t1;
88 expect1_390
89 390
90 SELECT count(*) AS expect1_1 FROM t2;
91 expect1_1
92 1
93 connection node_2;
94 SELECT count(*) AS expect2_390 FROM t1;
95 expect2_390
96 390
97 SELECT count(*) AS expect2_1 FROM t2;
98 expect2_1
99 1
100 connection node_3;
101 SELECT count(*) AS expect3_390 FROM t1;
102 expect3_390
103 390
104 SELECT count(*) AS expect3_1 FROM t2;
105 expect3_1
106 1
107 connection node_4;
108 SELECT count(*) AS expect4_390 FROM t1;
109 expect4_390
110 390
111 SELECT count(*) AS expect4_1 FROM t2;
112 expect4_1
113 1
114 DROP TABLE t1;
115 DROP TABLE t2;
116 DROP PROCEDURE p1;
117 CALL mtr.add_suppression("BF applier thread=.+ failed to open_and_lock_tables for Table ");
118 CALL mtr.add_suppression("Event 3 Write_rows_v1 apply failed: 1146");
119 CALL mtr.add_suppression("Inconsistency detected: Failed on preordered");
120 CALL mtr.add_suppression("Failed to apply write set");
121 CALL mtr.add_suppression("Sending JOIN failed: -103");
122 CALL mtr.add_suppression("Failed to JOIN the cluster after SST");