Debian Codegraph @

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

raw
1 connection node_4;
2 connection node_3;
3 connection node_2;
4 connection node_1;
5 connection node_1;
6 connection node_2;
7 connection node_3;
8 connection node_4;
9 connection node_1;
10 SET GLOBAL wsrep_provider_options = 'pc.weight=2';
11 connection node_3;
12 SET GLOBAL wsrep_provider_options = 'gmcast.isolate = 1';
13 connection node_1;
14 connection node_1;
15 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 CHAR(10)) ENGINE=InnoDB;
16 INSERT INTO t1 VALUES (1, 'A');
17 connection node_4;
18 SET SESSION wsrep_on=OFF;
19 INSERT INTO t1 VALUES (2, 'B');
20 SET SESSION wsrep_on=ON;
21 DELETE FROM t1 WHERE f1 = 2;
22 connection node_1;
23 connection node_3;
24 SET SESSION wsrep_on = ON;
25 SET SESSION wsrep_sync_wait = 15;
26 SET GLOBAL wsrep_provider_options = 'gmcast.isolate = 0';
27 connection node_1;
28 connection node_3;
29 SELECT COUNT(*) = 1 FROM t1 WHERE f2 = 'A';
30 COUNT(*) = 1
31 1
32 SELECT COUNT(*) = 0 FROM t1 WHERE f2 = 'B';
33 COUNT(*) = 0
34 1
35 connection node_4;
36 SET SESSION wsrep_on=OFF;
37 Killing server ...
38 Starting mysqld
39 connection node_1;
40 connection node_1;
41 SELECT COUNT(*) = 1 FROM t1 WHERE f2 = 'A';
42 COUNT(*) = 1
43 1
44 SELECT COUNT(*) = 0 FROM t1 WHERE f2 = 'B';
45 COUNT(*) = 0
46 1
47 CALL mtr.add_suppression("mariadbd: Can't find record in 't1'");
48 CALL mtr.add_suppression("Slave SQL: Could not execute Delete_rows");
49 CALL mtr.add_suppression("WSREP: Event 3 Delete_rows_v1 apply failed: 120, seqno ");
50 SET GLOBAL wsrep_provider_options = 'pc.weight=1';
51 connection node_2;
52 SELECT COUNT(*) = 1 FROM t1 WHERE f2 = 'A';
53 COUNT(*) = 1
54 1
55 SELECT COUNT(*) = 0 FROM t1 WHERE f2 = 'B';
56 COUNT(*) = 0
57 1
58 CALL mtr.add_suppression("mariadbd: Can't find record in 't1'");
59 CALL mtr.add_suppression("Slave SQL: Could not execute Delete_rows");
60 CALL mtr.add_suppression("WSREP: Event 3 Delete_rows_v1 apply failed: 120, seqno ");
61 connection node_3;
62 SELECT COUNT(*) = 1 FROM t1 WHERE f2 = 'A';
63 COUNT(*) = 1
64 1
65 SELECT COUNT(*) = 0 FROM t1 WHERE f2 = 'B';
66 COUNT(*) = 0
67 1
68 connection node_4;
69 SELECT COUNT(*) = 1 FROM t1 WHERE f2 = 'A';
70 COUNT(*) = 1
71 1
72 SELECT COUNT(*) = 0 FROM t1 WHERE f2 = 'B';
73 COUNT(*) = 0
74 1
75 CALL mtr.add_suppression("inconsistent with group");
76 DROP TABLE t1;