暂无图片
5.6 mysql 实例异常crash
我来答
分享
一生
2022-02-17
5.6 mysql 实例异常crash
暂无图片 10M

mysql 运行过程中异常重启,errlog 显示mysql got signal 11 错误,已排除内存、硬盘等资源满导致重启,其他相关信息如下

数据库版本:5.6.49

操作系统版本: RHEL7.4 

内存 :64G

buffer size : 20G

错误日志:

02:27:50 UTC - 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. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail.

key_buffer_size=33554432

read_buffer_size=16777216

max_used_connections=551 

max_threads=1000 

thread_count=133

connection_count=133 

It is possible that mysqld could use up to 

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 32813572 K bytes of memory 

Hope that's ok; if not, decrease some variables in the equation. 

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 = 0 thread_stack 0x80000 

/mysql/bin/mysqld(my_print_stacktrace+0x35)[0x926bf5] 

/mysql/bin/mysqld(handle_fatal_signal+0x494)[0x6b04c4] 

/lib64/libpthread.so.0(+0xf5e0)[0x7fbb19ebd5e0] 

/mysql/bin/mysqld[0x9b1521]

/mysql/bin/mysqld[0xa441fe] 

/mysql/bin/mysqld[0xa5f612] 

/mysql/bin/mysqld[0xa5aaad]

/mysql/bin/mysqld[0xa5b0f7] 

/mysql/bin/mysqld[0xa5b51e] 

/lib64/libpthread.so.0(+0x7e25)[0x7fbb19eb5e25

] /lib64/libc.so.6(clone+0x6d)[0x7fbb1897234d] 

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.

我来答
添加附件
收藏
分享
问题补充
2条回答
默认
最新
严少安
暂无图片

可能真是遇到bug了,可以试试找到crash前运行了什么sql,运行这个sql就会crash。
这只是一个思路,可以试下。毕竟只靠这段log也看不出太多信息。
另外,可以尝试升级下版本试试,因为5.6已经退役了。

暂无图片 评论
暂无图片 有用 0
打赏 0
cqiwen

是新装的环境,还是老环境?如果是新装的环境,可能是操作系统的库文件与mysql不兼容,此时可考虑把操作系统改为redhat6或者升级mysql至5.7及以上版本。

暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
Markdown


请输入正文
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏