求助：GreatSQL内存溢出
日志如下：*** buffer overflow detected ***: /usr/sbin/mysqld terminated
======= Backtrace: =========
/lib64/libc.so.6(__fortify_fail+0x37)
/lib64/libc.so.6(+0x116812)
/lib64/libc.so.6(+0x1185f7)
/usr/lib64/mysql/plugin/greatdb_ha.so(_ZN7greatdb20connect_with_timeoutEiP8sockaddrj+0x86)
/usr/lib64/mysql/plugin/greatdb_ha.so(+0x18e7f)
/usr/lib64/mysql/plugin/greatdb_ha.so(+0x1e357)
/usr/lib64/mysql/plugin/greatdb_ha.so(+0x204a1)
/lib64/libpthread.so.0(+0x7ea5)
/lib64/libc.so.6(clone+0x6d)
======= Memory map: ========
00400000-00ccd000 r--p 00000000 fd:01 33793852 /usr/sbin/mysqld
00ccd000-02c49000 r-xp 008cd000 fd:01 33793852 /usr/sbin/mysqld
02c49000-03ea8000 r--p 02849000 fd:01 33793852 /usr/sbin/mysqld
03ea9000-0408a000 r--p 03aa8000 fd:01 33793852 /usr/sbin/mysqld
0408a000-04431000 rw-p 03c89000 fd:01 33793852 /usr/sbin/mysqld
04431000-04aa9000 rw-p 00000000 00:00 0
7f5507000000-7f5516800000 rw-p 00000000 00:00 0
7f5516bfd000-7f5516bfe000 ---p 00000000 00:00 0
7f5516bfe000-7f55173fe000 rw-p 00000000 00:00 0
7f55173fe000-7f55173ff000 ---p 00000000 00:00 0
7f55173ff000-7f5517bff000 rw-p 00000000 00:00 0
...
...
...
7f5745376000-7f5745379000 rw-p 00000000 00:00 0
7f5745379000-7f574537a000 rw-p 00000000 00:00 0
7f574537a000-7f574537d000 rw-s 00000000 00:0b 121985263 / (deleted)
7f574537d000-7f574537e000 rw-s 00000000 00:0b 121985262 / (deleted)
7f574537e000-7f574537f000 rw-p 00000000 00:00 0
7f574537f000-7f5745380000 r--p 00021000 fd:01 33588544 /usr/lib64/ld-2.17.so
7f5745380000-7f5745381000 rw-p 00022000 fd:01 33588544 /usr/lib64/ld-2.17.so
7f5745381000-7f5745382000 rw-p 00000000 00:00 0
7ffd25d0b000-7ffd25d2c000 rw-p 00000000 00:00 0
7ffd25da5000-7ffd25da7000 r-xp 00000000 00:00 0
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0
2024-08-28T21:25:49Z UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID=5ebb14cb24339b2d60bb6951f2beccae3dfb1d60
Build ID: 5ebb14cb24339b2d60bb6951f2beccae3dfb1d60
Server Version: 8.0.32-26 GreatSQL (GPL), Release 26, Revision a68b3034c3d
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
2024-08-29T05:25:49.813930+08:00 0 Plugin group_replication reported: ' set fd:1071 connected'
2024-08-29T05:25:49.814024+08:00 0 Plugin group_replication reported: ' buffered_read_msg sets CON_PROTO for fd:1071'
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e)
/usr/sbin/mysqld(print_fatal_signal(int)+0x3af)
/usr/sbin/mysqld(handle_fatal_signal+0xc5)
/lib64/libpthread.so.0(+0xf630)
/lib64/libc.so.6(gsignal+0x37)
/lib64/libc.so.6(abort+0x148)
/lib64/libc.so.6(+0x78f67)
/lib64/libc.so.6(__fortify_fail+0x37)
/lib64/libc.so.6(+0x116812)
/lib64/libc.so.6(+0x1185f7)
/usr/lib64/mysql/plugin/greatdb_ha.so(greatdb::connect_with_timeout(int, sockaddr*, unsigned int)+0x86)
/usr/lib64/mysql/plugin/greatdb_ha.so(+0x18e7f)
/usr/lib64/mysql/plugin/greatdb_ha.so(+0x1e357)
/usr/lib64/mysql/plugin/greatdb_ha.so(+0x204a1)
/lib64/libpthread.so.0(+0x7ea5)
/lib64/libc.so.6(clone+0x6d)
Please help us make Percona Server better by reporting any
bugs at https://bugs.percona.com/
You may download the Percona Server operations manual by visiting
http://www.percona.com/software/percona-server/. You may find information
in the manual which will help you identify the cause of the crash.
看起来是 greatsql_ha 这个plugin引起的，还请先补充以下详细信息
1. 操作系统信息，主要是网络、网卡相关
2. GreatSQL的配置文件 my.cnf 内容 本帖最后由 edgar_mu 于 2024-8-29 10:52 编辑
yejr 发表于 2024-8-29 10:40
看起来是 greatsql_ha 这个plugin引起的，还请先补充以下详细信息
1. 操作系统信息，主要是网络、网卡相关
...
操作系统：CentOS Linux release 7.9.2009 (Core)
my.cnf:
loose_plugin_load_add = 'greatdb_ha.so'
loose_greatdb_ha_enable_mgr_vip = 1
loose_greatdb_ha_mgr_vip_nic = 'eth0'
loose_greatdb_ha_mgr_vip_ip = 'xxxx'
loose_greatdb_ha_mgr_vip_mask = '255.255.255.0'
loose_greatdb_ha_mgr_vip_broad = 'xxxx'
网卡：
cat /etc/sysconfig/network-scripts/ifcfg-eth0
TYPE="Ethernet"
PROXY_METHOD="none"
BROWSER_ONLY="no"
BOOTPROTO="dhcp"
DEFROUTE="yes"
IPV4_FAILURE_FATAL="no"
IPV6INIT="yes"
IPV6_AUTOCONF="yes"
IPV6_DEFROUTE="yes"
IPV6_FAILURE_FATAL="no"
IPV6_ADDR_GEN_MODE="stable-privacy"
NAME="eth0"
UUID="xxxxxxxx"
DEVICE="eth0"
ONBOOT="yes"
edgar_mu 发表于 2024-8-29 10:50
操作系统：CentOS Linux release 7.9.2009 (Core)
应该是你还使用旧版本配置导致的，请参考文档中提及的更新内容 https://greatsql.cn/docs/8.0.32- ... E%E5%8F%82%E6%95%B0
也可以参考这份新的 my.cnf 模板：https://gitee.com/GreatSQL/GreatSQL-Doc/blob/master/docs/my.cnf-example-greatsql-8.0.32-26
本帖最后由 edgar_mu 于 2024-8-29 11:06 编辑
yejr 发表于 2024-8-29 10:54
应该是你还使用旧版本配置导致的，请参考文档中提及的更新内容 https://greatsql.cn/docs/8.0.32- ... E%E ...
和新的配置对比了下，就差个端口： greatdb_ha_port，这个应该不影响吧greatdb_ha_port
配置如下：
| Variable_name | Value |
+--------------------------------------------------+---------------+
| greatdb_ha_enable_mgr_vip | OFF |
| greatdb_ha_force_change_mgr_vip | OFF |
| greatdb_ha_gateway_address | |
| greatdb_ha_mgr_exit_primary_kill_connection_mode | OFF |
| greatdb_ha_mgr_read_vip_floating_type | TO_PRIMARY |
| greatdb_ha_mgr_read_vip_ips | |
| greatdb_ha_mgr_vip_broad | 1xxx255 |
| greatdb_ha_mgr_vip_ip | 1xxxx3 |
| greatdb_ha_mgr_vip_mask | 255.255.255.0 |
| greatdb_ha_mgr_vip_nic | eth0 |
| greatdb_ha_port | |
| greatdb_ha_send_arp_packge_times | 5 |
| greatdb_ha_vip_tope | |
edgar_mu 发表于 2024-8-29 11:02
和新的配置对比了下，就差个端口： greatdb_ha_port，这个应该不影响吧greatdb_ha_port
配置如下：
影响相当大啊，这不就导致进程崩溃了嘛 ~ yejr 发表于 2024-8-29 11:13
影响相当大啊，这不就导致进程崩溃了嘛 ~
:'( 这。。我找窗口把greatdb_ha_port加上，感谢
页:
[1]