Debian Codegraph @

mysql-test/suite/galera/r/galera_vote_joined_apply.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_1;
42 SET SESSION wsrep_on = OFF;
43 CREATE TABLE t2(pk INT AUTO_INCREMENT PRIMARY KEY);
44 SET SESSION wsrep_on = ON;
45 connection node_2;
46 SET SESSION wsrep_on = OFF;
47 CREATE TABLE t2(pk INT AUTO_INCREMENT PRIMARY KEY);
48 SET SESSION wsrep_on = ON;
49 connection node_3;
50 SET SESSION wsrep_on = OFF;
51 CREATE TABLE t2(pk INT AUTO_INCREMENT PRIMARY KEY);
52 SET SESSION wsrep_on = ON;
53 INSERT INTO t2 VALUES (DEFAULT);
54 CALL p1(130);
55 Waiting for server 4 to leave the cluster
56 SET SESSION wsrep_on = ON;
57 SET SESSION wsrep_sync_wait = 15;
58 connection node_2;
59 SET SESSION wsrep_on = ON;
60 SET SESSION wsrep_sync_wait = 15;
61 connection node_1;
62 SET SESSION wsrep_on = ON;
63 SET SESSION wsrep_sync_wait = 15;
64 connection node_4;
65 Server 4 left the cluster, killing it...
66 Killed server 4...
67 Restarting server 4...
68 DROP TABLE t2;
69 connection node_1;
70 SET SESSION wsrep_on = ON;
71 SET SESSION wsrep_sync_wait = 15;
72 connection node_1;
73 SELECT count(*) AS expect1_390 FROM t1;
74 expect1_390
75 390
76 connection node_2;
77 SELECT count(*) AS expect2_390 FROM t1;
78 expect2_390
79 390
80 connection node_3;
81 SELECT count(*) AS expect3_390 FROM t1;
82 expect3_390
83 390
84 connection node_4;
85 SELECT count(*) AS expect4_390 FROM t1;
86 expect4_390
87 390
88 DROP TABLE t1;
89 DROP PROCEDURE p1;
90 connection node_4;
91 CALL mtr.add_suppression("BF applier thread=.+ failed to open_and_lock_tables for Table ");
92 CALL mtr.add_suppression("Event 3 Write_rows_v1 apply failed: 1146");
93 CALL mtr.add_suppression("Inconsistency detected: Inconsistent by consensus");
94 CALL mtr.add_suppression("Failed to apply write set: gtid:");