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:
- bootstrap last synced node
- starting garbd
- 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