pxc丛节点启动失败案例

2017-10-28 分类:数据库 阅读(3631) 评论(0)

 

pxc1主节点未正确关闭mysql,再次启动的时候

[root@pxc1 ~]# /etc/init.d/mysql bootstrap-pxc

Bootstrapping PXC (Percona XtraDB Cluster) ERROR! MySQL (Percona XtraDB Cluster) is not running, busys/mysql) exists

Starting MySQL (Percona XtraDB Cluster). SUCCESS!

然后我关闭了丛节点pxc2,pxc3

 

[root@pxc1 ~]# /etc/init.d/mysql

Usage: mysql {start|stop|restart|restart-bootstrap|reload|force-reload|status|bootstrap-pxc} [ MyS) options ]

注意pxc主节点启动的时候,不要直接使用start和restart

[root@pxc1 ~]# /etc/init.d/mysql restart-bootstrap

Shutting down MySQL (Percona XtraDB Cluster).... SUCCESS!

Bootstrapping PXC (Percona XtraDB Cluster)Starting MySQL (Percona XtraDB Cluster). SUCCESS!

 

然后再启动pxc2和pxc3,分别报错如下:

 

[root@pxc2 ~]# /etc/init.d/mysql start

Starting MySQL (Percona XtraDB Cluster). ERROR! The server quit without updating PID file (/var/lib

ERROR! MySQL (Percona XtraDB Cluster) server startup failed!

 

[root@pxc3 ~]# /etc/init.d/mysql start

Starting MySQL (Percona XtraDB Cluster)................................ ERROR! The server quit withr/lib/mysql/pxc3.pid).

ERROR! MySQL (Percona XtraDB Cluster) server startup failed!

 

第一时间果断查看日志,报错日志分别如下:

[root@pxc2 ~]# tail -100 /var/lib/mysql/pxc2.err

…………

…………

…………

2016-09-06 03:50:21 10755 [ERROR] WSREP: gcs/src/gcs_group.cpp:group_post_state_exchange():321: Reversing history: 86192 -> 86031, this member has applied 161 more events than the primary component.Data loss is possible. Aborting.

2016-09-06 03:50:21 10755 [Note] WSREP: /usr/sbin/mysqld: Terminated.

160906 03:50:21 mysqld_safe mysqld from pid file /var/lib/mysql/pxc2.pid ended

 

[root@pxc3 ~]# tail -100 /var/lib/mysql/pxc3.err

2016-09-06 03:41:01 8883 [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

2016-09-06 03:41:01 8883 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to open backend connection: -110 (Connection timed out)

2016-09-06 03:41:01 8883 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1387: Failed to open channel 'my_centos_cluster' at 'gcomm://172.16.5.5,172.16.5.6,172.16.5.3': -110 (Connection timed out)

2016-09-06 03:41:01 8883 [ERROR] WSREP: gcs connect failed: Connection timed out

2016-09-06 03:41:01 8883 [ERROR] WSREP: wsrep::connect(gcomm://172.16.5.5,172.16.5.6,172.16.5.3) failed: 7

2016-09-06 03:41:01 8883 [ERROR] Aborting

 

百度一番之后

……

……

解决办法如下

在pxc2和pxc3上分别执行

rm -fr /var/lib/mysql/grastate.dat

 

再次启动

[root@pxc2 ~]# /etc/init.d/mysql restart

Shutting down MySQL (Percona XtraDB Cluster) ERROR! MySQL (Percona XtraDB Cluster) PID file could not be found!

ERROR! MySQL (Percona XtraDB Cluster) is not running, but lock file (/var/lock/subsys/mysql) exists

Starting MySQL (Percona XtraDB Cluster)..State transfer in progress, setting sleep higher

.. SUCCESS!

 

[root@pxc3 ~]# /etc/init.d/mysql start

ERROR! MySQL (Percona XtraDB Cluster) is not running, but lock file (/var/lock/subsys/mysql) exists

Starting MySQL (Percona XtraDB Cluster)..State transfer in progress, setting sleep higher

.. SUCCESS!

 

[root@pxc2 ~]# netstat -lntup|egrep "4567|3306"

tcp 0 0 0.0.0.0:4567 0.0.0.0:* LISTEN 11639/mysqld

tcp 0 0 :::3306 :::* LISTEN 11639/mysqld

 

[root@pxc3 ~]# netstat -lntup|egrep "3306|4567"

tcp 0 0 0.0.0.0:4567 0.0.0.0:* LISTEN 9830/mysqld

tcp 0 0 :::3306 :::* LISTEN 9830/mysqld

 

分别在pxc1、pxc2和pxc3上登录mysql检查,发现功能都正常,至此,问题解决!!

评论已关闭

登录

忘记密码 ?

切换登录

注册