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
• Status: Duplicate
• Category: MySQL Server: Partitions
• Severity: S1 (Critical)
• Version: 5.1.12-Beta (06.07.19)
• OS: Linux (Suse 10.1)
• 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.