Debian Codegraph @

mysql-test/suite/parts/t/partition_debug_sync_innodb.test

raw
1 --source include/have_innodb.inc
2 --source include/have_partition.inc
3 --source include/have_debug_sync.inc
4
5 let $MYSQLD_DATADIR=`SELECT @@datadir`;
6
7 --echo #
8 --echo # Bug#49907: ALTER TABLE ... TRUNCATE PARTITION
9 --echo # does not wait for locks on the table
10 --echo #
11 CREATE TABLE t1 (a INT)
12 ENGINE = InnoDB
13 PARTITION BY RANGE (a)
14 (PARTITION p0 VALUES LESS THAN (15),
15 PARTITION pMax VALUES LESS THAN MAXVALUE);
16 INSERT INTO t1 VALUES (1), (11), (21), (33);
17 BEGIN;
18 DELETE FROM t1 WHERE a = 11;
19 --sorted_result
20 SELECT * FROM t1;
21
22 --connect (con1, localhost, root,,)
23 --send
24 ALTER TABLE t1 TRUNCATE PARTITION pMax;
25
26 --connection default
27 let $wait_condition=
28 SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST
29 WHERE STATE = "Waiting for table metadata lock" AND
30 INFO = "ALTER TABLE t1 TRUNCATE PARTITION pMax";
31 --source include/wait_condition.inc
32 --sorted_result
33 SELECT * FROM t1;
34 --echo # Commit will allow the TRUNCATE to finish
35 COMMIT;
36
37 --connection con1
38 --reap
39 --disconnect con1
40 --connection default
41 SELECT * FROM t1;
42 DROP TABLE t1;
43
44 --echo #
45 --echo # Bug#50561: ALTER PARTITIONS does not have adequate lock, breaks with
46 --echo # concurrent I_S query
47 create table t1 (a int)
48 engine = innodb stats_persistent=0
49 partition by range (a)
50 (partition p0 values less than MAXVALUE);
51 insert into t1 values (1), (11), (21), (33);
52 SELECT * FROM t1;
53 SHOW CREATE TABLE t1;
54 --replace_result #p# #P# #sp# #SP#
55 --list_files $MYSQLD_DATADIR/test
56
57 SET DEBUG_SYNC='before_open_in_get_all_tables SIGNAL parked WAIT_FOR open';
58 SET DEBUG_SYNC='partition_open_error SIGNAL alter WAIT_FOR finish';
59 send
60 SELECT TABLE_SCHEMA, TABLE_NAME, PARTITION_NAME, PARTITION_ORDINAL_POSITION,
61 PARTITION_DESCRIPTION, TABLE_ROWS
62 FROM INFORMATION_SCHEMA.PARTITIONS
63 WHERE TABLE_NAME = 't1' AND TABLE_SCHEMA = 'test';
64
65 connect (con1, localhost, root,,);
66 SET DEBUG_SYNC = 'now WAIT_FOR parked';
67 --echo # When waiting for the name lock in get_all_tables in sql_show.cc
68 --echo # this will not be concurrent any more, thus the TIMEOUT
69 SET DEBUG_SYNC = 'before_rename_partitions SIGNAL open WAIT_FOR alter TIMEOUT 1';
70 --echo # Needs to be executed twice, since first is this 'SET DEBUG_SYNC ...'
71 SET DEBUG_SYNC = 'before_close_thread_tables SIGNAL finish EXECUTE 2';
72 --error 0,ER_TABLE_EXISTS_ERROR
73 ALTER TABLE t1 REORGANIZE PARTITION p0 INTO
74 (PARTITION p0 VALUES LESS THAN (10),
75 PARTITION p10 VALUES LESS THAN MAXVALUE);
76
77 disconnect con1;
78 connection default;
79 --reap
80 --replace_result #p# #P# #sp# #SP#
81 --list_files $MYSQLD_DATADIR/test
82 SHOW CREATE TABLE t1;
83 SELECT * FROM t1;
84 drop table t1;
85 --list_files $MYSQLD_DATADIR/test
86 SET DEBUG_SYNC = 'RESET';