percona mysql 5.1.63-443版本crash说明

2014-03-23

dump导出所有myisam(gbk charset)表,重新导入到percona 5.1.63-443版本中,重启出现崩溃错误,bug参考: https://bugs.launchpad.net/pld-linux/+bug/1073584 https://bugs.launchpad.net/percona-server/+bug/984605 https://bugs.launchpad.net/codership-mysql/+bug/1254179 升级到新版5.1.73可解决改问题; 启动时触发该问题,未得到有效的信息. 测试环境: centos 6.4 x86_64 32G Percona-Server-5.1.63-rel13.4-443.Linux.x86_64

May 23 11:02:50 cz mysqld_safe-3306: Starting mysqld daemon with databases from /web/mysql/node3306/data
May 23 11:02:50 cz mysqld-3306: 140523 11:02:50 [Note] Flashcache bypass: disabled
May 23 11:02:50 cz mysqld-3306: 140523 11:02:50 [Note] Flashcache setup error is : ioctl failed
May 23 11:02:50 cz mysqld-3306: 
May 23 11:02:50 cz mysqld-3306: 140523 11:02:50 [Note] Plugin 'FEDERATED' is disabled.
May 23 11:02:50 cz mysqld-3306: 140523 11:02:50 [ERROR] Can't open shared library '/opt/Percona-Server-5.1.63-rel13.4-443.Linux.x86_64/lib/mysql/plugin/mysqlcft.so' (errno: 0 cannot open 
shared object file: No such file or directory)
May 23 11:02:50 cz mysqld-3306: 140523 11:02:50 [Warning] Couldn't load plugin named 'mysqlcft' with soname 'mysqlcft.so'.
May 23 11:02:50 cz mysqld-3306: 03:02:50 UTC - mysqld got signal 11 ;
May 23 11:02:50 cz mysqld-3306: This could be because you hit a bug. It is also possible that this binary
May 23 11:02:50 cz mysqld-3306: or one of the libraries it was linked against is corrupt, improperly built,
May 23 11:02:50 cz mysqld-3306: or misconfigured. This error can also be caused by malfunctioning hardware.
May 23 11:02:50 cz mysqld-3306: We will try our best to scrape up some info that will hopefully help
May 23 11:02:50 cz mysqld-3306: diagnose the problem, but since we have already crashed, 
May 23 11:02:50 cz mysqld-3306: something is definitely wrong and this may fail.
May 23 11:02:50 cz mysqld-3306: 
May 23 11:02:50 cz mysqld-3306: key_buffer_size=524288000
May 23 11:02:50 cz mysqld-3306: read_buffer_size=2097152
May 23 11:02:50 cz mysqld-3306: max_used_connections=0
May 23 11:02:50 cz mysqld-3306: max_threads=3000
May 23 11:02:50 cz mysqld-3306: thread_count=0
May 23 11:02:50 cz mysqld-3306: connection_count=0
May 23 11:02:50 cz mysqld-3306: It is possible that mysqld could use up to 
May 23 11:02:50 cz mysqld-3306: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 12833140 K  bytes of memory
May 23 11:02:50 cz mysqld-3306: Hope that's ok; if not, decrease some variables in the equation.
May 23 11:02:50 cz mysqld-3306: 
May 23 11:02:50 cz mysqld-3306: Thread pointer: 0x13a0800
May 23 11:02:50 cz mysqld-3306: Attempting backtrace. You can use the following information to find out
May 23 11:02:50 cz mysqld-3306: where mysqld died. If you see no messages after this, something went
May 23 11:02:50 cz mysqld-3306: terribly wrong...
May 23 11:02:50 cz mysqld-3306: stack_bottom = 7fffc5c8e0d0 thread_stack 0x40000
May 23 11:02:50 cz mysqld-3306: /opt/Percona-Server-5.1.63-rel13.4-443.Linux.x86_64/libexec/mysqld(my_print_stacktrace+0x35)[0x8a45e5]
May 23 11:02:50 cz mysqld-3306: /opt/Percona-Server-5.1.63-rel13.4-443.Linux.x86_64/libexec/mysqld(handle_fatal_signal+0x378)[0x6acb48]
May 23 11:02:50 cz mysqld-3306: /lib64/libpthread.so.0(+0xf710)[0x7f9f8452d710]
May 23 11:02:50 cz mysqld-3306: /opt/Percona-Server-5.1.63-rel13.4-443.Linux.x86_64/libexec/mysqld(my_hash_insert+0x25a)[0x8987da]
May 23 11:02:50 cz mysqld-3306: /opt/Percona-Server-5.1.63-rel13.4-443.Linux.x86_64/libexec/mysqld(_ZN7handler25update_global_table_statsEv+0x1ed)[0x6a132d]
May 23 11:02:50 cz mysqld-3306: /opt/Percona-Server-5.1.63-rel13.4-443.Linux.x86_64/libexec/mysqld(_Z18close_thread_tableP3THDPP8st_table+0x2b)[0x609acb]
May 23 11:02:50 cz mysqld-3306: /opt/Percona-Server-5.1.63-rel13.4-443.Linux.x86_64/libexec/mysqld(_Z19close_thread_tablesP3THD+0x14b)[0x609eeb]
May 23 11:02:50 cz mysqld-3306: /opt/Percona-Server-5.1.63-rel13.4-443.Linux.x86_64/libexec/mysqld(_Z11plugin_initPiPPci+0x6a4)[0x721234]
May 23 11:02:50 cz mysqld-3306: /opt/Percona-Server-5.1.63-rel13.4-443.Linux.x86_64/libexec/mysqld[0x5bccd1]
May 23 11:02:50 cz mysqld-3306: /opt/Percona-Server-5.1.63-rel13.4-443.Linux.x86_64/libexec/mysqld(main+0x7c9)[0x5be1e9]
May 23 11:02:50 cz mysqld-3306: /lib64/libc.so.6(__libc_start_main+0xfd)[0x7f9f834b2d1d]
May 23 11:02:50 cz mysqld-3306: /opt/Percona-Server-5.1.63-rel13.4-443.Linux.x86_64/libexec/mysqld[0x500379]
May 23 11:02:50 cz mysqld-3306: 
May 23 11:02:50 cz mysqld-3306: Trying to get some variables.
May 23 11:02:50 cz mysqld-3306: Some pointers may be invalid and cause the dump to abort.
May 23 11:02:50 cz mysqld-3306: Query (0): is an invalid pointer
May 23 11:02:50 cz mysqld-3306: Connection ID (thread ID): 0
May 23 11:02:50 cz mysqld-3306: Status: NOT_KILLED
May 23 11:02:50 cz mysqld-3306: 
May 23 11:02:50 cz mysqld-3306: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
May 23 11:02:50 cz mysqld-3306: information that should help you find out what is causing the crash.
May 23 11:02:50 cz mysqld_safe-3306: mysqld from pid file /web/mysql/node3306/data/mysql.pid ended