MySQL crashes during an ALTER TABLE

Bug #697701 reported by Laurent Bigonville
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Spider for MySQL
Fix Released
High
Kentoku SHIBA

Bug Description

Hi,

MySQL is crashing when doing an ALTER TABLE on an existing innodb table with existing data

ALTER TABLE table
ENGINE=SPIDER CONNECTION='table "table", user "root"'
PARTITION BY LIST(id)
(PARTITION p0 values in (0, 3, 6) COMMENT = 'host "m0", port "3306"' ENGINE = SPIDER,
PARTITION p1 values in (1, 4, 7) COMMENT = 'host "m1", port "3306"' ENGINE = SPIDER,
PARTITION p2 values in (2, 5, 8) COMMENT = 'host "m2", port "3306"' ENGINE = SPIDER);

I get the following backtrace:

thd: 0x39d5abe0
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 = 0x7f0b4a520ea0 thread_stack 0x30000
/usr/bin/mysqld(my_print_stacktrace+0x24) [0x781404]
/usr/bin/mysqld(handle_segfault+0x35c) [0x5c478c]
/lib64/libpthread.so.0(+0xf5d0) [0x7f13f14365d0]
/usr/bin/mysqld(my_pthread_fastmutex_lock+0xd) [0x786b3d]
/usr/lib64/mysql/plugin/ha_spider.so(spider_db_show_table_status(ha_spider*, int, int)+0x394) [0x7f13ed58aca4]
/usr/lib64/mysql/plugin/ha_spider.so(spider_get_sts(st_spider_share*, int, long, ha_spider*, double, int, int, int)+0xd3) [0x7f13ed59f243]
/usr/lib64/mysql/plugin/ha_spider.so(ha_spider::info(unsigned int)+0x5bb) [0x7f13ed5b62db]
/usr/bin/mysqld(ha_partition::info(unsigned int)+0x121) [0x6a1501]
/usr/bin/mysqld(ha_partition::open(char const*, int, unsigned int)+0x3d1) [0x6a5051]
/usr/bin/mysqld(handler::ha_open(st_table*, char const*, int, int)+0x3f) [0x69c1cf]
/usr/bin/mysqld(open_table_from_share(THD*, st_table_share*, char const*, unsigned int, unsigned int, unsigned int, st_table*, bool)+0x56a) [0x60f33a]
/usr/bin/mysqld(open_temporary_table(THD*, char const*, char const*, char const*, bool)+0x196) [0x603a46]
/usr/bin/mysqld(mysql_alter_table(THD*, char*, char*, st_ha_create_information*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool)+0x194d) [0x6b4e4d]
/usr/bin/mysqld(mysql_execute_command(THD*)+0xd6c) [0x5cfb8c]
/usr/bin/mysqld(mysql_parse(THD*, char const*, unsigned int, char const**)+0x217) [0x5d4757]
/usr/bin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x8f6) [0x5d60c6]
/usr/bin/mysqld(do_command(THD*)+0xe6) [0x5d6de6]
/usr/bin/mysqld(handle_one_connection+0x216) [0x5ca846]
/lib64/libpthread.so.0(+0x75f0) [0x7f13f142e5f0]
/lib64/libc.so.6(clone+0x6d) [0x7f13f03ce84d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x7f0b3c004a50 is an invalid pointer
thd->thread_id=8
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.

Changed in spiderformysql:
assignee: nobody → Kentoku SHIBA (kentokushiba)
importance: Undecided → High
Changed in spiderformysql:
status: New → In Progress
Revision history for this message
Kentoku SHIBA (kentokushiba) wrote :

Hi,

Thank you for reporting a bug.
This bug was fixed and released in Spider 2.24.

Thanks,
Kentoku

Changed in spiderformysql:
status: In Progress → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.