Bug #20767 Crash due to split of one partition with subpartitions ino 2.

• Submitted: 29 Jun 2006 8:32
• Modified: 19 Jul 2006 4:14
• Reporter: Horst Hunger
• Status: Closed
• Category: MySQL Server: Partitions
• Severity: S1 (Critical)
• Version: 5.1.12
• OS: Linux (Suse 10.1)
• Assigned to: Mikael Ronström
• CPU Architecture: Any

[29 Jun 2006 8:32] Horst Hunger

Description:
The following ALTER statement 

ALTER TABLE tb5_eng1 REORGANIZE PARTITION part2 INTO
(PARTITION part8 values in (5,6) DATA DIRECTORY =
'/data0/mysql/mysql-5.1-clone/mysql-test/var/master-data/tmpdata' INDEX DIRECTORY ='/data0/mysql/mysql-5.1-clone/mysql-test/var/master-data/tmpindex' (SUBPARTITION subpart81, SUBPARTITION subpart82,SUBPARTITION subpart83, SUBPARTITION subpart84),
PARTITION part9 values in (7,8) DATA DIRECTORY =
'/data0/mysql/mysql-5.1-clone/mysql-test/var/master-data/tmpdata' INDEX DIRECTORY ='/data0/mysql/mysql-5.1-clone/mysql-test/var/master-data/tmpindex' (SUBPARTITION subpart91, SUBPARTITION subpart92,SUBPARTITION subpart93, SUBPARTITION subpart94)

contains a split of one partition with 4 values (4 subpartitions) into 2 partitions with each 2 values and  4 subpartitions. I assume that this should be rejected.

See attached program.

How to repeat:
perl mysql-test-run.pl error_reorg_part2_8

[29 Jun 2006 12:10] MySQL Verification Team

Thank you for the bug report. Verified as described:

'/home/miguel/dbs/mysql-5.1/mysql-test/var/master-data/tmpindex' (SUBPARTITION subpart91, SUBPARTITION subpart92,SUBPARTITION subpart93, SUBPARTITION subpart94))' failed: 2013: Lost connection to MySQL server during query

[12 Jul 2006 8:47] Mikael Ronström

This is solved by the same patch as bug#20893

[18 Jul 2006 8:55] Mikael Ronström

Will appear in 5.1.12

[19 Jul 2006 4:14] Jon Stephens

Documented bugfix in 5.1.12 changelog.