Percona 8.0.30中show engine innodb status导致coredump排查及分析
- GreatSQL社区原创内容未经授权不得随意使用，转载请联系小编并注明来源。
- GreatSQL是MySQL的国产分支版本，使用上与MySQL一致。
- 作者：lh
- 文章来源：GreatSQL社区原创
1. 异常崩溃
GreatSQL合并Percona-Server 8.0.30的Beta版测试中，QA报了一个crash的bug：
########### bug list ##########
benchmarksql加载1000仓数据时，数据库实例发生coredump。
core堆栈信息如下：
#0 0x00007f51315a39d1 in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000013258cd in handle_fatal_signal () at /src/sql/signal_handler.cc:228
#2
#3 0x0000000001339244 in mem_root_deque::push_back () at /src/include/mem_root_deque.h:182
#4 0x0000000001364a16 in push_back () at /src/sql/parse_tree_helpers.h:126
#5 MYSQLparse(THD*, Parse_tree_root**) () at /src/sql/sql_yacc.yy:13506
#6 0x000000000103a595 in THD::sql_parser () at /src/sql/sql_class.cc:3287
#7 0x00000000010d0e37 in parse_sql () at /src/sql/sql_parse.cc:7353
#8 0x00000000010d61bd in dispatch_sql_command () at /src/sql/sql_parse.cc:5399
#9 0x00000000010d78d0 in dispatch_command () at /src/sql/sql_parse.cc:2052
#10 0x00000000010d9a12 in do_command () at /src/sql/sql_parse.cc:1424
#11 0x00000000013159f8 in handle_connection () at /src/sql/conn_handler/connection_handler_per_thread.cc:308
#12 0x00000000027db225 in pfs_spawn_thread () at /src/storage/perfschema/pfs.cc:2943
#13 0x00007f513159edd5 in start_thread () from /lib64/libpthread.so.0
#14 0x00007f512ffa9ead in clone () from /lib64/libc.so.6
core文件在测试服务器xxx.xxx.xxx.xxx的xxx目录，能够稳定复现crash。
