1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
drop table if exists t1;
#
# Test that alter during lock table aborts with error if
# global schema lock already exists
#
create table t1 (a int key) engine ndb row_format dynamic;
set session debug="+d,sleep_after_global_schema_lock";
alter table t1 add column (b int);
lock tables t1 write;
alter table t1 add column (c int);
ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
alter table t1 add column (c int);
ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
alter table t1 add column (c int);
ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
unlock tables;
#
# Test that alter during lock works without global schema lock
# and that an alter done in parallell test serialized
#
lock tables t1 write;
# delay is still set after lock
alter table t1 add column (c int);
# issue alter in parallell, which should be hanging waiting on
alter table t1 add column (d int);
# check thread state which should be:
# "Waiting for allowed to take ndbcluster global schema lock"
# _not_ "Waiting for ndbcluster global schema lock"
select state from information_schema.processlist where info = "alter table t1 add column (d int)";
state
Waiting for allowed to take ndbcluster global schema lock
unlock tables;
show create table t1;
Table Create Table
t1 CREATE TABLE `t1` (
`a` int(11) NOT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
`d` int(11) DEFAULT NULL,
PRIMARY KEY (`a`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
# Cleanup
set session debug="-d,";
drop table t1;
|
