Debian Codegraph @

mysql-test/suite/ndb_ddl/drop_table_release_mdl.test

raw
1 --source connect.inc
2
3 --echo # Create logfile group, tablespace, and table in the tablespace
4 CREATE LOGFILE GROUP lg1
5 ADD UNDOFILE 'lg1_undofile.dat'
6 INITIAL_SIZE 1M
7 UNDO_BUFFER_SIZE = 1M
8 ENGINE NDB;
9
10 CREATE TABLESPACE ts1
11 ADD DATAFILE 'ts1_datafile.dat'
12 USE LOGFILE GROUP lg1
13 INITIAL_SIZE 2M
14 ENGINE NDB;
15
16 CREATE TABLE t10 (
17 a INT PRIMARY KEY,
18 b VARCHAR(255)
19 ) ENGINE NDB
20 TABLESPACE ts1
21 STORAGE DISK;
22
23 --echo # Drop the table, this caused problem on participant which didn't
24 --echo # release an MDL lock in TRANSACTIONAL scope
25 DROP TABLE t10;
26
27 --connection mysqld2
28 --echo # mysqld2> Run query accessing the tablespace where t10 was located
29 SELECT LOGFILE_GROUP_NAME, FILE_NAME, TOTAL_EXTENTS, INITIAL_SIZE, ENGINE, EXTRA
30 FROM INFORMATION_SCHEMA.FILES
31 WHERE FILE_TYPE = 'UNDO LOG'
32 AND FILE_NAME IS NOT NULL
33 AND LOGFILE_GROUP_NAME IS NOT NULL
34 ORDER BY LOGFILE_GROUP_NAME;
35
36 --echo # Cleanup
37 --connection mysqld1
38 ALTER TABLESPACE ts1
39 DROP DATAFILE 'ts1_datafile.dat';
40 DROP TABLESPACE ts1;
41 DROP LOGFILE GROUP lg1 ENGINE NDB;