MySQL Forums
Forum List  »  Replication

Mysql master master group replica issues
Posted by: Tal Bar-Or
Date: March 08, 2018 04:52AM

Hello,

I configured master/master group replica (2 nodes)using the following link manual

https://www.digitalocean.com/community/tutorials/how-to-configure-mysql-group
replication-on-ubuntu-16-04

all went well and replica worked ok , but as soon as i rebooted one of the servers replica stopped since then i don't know how to make it work again.
looking on the logs i have the following errors showen below
any idea how to fix it
please advice
Thanks

==============node2============
2018-03-07T16:17:23.254290Z 0 [ERROR] Plugin group_replication reported: 'This member has more executed transactions than those present in the group. Local transactions: 0f61bb93-207f-11e8-ac87-9af0fb4099ff:1-67,
e8d36888-737d-4db3-825b-ceecfa0955be:1-843:1000006-1000700:2000006-2000572 > Group transactions: 0f61bb93-207f-11e8-ac87-9af0fb4099ff:1-4,
13c18d09-207f-11e8-ae00-a2eda516abf7:1-604,
e8d36888-737d-4db3-825b-ceecfa0955be:1-861:1000006-1000700:2000006-2000572'
2018-03-07T16:17:23.254406Z 0 [ERROR] Plugin group_replication reported: 'The member contains transactions not present in the group. The member will now exit the group.'
2018-03-07T16:17:23.254422Z 0 [Note] Plugin group_replication reported: 'To force this member into the group you can use the group_replication_allow_local_disjoint_gtids_join option'
2018-03-07T16:17:23.254506Z 0 [Note] Plugin group_replication reported: 'Group membership changed to , 172.18.12.221:3306 on view 15204385578796633:8.'
2018-03-07T16:17:23.254643Z 46 [Note] Plugin group_replication reported: 'Going to wait for view modification'
2018-03-07T16:17:23.256113Z 0 [Note] Plugin group_replication reported: 'getstart group_id 5b42312'
2018-03-07T16:17:28.089804Z 0 [Note] Plugin group_replication reported: 'state 4411 action xa_terminate'
2018-03-07T16:17:28.094466Z 0 [Note] Plugin group_replication reported: 'new state x_start'
2018-03-07T16:17:28.094509Z 0 [Note] Plugin group_replication reported: 'state 4338 action xa_exit'
2018-03-07T16:17:28.097740Z 0 [Note] Plugin group_replication reported: 'Exiting xcom thread'
2018-03-07T16:17:28.097765Z 0 [Note] Plugin group_replication reported: 'new state x_start'
2018-03-07T16:17:28.144402Z 0 [Note] Plugin group_replication reported: 'Group membership changed: This member has left the group.'
2018-03-07T16:17:33.144679Z 0 [Note] Plugin group_replication reported: 'Destroying SSL'
2018-03-07T16:17:33.146225Z 0 [Note] Plugin group_replication reported: 'Success destroying SSL'
2018-03-07T16:17:33.146463Z 46 [Note] Plugin group_replication reported: 'auto_increment_increment is reset to 1'
2018-03-07T16:17:33.146538Z 46 [Note] Plugin group_replication reported: 'auto_increment_offset is reset to 1'
2018-03-07T16:17:33.146935Z 87 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed
2018-03-07T16:17:33.149854Z 84 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'

===========node1=========================================
018-03-08T08:45:48.194055Z 0 [Note] Plugin group_replication reported: 'getstart group_id 5b42312'
2018-03-08T08:45:49.195018Z 10 [Note] Plugin group_replication reported: 'Only one server alive. Declaring this server as online within the replication group'
2018-03-08T08:45:49.195046Z 0 [Note] Plugin group_replication reported: 'Group membership changed to 172.18.12.221:3306 on view 15204987491941055:1.'
2018-03-08T08:45:49.198206Z 0 [Note] Plugin group_replication reported: 'This server was declared online within the replication group'
2018-03-08T08:46:23.435610Z 0 [Note] Plugin group_replication reported: 'getstart group_id 5b42312'
2018-03-08T08:46:28.951285Z 0 [Note] Plugin group_replication reported: 'Members joined the group: 172.18.12.220:3306'
2018-03-08T08:46:28.951441Z 0 [Note] Plugin group_replication reported: 'Group membership changed to 172.18.12.220:3306, 172.18.12.221:3306 on view 15204987491941055:2.'
2018-03-08T08:46:28.953203Z 0 [Note] Plugin group_replication reported: 'getstart group_id 5b42312'
2018-03-08T08:46:30.178993Z 0 [Warning] Plugin group_replication reported: 'Members removed from the group: 172.18.12.220:3306'
2018-03-08T08:46:30.179119Z 0 [Note] Plugin group_replication reported: 'Group membership changed to 172.18.12.221:3306 on view 15204987491941055:3.'
2018-03-08T10:49:44.184308Z 0 [Note] Plugin group_replication reported: 'getstart group_id 5b42312'
2018-03-08T10:49:49.710064Z 0 [Note] Plugin group_replication reported: 'Members joined the group: 172.18.12.220:3306'
2018-03-08T10:49:49.711432Z 0 [Note] Plugin group_replication reported: 'Group membership changed to 172.18.12.220:3306, 172.18.12.221:3306 on view 15204987491941055:4.'
2018-03-08T10:49:49.712629Z 0 [Note] Plugin group_replication reported: 'getstart group_id 5b42312'
2018-03-08T10:49:50.390917Z 0 [Warning] Plugin group_replication reported: 'Members removed from the group: 172.18.12.220:3306'
2018-03-08T10:49:50.391033Z 0 [Note] Plugin group_replication reported: 'Group membership changed to 172.18.12.221:3306 on view 15204987491941055:5.'

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql master master group replica issues
1249
March 08, 2018 04:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.