MySQL Forums
Forum List  »  Replication

group_replication_recovery - Service State OFF
Posted by: Ricardo Parra
Date: December 12, 2017 04:22AM

Hi,

On my config, the group_replication_recovery Channel is offline, but all appears to be working just fine.
What is this channel and how meaningful it is? How can i turn it ON? 'Repl' is my replication user, but its not connecting to the db's..

mysql> select * from performance_schema.replication_connection_status\G
*************************** 1. row ***************************
CHANNEL_NAME: group_replication_applier
GROUP_NAME: efbeffc0-0415-4c2c-b9bd-0c9781c52a1e
SOURCE_UUID: efbeffc0-0415-4c2c-b9bd-0c9781c52a1e
THREAD_ID: NULL
SERVICE_STATE: ON
COUNT_RECEIVED_HEARTBEATS: 0
LAST_HEARTBEAT_TIMESTAMP: 0000-00-00 00:00:00
RECEIVED_TRANSACTION_SET: 6cbc047c-d78c-11e7-a899-08002733828a:1,
efbeffc0-0415-4c2c-b9bd-0c9781c52a1e:1-3051:1000081-1000131,
fba2794d-d791-11e7-a8de-08002733828a:1
LAST_ERROR_NUMBER: 0
LAST_ERROR_MESSAGE:
LAST_ERROR_TIMESTAMP: 0000-00-00 00:00:00
*************************** 2. row ***************************
CHANNEL_NAME: group_replication_recovery
GROUP_NAME:
SOURCE_UUID:
THREAD_ID: NULL
SERVICE_STATE: OFF
COUNT_RECEIVED_HEARTBEATS: 0
LAST_HEARTBEAT_TIMESTAMP: 0000-00-00 00:00:00
RECEIVED_TRANSACTION_SET:
LAST_ERROR_NUMBER: 0
LAST_ERROR_MESSAGE:
LAST_ERROR_TIMESTAMP: 0000-00-00 00:00:00
2 rows in set (0.00 sec)


On my logs i get:
(SLAVE)

2017-12-12T10:10:24.539736Z 21 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='172.18.209.31', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2017-12-12T10:10:24.550387Z 21 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor 6cbc047c-d78c-11e7-a899-08002733828a at 172.18.209.31 port: 3306.'
2017-12-12T10:10:24.551260Z 23 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
2017-12-12T10:10:24.554039Z 24 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in log 'FIRST' at position 0, relay log './secondMachine-relay-bin-group_replication_recovery.000001' position: 4
2017-12-12T10:10:24.589381Z 23 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'repl@172.18.209.31:3306',replication started in log 'FIRST' at position 4
2017-12-12T10:10:24.611231Z 21 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and purging the corresponding logs.'
2017-12-12T10:10:24.612501Z 24 [Note] Slave SQL thread for channel 'group_replication_recovery' exiting, replication stopped in log 'binlog.000027' at position 1126
2017-12-12T10:10:24.614285Z 23 [Note] Slave I/O thread killed while reading event for channel 'group_replication_recovery'
2017-12-12T10:10:24.614523Z 23 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'binlog.000027', position 1126
2017-12-12T10:10:24.627724Z 21 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='172.18.209.31', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''.
2017-12-12T10:10:24.644918Z 0 [Note] Plugin group_replication reported: 'This server was declared online within the replication group'
2017-12-12T10:10:27.945898Z 3 [Note] Aborted connection 3 to db: 'unconnected' user: 'monitor' host: '172.18.208.233' (Got an error writing communication packets)

(MASTER)

2017-12-12T10:10:24.532118Z 0 [Note] Plugin group_replication reported: 'Group membership changed to 172.18.209.31:3306, 172.18.209.34:3306 on view 15130733669263760:2.'
2017-12-12T10:10:24.603586Z 29 [Note] Start binlog_dump to master_thread_id(29) slave_server(2), pos(, 4)
2017-12-12T10:10:24.651110Z 0 [Note] Plugin group_replication reported: 'The member with address 172.18.209.34:3306 was declared online within the replication group'
2017-12-12T10:11:24.606963Z 29 [Note] Aborted connection 29 to db: 'unconnected' user: 'repl' host: '172.18.209.34' (failed on flush_net())

Options: ReplyQuote


Subject
Views
Written By
Posted
group_replication_recovery - Service State OFF
1487
December 12, 2017 04:22AM


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.