I just tried this multiple times including a scenario when both nodes leave at same time but couldn't reproduce the issue. Do you have anything specific in your my.cnf ?
Can you share your my.cnf ?
----------------------
2017-07-17T08:50:21.717558Z 0 [Note] WSREP: 2.2 (n3): State transfer from 0.0 (n1) complete.
2017-07-17T08:50:21.718225Z 0 [Note] WSREP: Member 2.2 (n3) synced with group.
2017-07-17T08:50:22.834585Z 0 [Note] WSREP: 1.0 (n2): State transfer from 0.0 (n1) complete.
2017-07-17T08:50:22.835420Z 0 [Note] WSREP: Member 1.0 (n2) synced with group.
2017-07-17T08:50:36.900232Z 0 [Note] WSREP: forgetting ed17fecc (tcp://127.0.0.1:5030)
2017-07-17T08:50:36.900323Z 0 [Note] WSREP: forgetting edcc146d (tcp://127.0.0.1:6030)
2017-07-17T08:50:36.900459Z 0 [Note] WSREP: Node ec95cd79 state primary
2017-07-17T08:50:36.900572Z 0 [Note] WSREP: Current view of cluster as seen by this node
view (view_id(PRIM,ec95cd79,4)
memb {
ec95cd79,0
}
joined {
}
left {
}
partitioned {
ed17fecc,0
edcc146d,2
}
)
***************** BOTH NODE NOTIFIED TO LEAVE AT SAME TIME ******************************
2017-07-17T08:50:36.900598Z 0 [Note] WSREP: Save the discovered primary-component to disk
2017-07-17T08:50:36.900810Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2017-07-17T08:50:36.901330Z 0 [Note] WSREP: forgetting ed17fecc (tcp://127.0.0.1:5030)
2017-07-17T08:50:36.901356Z 0 [Note] WSREP: forgetting edcc146d (tcp://127.0.0.1:6030)
2017-07-17T08:50:36.901518Z 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 0099ca74-6acd-11e7-b21f-9715285cfec1
2017-07-17T08:50:36.901586Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 0099ca74-6acd-11e7-b21f-9715285cfec1
2017-07-17T08:50:36.901600Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 0099ca74-6acd-11e7-b21f-9715285cfec1 from 0 (n1)
2017-07-17T08:50:36.901612Z 0 [Note] WSREP: Quorum results:
version = 4,
component = PRIMARY,
conf_id = 3,
members = 1/1 (primary/total),
act_id = 4,
last_appl. = 0,
protocols = 0/7/3 (gcs/repl/appl),
group UUID = ec962b8c-6acc-11e7-9cca-5bbfe78342d4
2017-07-17T08:50:36.901624Z 0 [Note] WSREP: Flow-control interval: [100, 100]
2017-07-17T08:50:36.901666Z 2 [Note] WSREP: New cluster view: global state: ec962b8c-6acc-11e7-9cca-5bbfe78342d4:4, view# 4: Primary, number of nodes: 1, my index: 0, protocol version 3
2017-07-17T08:50:36.901676Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2017-07-17T08:50:36.901686Z 2 [Note] WSREP: REPL Protocols: 7 (3, 2)
2017-07-17T08:50:36.901750Z 2 [Note] WSREP: Assign initial position for certification: 4, protocol version: 3
2017-07-17T08:50:36.901793Z 0 [Note] WSREP: Service thread queue flushed.
Przemek,
I just tried this multiple times including a scenario when both nodes leave at same time but couldn't reproduce the issue. Do you have anything specific in your my.cnf ?
Can you share your my.cnf ?
------- ------- ------- -
2017-07- 17T08:50: 21.717558Z 0 [Note] WSREP: 2.2 (n3): State transfer from 0.0 (n1) complete. 17T08:50: 21.718225Z 0 [Note] WSREP: Member 2.2 (n3) synced with group. 17T08:50: 22.834585Z 0 [Note] WSREP: 1.0 (n2): State transfer from 0.0 (n1) complete. 17T08:50: 22.835420Z 0 [Note] WSREP: Member 1.0 (n2) synced with group. 17T08:50: 36.900232Z 0 [Note] WSREP: forgetting ed17fecc (tcp:// 127.0.0. 1:5030) 17T08:50: 36.900323Z 0 [Note] WSREP: forgetting edcc146d (tcp:// 127.0.0. 1:6030) 17T08:50: 36.900459Z 0 [Note] WSREP: Node ec95cd79 state primary 17T08:50: 36.900572Z 0 [Note] WSREP: Current view of cluster as seen by this node PRIM,ec95cd79, 4)
2017-07-
2017-07-
2017-07-
2017-07-
2017-07-
2017-07-
2017-07-
view (view_id(
memb {
ec95cd79,0
}
joined {
}
left {
}
partitioned {
ed17fecc,0
edcc146d,2
}
)
***************** BOTH NODE NOTIFIED TO LEAVE AT SAME TIME ******* ******* ******* ******* **
2017-07- 17T08:50: 36.900598Z 0 [Note] WSREP: Save the discovered primary-component to disk 17T08:50: 36.900810Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 17T08:50: 36.901330Z 0 [Note] WSREP: forgetting ed17fecc (tcp:// 127.0.0. 1:5030) 17T08:50: 36.901356Z 0 [Note] WSREP: forgetting edcc146d (tcp:// 127.0.0. 1:6030) 17T08:50: 36.901518Z 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 0099ca74- 6acd-11e7- b21f-9715285cfe c1 17T08:50: 36.901586Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 0099ca74- 6acd-11e7- b21f-9715285cfe c1 17T08:50: 36.901600Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 0099ca74- 6acd-11e7- b21f-9715285cfe c1 from 0 (n1) 17T08:50: 36.901612Z 0 [Note] WSREP: Quorum results: 6acc-11e7- 9cca-5bbfe78342 d4 17T08:50: 36.901624Z 0 [Note] WSREP: Flow-control interval: [100, 100] 17T08:50: 36.901666Z 2 [Note] WSREP: New cluster view: global state: ec962b8c- 6acc-11e7- 9cca-5bbfe78342 d4:4, view# 4: Primary, number of nodes: 1, my index: 0, protocol version 3 17T08:50: 36.901676Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 17T08:50: 36.901686Z 2 [Note] WSREP: REPL Protocols: 7 (3, 2) 17T08:50: 36.901750Z 2 [Note] WSREP: Assign initial position for certification: 4, protocol version: 3 17T08:50: 36.901793Z 0 [Note] WSREP: Service thread queue flushed.
2017-07-
2017-07-
2017-07-
2017-07-
2017-07-
2017-07-
2017-07-
version = 4,
component = PRIMARY,
conf_id = 3,
members = 1/1 (primary/total),
act_id = 4,
last_appl. = 0,
protocols = 0/7/3 (gcs/repl/appl),
group UUID = ec962b8c-
2017-07-
2017-07-
2017-07-
2017-07-
2017-07-
2017-07-