Bug #21211 Alter of nb of subpartitions (table partition by list) cause a crash with innodb
Submitted: 21 Jul 2006 10:36 Modified: 8 Dec 2006 15:37
Reporter: Horst Hunger Email Updates:
Status: No Feedback 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

[21 Jul 2006 10:36] Horst Hunger
Description:
Tried to change the number of subpartitions in by list  partitioned table. the statement:

ALTER TABLE systest1.tb6_eng1 REORGANIZE PARTITION part1,part2,part3,part4 INTO
(PARTITION part1 VALUES in (1,2,3) 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,SUBPARTITION subpart13,SUBPARTITION subpart14),
PARTITION part2 VALUES in (4,5,6,7,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,SUBPARTITION subpart23,SUBPARTITION subpart24),
PARTITION part3 VALUES in (9,10) 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,SUBPARTITION subpart33,SUBPARTITION subpart34),
PARTITION part4 VALUES in (11,12,13,14,15,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 subpart41,SUBPARTITION subpart42,SUBPARTITION subpart43,SUBPARTITION subpart44));

There is a lot of info in master.err (attached).
Backtrace is also attached.

How to repeat:
Will try to repeat it with a short program.
More: See comments.
[21 Jul 2006 14:53] Valeriy Kravchuk
Thank you for a bug report. Please, upload file
/data0/mysql/mysql-test-extra-5.1/mysql-test/suite/system_3/data/tb1.txt
mentioned in your test case, or explain, what content should it have.
[27 Jul 2006 5:27] Heikki Tuuri
Hmm... looks like MySQL is trying to rename a partition table to an existing partition table. Below I removed the warnings printed by the MySQL table name print function. I wonder why the MySQL print function refuses to print a legal MySQL-5.0 table name.

InnoDB: 2) table `systest1`.`#mysql50#tb6_eng1#P#part2#SP#subpart22` exists in the InnoDB internal data
InnoDB: dictionary though MySQL is trying rename table `systest1`.`#mysql50#tb6_eng1#P#part2#SP#subpart22#TMP#` to it.
[21 Aug 2006 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[8 Nov 2006 15:37] Valeriy Kravchuk
Please, try to repeat with 5.1.12, now GA, and inform about the results.
[9 Dec 2006 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".