MySQL Forums
Forum List  »  InnoDB clusters

Re: second node in InnoDB cluster stopped working
Posted by: Ajay P
Date: October 03, 2017 11:45AM

Thanks for the tip .Issue resurfaced and now i am clueless as it happened early hours when system is pretty much idle .I couldn't find anything in binlog with this timestamp and in general log i see below statements .

error log

2017-09-28T23:33:14.229881Z 0 [Warning] Plugin group_replication reported: 'The member with address xxxx:3306 has already sent the stable set. Therefore discarding the second message.'
2017-09-28T23:33:19.717773Z 0 [Warning] Plugin group_replication reported: 'The member with address xxxxx:3306 has already sent the stable set. Therefore discarding the second message.'
2017-09-28T23:36:50.427294Z 0 [Warning] Plugin group_replication reported: 'The member with address xxxxx:3306 has already sent the stable set. Therefore discarding the second message.'
2017-09-29T00:54:59.591929Z 0 [Note] Plugin group_replication reported: 'dispatch_op /export/home2/pb2/build/sb_1-23948522-1498141788.79/rpm/BUILD/mysql-5.7.19/mysql-5.7.19/rapid/plugin/group_r
eplication/libmysqlgcs/src/bindings/xcom/xcom/xcom_base.c:3665 executed_msg={3b5bf904 542262 0} '
2017-09-29T00:54:59.591983Z 0 [ERROR] Plugin group_replication reported: 'Node 4294967295 unable to get message, process will now exit. Please ensure that the process is restarted'

General log:

2017-09-29T00:54:58.569032Z 7 Query BEGIN
2017-09-29T00:54:58.593070Z 7 Query COMMIT /* implicit, from Xid_log_event */
2017-09-29T00:54:58.602730Z 7 Query BEGIN
2017-09-29T00:54:58.603763Z 7 Query COMMIT /* implicit, from Xid_log_event */
2017-09-29T00:54:58.609852Z 7 Query BEGIN
2017-09-29T00:54:58.629214Z 7 Query COMMIT /* implicit, from Xid_log_event */
2017-09-29T00:54:58.637418Z 7 Query BEGIN
2017-09-29T00:54:58.638185Z 7 Query COMMIT /* implicit, from Xid_log_event */
2017-09-29T00:54:58.640457Z 7 Query BEGIN
2017-09-29T00:54:58.641620Z 7 Query COMMIT /* implicit, from Xid_log_event */
2017-09-29T00:54:58.643048Z 7 Query BEGIN
2017-09-29T00:54:58.643787Z 7 Query COMMIT /* implicit, from Xid_log_event */

any clues i should look for ?

Thanks!!



Edited 2 time(s). Last edit at 10/03/2017 12:02PM by Ajay P.

Options: ReplyQuote


Subject
Views
Written By
Posted
1164
September 12, 2017 12:53PM
Re: second node in InnoDB cluster stopped working
1116
October 03, 2017 11:45AM


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.