Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
4 connect node_4, 127.0.0.1, root, , test, $NODE_MYPORT_4;
5 connection node_1;
6 connection node_2;
7 connection node_3;
8 connection node_4;
9 connection node_3;
10 SET GLOBAL wsrep_provider_options = 'gmcast.isolate = 1';
11 connection node_1;
12 connection node_4;
13 SET SESSION wsrep_on=OFF;
14 CREATE TABLE t1 (f1 INTEGER);
15 SET SESSION wsrep_on=ON;
16 DROP TABLE t1;
17 connection node_1;
18 CREATE TABLE t2 (f1 INTEGER);
19 connection node_3;
20 SET GLOBAL wsrep_provider_options = 'gmcast.isolate = 0';
21 connection node_1;
22 connection node_3;
23 SELECT COUNT(*) AS expect_0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
24 expect_0
25 0
26 SELECT COUNT(*) AS expect_1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2';
27 expect_1
28 1
29 connection node_4;
30 SET SESSION wsrep_on=OFF;
31 Killing server ...
32 Starting mysqld
33 connection node_1;
34 SELECT COUNT(*) AS expect_0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
35 expect_0
36 0
37 SELECT COUNT(*) AS expect_1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2';
38 expect_1
39 1
40 CALL mtr.add_suppression("Slave SQL: Error 'Unknown table");
41 connection node_2;
42 SELECT COUNT(*) AS expect_0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
43 expect_0
44 0
45 SELECT COUNT(*) AS expect_1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2';
46 expect_1
47 1
48 CALL mtr.add_suppression("Slave SQL: Error 'Unknown table");
49 connection node_3;
50 SELECT COUNT(*) AS expect_0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
51 expect_0
52 0
53 SELECT COUNT(*) AS expect_1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2';
54 expect_1
55 1
56 CALL mtr.add_suppression("WSREP: Vote 0 \\(success\\) on .* is inconsistent with group\\. Leaving cluster\\.");
57 connection node_4;
58 SELECT COUNT(*) AS expect_0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
59 expect_0
60 0
61 SELECT COUNT(*) AS expect_1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2';
62 expect_1
63 1
64 CALL mtr.add_suppression("WSREP: Vote 0 \\(success\\) on .* is inconsistent with group\\. Leaving cluster\\.");
65 DROP TABLE t2;
66 disconnect node_3;
67 disconnect node_4;