5.1.48版本 truncate table导致crash

这个问题在去年已遇到过了,当时我记得大部分机器都打patch,今天又遇到(少部分机器没打),还是简单记录一下,实例crash后,直接启来,就恢复了。5.1.53版本中修复。
bug地址:http://bugs.mysql.com/bug.php?id=54678
alert.log里报错

InnoDB: but the tablespace does not exist or is just being dropped.
121022 13:32:38  InnoDB: Error: trying to access tablespace 5331 page no. 2,
InnoDB: but the tablespace does not exist or is just being dropped.
121022 13:32:38  InnoDB: Error: trying to access tablespace 5331 page no. 2,
InnoDB: but the tablespace does not exist or is just being dropped.
121022 13:32:38  InnoDB: Error: trying to access tablespace 5331 page no. 2,
InnoDB: but the tablespace does not exist or is just being dropped.
121022 13:32:38  InnoDB: Error: trying to access tablespace 5331 page no. 2,
......
stack_bottom = 0x4ab860f0 thread_stack 0x40000
/xx/xxlibexec/mysqld(my_print_stacktrace+0x2e)[0x872b2e]
/xx/xxlibexec/mysqld(handle_segfault+0x322)[0x5b6d02]
/lib64/libpthread.so.0[0x309100e7c0]
/lib64/libc.so.6(gsignal+0x35)[0x3090430265]
/lib64/libc.so.6(abort+0x110)[0x3090431d10]
/xx/xxlib/mysql/plugin/ha_innodb_plugin.so[0x2aaab2df35f8]
/xx/xxlib/mysql/plugin/ha_innodb_plugin.so[0x2aaab2e1bcc5]
/xx/xxlib/mysql/plugin/ha_innodb_plugin.so[0x2aaab2e1be5a]
/xx/xxlib/mysql/plugin/ha_innodb_plugin.so[0x2aaab2dd09d4]
/xx/xxlib/mysql/plugin/ha_innodb_plugin.so[0x2aaab2e069e3]
/xx/xxlib/mysql/plugin/ha_innodb_plugin.so[0x2aaab2e323b3]
/xx/xxlibexec/mysqld[0x6e17f1]
/xx/xxlibexec/mysqld(_Z14get_all_tablesP3THDP10TABLE_LISTP4Item+0xa6a)[0x6dbe9a]
/xx/xxlibexec/mysqld(_Z24get_schema_tables_resultP4JOIN23enum_schema_table_state+0x1d0)[0x6d1a90]
/xx/xxlibexec/mysqld(_ZN4JOIN4execEv+0x439)[0x63abd9]
/xx/xxlibexec/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select
_lex_unitP13st_select_lex+0x198)[0x63cd38]
/xx/xxlibexec/mysqld(_Z13handle_selectP3THDP6st_lexP13select_resultm+0x169)[0x63d679]
/xx/xxlibexec/mysqld[0x5c167c]
/xx/xxlibexec/mysqld(_Z21mysql_execute_commandP3THD+0x3365)[0x5c8785]
/xx/xxlibexec/mysqld(_Z11mysql_parseP3THDPKcjPS2_+0x231)[0x5cd371]
/xx/xxlibexec/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x3f3)[0x5cd773]
/xx/xxlibexec/mysqld(_Z10do_commandP3THD+0xe4)[0x5cea04]
/xx/xxlibexec/mysqld(handle_one_connection+0x5b7)[0x5bf0d7]
/lib64/libpthread.so.0[0x30910064a7]
/lib64/libc.so.6(clone+0x6d)[0x30904d3c2d]

Post a Comment