[ERROR] WSREP: gcs/src/gcs_group.cpp:gcs_group_handle_join_msg

[Christos Tsalidis]

Hi all,

i am running in centos7 in 2 node setup galera cluster and gettig the following error on second node


[root@cont2 ~]# systemctl status mariadb.service -l
● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: activating (start) since Sat 2017-09-02 19:57:04 CEST; 5s ago
  Process: 19354 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 21181 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 21179 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 21255 (mysqld)
   CGroup: /system.slice/mariadb.service
           ├─21255 /usr/sbin/mysqld --wsrep_start_position=00000000-0000-0000-0000-000000000000:-1
           ├─21264 /bin/bash -ue /usr//bin/wsrep_sst_rsync --role joiner --address 10.0.2.131 --datadir /var/lib/mysql/ --parent 21255
           ├─21294 rsync --daemon --no-detach --port 4444 --config /var/lib/mysql//rsync_sst.conf
           └─21312 sleep 1

Sep 02 19:57:08 cont2.lab.local mysqld[21255]: at galera/src/replicator_str.cpp:prepare_for_IST():482. IST will be unavailable.
Sep 02 19:57:08 cont2.lab.local mysqld[21255]: 2017-09-02 19:57:08 140522328942336 [Note] WSREP: Member 0.0 (galera2) requested state transfer from '*any*'. Selected 1.0 (galera1)(SYNCED) as donor.
Sep 02 19:57:08 cont2.lab.local mysqld[21255]: 2017-09-02 19:57:08 140522328942336 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 1)
Sep 02 19:57:08 cont2.lab.local mysqld[21255]: 2017-09-02 19:57:08 140522629356288 [Note] WSREP: Requesting state transfer: success, donor: 1
Sep 02 19:57:08 cont2.lab.local mysqld[21255]: 2017-09-02 19:57:08 140522629356288 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(82af93c7-8ff6-11e7-9f16-169bdb69ebd5:1)
Sep 02 19:57:08 cont2.lab.local mysqld[21255]: 2017-09-02 19:57:08 140522328942336 [Warning] WSREP: 1.0 (galera1): State transfer to 0.0 (galera2) failed: -2 (No such file or directory)
Sep 02 19:57:08 cont2.lab.local mysqld[21255]: 2017-09-02 19:57:08 140522328942336 [ERROR] WSREP: gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():736: Will never receive state. Need to abort.
Sep 02 19:57:08 cont2.lab.local mysqld[21255]: 2017-09-02 19:57:08 140522328942336 [Note] WSREP: gcomm: terminating thread
Sep 02 19:57:08 cont2.lab.local mysqld[21255]: 2017-09-02 19:57:08 140522328942336 [Note] WSREP: gcomm: joining thread
Sep 02 19:57:08 cont2.lab.local mysqld[21255]: 2017-09-02 19:57:08 140522328942336 [Note] WSREP: gcomm: closing backend


on first node i started the service by entering galera_new_cluster and service is running fine.

here is my firewall config


[root@cont1 ~]# firewall-cmd --list-all
public (active)
  target: default
  icmp-block-inversion: no
  interfaces: enp0s3
  sources:
  services: dhcpv6-client glusterfs nfs ssh
  ports: 24007-24008/tcp 4568/tcp 873/tcp 4444/tcp 9200/tcp 3306/tcp 24009/tcp 4567/tcp
  protocols:
  masquerade: no
  forward-ports:
  sourceports:
  icmp-blocks:
  rich rules:



[root@cont2 ~]# firewall-cmd --list-all
public (active)
  target: default
  icmp-block-inversion: no
  interfaces: enp0s3
  sources:
  services: dhcpv6-client glusterfs nfs ssh
  ports: 24007-24008/tcp 4568/tcp 873/tcp 4444/tcp 9200/tcp 3306/tcp 24009/tcp 4567/tcp
  protocols:
  masquerade: no
  forward-ports:
  sourceports:
  icmp-blocks:
  rich rules:


Any idea?

Many thanks!

[cjw9...@gmail.com]

I have same problem now, did you solve it?

2017년 9월 3일 일요일 오후 5시 16분 18초 UTC+9, Christos Tsalidis 님의 말: