Bug #21102 Merge of 2 partitions into one cause a crash.
Submitted: 17 Jul 2006 20:17 Modified: 18 Jul 2006 14:34
Reporter: Horst Hunger Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Partitions Severity:S1 (Critical)
Version:5.1.12-Beta OS:Linux (Suse 10.1)
Assigned to: CPU Architecture:Any

[17 Jul 2006 20:17] Horst Hunger
Description:
The following SQL statement caused the crash

ALTER TABLE tb5_eng1 REORGANIZE PARTITION part8,part9 INTO
(PARTITION part1 values in (1,2,3,4,5,6,7,8) DATA DIRECTORY =
'/data0/mysql/mysql-5.1-clone/mysql-test/var/master-data/tmpdata' INDEX DIRECTORY =
'/data0/mysql/mysql-5.1-clone/mysql-test/var/master-data/tmpindex'
(SUBPARTITION subpart21, SUBPARTITION subpart22, SUBPARTITION subpart23, SUBPARTITION subpart24))' failed: 2013: Lost connection to MySQL server during query

More information in attached files.

How to repeat:
perl mysql-test-run.pl --skip-ndb --suite experiments reorg_part2_8
[17 Jul 2006 20:21] Horst Hunger
master.err

Attachment: master.err (application/octet-stream, text), 3.40 KiB.

[18 Jul 2006 14:34] Valeriy Kravchuk
Thank you for a problem report. Sorry, but I was not able to repeat the behaviour described with today's 5.1.12-BK (ChangeSet@1.2258, 2006-07-17 06:53:46-04:00, mikael@dator5.(none) +1 -0), built --with-debug=full, on SuSE 9.3:

openxs@suse:~/dbs/5.1/mysql-test> ./mysql-test-run.pl --record reorg_part2_8
Logging: ./mysql-test-run.pl --record reorg_part2_8
Using ndbcluster if necessary, mysqld supports it
Skipping SSL, mysqld not compiled with SSL
Using MTR_BUILD_THREAD      = 0
Using MASTER_MYPORT         = 9306
Using MASTER_MYPORT1        = 9307
Using SLAVE_MYPORT          = 9308
Using SLAVE_MYPORT1         = 9309
Using SLAVE_MYPORT2         = 9310
Using NDBCLUSTER_PORT       = 9310
Using NDBCLUSTER_PORT_SLAVE = 9311
Using IM_PORT               = 9312
Using IM_MYSQLD1_PORT       = 9313
Using IM_MYSQLD2_PORT       = 9314
Killing Possible Leftover Processes
Removing Stale Files
Installing Master Database
Installing Master Database
=======================================================
Starting Tests in the 'main' suite

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

reorg_part2_8                  [ pass ]            417
-------------------------------------------------------
Ending Tests
Shutting-down MySQL daemon

Master(s) shutdown finished
Slave(s) shutdown finished
All 1 tests were successful.