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.
Subject
Views
Written By
Posted
1164
September 12, 2017 12:53PM
780
September 13, 2017 07:58AM
682
September 13, 2017 10:33AM
719
September 13, 2017 11:20AM
Re: second node in InnoDB cluster stopped working
1116
October 03, 2017 11:45AM
741
November 17, 2017 03:55AM
752
November 17, 2017 12:15PM
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.