Debian Codegraph @

mysql-test/suite/galera_3nodes_sr/r/galera_vote_sr.result

raw
1 connection node_2;
2 connection node_1;
3 connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
4 connection node_1;
5 connection node_2;
6 connection node_3;
7 Inconsistency on the first fragment
8 connection node_1;
9 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 BLOB) ENGINE=InnoDB;
10 connection node_2;
11 SET SESSION wsrep_on=OFF;
12 INSERT INTO t1 VALUES (1, 'X');
13 SET SESSION wsrep_on=ON;
14 DELETE FROM t1 WHERE f1 = 2;
15 connection node_1;
16 SET AUTOCOMMIT=OFF;
17 SET SESSION wsrep_trx_fragment_size = 16384;
18 START TRANSACTION;
19 INSERT INTO t1 VALUES (1, REPEAT('A', 16384));
20 INSERT INTO t1 VALUES (2, REPEAT('A', 16384));
21 INSERT INTO t1 VALUES (3, REPEAT('A', 16384));
22 INSERT INTO t1 VALUES (4, REPEAT('A', 16384));
23 INSERT INTO t1 VALUES (5, REPEAT('A', 16384));
24 COMMIT;
25 SELECT COUNT(*) AS expect_0 FROM mysql.wsrep_streaming_log;
26 expect_0
27 0
28 START TRANSACTION;
29 INSERT INTO t1 VALUES (11, REPEAT('A', 16384));
30 INSERT INTO t1 VALUES (12, REPEAT('A', 16384));
31 INSERT INTO t1 VALUES (13, REPEAT('A', 16384));
32 INSERT INTO t1 VALUES (14, REPEAT('A', 16384));
33 INSERT INTO t1 VALUES (15, REPEAT('A', 16384));
34 connection node_2;
35 SET SESSION wsrep_on=OFF;
36 Starting mysqld
37 # restart
38 connection node_1;
39 connection node_2;
40 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
41 COUNT(*) > 0
42 1
43 connection node_1;
44 COMMIT;
45 connection node_1;
46 SELECT COUNT(*) AS expect_0 FROM mysql.wsrep_streaming_log;
47 expect_0
48 0
49 SELECT COUNT(*) AS expect_10 FROM t1;
50 expect_10
51 10
52 connection node_2;
53 SELECT COUNT(*) AS expect_0 FROM mysql.wsrep_streaming_log;
54 expect_0
55 0
56 SELECT COUNT(*) AS expect_10 FROM t1;
57 expect_10
58 10
59 connection node_3;
60 SELECT COUNT(*) AS expect_0 FROM mysql.wsrep_streaming_log;
61 expect_0
62 0
63 SELECT COUNT(*) AS expect_10 FROM t1;
64 expect_10
65 10
66 connection node_1;
67 DROP TABLE t1;
68 Inconsistency on a middle fragment
69 connection node_1;
70 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 BLOB) ENGINE=InnoDB;
71 connection node_2;
72 SET SESSION wsrep_on=OFF;
73 INSERT INTO t1 VALUES (3, 'X');
74 SET SESSION wsrep_on=ON;
75 DELETE FROM t1 WHERE f1 = 2;
76 connection node_1;
77 SET AUTOCOMMIT=OFF;
78 SET SESSION wsrep_trx_fragment_size = 16384;
79 START TRANSACTION;
80 INSERT INTO t1 VALUES (1, REPEAT('A', 16384));
81 INSERT INTO t1 VALUES (2, REPEAT('A', 16384));
82 INSERT INTO t1 VALUES (3, REPEAT('A', 16384));
83 INSERT INTO t1 VALUES (4, REPEAT('A', 16384));
84 INSERT INTO t1 VALUES (5, REPEAT('A', 16384));
85 COMMIT;
86 SELECT COUNT(*) AS expect_0 FROM mysql.wsrep_streaming_log;
87 expect_0
88 0
89 START TRANSACTION;
90 INSERT INTO t1 VALUES (11, REPEAT('A', 16384));
91 INSERT INTO t1 VALUES (12, REPEAT('A', 16384));
92 INSERT INTO t1 VALUES (13, REPEAT('A', 16384));
93 INSERT INTO t1 VALUES (14, REPEAT('A', 16384));
94 INSERT INTO t1 VALUES (15, REPEAT('A', 16384));
95 connection node_2;
96 SET SESSION wsrep_on=OFF;
97 Starting mysqld
98 # restart
99 connection node_1;
100 connection node_2;
101 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
102 COUNT(*) > 0
103 1
104 connection node_1;
105 COMMIT;
106 connection node_1;
107 SELECT COUNT(*) AS expect_0 FROM mysql.wsrep_streaming_log;
108 expect_0
109 0
110 SELECT COUNT(*) AS expect_10 FROM t1;
111 expect_10
112 10
113 connection node_2;
114 SELECT COUNT(*) AS expect_0 FROM mysql.wsrep_streaming_log;
115 expect_0
116 0
117 SELECT COUNT(*) AS expect_10 FROM t1;
118 expect_10
119 10
120 connection node_3;
121 SELECT COUNT(*) AS expect_0 FROM mysql.wsrep_streaming_log;
122 expect_0
123 0
124 SELECT COUNT(*) AS expect_10 FROM t1;
125 expect_10
126 10
127 connection node_1;
128 DROP TABLE t1;
129 Inconsistency on the commit fragment
130 connection node_1;
131 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 BLOB) ENGINE=InnoDB;
132 connection node_2;
133 SET SESSION wsrep_on=OFF;
134 INSERT INTO t1 VALUES (5, 'X');
135 SET SESSION wsrep_on=ON;
136 DELETE FROM t1 WHERE f1 = 2;
137 connection node_1;
138 SET AUTOCOMMIT=OFF;
139 SET SESSION wsrep_trx_fragment_size = 16384;
140 START TRANSACTION;
141 INSERT INTO t1 VALUES (1, REPEAT('A', 16384));
142 INSERT INTO t1 VALUES (2, REPEAT('A', 16384));
143 INSERT INTO t1 VALUES (3, REPEAT('A', 16384));
144 INSERT INTO t1 VALUES (4, REPEAT('A', 16384));
145 INSERT INTO t1 VALUES (5, REPEAT('A', 16384));
146 COMMIT;
147 SELECT COUNT(*) AS expect_0 FROM mysql.wsrep_streaming_log;
148 expect_0
149 0
150 START TRANSACTION;
151 INSERT INTO t1 VALUES (11, REPEAT('A', 16384));
152 INSERT INTO t1 VALUES (12, REPEAT('A', 16384));
153 INSERT INTO t1 VALUES (13, REPEAT('A', 16384));
154 INSERT INTO t1 VALUES (14, REPEAT('A', 16384));
155 INSERT INTO t1 VALUES (15, REPEAT('A', 16384));
156 connection node_2;
157 SET SESSION wsrep_on=OFF;
158 Starting mysqld
159 # restart
160 connection node_1;
161 connection node_2;
162 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
163 COUNT(*) > 0
164 1
165 connection node_1;
166 COMMIT;
167 connection node_1;
168 SELECT COUNT(*) AS expect_0 FROM mysql.wsrep_streaming_log;
169 expect_0
170 0
171 SELECT COUNT(*) AS expect_10 FROM t1;
172 expect_10
173 10
174 connection node_2;
175 SELECT COUNT(*) AS expect_0 FROM mysql.wsrep_streaming_log;
176 expect_0
177 0
178 SELECT COUNT(*) AS expect_10 FROM t1;
179 expect_10
180 10
181 connection node_3;
182 SELECT COUNT(*) AS expect_0 FROM mysql.wsrep_streaming_log;
183 expect_0
184 0
185 SELECT COUNT(*) AS expect_10 FROM t1;
186 expect_10
187 10
188 connection node_1;
189 DROP TABLE t1;
190 connection node_2;
191 CALL mtr.add_suppression("Slave SQL: Could not execute Write_rows event on table test.t1; Duplicate entry '1' for key 'PRIMARY'");
192 CALL mtr.add_suppression("Slave SQL: Could not execute Write_rows event on table test.t1; Duplicate entry '3' for key 'PRIMARY'");
193 CALL mtr.add_suppression("Slave SQL: Could not execute Write_rows event on table test.t1; Duplicate entry '5' for key 'PRIMARY'");
194 CALL mtr.add_suppression("Write_rows_v1 apply failed");
195 CALL mtr.add_suppression("Inconsistent by consensus");
196 CALL mtr.add_suppression("WSREP: Failed to apply write set: ");
197 CALL mtr.add_suppression("WSREP: Failed to report last committed");