2009-11-24 13:01:59 |
merikonjatta |
bug |
|
|
added bug |
2009-11-24 13:03:11 |
merikonjatta |
description |
MySQL crashes on attempt to SHOW TABLE STATUS when the results include a table partitioned by Spider.
SHOW TABLE STATUSを実行したとき、当該DBにSpiderによってパーティションされたテーブルが含まれるとMySQLごとクラッシュします。
ソフトウェアのバージョンやテーブル構成は以下の通りです。
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 |
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ごとクラッシュします。
ソフトウェアのバージョンやテーブル構成は以下の通りです。
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
|
|
2009-11-24 13:03:45 |
merikonjatta |
description |
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ごとクラッシュします。
ソフトウェアのバージョンやテーブル構成は以下の通りです。
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
|
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
|
|
2009-11-24 14:56:23 |
Kentoku SHIBA |
spiderformysql: assignee |
|
Kentoku SHIBA (kentokushiba) |
|
2009-11-28 16:38:56 |
Kentoku SHIBA |
spiderformysql: importance |
Undecided |
Critical |
|
2009-11-28 16:39:32 |
Kentoku SHIBA |
spiderformysql: status |
New |
Fix Released |
|
2009-11-28 16:39:57 |
Kentoku SHIBA |
nominated for series |
|
spiderformysql/spider-2.x |
|
2009-11-28 16:39:57 |
Kentoku SHIBA |
bug task added |
|
spiderformysql/spider-2.x |
|