Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_2;
4 SET GLOBAL wsrep_ignore_apply_errors = 1;
5 connection node_1;
6 SET GLOBAL wsrep_on = OFF;
7 CREATE TABLE t1 (f1 INTEGER);
8 SET GLOBAL wsrep_on = ON;
9 DROP TABLE t1;
10 connection node_2;
11 SHOW TABLES;
12 Tables_in_test
13 connection node_1;
14 SET GLOBAL wsrep_on = OFF;
15 CREATE SCHEMA s1;
16 SET GLOBAL wsrep_on = ON;
17 DROP SCHEMA s1;
18 connection node_2;
19 SHOW SCHEMAS;
20 Database
21 information_schema
22 mtr
23 mysql
24 performance_schema
25 sys
26 test
27 connection node_1;
28 CREATE TABLE t1 (f1 INTEGER);
29 SET GLOBAL wsrep_on = OFF;
30 CREATE INDEX idx1 ON t1 (f1);
31 SET GLOBAL wsrep_on = ON;
32 DROP INDEX idx1 ON t1;
33 connection node_2;
34 SHOW CREATE TABLE t1;
35 Table Create Table
36 t1 CREATE TABLE `t1` (
37 `f1` int(11) DEFAULT NULL
38 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
39 DROP TABLE t1;
40 connection node_1;
41 CREATE TABLE t1 (f1 INTEGER);
42 SET GLOBAL wsrep_on = OFF;
43 CREATE INDEX idx1 ON t1 (f1);
44 SET GLOBAL wsrep_on = ON;
45 ALTER TABLE t1 DROP INDEX idx1;
46 connection node_2;
47 SHOW CREATE TABLE t1;
48 Table Create Table
49 t1 CREATE TABLE `t1` (
50 `f1` int(11) DEFAULT NULL
51 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
52 DROP TABLE t1;
53 connection node_1;
54 CREATE TABLE t1 (f1 INTEGER);
55 SET GLOBAL wsrep_on = OFF;
56 ALTER TABLE t1 ADD COLUMN f2 INTEGER;
57 SET GLOBAL wsrep_on = ON;
58 ALTER TABLE t1 DROP COLUMN f2;
59 connection node_2;
60 SHOW CREATE TABLE t1;
61 Table Create Table
62 t1 CREATE TABLE `t1` (
63 `f1` int(11) DEFAULT NULL
64 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
65 DROP TABLE t1;
66 connection node_2;
67 SET GLOBAL wsrep_ignore_apply_errors = 2;
68 connection node_1;
69 CREATE TABLE t1 (f1 INTEGER);
70 SET GLOBAL wsrep_on = OFF;
71 INSERT INTO t1 VALUES (1);
72 SET GLOBAL wsrep_on = ON;
73 DELETE FROM t1 WHERE f1 = 1;
74 SELECT COUNT(*) AS expect_0 FROM t1;
75 expect_0
76 0
77 connection node_2;
78 SELECT COUNT(*) AS expect_0 FROM t1;
79 expect_0
80 0
81 DROP TABLE t1;
82 connection node_1;
83 CREATE TABLE t1 (f1 INTEGER);
84 INSERT INTO t1 VALUES (2);
85 SET GLOBAL wsrep_on = OFF;
86 INSERT INTO t1 VALUES (1);
87 SET GLOBAL wsrep_on = ON;
88 START TRANSACTION;
89 INSERT INTO t1 VALUES (3);
90 DELETE FROM t1 WHERE f1 = 1;
91 DELETE FROM t1 WHERE f1 = 2;
92 COMMIT;
93 SELECT COUNT(*) AS expect_1 FROM t1;
94 expect_1
95 1
96 connection node_2;
97 SELECT COUNT(*) AS expect_1 FROM t1;
98 expect_1
99 1
100 DROP TABLE t1;
101 connection node_1;
102 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
103 INSERT INTO t1 VALUES (1),(2),(3),(4),(5);
104 connection node_2;
105 SET SESSION wsrep_on = OFF;
106 DELETE FROM t1 WHERE f1 = 3;
107 SET SESSION wsrep_on = ON;
108 connection node_1;
109 DELETE FROM t1;
110 SELECT COUNT(*) AS expect_0 FROM t1;
111 expect_0
112 0
113 connection node_2;
114 SELECT VARIABLE_VALUE expect_Primary FROM performance_schema.global_status WHERE VARIABLE_NAME = 'wsrep_cluster_status';
115 expect_Primary
116 Primary
117 SELECT COUNT(*) AS expect_0 FROM t1;
118 expect_0
119 0
120 DROP TABLE t1;
121 connection node_1;
122 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
123 INSERT INTO t1 VALUES (1),(2),(3),(4),(5);
124 connection node_2;
125 SET SESSION wsrep_on = OFF;
126 DELETE FROM t1 WHERE f1 = 3;
127 SET SESSION wsrep_on = ON;
128 connection node_1;
129 SET AUTOCOMMIT=OFF;
130 START TRANSACTION;
131 DELETE FROM t1 WHERE f1 = 1;
132 DELETE FROM t1 WHERE f1 = 2;
133 DELETE FROM t1 WHERE f1 = 3;
134 DELETE FROM t1 WHERE f1 = 4;
135 DELETE FROM t1 WHERE f1 = 5;
136 COMMIT;
137 SET AUTOCOMMIT=ON;
138 SELECT COUNT(*) AS expect_0 FROM t1;
139 expect_0
140 0
141 connection node_2;
142 SELECT VARIABLE_VALUE expect_Primary FROM performance_schema.global_status WHERE VARIABLE_NAME = 'wsrep_cluster_status';
143 expect_Primary
144 Primary
145 SELECT COUNT(*) AS expect_0 FROM t1;
146 expect_0
147 0
148 DROP TABLE t1;
149 connection node_1;
150 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
151 INSERT INTO t1 VALUES (1),(2),(3);
152 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
153 INSERT INTO t2 VALUES (1),(2),(3);
154 connection node_2;
155 SET SESSION wsrep_on = OFF;
156 DELETE FROM t2 WHERE f1 = 2;
157 DELETE FROM t1 WHERE f1 = 3;
158 SET SESSION wsrep_on = ON;
159 connection node_1;
160 DELETE t1, t2 FROM t1 JOIN t2 WHERE t1.f1 = t2.f1;
161 SELECT COUNT(*) expect_0 FROM t1;
162 expect_0
163 0
164 connection node_2;
165 SELECT VARIABLE_VALUE = 'Primary' FROM performance_schema.global_status WHERE VARIABLE_NAME = 'wsrep_cluster_status';
166 VARIABLE_VALUE = 'Primary'
167 1
168 SELECT COUNT(*) expect_0 FROM t1;
169 expect_0
170 0
171 DROP TABLE t1,t2;
172 connection node_1;
173 CREATE TABLE parent (id INT NOT NULL, PRIMARY KEY (id)) ENGINE=INNODB;
174 INSERT INTO parent VALUES (1),(2),(3);
175 CREATE TABLE child (id INT, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE CASCADE) ENGINE=INNODB;
176 INSERT INTO child VALUES (1,1),(2,2),(3,3);
177 connection node_2;
178 SET SESSION wsrep_on = OFF;
179 DELETE FROM child WHERE parent_id = 2;
180 SET SESSION wsrep_on = ON;
181 connection node_1;
182 DELETE FROM parent;
183 SELECT COUNT(*) AS expect_0 FROM parent;
184 expect_0
185 0
186 SELECT COUNT(*) AS expect_0 FROM child;
187 expect_0
188 0
189 connection node_2;
190 SELECT VARIABLE_VALUE = 'Primary' FROM performance_schema.global_status WHERE VARIABLE_NAME = 'wsrep_cluster_status';
191 VARIABLE_VALUE = 'Primary'
192 1
193 SELECT COUNT(*) AS expect_0 FROM parent;
194 expect_0
195 0
196 SELECT COUNT(*) AS expect_0 FROM child;
197 expect_0
198 0
199 DROP TABLE child, parent;
200 connection node_2;
201 SET GLOBAL wsrep_ignore_apply_errors = 4;
202 connection node_2;
203 SET GLOBAL wsrep_on = OFF;
204 CREATE TABLE t1 (f1 INTEGER);
205 SET GLOBAL wsrep_on = ON;
206 connection node_1;
207 CREATE TABLE t1 (f1 INTEGER, f2 INTEGER);
208 DROP TABLE t1;
209 connection node_2;
210 set session wsrep_sync_wait=0;
211 SELECT * FROM t1;
212 ERROR 42S02: Table 'test.t1' doesn't exist
213 SET GLOBAL wsrep_ignore_apply_errors = 10;
214 Warnings:
215 Warning 1292 Truncated incorrect wsrep_ignore_apply_errors value: '10'
216 CALL mtr.add_suppression("Can't find record in ");
217 CALL mtr.add_suppression("Slave SQL: Could not execute Delete_rows event");
218 CALL mtr.add_suppression("Slave SQL: Error 'Unknown table 'test\\.t1'' on query\\. Default database: 'test'\\. Query: 'DROP TABLE t1', Error_code: 1051");
219 CALL mtr.add_suppression("Slave SQL: Error 'Can't drop database 's1'; database doesn't exist' on query\\. Default database: 'test'\\. Query: 'DROP SCHEMA s1', Error_code: 1008");
220 CALL mtr.add_suppression("Slave SQL: Error 'Can't DROP 'idx1'; check that column/key exists' on query\\. Default database: 'test'\\. Query: 'DROP INDEX idx1 ON t1', Error_code: 1091");
221 CALL mtr.add_suppression("Slave SQL: Error 'Can't DROP 'idx1'; check that column/key exists' on query\\. Default database: 'test'\\. Query: 'ALTER TABLE t1 DROP INDEX idx1', Error_code: 1091");
222 CALL mtr.add_suppression("Slave SQL: Error 'Can't DROP 'f2'; check that column/key exists' on query\\. Default database: 'test'\\. Query: 'ALTER TABLE t1 DROP COLUMN f2', Error_code: 1091");
223 CALL mtr.add_suppression("Slave SQL: Error 'Table 't1' already exists' on query\\.");
224 CALL mtr.add_suppression("Inconsistency detected: Inconsistent by consensus on ");