MySQL Forums
Forum List  »  InnoDB clusters

innodb cluster issues
Posted by: Ajay P
Date: November 17, 2017 03:34PM

Hello,

I am running into a issue where second node in cluster(first slave) will no longer accept any connections on port 3306 mysql service is running.Any recommended way to fix this gracefully ?Below is the error i run into

[ERROR] Plugin group_replication reported: 'This server is not able to reach a majority of members in the group. This server will now block all updates. The server will remain blocked until contact with the majority is restored. It is possible to use group_replication_force_members to force a new group membership.'
(END)

when i tried to restart the node is not able to join the cluster.

ERROR] Plugin group_replication reported: '[GCS] Timeout while waiting for the group communication engine to be ready!'
2017-11-17T21:30:46.598428Z 0 [ERROR] Plugin group_replication reported: '[GCS] The group communication engine is not ready for the member to join. Local port: 13306'
2017-11-17T21:30:46.598544Z 0 [Note] Plugin group_replication reported: 'state 4337 action xa_terminate'
2017-11-17T21:30:46.598563Z 0 [Note] Plugin group_replication reported: 'new state x_start'
2017-11-17T21:30:46.598568Z 0 [Note] Plugin group_replication reported: 'state 4337 action xa_exit'
2017-11-17T21:30:46.598654Z 0 [Note] Plugin group_replication reported: 'Exiting xcom thread'
2017-11-17T21:30:46.598669Z 0 [Note] Plugin group_replication reported: 'new state x_start'
2017-11-17T21:30:46.600297Z 0 [Warning] Plugin group_replication reported: 'read failed'
2017-11-17T21:30:46.607377Z 0 [ERROR] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 13306'
2017-11-17T21:31:16.540239Z 3 [ERROR] Plugin group_replication reported: 'Timeout on wait for view after joining group'
2017-11-17T21:31:16.540304Z 3 [Note] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
2017-11-17T21:31:16.540323Z 3 [ERROR] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'
2017-11-17T21:31:16.540380Z 0 [Note] Plugin group_replication reported: 'Destroying SSL'
2017-11-17T21:31:16.540417Z 0 [Note] Plugin group_replication reported: 'Success destroying SSL'
2017-11-17T21:31:16.540650Z 7 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed
2017-11-17T21:31:16.541961Z 4 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'
(END)

Any help is appreciated.

Options: ReplyQuote


Subject
Views
Written By
Posted
innodb cluster issues
1578
November 17, 2017 03:34PM


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.