记一次mysql故障的恢复处理过程

Thread pointer: 0x0
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 = 0x0 thread_stack 0x49000
/usr/local/mysql/bin/mysqld(my_print_stacktrace+0x29)[0x562cb8522d19]
/usr/local/mysql/bin/mysqld(handle_fatal_signal+0x33d)[0x562cb8048f0d]
/lib64/libpthread.so.0(+0xf5d0)[0x7f978ed185d0]
/usr/local/mysql/bin/mysqld(+0xa6b2e8)[0x562cb846b2e8]
/usr/local/mysql/bin/mysqld(+0xa69ffc)[0x562cb8469ffc]
/usr/local/mysql/bin/mysqld(+0xa6a5fe)[0x562cb846a5fe]
/usr/local/mysql/bin/mysqld(+0xa6e986)[0x562cb846e986]
/usr/local/mysql/bin/mysqld(+0xa6f2ba)[0x562cb846f2ba]
/usr/local/mysql/bin/mysqld(+0xa50ab4)[0x562cb8450ab4]
/usr/local/mysql/bin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x61)[0x562cb804b321]
/usr/local/mysql/bin/mysqld(+0x4dfa90)[0x562cb7edfa90]
/usr/local/mysql/bin/mysqld(_Z11plugin_initPiPPci+0x9ca)[0x562cb7ee0ada]
/usr/local/mysql/bin/mysqld(+0x449360)[0x562cb7e49360]
mysys/stacktrace.c:268(my_print_stacktrace)[0x562cb7e4d959]
sql/signal_handler.cc:168(handle_fatal_signal)[0x7f978d6c63d5]
maria/ha_maria.cc:3604(ha_maria_init(void*))[0x562cb7e42978]
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.
2025-04-25 16:21:57 140265882855232 [Note] Loaded 'query_cache_info.so' with offset 0x7f922e745000
2025-04-25 16:21:57 140265882855232 [Note] mysqld: Aria engine: starting recovery
recovered pages: 0% 10% 20%250425 16:21:57 [ERROR] mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

 

mysql服务启动不起来，mysqld.log如上

根据错误信息：

2025-04-25 16:21:57 140265882855232 [Note] Loaded 'query_cache_info.so' with offset 0x7f922e745000
2025-04-25 16:21:57 140265882855232 [Note] mysqld: Aria engine: starting recovery
recovered pages: 0% 10% 20%250425 16:21:57 [ERROR] mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

应该是Aria数据库出现损坏，在恢复的过程中，coredump了

先手工修复下：

cd /var/lib/mysql

find ./ -name '*.MAI' -exec /usr/local/mysql/bin/aria_chk -r {} \;

等修复结束后，重启mysqld，成功了