Error while stating the mysql cluster

[deepak gupta]

i am getting error while starting thr mysql cluster.
command :
service mysql start --wsrep-new-cluster

config file on all 3 server look like this.

mysql 5.7 wsrep server

[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
log-error       = /var/log/mysql/error.log
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
#datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
binlog_format=ROW
bind-address=0.0.0.0
default_storage_engine=innodb
innodb_autoinc_lock_mode=2
innodb_flush_log_at_trx_commit=0
innodb_buffer_pool_size=122M
wsrep_provider=/usr/lib/libgalera_smm.so
wsrep_provider_options="gcache.size=300M; gcache.page_size=300M"
wsrep_cluster_name="megh"
wsrep_cluster_address="gcomm://10.244.0.237,10.244.1.193,10.244.1.54"
wsrep_sst_method=rsync
wsrep_node_name=slave1
wsrep_node_address = "10.244.1.193"
[mysql_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

2017-11-20T06:14:16.787535Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2017-11-20T06:14:16.794809Z 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2017-11-20T06:14:16.795419Z 0 [Note] WSREP: restore pc from disk failed
2017-11-20T06:14:16.841227Z 0 [Note] WSREP: GMCast version 0
2017-11-20T06:14:16.898664Z 0 [Note] WSREP: (09abf584, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2017-11-20T06:14:16.899251Z 0 [Note] WSREP: (09abf584, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2017-11-20T06:14:16.966502Z 0 [Note] WSREP: EVS version 0
2017-11-20T06:14:16.976378Z 0 [Note] WSREP: gcomm: connecting to group 'megh', peer '10.244.0.237:,10.244.1.193:,10.244.1.54:'
2017-11-20T06:14:17.396602Z
 0 [Note] WSREP: (09abf584, 'tcp://0.0.0.0:4567') connection established
 to 09abf584 tcp://10.244.0.237:4567
2017-11-20T06:14:17.398099Z 0
[Warning] WSREP: (09abf584, 'tcp://0.0.0.0:4567') address
'tcp://10.244.0.237:4567' points to own listening address, blacklisting
2017-11-20T06:14:20.252375Z 0 [Warning] WSREP: no nodes coming from prim view, prim not possible
2017-11-20T06:14:20.259627Z 0 [Note] WSREP: view(view_id(NON_PRIM,09abf584,1) memb {
        09abf584,0
} joined {
} left {
} partitioned {
})
2017-11-20T06:14:20.776532Z 0 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.82433S), skipping check
2017-11-20T06:14:20.794709Z
 0 [Note] WSREP: (09abf584, 'tcp://0.0.0.0:4567') connection to peer
09abf584 with addr tcp://10.244.0.237:4567 timed out, no messages seen
in PT3S
2017-11-20T06:14:50.697676Z 0 [Note] WSREP: view((empty))
2017-11-20T06:14:50.822182Z
 0 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed
to reach primary view: 110 (Connection timed out)
         at gcomm/src/pc.cpp:connect():158
2017-11-20T06:14:50.822821Z
 0 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to
open backend connection: -110 (Connection timed out)
2017-11-20T06:14:50.833076Z
 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1458: Failed to open
channel 'megh' at 'gcomm://10.244.0.237,10.244.1.193,10.244.1.54': -110
(Connection timed out)
2017-11-20T06:14:50.840665Z 0 [ERROR] WSREP: gcs connect failed: Connection timed out
2017-11-20T06:14:50.841129Z 0 [ERROR] WSREP: wsrep::connect(gcomm://10.244.0.237,10.244.1.193,10.244.1.54) failed: 7
2017-11-20T06:14:50.845765Z 0 [ERROR] Aborting

2017-11-20T06:14:50.846028Z 0 [Note] Giving 0 client threads a chance to die gracefully
2017-11-20T06:14:50.847040Z 0 [Note] WSREP: Service disconnected.
2017-11-20T06:14:51.849926Z 0 [Note] WSREP: Some threads may fail to exit.
2017-11-20T06:14:51.853823Z 0 [Note] Binlog end
2017-11-20T06:14:51.868161Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2017-11-20T06:14:54.388049Z mysqld_safe mysqld from pid file /var/lib/mysql/cdac-Standard-PC-i440FX-PIIX-1996.pid endedcode here...Enter code here...

[FISH]

Purely this is connectivity issue between the servers.  Fix the same and it will work.