Debian Codegraph @

mysql-test/suite/ndb_ddl/create_table_release_mdl.result

raw
1 #
2 # Bug#29871406 HANG IN ACQUIRE_LOCK WHEN ALTERING TABLESPACE
3 # Create table in tablespace with RANGE partition caused MDL lock
4 # on the tablespace to be left behind on the participant, thus
5 # preventing further use of the tablespace
6 #
7 CREATE LOGFILE GROUP lg1
8 ADD UNDOFILE 'lg1_undofile.dat'
9 INITIAL_SIZE 16M
10 UNDO_BUFFER_SIZE = 1M ENGINE=NDB;
11 CREATE TABLESPACE ts1
12 ADD DATAFILE 'ts1_datafile1.dat'
13 USE LOGFILE GROUP lg1
14 INITIAL_SIZE 64M
15 ENGINE NDB;
16 set new=on;
17 Warnings:
18 Warning 1287 '@@new' is deprecated and will be removed in a future release.
19 CREATE TABLE t1 (
20 a INT NOT NULL,
21 PRIMARY KEY (a)
22 ) ENGINE=NDB
23 PARTITION BY RANGE (a)
24 PARTITIONS 1
25 (PARTITION P1 VALUES LESS THAN (2) TABLESPACE ts1);
26 # Workaround BUG#30248840 which describes problem with updating
27 # tablespace id on participant when altering tablespace where table
28 # has RANGE partitions
29 DROP TABLE t1;
30 CREATE TABLE t1 (
31 a INT NOT NULL,
32 PRIMARY KEY (a)
33 ) ENGINE=NDB;
34 # End Workaround
35 # mysqld2> Check that tablespace can be altered on participant
36 ALTER TABLESPACE ts1
37 ADD DATAFILE 'ts1_datafile2.dat';
38 ALTER TABLESPACE ts1
39 DROP DATAFILE 'ts1_datafile2.dat';
40 # Cleanup
41 DROP TABLE t1;
42 ALTER TABLESPACE ts1
43 DROP DATAFILE 'ts1_datafile1.dat';
44 DROP TABLESPACE ts1;
45 DROP LOGFILE GROUP lg1 ENGINE = NDB;