Not the answer you need?
Register and ask your own question!

2 node Percona 5.6 Cluster with garbd fails

KvagaKvaga EntrantCurrent User Role Beginner
There is 2 node Percona 5.6 Cluster on CentOS 7.3 with garbd, and as balancer is haproxy.
It fails after sync

garbd located on db1_stage
haproxy located on standalone server

haproxy
db1_stage 10.128.10.26
db2_stage 10.128.10.27

start cluster sequence:

1. bootstrap last synced node
2. starting garbd
3. starting second node
2018-10-03 04:31:26 31002 [Note] WSREP: Service thread queue flushed.
2018-10-03 04:31:26 31002 [Note] WSREP: IST receiver addr using tcp://10.128.10.26:4568
2018-10-03 04:31:26 31002 [Note] WSREP: Prepared IST receiver, listening at: tcp://10.128.10.26:4568
2018-10-03 04:31:26 31002 [Warning] WSREP: Member 1.0 (Node1) requested state transfer from '*any*', but it is impossible to select State Transfer donor: Resource temporarily unavailable
2018-10-03 04:31:26 31002 [Note] WSREP: Requesting state transfer failed: -11(Resource temporarily unavailable). Will keep retrying every 1 second(s)
2018-10-03 04:31:26 31002 [Note] WSREP: Deleted page /var/lib/mysql/gcache.page.000110
2018-10-03 04:31:26 31002 [Warning] WSREP: Could not find peer:
2018-10-03 04:31:26 31002 [Note] WSREP: 0.0 (Node2): State transfer to -1.-1 (left the group) complete.
2018-10-03 04:31:26 31002 [Note] WSREP: Member 0.0 (Node2) synced with group.
2018-10-03 04:31:27 31002 [Note] WSREP: Member 1.0 (Node1) requested state transfer from '*any*'. Selected 0.0 (Node2)(SYNCED) as donor.
2018-10-03 04:31:27 31002 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 1106114065)
2018-10-03 04:31:27 31002 [Note] WSREP: Requesting state transfer: success after 2 tries, donor: 0
2018-10-03 04:31:27 31002 [Note] WSREP: GCache history reset: old(a78fbb91-ff93-11e7-a897-8f9361fbeda8:1106114028) -> new(a78fbb91-ff93-11e7-a897-8f9361fbeda8:1106114032)
2018-10-03 04:31:27 31002 [Warning] WSREP: 0.0 (Node2): State transfer to 1.0 (Node1) failed: -61 (No data available)
2018-10-03 04:31:27 31002 [ERROR] WSREP: gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():759: State transfer request failed unrecoverably because the donor seqno had gone forward during IST, but SST request was not prepared from our side due to selected state transfer method (which do not supports SST during node operation). Restart required.
2018-10-03 04:31:27 31002 [Note] WSREP: gcomm: terminating thread
2018-10-03 04:31:27 31002 [Note] WSREP: gcomm: joining thread
2018-10-03 04:31:27 31002 [Note] WSREP: Receiving IST: 4 writesets, seqnos 1106114028-1106114032
2018-10-03 04:31:27 31002 [Note] WSREP: gcomm: closing backend
2018-10-03 04:31:27 31002 [Note] WSREP: view(view_id(NON_PRIM,01832163,5) memb {
        df81755f,0
} joined {
} left {
} partitioned {
        01832163,0
        ecdd94c0,0
})
2018-10-03 04:31:27 31002 [Note] WSREP: view((empty))
2018-10-03 04:31:27 31002 [Note] WSREP: gcomm: closed
2018-10-03 04:31:27 31002 [Note] WSREP: /usr/sbin/mysqld: Terminated.


I am a beginner in percona, it was yesteday error

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    Can you share the complete log sequence from both db1 and db2 nodes? It seems like the potential donor left the cluster already. Please post also configuration files.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.