Debian Codegraph @

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

raw
1 # We are using some debug-only features in this test
2 call mtr.add_suppression("Receive from NDB failed");
3 Create some tables suitable for executing operations on
4 -------------------------------------------------------
5 create table test.t1 (a int primary key, b int, key(b)) engine=ndb;
6 create table test.t2 (a int primary key, b int, key(b)) engine=ndb;
7 Insert 40 rows
8 insert into test.t1 values (0, 0);;
9 insert into test.t1 values (1, 1);;
10 insert into test.t1 values (2, 2);;
11 insert into test.t1 values (3, 3);;
12 insert into test.t1 values (4, 4);;
13 insert into test.t1 values (5, 5);;
14 insert into test.t1 values (6, 6);;
15 insert into test.t1 values (7, 7);;
16 insert into test.t1 values (8, 8);;
17 insert into test.t1 values (9, 9);;
18 insert into test.t1 values (10, 10);;
19 insert into test.t1 values (11, 11);;
20 insert into test.t1 values (12, 12);;
21 insert into test.t1 values (13, 13);;
22 insert into test.t1 values (14, 14);;
23 insert into test.t1 values (15, 15);;
24 insert into test.t1 values (16, 16);;
25 insert into test.t1 values (17, 17);;
26 insert into test.t1 values (18, 18);;
27 insert into test.t1 values (19, 19);;
28 insert into test.t1 values (20, 20);;
29 insert into test.t1 values (21, 21);;
30 insert into test.t1 values (22, 22);;
31 insert into test.t1 values (23, 23);;
32 insert into test.t1 values (24, 24);;
33 insert into test.t1 values (25, 25);;
34 insert into test.t1 values (26, 26);;
35 insert into test.t1 values (27, 27);;
36 insert into test.t1 values (28, 28);;
37 insert into test.t1 values (29, 29);;
38 insert into test.t1 values (30, 30);;
39 insert into test.t1 values (31, 31);;
40 insert into test.t1 values (32, 32);;
41 insert into test.t1 values (33, 33);;
42 insert into test.t1 values (34, 34);;
43 insert into test.t1 values (35, 35);;
44 insert into test.t1 values (36, 36);;
45 insert into test.t1 values (37, 37);;
46 insert into test.t1 values (38, 38);;
47 insert into test.t1 values (39, 39);;
48 insert into test.t2 select * from test.t1;
49 Show expected operation outcomes
50 --------------------------------
51 select * from test.t1 where a > 70 order by b;
52 a b
53 select * from test.t1 order by b;
54 a b
55 0 0
56 1 1
57 2 2
58 3 3
59 4 4
60 5 5
61 6 6
62 7 7
63 8 8
64 9 9
65 10 10
66 11 11
67 12 12
68 13 13
69 14 14
70 15 15
71 16 16
72 17 17
73 18 18
74 19 19
75 20 20
76 21 21
77 22 22
78 23 23
79 24 24
80 25 25
81 26 26
82 27 27
83 28 28
84 29 29
85 30 30
86 31 31
87 32 32
88 33 33
89 34 34
90 35 35
91 36 36
92 37 37
93 38 38
94 39 39
95 select * from test.t1 where a > 70 order by a;
96 a b
97 select * from test.t1 order by a;
98 a b
99 0 0
100 1 1
101 2 2
102 3 3
103 4 4
104 5 5
105 6 6
106 7 7
107 8 8
108 9 9
109 10 10
110 11 11
111 12 12
112 13 13
113 14 14
114 15 15
115 16 16
116 17 17
117 18 18
118 19 19
119 20 20
120 21 21
121 22 22
122 23 23
123 24 24
124 25 25
125 26 26
126 27 27
127 28 28
128 29 29
129 30 30
130 31 31
131 32 32
132 33 33
133 34 34
134 35 35
135 36 36
136 37 37
137 38 38
138 39 39
139 select t1.b, t2.b from test.t1 join test.t2 on t2.a = t1.b;
140 b b
141 0 0
142 1 1
143 10 10
144 11 11
145 12 12
146 13 13
147 14 14
148 15 15
149 16 16
150 17 17
151 18 18
152 19 19
153 2 2
154 20 20
155 21 21
156 22 22
157 23 23
158 24 24
159 25 25
160 26 26
161 27 27
162 28 28
163 29 29
164 3 3
165 30 30
166 31 31
167 32 32
168 33 33
169 34 34
170 35 35
171 36 36
172 37 37
173 38 38
174 39 39
175 4 4
176 5 5
177 6 6
178 7 7
179 8 8
180 9 9
181 set @save_debug = @@session.debug;
182 SET SESSION debug="+d,ndb_reduced_api_protocol_timeout";
183
184 ----------------------------------
185 Unordered scan timeout due to load
186 Standalone
187 ----------------------------------
188 Time out waiting for response, but close() cleans up
189
190 select * from test.t1 where a > 70 order by b;
191 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
192 Check pk lookups
193
194 Check transaction leaks
195 Leaks
196 0
197 select count(1) as ops from ndbinfo.cluster_operations;
198 ops
199 0
200
201 ----------------------------------
202 Unordered scan timeout due to load
203 As part of a stateful transaction
204 ----------------------------------
205 Time out waiting for response, but close() cleans up
206
207 begin;
208 insert into test.t1 values (54,54);
209 select * from test.t1 where a > 70 order by b;
210 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
211 Check pk lookups
212
213 Check transaction leaks
214 Leaks
215 0
216 select count(1) as ops from ndbinfo.cluster_operations;
217 ops
218 0
219
220 ----------------------------------
221 Unordered scan timeout due to bug
222 ----------------------------------
223 Standalone
224
225 select * from test.t1 order by b;
226 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
227 Check pk lookups
228
229 Check transaction leaks
230 Leaks
231 0
232 select count(1) as ops from ndbinfo.cluster_operations;
233 ops
234 0
235
236 ----------------------------------
237 Unordered scan timeout due to bug
238 ----------------------------------
239 As part of a stateful transaction
240
241 begin;
242 insert into test.t1 values (54,54);
243 select * from test.t1 order by b;
244 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
245 Check pk lookups
246
247 Check transaction leaks
248 Leaks
249 0
250 select count(1) as ops from ndbinfo.cluster_operations;
251 ops
252 0
253
254 ----------------------------------
255 Ordered scan timeout due to load
256 Standalone
257 ----------------------------------
258 Time out waiting for response, but close() cleans up
259
260 select * from test.t1 where a > 70 order by a;
261 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
262 Check pk lookups
263
264 Check transaction leaks
265 Leaks
266 0
267 select count(1) as ops from ndbinfo.cluster_operations;
268 ops
269 0
270
271 ----------------------------------
272 Ordered scan timeout due to load
273 As part of a stateful transaction
274 ----------------------------------
275 Time out waiting for response, but close() cleans up
276
277 begin;
278 insert into test.t1 values (54,54);
279 select * from test.t1 where a > 70 order by a;
280 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
281 Check pk lookups
282
283 Check transaction leaks
284 Leaks
285 0
286 select count(1) as ops from ndbinfo.cluster_operations;
287 ops
288 0
289
290 ----------------------------------
291 Ordered scan timeout due to bug
292 Standalone
293 ----------------------------------
294
295 select * from test.t1 order by a;
296 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
297 Check pk lookups
298
299 Check transaction leaks
300 Leaks
301 0
302 select count(1) as ops from ndbinfo.cluster_operations;
303 ops
304 0
305
306 ----------------------------------
307 Ordered scan timeout due to bug
308 As part of a stateful transaction
309 ----------------------------------
310
311 begin;
312 insert into test.t1 values (54,54);
313 select * from test.t1 order by a;
314 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
315 Check pk lookups
316
317 Check transaction leaks
318 Leaks
319 0
320 select count(1) as ops from ndbinfo.cluster_operations;
321 ops
322 0
323
324 -------------------------------
325 SPJ request timeout due to load
326 -------------------------------
327 Standalone
328
329 select t1.b, t2.b from test.t1 join test.t2 on t2.a = t1.b where t1.a > 70;
330 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
331 Check pk lookups
332 Clear error condition
333
334 Check transaction leaks
335 Leaks
336 0
337 select count(1) as ops from ndbinfo.cluster_operations;
338 ops
339 0
340
341 -------------------------------
342 SPJ request timeout due to load
343 -------------------------------
344 As part of a stateful transaction
345
346 begin;
347 insert into test.t1 values (54,54);
348 select t1.b, t2.b from test.t1 join test.t2 on t2.a = t1.b where t1.a > 70;
349 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
350 Clear error condition
351
352 Check pk lookups
353 Check transaction leaks
354 Leaks
355 0
356 select count(1) as ops from ndbinfo.cluster_operations;
357 ops
358 0
359
360 ------------------------------
361 SPJ request timeout due to bug
362 ------------------------------
363 Standalone
364
365 select t1.b, t2.b from test.t1 join test.t2 on t2.a = t1.b;
366 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
367 Check pk lookups
368 Clear error condition
369
370 Check transaction leaks
371 Leaks
372 0
373 select count(1) as ops from ndbinfo.cluster_operations;
374 ops
375 0
376
377 -------------------------------
378 SPJ request timeout due to bug
379 ------------------------------
380 As part of a stateful transaction
381
382 begin;
383 insert into test.t1 values (54,54);
384 select t1.b, t2.b from test.t1 join test.t2 on t2.a = t1.b;
385 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
386 Check pk lookups
387 Clear error condition
388
389 Check transaction leaks
390 Leaks
391 0
392 select count(1) as ops from ndbinfo.cluster_operations;
393 ops
394 0
395 SET SESSION debug=@save_debug;
396 Normal requests
397 ---------------
398 select * from test.t1 where a=3 for update;
399 a b
400 3 3
401 select * from test.t1 order by b;
402 a b
403 0 0
404 1 1
405 2 2
406 3 3
407 4 4
408 5 5
409 6 6
410 7 7
411 8 8
412 9 9
413 10 10
414 11 11
415 12 12
416 13 13
417 14 14
418 15 15
419 16 16
420 17 17
421 18 18
422 19 19
423 20 20
424 21 21
425 22 22
426 23 23
427 24 24
428 25 25
429 26 26
430 27 27
431 28 28
432 29 29
433 30 30
434 31 31
435 32 32
436 33 33
437 34 34
438 35 35
439 36 36
440 37 37
441 38 38
442 39 39
443 select * from test.t1 order by a;
444 a b
445 0 0
446 1 1
447 2 2
448 3 3
449 4 4
450 5 5
451 6 6
452 7 7
453 8 8
454 9 9
455 10 10
456 11 11
457 12 12
458 13 13
459 14 14
460 15 15
461 16 16
462 17 17
463 18 18
464 19 19
465 20 20
466 21 21
467 22 22
468 23 23
469 24 24
470 25 25
471 26 26
472 27 27
473 28 28
474 29 29
475 30 30
476 31 31
477 32 32
478 33 33
479 34 34
480 35 35
481 36 36
482 37 37
483 38 38
484 39 39
485 select t1.b, t2.b from test.t1 join test.t2 on t2.a = t1.b;
486 b b
487 0 0
488 1 1
489 10 10
490 11 11
491 12 12
492 13 13
493 14 14
494 15 15
495 16 16
496 17 17
497 18 18
498 19 19
499 2 2
500 20 20
501 21 21
502 22 22
503 23 23
504 24 24
505 25 25
506 26 26
507 27 27
508 28 28
509 29 29
510 3 3
511 30 30
512 31 31
513 32 32
514 33 33
515 34 34
516 35 35
517 36 36
518 37 37
519 38 38
520 39 39
521 4 4
522 5 5
523 6 6
524 7 7
525 8 8
526 9 9
527 update test.t1 set b=b+1;
528 Wait to show that subsequent actions do not cause reclamation
529 Leaks
530 0
531 select count(1) as ops from ndbinfo.cluster_operations;
532 ops
533 0
534 drop table test.t1;
535 drop table test.t2;
536 set @save_debug = @@session.debug;
537 SET SESSION debug="+d,ndb_reduced_api_protocol_timeout";
538 Determine our NdbApi connection id
539 Determine row ids used to control data nodes involved
540 Drop down to just the row on node 1
541 Block send from node 1 to our API
542 Hint transaction to node 2
543 a nodeid
544 Send select of all - will hang
545 Now cause restart of node 1
546 Node 1 is being restarted
547
548 Wait for data node to restart
549 Reap query - will get timeout error
550 ERROR HY000: Got error 4008 'Receive from NDB failed' from NDBCLUSTER
551 Issue more queries to check all is well
552 select * from test.t1;
553 select * from test.t1;
554 select * from test.t1;
555 Cleanup
556 drop table test.t1;
557 SET SESSION debug=@save_debug;