2
# Bug#50561: ALTER PARTITIONS does not have adequate lock, breaks with
4
create table t1 (a int)
7
(partition p0 values less than MAXVALUE);
8
insert into t1 values (1), (11), (21), (33);
17
t1 CREATE TABLE `t1` (
18
`a` int(11) DEFAULT NULL
19
) ENGINE=InnoDB DEFAULT CHARSET=latin1
20
/*!50100 PARTITION BY RANGE (a)
21
(PARTITION p0 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
25
SET DEBUG_SYNC='before_open_in_get_all_tables SIGNAL parked WAIT_FOR open';
26
SET DEBUG_SYNC='partition_open_error SIGNAL alter WAIT_FOR finish';
27
SELECT * FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME = 't1' AND TABLE_SCHEMA = 'test';
28
SET DEBUG_SYNC = 'now WAIT_FOR parked';
29
# When waiting for the name lock in get_all_tables in sql_show.cc
30
# this will not be concurrent any more, thus the TIMEOUT
31
SET DEBUG_SYNC = 'before_rename_partitions SIGNAL open WAIT_FOR alter TIMEOUT 1';
32
# Needs to be executed twice, since first is this 'SET DEBUG_SYNC ...'
33
SET DEBUG_SYNC = 'before_close_thread_tables SIGNAL finish EXECUTE 2';
34
ALTER TABLE t1 REORGANIZE PARTITION p0 INTO
35
(PARTITION p0 VALUES LESS THAN (10),
36
PARTITION p10 VALUES LESS THAN MAXVALUE);
38
Warning 1639 debug sync point wait timed out
39
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME PARTITION_NAME SUBPARTITION_NAME PARTITION_ORDINAL_POSITION SUBPARTITION_ORDINAL_POSITION PARTITION_METHOD SUBPARTITION_METHOD PARTITION_EXPRESSION SUBPARTITION_EXPRESSION PARTITION_DESCRIPTION TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE CREATE_TIME UPDATE_TIME CHECK_TIME CHECKSUM PARTITION_COMMENT NODEGROUP TABLESPACE_NAME
40
NULL test t1 p0 NULL 1 NULL RANGE NULL a NULL 10 1 16384 16384 NULL 0 0 NULL NULL NULL NULL default NULL
41
NULL test t1 p10 NULL 2 NULL RANGE NULL a NULL MAXVALUE 3 5461 16384 NULL 0 0 NULL NULL NULL NULL default NULL
48
t1 CREATE TABLE `t1` (
49
`a` int(11) DEFAULT NULL
50
) ENGINE=InnoDB DEFAULT CHARSET=latin1
51
/*!50100 PARTITION BY RANGE (a)
52
(PARTITION p0 VALUES LESS THAN (10) ENGINE = InnoDB,
53
PARTITION p10 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
61
SET DEBUG_SYNC = 'RESET';