• WSREP: gcs/src/gcs_core.cpp:gcs_core_open():220: Failed to open backend connection: -110


                 此Bug详细日志是:

    3月 19 10:24:39 localhost.localdomain mysqld[80382]: 2020-03-19 10:24:39 0 [Warning] WSREP: handshake with 2ca7072e tcp://172.30.251.39:4567 failed: 'invalid group'
    3月 19 10:24:40 localhost.localdomain mysqld[80382]: 2020-03-19 10:24:40 0 [Warning] WSREP: handshake with 2ca7072e tcp://172.30.251.39:4567 failed: 'invalid group'
    3月 19 10:24:42 localhost.localdomain mysqld[80382]: 2020-03-19 10:24:42 0 [Warning] WSREP: handshake with 2ca7072e tcp://172.30.251.39:4567 failed: 'invalid group'
    3月 19 10:24:43 localhost.localdomain mysqld[80382]: 2020-03-19 10:24:43 0 [Warning] WSREP: handshake with 2ca7072e tcp://172.30.251.39:4567 failed: 'invalid group'
    3月 19 10:24:45 localhost.localdomain mysqld[80382]: 2020-03-19 10:24:45 0 [Warning] WSREP: handshake with 2ca7072e tcp://172.30.251.39:4567 failed: 'invalid group'
    3月 19 10:24:46 localhost.localdomain mysqld[80382]: 2020-03-19 10:24:46 0 [Warning] WSREP: handshake with 2ca7072e tcp://172.30.251.39:4567 failed: 'invalid group'
    3月 19 10:24:48 localhost.localdomain mysqld[80382]: 2020-03-19 10:24:48 0 [Warning] WSREP: handshake with 2ca7072e tcp://172.30.251.39:4567 failed: 'invalid group'
    3月 19 10:24:49 localhost.localdomain mysqld[80382]: 2020-03-19 10:24:49 0 [Warning] WSREP: handshake with 2ca7072e tcp://172.30.251.39:4567 failed: 'invalid group'
    3月 19 10:24:51 localhost.localdomain mysqld[80382]: 2020-03-19 10:24:51 0 [Warning] WSREP: handshake with 2ca7072e tcp://172.30.251.39:4567 failed: 'invalid group'
    3月 19 10:24:52 localhost.localdomain mysqld[80382]: 2020-03-19 10:24:52 0 [Warning] WSREP: handshake with 2ca7072e tcp://172.30.251.39:4567 failed: 'invalid group'
    3月 19 10:24:54 localhost.localdomain mysqld[80382]: 2020-03-19 10:24:54 0 [Warning] WSREP: handshake with 2ca7072e tcp://172.30.251.39:4567 failed: 'invalid group'
    3月 19 10:24:55 localhost.localdomain mysqld[80382]: 2020-03-19 10:24:55 0 [Warning] WSREP: handshake with 2ca7072e tcp://172.30.251.39:4567 failed: 'invalid group'
    3月 19 10:24:57 localhost.localdomain mysqld[80382]: 2020-03-19 10:24:57 0 [Warning] WSREP: handshake with 2ca7072e tcp://172.30.251.39:4567 failed: 'invalid group'
    3月 19 10:24:58 localhost.localdomain mysqld[80382]: 2020-03-19 10:24:58 0 [Warning] WSREP: handshake with 2ca7072e tcp://172.30.251.39:4567 failed: 'invalid group'
    3月 19 10:25:00 localhost.localdomain mysqld[80382]: 2020-03-19 10:25:00 0 [Warning] WSREP: handshake with 2ca7072e tcp://172.30.251.39:4567 failed: 'invalid group'
    3月 19 10:25:00 localhost.localdomain mysqld[80382]: 2020-03-19 10:25:00 0 [Note] WSREP: PC protocol downgrade 1 -> 0
    3月 19 10:25:00 localhost.localdomain mysqld[80382]: 2020-03-19 10:25:00 0 [Note] WSREP: view((empty))
    3月 19 10:25:00 localhost.localdomain mysqld[80382]: 2020-03-19 10:25:00 0 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out
    3月 19 10:25:00 localhost.localdomain mysqld[80382]: at gcomm/src/pc.cpp:connect():158
    3月 19 10:25:00 localhost.localdomain mysqld[80382]: 2020-03-19 10:25:00 0 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():220: Failed to open backend connection: -110 (Connection timed o
    3月 19 10:25:00 localhost.localdomain mysqld[80382]: 2020-03-19 10:25:00 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1608: Failed to open channel 'db_cluster' at 'gcomm://192.30.251.40
    3月 19 10:25:00 localhost.localdomain mysqld[80382]: 2020-03-19 10:25:00 0 [ERROR] WSREP: gcs connect failed: Connection timed out
    3月 19 10:25:00 localhost.localdomain mysqld[80382]: 2020-03-19 10:25:00 0 [ERROR] WSREP: wsrep::connect(gcomm://) failed: 7
    3月 19 10:25:00 localhost.localdomain mysqld[80382]: 2020-03-19 10:25:00 0 [ERROR] Aborting
    3月 19 10:25:00 localhost.localdomain systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
    3月 19 10:25:00 localhost.localdomain systemd[1]: Failed to start MariaDB 10.4.12 database server.
    

      

              此Bug差不多困扰我了一天,经过排查发现是因为主节点配置文件少了一个参数:wsrep_cluster_name=db_cluster

              在此谨记配置文件及启动顺序

    [galera]
    # Mandatory settings
    wsrep_on=ON
    wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so
    wsrep_cluster_address="gcomm://192.30.251.40,192.30.251.41,192.30.251.39"
    wsrep_cluster_name=db_cluster
    wsrep_node_name=db_192.30.251.41
    wsrep_node_address=192.30.251.41
    wsrep_sst_method=rsync
    binlog_format=row
    default_storage_engine=InnoDB
    innodb_autoinc_lock_mode=2
    

          第一个节点(主节点)启动命令: galera_new_cluster 

               后续几个节点数据库服务启动命令就直接用:systemctl start mariadb

               查看节点数量:show status like '%wsrep_cluster_size%';

  • 相关阅读:
    xunsearch 在 window 下测试实践(2)
    xunsearch 在 window 下测试实践(1)
    PHPExcel 读取excel文档单元格的值时出现多种字体的解决方法
    laravel session丢失问题
    php多进程批量处理任务
    idea系列产品破解
    lnmp1.4环境下phpinfo扩展缺失解决方法
    从今天开始培养我的写作能力
    go map底层实现
    go之cron使用
  • 原文地址:https://www.cnblogs.com/zhongjicainiao/p/12522764.html
Copyright © 2020-2023  润新知