Bug #21177 Alter partitioning methode to list caused a crash
Submitted: 20 Jul 2006 11:35 Modified: 11 Sep 2006 12:03
Reporter: Horst Hunger Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Partitions Severity:S1 (Critical)
Version:5.1.12-Beta (06.07.19) OS:Linux (Suse 10.1)
Assigned to: CPU Architecture:Any

[20 Jul 2006 11:35] Horst Hunger
Description:
The following statement,which I used to change the partitioning methode from list,subpartition by hash, to range, subpartition by hash, caused a crash:

ALTER TABLE systest1.tb9_eng1 PARTITION BY RANGE (f1)
SUBPARTITION BY HASH (f1)
(PARTITION part1 VALUES LESS THAN (4) DATA DIRECTORY =
'/data0/mysql/mysql-5.1/mysql-test/var/master-data/tmpdata' INDEX DIRECTORY =
'/data0/mysql/mysql-5.1/mysql-test/var/master-data/tmpindex'
(SUBPARTITION subpart11, SUBPARTITION subpart12),
PARTITION part2 VALUES LESS THAN (8) DATA DIRECTORY =
'/data0/mysql/mysql-5.1/mysql-test/var/master-data/tmpdata' INDEX DIRECTORY =
'/data0/mysql/mysql-5.1/mysql-test/var/master-data/tmpindex'
(SUBPARTITION subpart21, SUBPARTITION subpart22),
PARTITION part3 VALUES LESS THAN (12) DATA DIRECTORY =
'/data0/mysql/mysql-5.1/mysql-test/var/master-data/tmpdata' INDEX DIRECTORY =
'/data0/mysql/mysql-5.1/mysql-test/var/master-data/tmpindex'
(SUBPARTITION subpart31, SUBPARTITION subpart32),
PARTITION part4 VALUES LESS THAN (16) DATA DIRECTORY =
'/data0/mysql/mysql-5.1/mysql-test/var/master-data/tmpdata' INDEX DIRECTORY =
'/data0/mysql/mysql-5.1/mysql-test/var/master-data/tmpindex'
(SUBPARTITION subp ...

See attached files.

How to repeat:
Can be repeated by executing "system_3".
But try to reproduce it with a smal program.
See comments.
[3 Aug 2006 12:18] Valeriy Kravchuk
Thank you for a bug report. Did you have a chance to reproduce the crash with a simple test case?
[3 Aug 2006 20:22] Horst Hunger
Take a look at BUG #21210.
It crashes in the same function 'load_master_data'.
May be, that both bugs have the same reason.
[8 Sep 2006 17:19] Mikael Ronström
Most likely a variant of bug#21210
[11 Sep 2006 12:03] Valeriy Kravchuk
Duplicate of bug #21210. At least, should be re-checked when that bug will be fixed.