MySQL 5.7.28,CentOS6,主机服务器:128c128G
MySQL crash之后被守护进程拉起,现在无法定位原因。Error 日志如下:
*** glibc detected *** /newdata/app/mysql57/bin/mysqld: invalid fastbin entry (free): 0x00002bcb9d48a0b0 ***
======= Backtrace: =========
/lib64/libc.so.6[0x3261876166]
/newdata/app/mysql57/bin/mysqld[0xd10509]
/newdata/app/mysql57/bin/mysqld(_Z15mysql_change_dbP3THDRK25st_mysql_const_lex_stringb+0x3ce)[0xd1117e]
/newdata/app/mysql57/bin/mysqld(_Z21mysql_execute_commandP3THDb+0xac4)[0xd48e34]
/newdata/app/mysql57/bin/mysqld(_Z11mysql_parseP3THDP12Parser_state+0x3dd)[0xd4d6cd]
/newdata/app/mysql57/bin/mysqld(_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+0x11d5)[0xd4e975]
/newdata/app/mysql57/bin/mysqld(_Z10do_commandP3THD+0x194)[0xd4f854]
/newdata/app/mysql57/bin/mysqld(handle_connection+0x2ac)[0xe21a8c]
/newdata/app/mysql57/bin/mysqld(pfs_spawn_thread+0x174)[0x10004e4]
/lib64/libpthread.so.0[0x3261c079d1]
/lib64/libc.so.6(clone+0x6d)[0x32618e8b6d]
......
Thread pointer: 0x2bcd21149720
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 = 2bd54a8dce28 thread_stack 0x40000
/newdata/app/mysql57/bin/mysqld(my_print_stacktrace+0x35)[0xf81bf5]
/newdata/app/mysql57/bin/mysqld(handle_fatal_signal+0x4a4)[0x7fb344]
/lib64/libpthread.so.0[0x3261c0f710]
/lib64/libc.so.6(gsignal+0x35)[0x3261832925]
/lib64/libc.so.6(abort+0x175)[0x3261834105]
/lib64/libc.so.6[0x3261870837]
/lib64/libc.so.6[0x3261876166]
/newdata/app/mysql57/bin/mysqld[0xd10509]
/newdata/app/mysql57/bin/mysqld(_Z15mysql_change_dbP3THDRK25st_mysql_const_lex_stringb+0x3ce)[0xd1117e]
/newdata/app/mysql57/bin/mysqld(_Z21mysql_execute_commandP3THDb+0xac4)[0xd48e34]
/newdata/app/mysql57/bin/mysqld(_Z11mysql_parseP3THDP12Parser_state+0x3dd)[0xd4d6cd]
/newdata/app/mysql57/bin/mysqld(_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+0x11d5)[0xd4e975]
/newdata/app/mysql57/bin/mysqld(_Z10do_commandP3THD+0x194)[0xd4f854]
/newdata/app/mysql57/bin/mysqld(handle_connection+0x2ac)[0xe21a8c]
/newdata/app/mysql57/bin/mysqld(pfs_spawn_thread+0x174)[0x10004e4]
/lib64/libpthread.so.0[0x3261c079d1]
/lib64/libc.so.6(clone+0x6d)[0x32618e8b6d]
具体其他见附件。
gdb可以定位到
(gdb) b *0xd10509
Breakpoint 1 at 0xd10509: file /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/sql_class.h, line 4178.
(gdb) b *0xd1117e
Breakpoint 2 at 0xd1117e: file /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/sql_db.cc, line 1689.
但是没有找到相关bug,崩溃前数据库负载正常,无异常会话,感觉像是内存问题,有没有老师帮看下