Bug #21143 Reorganizing of subpartitions let mysqld hang.
Submitted: 19 Jul 2006 10:09 Modified: 2 Sep 2006 4:35
Reporter: Horst Hunger Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Partitions Severity:S1 (Critical)
Version:5.1.12-Beta (06.07.19) OS:Linux (Linux, Suse 10.1)
Assigned to: Mikael Ronström CPU Architecture:Any

[19 Jul 2006 10:09] Horst Hunger
Description:
After the following ALTER statement mysqld and 11 threads hang:

ALTER TABLE systest1.tb6_eng1 REORGANIZE PARTITION part1,part2,part3,part4 INTO
(PARTITION part1 VALUES in(1,2,3,4) <data_directory> <index_directory>
(SUBPARTITION subpart11,SUBPARTITION subpart12,SUBPARTITION subpart13,SUBPARTITION subpart14,SUBPARTITION subpart15),
PARTITION part2 VALUES in (5,6,7,8) <data_directory> <index_directory>
(SUBPARTITION subpart21,SUBPARTITION subpart22,SUBPARTITION subpart23,SUBPARTITION subpart24,SUBPARTITION subpart25),
PARTITION part3 VALUES in (9,10,11,12) <data_directory> <index_directory>
(SUBPARTITION subpart31,SUBPARTITION subpart32,SUBPARTITION subpart33,SUBPARTITION subpart34,SUBPARTITION subpart35),
PARTITION part4 VALUES in (13,14,15,16) <data_directory> <index_directory>
(SUBPARTITION subpart41,SUBPARTITION subpart42,SUBPARTITION subpart43,SUBPARTITION subpart44,SUBPARTITION subpart45));

In the log file contains the following error message:
ERROR HY000: Can't create symlink './systest1/tb6_eng1#P#part2#SP#subpart22.MYI' pointing at '/data0/mysql/mysql-5.1/mysql-test/var/master-data/tmpindex/tb6_eng1#P#part2#SP#subpart22.MYI' (Error 17)

That there is a problem creating a symlink may be, but mysqld must not hang.

How to repeat:
follows as comment.
[19 Jul 2006 11:48] Horst Hunger
How to execute the attached program (test-21143.test):
perl mysql-test-run.pl --skip-ndb --suite experiments test-21143
[19 Jul 2006 12:31] Horst Hunger
To repeat the hangigng mysqld use "cre-alter-21143.sql" with mysql. Change the directories if necessary to those you want.
[16 Aug 2006 11:55] Mikael Ronström
Reviewed by gluh
[31 Aug 2006 20:37] Mikael Ronström
fixed in 5.1-kt tree
[31 Aug 2006 20:40] Mikael Ronström
fixed in 5.1-kt team tree
[1 Sep 2006 7:52] Mikael Ronström
Patch will appear in 5.1.12
[2 Sep 2006 4:35] Jon Stephens
Documented bugfix in 5.1.12 changelog.