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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.043 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.