Debian Codegraph @

mysql-test/suite/ndb/r/ndb_key_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 use test;
6 create table test.t1 (a int primary key, b int, key(b), c int, unique(c)) engine=ndb;
7 Insert 40 rows
8 insert into test.t1 values (0, 0, 0);;
9 insert into test.t1 values (1, 1, 1);;
10 insert into test.t1 values (2, 2, 2);;
11 insert into test.t1 values (3, 3, 3);;
12 insert into test.t1 values (4, 4, 4);;
13 insert into test.t1 values (5, 5, 5);;
14 insert into test.t1 values (6, 6, 6);;
15 insert into test.t1 values (7, 7, 7);;
16 insert into test.t1 values (8, 8, 8);;
17 insert into test.t1 values (9, 9, 9);;
18 insert into test.t1 values (10, 10, 10);;
19 insert into test.t1 values (11, 11, 11);;
20 insert into test.t1 values (12, 12, 12);;
21 insert into test.t1 values (13, 13, 13);;
22 insert into test.t1 values (14, 14, 14);;
23 insert into test.t1 values (15, 15, 15);;
24 insert into test.t1 values (16, 16, 16);;
25 insert into test.t1 values (17, 17, 17);;
26 insert into test.t1 values (18, 18, 18);;
27 insert into test.t1 values (19, 19, 19);;
28 insert into test.t1 values (20, 20, 20);;
29 insert into test.t1 values (21, 21, 21);;
30 insert into test.t1 values (22, 22, 22);;
31 insert into test.t1 values (23, 23, 23);;
32 insert into test.t1 values (24, 24, 24);;
33 insert into test.t1 values (25, 25, 25);;
34 insert into test.t1 values (26, 26, 26);;
35 insert into test.t1 values (27, 27, 27);;
36 insert into test.t1 values (28, 28, 28);;
37 insert into test.t1 values (29, 29, 29);;
38 insert into test.t1 values (30, 30, 30);;
39 insert into test.t1 values (31, 31, 31);;
40 insert into test.t1 values (32, 32, 32);;
41 insert into test.t1 values (33, 33, 33);;
42 insert into test.t1 values (34, 34, 34);;
43 insert into test.t1 values (35, 35, 35);;
44 insert into test.t1 values (36, 36, 36);;
45 insert into test.t1 values (37, 37, 37);;
46 insert into test.t1 values (38, 38, 38);;
47 insert into test.t1 values (39, 39, 39);;
48 Take row locks in other session
49 begin;
50 select * from test.t1 where a < 10 order by a for update;
51 a b c
52 0 0 0
53 1 1 1
54 2 2 2
55 3 3 3
56 4 4 4
57 5 5 5
58 6 6 6
59 7 7 7
60 8 8 8
61 9 9 9
62 set @save_debug = @@session.debug;
63 SET SESSION debug="+d,ndb_reduced_api_protocol_timeout";
64 ----------------------------
65 Autocommit PK SELECT timeout
66 ----------------------------
67 select * from test.t1 where a=0 for update;
68 ERROR HY000: Got error 4012 'Request ndbd time-out, maybe due to high load or communication problems' from NDBCLUSTER
69 Check pk lookups
70 Check transaction leaks
71 Leaks
72 0
73 select count(1) as ops from ndbinfo.cluster_operations;
74 ops
75 10
76 --------------------------------------
77 Stateful transaction PK SELECT timeout
78 --------------------------------------
79 begin;
80 insert into test.t1 values (100,100,100);
81 select * from test.t1 where a=2 for update;
82 ERROR HY000: Got error 4012 'Request ndbd time-out, maybe due to high load or communication problems' from NDBCLUSTER
83 Check pk lookups
84 Check transaction leaks
85 Leaks
86 0
87 select count(1) as ops from ndbinfo.cluster_operations;
88 ops
89 10
90 ----------------------------
91 Autocommit UK SELECT timeout
92 ----------------------------
93 select * from test.t1 where c=0 for update;
94 ERROR HY000: Got error 4012 'Request ndbd time-out, maybe due to high load or communication problems' from NDBCLUSTER
95 Check pk lookups
96 Check transaction leaks
97 Leaks
98 0
99 select count(1) as ops from ndbinfo.cluster_operations;
100 ops
101 10
102 --------------------------------------
103 Stateful transaction UK SELECT timeout
104 --------------------------------------
105 begin;
106 insert into test.t1 values (100,100,100);
107 select * from test.t1 where c=2 for update;
108 ERROR HY000: Got error 4012 'Request ndbd time-out, maybe due to high load or communication problems' from NDBCLUSTER
109 Check pk lookups
110 Check transaction leaks
111 Leaks
112 0
113 select count(1) as ops from ndbinfo.cluster_operations;
114 ops
115 10
116 rollback;
117 SET SESSION debug=@save_debug;
118 drop table test.t1;