当前位置:首页 > 服务器系统 > Centos > 正文内容

Centos7 MariaDB Galera cluster初始化和启动报错两例

一二三5年前 (2020-11-30)Centos561

问题一:

160613  0:43:36 [Note] WSREP: Read nil XID from storage engines, skipping position init
160613  0:43:36 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so'
160613  0:43:36 [Note] WSREP: wsrep_load(): Galera 25.3.15(r3578) by Codership Oy <info@codership.com> loaded successfully.
160613  0:43:36 [Note] WSREP: CRC-32C: using hardware acceleration.
160613  0:43:36 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1
160613  0:43:36 [ERROR] WSREP: Value 2147483648 too large for requested type (int).: 75 (Value too large for defined data type)
         at galerautils/src/gu_config.cpp:overflow_int():175
160613  0:43:36 [ERROR] WSREP: wsrep::init() failed: 7, must shutdown
160613  0:43:36 [ERROR] Aborting

160613  0:43:36 [Note] /usr/sbin/mysqld: Shutdown complete

分析:
wsrep_provider_options="gcache.size=2048M"
设置超过2G时,会引起bug,参考:https://jira.mariadb.org/browse/MDEV-9052

处理方法:

wsrep_provider_options="gcache.size=1999M"

 

问题二:
 
160613  9:42:32 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.50315S), skipping check
160613  9:43:01 [Note] WSREP: view((empty))
160613  9:43:01 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out)
         at gcomm/src/pc.cpp:connect():162
160613  9:43:01 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to open backend connection: -110 (Connection timed out)
160613  9:43:01 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1379: Failed to open channel ''galera_cluster’' at 'gcomm://10.16.24.107,10.16.24.108,10.16.24.109': -110 (Connection timed out)
160613  9:43:01 [ERROR] WSREP: gcs connect failed: Connection timed out
160613  9:43:01 [ERROR] WSREP: wsrep::connect(gcomm://10.16.24.107,10.16.24.108,10.16.24.109) failed: 7
160613  9:43:01 [ERROR] Aborting

160613  9:43:01 [Note] WSREP: Service disconnected.
160613  9:43:02 [Note] WSREP: Some threads may fail to exit.
160613  9:43:02 [Note] /usr/sbin/mysqld: Shutdown complete

分析处理:

删除该节点及该借点前面所有节点mysql文件安装目录下的两个缓存文件及/var/lock/subsys 目录下的mysql 文件,然后重新启动:
[root@mvxl0782 etc]# cd /var/lock/subsys
[root@mvxl0782 subsys]# rm -rf mysql
[root@mvxl0782 subsys]# cd /data/mysql/
[root@mvxl0782 3306]# rm -rf galera.cache
[root@mvxl0782 3306]# rm -rf grastate.dat

第一节点:
service mysql start --wsrep-new-cluster

其它节点:
service mysql start

扫描二维码至手机访问

扫描二维码推送至手机访问。

版权声明:本文由一二三博客发布,如需转载请注明出处。

分享给朋友:

相关文章

MySQL数据库的数据备份和恢复(导入和导出)命令操作语法

1、mysql导出数据库命令mysqldump -h[主机所在IP] -u[用户名] -p [要导出的数据库]>[导出的路径//[文件名].sql]1)mysqldump字符集设置mysqldu...

CENTOS7开机自启动脚本

1、因为在centos7中/etc/rc.d/rc.local的权限被降低了,所以需要赋予其可执行权 chmod +x /etc/rc.d/rc.local 2、赋予脚本可执行...

Centos7 yum 安装 keepalived

1、安装epel源,方便后面安装keepalivedyum install epel-release -y2、安装keepalivedyum install keepalived -y3、常用命令开机...

Centos修改MTU(巨型帧)

ifconfig eth1 mtu 9000 up      //执行命令后,实时生效。重启失效。MTU=&q...

centos7 添加磁盘到/(根目录下),扩展VG卷和lv

1.创建pvfdisk /dev/xvdc输入n增加分区输入p类型设置为:主分区输入1分区编号设置为1回车 为默认大小回车 为默认 大小输入w退出2.把pv加入vg中,相当于扩充vg的大小扩展vg,使...

Centos7 使用scp命令进行数据迁移

复制文件(本地>>远程):scp -P 33699 /etc/nginx/conf.d/default.conf root@10.88.1.23:/...