• ADADADADAD

    PXC failed to open gcomm backend connection: 110[ mysql数据库 ]

    mysql数据库 时间:2024-12-25 09:58:31

    作者:文/会员上传

    简介:

    有想学习PXC高可用架构可以给我留言~~PXC 启动第一个节点报错如下:2019-08-12T03:24:10.282944Z 0 [Note] WSREP: Current view of cluster as seen by this nodeview ((emp

    以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。

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

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

    2019-08-12T03:24:10.282944Z 0 [Note] WSREP: Current view of cluster as seen by this nodeview ((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():1592019-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 out2019-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] Aborting2019-08-12T03:24:10.283412Z 0 [Note] Giving 0 client threads a chance to die gracefully2019-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]# 
    PXC failed to open gcomm backend connection: 110.docx

    将本文的Word文档下载到电脑

    推荐度:

    下载