MySQL Crashes on COALESCE PARTITION

[merikonjatta]

MySQL crashes on attempt to SHOW TABLE STATUS when the results include a table partitioned by Spider. Neither can I add new partitions.

COALESCE PARTITIONを実行したとき、当該DBにSpiderによってパーティションされたテーブルが含まれるとMySQLごとクラッシュします。同じくADD PARTITIONも実行できずクラッシュします。
ソフトウェアのバージョンやテーブル構成は以下の通りです。

Spider table:

CREATE TABLE `table_one` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=SPIDER DEFAULT CHARSET=utf8 CONNECTION='database "mtest", table "table_one", user "user", password ""'
PARTITION BY LINEAR HASH (id)
(PARTITION pt1 COMMENT = 'host "remotenode1"' ENGINE = SPIDER,
 PARTITION pt2 COMMENT = 'host "remotenode2"' ENGINE = SPIDER,
 PARTITION pt3 COMMENT = 'host "remotenode3"' ENGINE = SPIDER);

Remote InnoDB partition tables:

CREATE TABLE `table_one` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Now I try to coalesce a partition and MySQL crashes:

mysql> ALTER TABLE `table_one` COALESCE PARTITION 1;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> 091124 21:59:31 mysqld_safe Number of processes running now: 0
091124 21:59:31 mysqld_safe mysqld restarted

Here's the error log from mysqld:

thd: 0x87f1be0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x8c9c5398 thread_stack 0x30000
/usr/local/mysql/bin/mysqld(my_print_stacktrace+0x22) [0x84f8922]
/usr/local/mysql/bin/mysqld(handle_segfault+0x3d9) [0x8216c79]
[0xb7fe5400]
/usr/local/mysql/lib/mysql/plugin/ha_spider.so(spider_parse_connect_info(st_spider_share*, st_table*, unsigned int)+0xd8c) [0xb4b8
703c]
/usr/local/mysql/lib/mysql/plugin/ha_spider.so(ha_spider::create(char const*, st_table*, st_ha_create_information*)+0x10a) [0xb4b9
739a]
/usr/local/mysql/bin/mysqld(ha_partition::prepare_new_partition(st_table*, st_ha_create_information*, handler*, char const*, parti
tion_element*)+0x72) [0x831a072]
/usr/local/mysql/bin/mysqld(ha_partition::change_partitions(st_ha_create_information*, char const*, unsigned long long*, unsigned
long long*, unsigned char const*, unsigned int)+0x73d) [0x831a82d]
/usr/local/mysql/bin/mysqld [0x8154370]
/usr/local/mysql/bin/mysqld(fast_alter_partition_table(THD*, st_table*, Alter_info*, st_ha_create_information*, TABLE_LIST*, char*
, char const*, unsigned int)+0x6a7) [0x815a077]
/usr/local/mysql/bin/mysqld(mysql_alter_table(THD*, char*, char*, st_ha_create_information*, TABLE_LIST*, Alter_info*, unsigned in
t, st_order*, bool)+0x18ff) [0x832887f]
/usr/local/mysql/bin/mysqld(mysql_execute_command(THD*)+0x10b6) [0x8228666]
/usr/local/mysql/bin/mysqld(mysql_parse(THD*, char const*, unsigned int, char const**)+0x340) [0x822f530]
/usr/local/mysql/bin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x1112) [0x8230652]
/usr/local/mysql/bin/mysqld(do_command(THD*)+0xdf) [0x82311ef]
/usr/local/mysql/bin/mysqld(handle_one_connection+0x253) [0x8221123]
/lib/tls/i686/cmov/libpthread.so.0 [0xb7fcc4ff]
/lib/tls/i686/cmov/libc.so.6(clone+0x5e) [0xb7dd349e]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x9579660 = ALTER TABLE `table_one` COALESCE PARTITION 1
thd->thread_id=1
thd->killed=NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
091124 21:59:31 mysqld_safe Number of processes running now: 0
091124 21:59:31 mysqld_safe mysqld restarted

[Kentoku SHIBA (kentokushiba)]

バグ報告ありがとうございます。
修正を行い、バージョン2.9でリリースしましたので、ご確認をお願いします。