Debian Codegraph @

mysql-test/suite/ndb/r/ndb_err4012.result

raw
1 # We are using some debug-only features in this test
2 SET SESSION debug="+d,ndb_metadata_compare_skip";
3 # bulk delete with timeout error 4012
4 create table t4(id int primary key, val int) engine=ndb;
5 insert into t4 values (1,1), (2,2), (3,3), (4,4), (5,5);
6 set @save_debug = @@session.debug;
7 # Error injection in Ndb::waitCompletedTransactions so that transaction times out quickly
8 SET SESSION debug="+d,early_trans_timeout";
9 delete from t4 where id > 0;
10 ERROR HY000: Got error 4012 'Request ndbd time-out, maybe due to high load or communication problems' from NDBCLUSTER
11 SET SESSION debug=@save_debug;
12 drop table t4;
13 # bulk delete ignore with timeout error 4012
14 create table t4(id int primary key, val int) engine=ndb;
15 insert into t4 values (1,1), (2,2), (3,3), (4,4), (5,5);
16 set @save_debug = @@session.debug;
17 # Error injection in Ndb::waitCompletedTransactions so that transaction times out quickly
18 SET SESSION debug="+d,early_trans_timeout";
19 delete ignore from t4 where id > 0;
20 ERROR HY000: Got error 4012 'Request ndbd time-out, maybe due to high load or communication problems' from NDBCLUSTER
21 SET SESSION debug=@save_debug;
22 drop table t4;
23 # bulk update with timeout error 4012
24 create table t4(id int primary key, val int) engine=ndb;
25 insert into t4 values (1,1), (2,2), (3,3), (4,4), (5,5);
26 set @save_debug = @@session.debug;
27 # Error injection in Ndb::waitCompletedTransactions so that transaction times out quickly
28 SET SESSION debug="+d,early_trans_timeout";
29 update t4 set val = 0 where id > 0;
30 ERROR HY000: Got error 4012 'Request ndbd time-out, maybe due to high load or communication problems' from NDBCLUSTER
31 SET SESSION debug=@save_debug;
32 drop table t4;
33 # bulk update ignore is not possible because 'ignore' disables bulk updates
34 # mysqld gets timeout error 4008 on GET_TABINFOREQ for table create
35 set @save_debug = @@session.debug;
36 SET SESSION debug="+d,ndb_dictsignal_timeout";
37 create table t1(id int primary key, val int)engine=ndb;
38 ERROR HY000: Bad schema for mysql.ndb_replication table. Message: Unable to retrieve mysql.ndb_replication, logging and conflict r
39 show warnings;
40 Level Code Message
41 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
42 Warning 1296 Failed to discover table 't1' from NDB
43 Error 1625 Bad schema for mysql.ndb_replication table. Message: Unable to retrieve mysql.ndb_replication, logging and conflict r
44 Error 1031 Table storage engine for 't1' doesn't have this option
45 SET SESSION debug=@save_debug;
46 # mysqld gets timeout error 4008 on GET_TABINFOREQ for table drop
47 create table t2(id int primary key, val int)engine=ndb;
48 set @save_debug = @@session.debug;
49 SET SESSION debug="+d,ndb_dictsignal_timeout";
50 drop table t2;
51 ERROR HY000: Storage engine can't drop table 'test.t2'
52 show warnings;
53 Level Code Message
54 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
55 Warning 1296 Got error 4008 'Receive from NDB failed' from NDBCLUSTER
56 Error 3604 Storage engine can't drop table 'test.t2'
57 SET SESSION debug=@save_debug;
58 drop table t2;
59 # mysqld gets timeout error 1008 on GET_TABINFOREQ for index create
60 create table t3(id int primary key, val int)engine=ndb;
61 set @save_debug = @@session.debug;
62 SET SESSION debug="+d,ndb_dictsignal_timeout";
63 create unique index val_unq on t3(val);
64 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
65 show warnings;
66 Level Code Message
67 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
68 Error 1296 Got error 4008 'Receive from NDB failed' from NDBCLUSTER
69 SET SESSION debug=@save_debug;
70 drop table t3;
71 # mysqld gets timeout error 4008 on GET_TABINFOREQ for index drop
72 create table t4(id int primary key, val int, unique key val_unq(val))engine=ndb;
73 set @save_debug = @@session.debug;
74 SET SESSION debug="+d,ndb_dictsignal_timeout";
75 drop index val_unq on t4;
76 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
77 show warnings;
78 Level Code Message
79 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
80 Error 1296 Got error 4008 'Receive from NDB failed' from NDBCLUSTER
81 SET SESSION debug=@save_debug;
82 drop table t4;
83 # mysqld gets timeout error 4008 on GET_TABINFOREQ for hashmap
84 create table t1(id int primary key, val int)engine=ndb;
85 SET SESSION debug="+d,ndb_dictsignal_timeout";
86 alter table t1 add partition partitions 2;
87 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
88 show warnings;
89 Level Code Message
90 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
91 Error 1296 Got error 4008 'Receive from NDB failed' from NDBCLUSTER
92 SET SESSION debug=@save_debug;
93 drop table t1;
94 # mysqld gets timeout error 4008 on GET_TABINFOREQ for foreign key
95 create table t1(id int primary key, val int) engine=ndb;
96 create table t2(id int primary key, id2 int, constraint t2_fk foreign key(id2) references t1(id))engine=ndb;
97 SET SESSION debug="+d,ndb_dictsignal_timeout";
98 alter table t2 algorithm=inplace, drop foreign key t2_fk;
99 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
100 show warnings;
101 Level Code Message
102 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
103 Error 1296 Got error 4008 'Receive from NDB failed' from NDBCLUSTER
104 SET SESSION debug=@save_debug;
105 drop table t2;
106 drop table t1;
107 create logfile group lg1 add undofile 'undo1.dat' engine=ndb;
108 create tablespace ts1 add datafile 'data1.dat' use logfile group lg1 engine=ndb;
109 # mysqld gets timeout error 4008 on GET_TABINFOREQ for file
110 set @save_debug = @@session.debug;
111 SET SESSION debug="+d,ndb_dictsignal_timeout";
112 alter tablespace ts1 drop datafile 'data1.dat';
113 ERROR HY000: Failed to alter: DROP DATAFILE FAILED
114 show warnings;
115 Level Code Message
116 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
117 Warning 1296 Failed to get tablespace 'ts1' from NDB
118 Error 1533 Failed to alter: DROP DATAFILE FAILED
119 SET SESSION debug=@save_debug;
120 # mysqld gets timeout error 4008 on GET_TABINFOREQ for filegroup
121 set @save_debug = @@session.debug;
122 SET SESSION debug="+d,ndb_dictsignal_timeout";
123 alter logfile group lg1 add undofile 'undo2.dat' engine=ndb;
124 ERROR HY000: Failed to alter: CREATE UNDOFILE FAILED
125 show warnings;
126 Level Code Message
127 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
128 Warning 1296 Failed to create undofile 'undo2.dat' in NDB
129 Error 1533 Failed to alter: CREATE UNDOFILE FAILED
130 SET SESSION debug=@save_debug;
131 alter tablespace ts1 drop datafile 'data1.dat';
132 drop tablespace ts1;
133 drop logfile group lg1 engine=ndb;
134 # mysqld gets timeout error 4008 on CREATE_TABLE_REQ
135 set @save_debug = @@session.debug;
136 SET SESSION debug="+d,ndb_dictsignal_timeout";
137 create table t1(id int primary key, val int)engine=ndb;
138 ERROR HY000: Can't create table 't1' (use SHOW WARNINGS for more info).
139 show warnings;
140 Level Code Message
141 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
142 Error 1005 Can't create table 't1' (use SHOW WARNINGS for more info).
143 SET SESSION debug=@save_debug;
144 # mysqld gets timeout error 4008 on ALTER_TAB_REQ
145 create table t1(id int primary key, val int) engine=ndb;
146 SET SESSION debug="+d,ndb_dictsignal_timeout";
147 alter table t1 add partition partitions 2;
148 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
149 show warnings;
150 Level Code Message
151 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
152 Error 1296 Got error 4008 'Receive from NDB failed' from NDBCLUSTER
153 SET SESSION debug=@save_debug;
154 drop table t1;
155 # mysqld gets timeout error 4008 on DROP_TAB_REQ for table drop
156 create table t1(id int primary key, val int) engine=ndb;
157 SET SESSION debug="+d,ndb_dictsignal_timeout";
158 drop table t1;
159 ERROR HY000: Storage engine can't drop table 'test.t1'
160 show warnings;
161 Level Code Message
162 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
163 Warning 1296 Got error 4008 'Receive from NDB failed' from NDBCLUSTER
164 Error 3604 Storage engine can't drop table 'test.t1'
165 SET SESSION debug=@save_debug;
166 drop table t1;
167 # mysqld gets timeout error 4008 on CREATE_INDX_REQ
168 create table t1(id int primary key, val int) engine=ndb;
169 set @save_debug = @@session.debug;
170 SET SESSION debug="+d,ndb_dictsignal_timeout";
171 create unique index val_unq on t1(val);
172 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
173 show warnings;
174 Level Code Message
175 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
176 Error 1296 Got error 4008 'Receive from NDB failed' from NDBCLUSTER
177 SET SESSION debug=@save_debug;
178 drop table t1;
179 # mysqld gets timeout error 4008 on DROP_INDX_REQ
180 create table t1(id int primary key, val int, unique key val_unq(val))engine=ndb;
181 set @save_debug = @@session.debug;
182 SET SESSION debug="+d,ndb_dictsignal_timeout";
183 drop index val_unq on t1;
184 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
185 show warnings;
186 Level Code Message
187 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
188 Error 1296 Got error 4008 'Receive from NDB failed' from NDBCLUSTER
189 SET SESSION debug=@save_debug;
190 drop table t1;
191 # mysqld gets timeout error 4008 on CREATE_FILEGROUP_REQ
192 set @save_debug = @@session.debug;
193 SET SESSION debug="+d,ndb_dictsignal_timeout";
194 create logfile group lg1 add undofile 'undo1.dat' engine=ndb;
195 ERROR HY000: Failed to create LOGFILE GROUP
196 show warnings;
197 Level Code Message
198 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
199 Warning 1296 Failed to create logfile group 'lg1' in NDB
200 Error 1528 Failed to create LOGFILE GROUP
201 SET SESSION debug=@save_debug;
202 # mysqld gets timeout error 4008 on DROP_FILEGROUP_REQ
203 create logfile group lg1 add undofile 'undo1.dat' engine=ndb;
204 set @save_debug = @@session.debug;
205 SET SESSION debug="+d,ndb_dictsignal_timeout";
206 drop logfile group lg1 engine=ndb;
207 ERROR HY000: Failed to drop LOGFILE GROUP
208 show warnings;
209 Level Code Message
210 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
211 Warning 1296 Failed to drop logfile group 'lg1' from NDB
212 Error 1529 Failed to drop LOGFILE GROUP
213 SET SESSION debug=@save_debug;
214 drop logfile group lg1 engine=ndb;
215 # mysqld gets timeout error 4008 on CREATE_FK_REQ for foreign key
216 create table t1(id int primary key, val int) engine=ndb;
217 create table t2(id int primary key, val int) engine=ndb;
218 SET SESSION debug="+d,ndb_dictsignal_timeout";
219 alter table t2 add constraint foreign key (id) references t1(id);
220 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
221 show warnings;
222 Level Code Message
223 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
224 Error 1296 Got error 4008 'Receive from NDB failed' from NDBCLUSTER
225 SET SESSION debug=@save_debug;
226 drop table t2;
227 drop table t1;
228 # mysqld gets timeout error 4008 on DROP_FK_REQ for foreign key
229 create table t1(id int primary key, val int) engine=ndb;
230 create table t2(id int primary key, id2 int, constraint t2_fk foreign key(id2) references t1(id))engine=ndb;
231 SET SESSION debug="+d,ndb_dictsignal_timeout";
232 alter table t2 algorithm=inplace, drop foreign key t2_fk;
233 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
234 show warnings;
235 Level Code Message
236 Warning 1215 Failed to drop fk 'X/X/t2_fk'
237 Warning 1215 Ndb error: 4008 'Receive from NDB failed'
238 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
239 Error 1296 Got error 4008 'Receive from NDB failed' from NDBCLUSTER
240 SET SESSION debug=@save_debug;
241 drop table t2;
242 drop table t1;
243 # mysqld gets timeout error 4008 on CREATE_FILE_REQ
244 create logfile group lg1 add undofile 'undo1.dat' engine=ndb;
245 create tablespace ts1 add datafile 'data1.dat' use logfile group lg1 engine=ndb;
246 set @save_debug = @@session.debug;
247 SET SESSION debug="+d,ndb_dictsignal_timeout";
248 alter tablespace ts1 add datafile 'data2.dat';
249 ERROR HY000: Failed to alter: CREATE DATAFILE FAILED
250 show warnings;
251 Level Code Message
252 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
253 Warning 1296 Failed to create datafile 'data2.dat' in NDB
254 Error 1533 Failed to alter: CREATE DATAFILE FAILED
255 SET SESSION debug=@save_debug;
256 alter tablespace ts1 drop datafile 'data1.dat';
257 drop tablespace ts1;
258 drop logfile group lg1 engine=ndb;
259 # mysqld gets timeout error 4008 on DROP_FILE_REQ
260 create logfile group lg1 add undofile 'undo1.dat' engine=ndb;
261 create tablespace ts1 add datafile 'data1.dat' use logfile group lg1 engine=ndb;
262 set @save_debug = @@session.debug;
263 SET SESSION debug="+d,ndb_dictsignal_timeout";
264 alter tablespace ts1 drop datafile 'data1.dat';
265 ERROR HY000: Failed to alter: DROP DATAFILE FAILED
266 show warnings;
267 Level Code Message
268 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
269 Warning 1296 Failed to drop datafile 'data1.dat' from NDB
270 Error 1533 Failed to alter: DROP DATAFILE FAILED
271 SET SESSION debug=@save_debug;
272 alter tablespace ts1 drop datafile 'data1.dat';
273 drop tablespace ts1;
274 drop logfile group lg1 engine=ndb;
275 # mysqld gets timeout error 4008 on CREATE_HASH_MAP_REQ
276 set @save_debug = @@session.debug;
277 SET SESSION debug="+d,ndb_dictsignal_timeout";
278 create table t1(id int primary key, val int) engine=ndb;
279 ERROR HY000: Can't create table 't1' (use SHOW WARNINGS for more info).
280 show warnings;
281 Level Code Message
282 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
283 Error 1005 Can't create table 't1' (use SHOW WARNINGS for more info).
284 SET SESSION debug=@save_debug;
285 # mysqld gets timeout error 4008 on LIST_TABLES_REQ
286 create table t1(id int primary key, val int) engine=ndb;
287 set @save_debug = @@session.debug;
288 SET SESSION debug="+d,ndb_dictsignal_timeout";
289 drop table if exists t1;
290 ERROR HY000: Storage engine can't drop table 'test.t1'
291 show warnings;
292 Level Code Message
293 Warning 1215 Failed to list dependent objects for table 't1'
294 Warning 1215 Ndb error: 4008 'Receive from NDB failed'
295 Warning 1296 Got error 4008 'Receive from NDB failed' from NDB
296 Warning 1296 Got error 4008 'Receive from NDB failed' from NDBCLUSTER
297 Error 3604 Storage engine can't drop table 'test.t1'
298 SET SESSION debug=@save_debug;
299 drop table t1;
300 # mysqld gets timeout 4013 while opening index
301 create table t1(id int primary key, val int unique) engine=ndb;
302 set @save_debug = @@session.debug;
303 SET SESSION debug="+d,ndb_simulate_nodefail";
304 show create table t1;
305 ERROR HY000: Got temporary error 4013 'Request timed out in waiting for node failure' from NDBCLUSTER
306 show warnings;
307 Level Code Message
308 Warning 1297 Got temporary error 4013 'Request timed out in waiting for node failure' from NDB
309 Error 1297 Got temporary error 4013 'Request timed out in waiting for node failure' from NDBCLUSTER
310 SET SESSION debug=@save_debug;
311 drop table t1;
312 # mysqld gets timeout error 4009 while creating transaction for bulk update
313 create table t1(id int primary key, val int) engine=ndb;
314 insert into t1 values(1,1), (2,2), (3,3), (4,4), (5,5);
315 set @save_debug = @@session.debug;
316 SET SESSION debug="+d,ndb_start_transaction_fail";
317 update t1 set val = 11111 where id > 0;
318 ERROR HY000: Got error 4009 'Cluster Failure' from NDBCLUSTER
319 show warnings;
320 Level Code Message
321 Warning 1296 Got error 4009 'Cluster Failure' from NDB
322 Error 1296 Got error 4009 'Cluster Failure' from NDBCLUSTER
323 Warning 1296 Got error 4009 'Cluster Failure' from NDB
324 SET SESSION debug=@save_debug;
325 drop table t1;