MariaDB Galera – error：[ERROR] WSREP: gcs/src/gcs_gcomm.cpp:gcomm_open():791: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out)
具体报错如下：
|
1 2 3 4 |
[root@mariadb-cluster-1 ~]# service mysql start Starting mysql (via systemctl): Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. [FAILED] [root@mariadb-cluster-1 ~]# |
日志：/var/log/messages
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 |
Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [Note] [Debug] WSREP: gcomm/src/evs_proto.hpp:close():290: evs::proto(bf49540b, OPERATIONAL, view_id(REG,bf49540b,1)) closing in state 5 Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [Note] [Debug] WSREP: gcomm/src/pc_proto.cpp:handle_view():617: bf49540b view(view_id(TRANS,bf49540b,1) memb { Dec 21 16:49:15 mariadb-cluster-1 mysqld: bf49540b,0 Dec 21 16:49:15 mariadb-cluster-1 mysqld: } joined { Dec 21 16:49:15 mariadb-cluster-1 mysqld: } left { Dec 21 16:49:15 mariadb-cluster-1 mysqld: } partitioned { Dec 21 16:49:15 mariadb-cluster-1 mysqld: }) Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [Note] [Debug] WSREP: gcomm/src/pc_proto.cpp:handle_trans():519: bf49540b Dec 21 16:49:15 mariadb-cluster-1 mysqld: current view view(view_id(REG,bf49540b,1) memb { Dec 21 16:49:15 mariadb-cluster-1 mysqld: bf49540b,0 Dec 21 16:49:15 mariadb-cluster-1 mysqld: } joined { Dec 21 16:49:15 mariadb-cluster-1 mysqld: } left { Dec 21 16:49:15 mariadb-cluster-1 mysqld: } partitioned { Dec 21 16:49:15 mariadb-cluster-1 mysqld: }) Dec 21 16:49:15 mariadb-cluster-1 mysqld: next view view(view_id(TRANS,bf49540b,1) memb { Dec 21 16:49:15 mariadb-cluster-1 mysqld: bf49540b,0 Dec 21 16:49:15 mariadb-cluster-1 mysqld: } joined { Dec 21 16:49:15 mariadb-cluster-1 mysqld: } left { Dec 21 16:49:15 mariadb-cluster-1 mysqld: } partitioned { Dec 21 16:49:15 mariadb-cluster-1 mysqld: }) Dec 21 16:49:15 mariadb-cluster-1 mysqld: pc view view(view_id(NON_PRIM,bf49540b,1) memb { Dec 21 16:49:15 mariadb-cluster-1 mysqld: bf49540b,0 Dec 21 16:49:15 mariadb-cluster-1 mysqld: } joined { Dec 21 16:49:15 mariadb-cluster-1 mysqld: } left { Dec 21 16:49:15 mariadb-cluster-1 mysqld: } partitioned { Dec 21 16:49:15 mariadb-cluster-1 mysqld: }) Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [Note] [Debug] WSREP: gcomm/src/pc_proto.cpp:handle_trans():551: bf49540b quorum ok Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [Note] [Debug] WSREP: gcomm/src/pc_proto.cpp:shift_to():388: bf49540b shift_to: NON_PRIM -> TRANS prim 0 last prim view_id(NON_PRIM,00000000,0) to_seq -1 Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [Note] [Debug] WSREP: gcomm/src/pc_proto.cpp:handle_view():617: bf49540b view((empty)) Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [Note] [Debug] WSREP: gcomm/src/pc_proto.cpp:shift_to():388: bf49540b shift_to: TRANS -> NON_PRIM prim 0 last prim view_id(NON_PRIM,00000000,0) to_seq -1 Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [Note] WSREP: gcomm/src/pc_proto.cpp:deliver_view():229: view((empty)) Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [Note] [Debug] WSREP: gcs/src/gcs_gcomm.cpp:handle_up():440: handle_up: self leave Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [Note] [Debug] WSREP: gcomm/src/gmcast.cpp:handle_stable_view():1508: GMCast::handle_stable_view: view((empty)) Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [Note] [Debug] WSREP: gcomm/src/gmcast.cpp:handle_stable_view():1613: proto: v=0,lu=bf49540b,ru=00000000,ls=0,rs=0,la=tcp://0.0.0.0:4567,ra=tcp://10.158.1.174:4567,mc=,gn=wsrep_cluster,ch=0,st=HANDSHAKE_WAIT,pr=0,tp=0x55d41b5c0de0,ts=110542285158 Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [Note] [Debug] WSREP: gcomm/src/pc_proto.cpp:shift_to():388: bf49540b shift_to: NON_PRIM -> CLOSED prim 0 last prim view_id(NON_PRIM,00000000,0) to_seq -1 Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [Note] [Debug] WSREP: gcomm/src/gmcast.cpp:close():336: gmcast bf49540b close Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [Note] [Debug] WSREP: gcomm/src/asio_tcp.cpp:~AsioTcpSocket():32: dtor for 0x55d41b5b0278 Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [Note] [Debug] WSREP: gcomm/src/asio_tcp.cpp:close():223: closing 0x55d41b5c0e88 state 1 send_q size 0 Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [Note] [Debug] WSREP: gcomm/src/protonet.cpp:erase():26: erase pstack 0x55d41b5a2a78 Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [ERROR] WSREP: gcs/src/gcs_gcomm.cpp:gcomm_open():791: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out) Dec 21 16:49:15 mariadb-cluster-1 mysqld: at gcomm/src/pc.cpp:connect():158 Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to open backend connection: -110 (Connection timed out) Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [Note] [Debug] WSREP: gcomm/src/asio_tcp.cpp:~AsioTcpSocket():32: dtor for 0x55d41b5d2508 Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [Note] [Debug] WSREP: gcomm/src/asio_tcp.cpp:~AsioTcpSocket():32: dtor for 0x55d41b5c0e88 Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1458: Failed to open channel 'wsrep_cluster' at 'gcomm://10.158.1.113,10.158.1.174,10.158.1.178': -110 (Connection timed out) Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [ERROR] WSREP: galera/src/replicator_smm.cpp:connect():317: gcs connect failed: Connection timed out Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [ERROR] WSREP: wsrep::connect(gcomm://10.158.1.113,10.158.1.174,10.158.1.178) failed: 7 Dec 21 16:49:15 mariadb-cluster-1 mysqld: 2017-12-21 16:49:15 140612430137472 [ERROR] Aborting Dec 21 16:49:16 mariadb-cluster-1 systemd: mariadb.service: main process exited, code=exited, status=1/FAILURE Dec 21 16:49:16 mariadb-cluster-1 systemd: Failed to start MariaDB database server. Dec 21 16:49:16 mariadb-cluster-1 systemd: Unit mariadb.service entered failed state. Dec 21 16:49:16 mariadb-cluster-1 systemd: mariadb.service failed. Dec 21 16:50:01 mariadb-cluster-1 systemd: Started Session 4 of user root. Dec 21 16:50:01 mariadb-cluster-1 systemd: Starting Session 4 of user root. |
原因：第一次启动集群的时候，应该用以下两个中的一个：
1. galera_new_cluster
2. service mysql start –wsrep-new-cluster
我这里，第一次启动集群的时候使用的是: galera_new_cluster，就没有上面的问题了。
——————————
Done。
