温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

PXC failed to open gcomm backend connection: 110

发布时间:2020-07-06 01:15:20 来源:网络 阅读:2044 作者:roidba 栏目:MySQL数据库

有想学习PXC高可用架构可以给我留言~~

PXC 启动第一个节点报错如下:

2019-08-12T03:24:10.282944Z 0 [Note] WSREP: Current view of cluster as seen by this node
view ((empty))
2019-08-12T03:24:10.283160Z 0 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view (pc.wait_prim_timeout): 110 (Connection timed out)
         at gcomm/src/pc.cpp:connect():159
2019-08-12T03:24:10.283195Z 0 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():209: Failed to open backend connection: -110 (Connection timed out)
2019-08-12T03:24:10.283350Z 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1514: Failed to open channel 'pxc_cluster' at 'gcomm://196.55.7.33:4106,196.55.7.34:4106,196.55.7.35:4106': -110 (Connection timed out)
2019-08-12T03:24:10.283372Z 0 [ERROR] WSREP: gcs connect failed: Connection timed out
2019-08-12T03:24:10.283391Z 0 [ERROR] WSREP: Provider/Node (gcomm://196.55.7.33:4106,196.55.7.34:4106,196.55.7.35:4106) failed to establish connection with cluster (reason: 7)
2019-08-12T03:24:10.283402Z 0 [ERROR] Aborting

2019-08-12T03:24:10.283412Z 0 [Note] Giving 0 client threads a chance to die gracefully
2019-08-12T03:24:10.283424Z 0 [Note] WSREP: Waiting for active wsrep applier to exit

解决方法
添加一个参数--wsrep-new-cluster

[root@localhost 3306]# ./mysql.server -P 3306 start --wsrep-new-cluster 
Starting MySQL (Galera Cluster)... SUCCESS! 
[root@localhost 3306]# 
向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI