Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 call mtr.add_suppression("WSREP: wsrep_mode = STRICT_REPLICATION enabled");
4 CREATE TABLE t1(a int NOT NULL PRIMARY KEY, b varchar(50)) ENGINE=INNODB;
5 CREATE TABLE t2(a int NOT NULL PRIMARY KEY, b varchar(50)) ENGINE=MYISAM;
6 CREATE TABLE t3(a int NOT NULL PRIMARY KEY, b varchar(50)) ENGINE=ARIA;
7 CREATE TABLE t4(a int NOT NULL PRIMARY KEY, b varchar(50)) ENGINE=MEMORY;
8 SET GLOBAL log_warnings=2;
9 SET GLOBAL wsrep_mode = "STRICT_REPLICATION,REPLICATE_MYISAM,REPLICATE_ARIA";
10 INSERT INTO t1 values (1,'innodb1');
11 INSERT INTO t2 values (1,'myisam1');
12 Warnings:
13 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MyISAM for table 'test'.'t2' is not supported in Galera
14 INSERT INTO t3 values (1,'aria1');
15 Warnings:
16 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine Aria for table 'test'.'t3' is not supported in Galera
17 INSERT INTO t4 values (1,'memory1');
18 Warnings:
19 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MEMORY for table 'test'.'t4' is not supported in Galera
20 SET GLOBAL wsrep_mode = "STRICT_REPLICATION,REPLICATE_ARIA";
21 INSERT INTO t2 values (2,'myisam2');
22 Warnings:
23 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MyISAM for table 'test'.'t2' is not supported in Galera
24 SET GLOBAL wsrep_mode = "STRICT_REPLICATION,REPLICATE_MYISAM";
25 INSERT INTO t3 values (2,'aria2');
26 Warnings:
27 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine Aria for table 'test'.'t3' is not supported in Galera
28 SET GLOBAL log_warnings=1;
29 INSERT INTO t1 values (3,'innodb3');
30 INSERT INTO t2 values (3,'myisam3');
31 Warnings:
32 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MyISAM for table 'test'.'t2' is not supported in Galera
33 INSERT INTO t3 values (3,'aria3');
34 Warnings:
35 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine Aria for table 'test'.'t3' is not supported in Galera
36 INSERT INTO t4 values (3,'memory3');
37 Warnings:
38 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MEMORY for table 'test'.'t4' is not supported in Galera
39 include/assert_grep.inc [WSREP: wsrep_mode = STRICT_REPLICATION enabled.]
40 SET GLOBAL log_warnings=2;
41 INSERT INTO t2 values (4,'myisam3');
42 Warnings:
43 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MyISAM for table 'test'.'t2' is not supported in Galera
44 INSERT INTO t3 values (4,'aria2');
45 Warnings:
46 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine Aria for table 'test'.'t3' is not supported in Galera
47 INSERT INTO t4 values (4,'memory2');
48 Warnings:
49 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MEMORY for table 'test'.'t4' is not supported in Galera
50 INSERT INTO t2 values (5,'myisam3');
51 Warnings:
52 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MyISAM for table 'test'.'t2' is not supported in Galera
53 INSERT INTO t3 values (5,'aria2');
54 Warnings:
55 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine Aria for table 'test'.'t3' is not supported in Galera
56 INSERT INTO t4 values (5,'memory2');
57 Warnings:
58 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MEMORY for table 'test'.'t4' is not supported in Galera
59 INSERT INTO t2 values (6,'myisam3');
60 Warnings:
61 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MyISAM for table 'test'.'t2' is not supported in Galera
62 INSERT INTO t3 values (6,'aria2');
63 Warnings:
64 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine Aria for table 'test'.'t3' is not supported in Galera
65 INSERT INTO t4 values (6,'memory2');
66 Warnings:
67 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MEMORY for table 'test'.'t4' is not supported in Galera
68 INSERT INTO t2 values (7,'myisam3');
69 Warnings:
70 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MyISAM for table 'test'.'t2' is not supported in Galera
71 INSERT INTO t3 values (7,'aria2');
72 Warnings:
73 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine Aria for table 'test'.'t3' is not supported in Galera
74 INSERT INTO t4 values (7,'memory2');
75 Warnings:
76 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MEMORY for table 'test'.'t4' is not supported in Galera
77 INSERT INTO t2 values (8,'myisam3');
78 Warnings:
79 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MyISAM for table 'test'.'t2' is not supported in Galera
80 INSERT INTO t3 values (8,'aria2');
81 Warnings:
82 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine Aria for table 'test'.'t3' is not supported in Galera
83 INSERT INTO t4 values (8,'memory2');
84 Warnings:
85 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MEMORY for table 'test'.'t4' is not supported in Galera
86 INSERT INTO t2 values (9,'myisam3');
87 Warnings:
88 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MyISAM for table 'test'.'t2' is not supported in Galera
89 INSERT INTO t3 values (9,'aria2');
90 Warnings:
91 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine Aria for table 'test'.'t3' is not supported in Galera
92 INSERT INTO t4 values (9,'memory2');
93 Warnings:
94 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MEMORY for table 'test'.'t4' is not supported in Galera
95 INSERT INTO t2 values (10,'myisam3');
96 Warnings:
97 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MyISAM for table 'test'.'t2' is not supported in Galera
98 INSERT INTO t3 values (10,'aria2');
99 Warnings:
100 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine Aria for table 'test'.'t3' is not supported in Galera
101 INSERT INTO t4 values (10,'memory2');
102 Warnings:
103 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MEMORY for table 'test'.'t4' is not supported in Galera
104 INSERT INTO t2 values (11,'myisam3');
105 Warnings:
106 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MyISAM for table 'test'.'t2' is not supported in Galera
107 INSERT INTO t3 values (11,'aria2');
108 Warnings:
109 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine Aria for table 'test'.'t3' is not supported in Galera
110 INSERT INTO t4 values (11,'memory2');
111 Warnings:
112 Warning 1290 WSREP: wsrep_mode = STRICT_REPLICATION enabled. Storage engine MEMORY for table 'test'.'t4' is not supported in Galera
113 SELECT COUNT(*) AS EXPECT_2 FROM t1;
114 EXPECT_2
115 2
116 SELECT COUNT(*) AS EXPECT_10 FROM t2;
117 EXPECT_10
118 11
119 SELECT COUNT(*) AS EXPECT_10 FROM t3;
120 EXPECT_10
121 11
122 SELECT COUNT(*) AS EXPECT_10 FROM t4;
123 EXPECT_10
124 10
125 connection node_2;
126 SELECT COUNT(*) AS EXPECT_2 FROM t1;
127 EXPECT_2
128 2
129 SELECT COUNT(*) AS EXPECT_10 FROM t2;
130 EXPECT_10
131 10
132 SELECT COUNT(*) AS EXPECT_1 FROM t3;
133 EXPECT_1
134 1
135 SELECT COUNT(*) AS EXPECT_0 FROM t4;
136 EXPECT_0
137 0
138 connection node_1;
139 SET GLOBAL wsrep_mode= DEFAULT;
140 DROP TABLE t1,t2,t3,t4;
141 include/assert_grep.inc [WSREP: wsrep_mode = STRICT_REPLICATION enabled.]
142 include/assert_grep.inc [WSREP: Suppressing warnings of type 'WSREP_REQUIRE_INNODB' for up to 300 seconds because of flooding]