Re: second node in InnoDB cluster stopped working

[Ajay P]

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.