| 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; |