mysql mgr 从库意外离线后执行:START group_replication;命令报错,
无法恢复,以下是一些报错信息:
2023-02-23T16:49:58.908279+08:00 516 [Note] Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mode: "DISABLED"'
2023-02-23T16:49:58.908440+08:00 516 [Note] Plugin group_replication reported: '[GCS] Added automatically IP ranges 10.8.63.173/24,127.0.0.1/8 to the whitelist'
2023-02-23T16:49:58.908531+08:00 516 [Warning] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the whitelist. It is mandatory that it is added.'
2023-02-23T16:49:58.908575+08:00 516 [Note] Plugin group_replication reported: '[GCS] SSL was not enabled'
2023-02-23T16:49:58.908613+08:00 516 [Note] Plugin group_replication reported: 'Initialized group communication with configuration: group_replication_group_name: "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"; group_replication_local_address: "10.8.63.173:33060"; group_replication_group_seeds: "10.8.63.173:33060,10.8.63.174:33060,10.8.63.175:33060"; group_replication_bootstrap_group: false; group_replication_poll_spin_loops: 0; group_replication_compression_threshold: 1000000; group_replication_ip_whitelist: "AUTOMATIC"'
2023-02-23T16:49:58.908641+08:00 516 [Note] Plugin group_replication reported: '[GCS] Configured number of attempts to join: 0'
2023-02-23T16:49:58.908653+08:00 516 [Note] Plugin group_replication reported: '[GCS] Configured time between attempts to join: 5 seconds'
2023-02-23T16:49:58.908678+08:00 516 [Note] Plugin group_replication reported: 'Member configuration: member_id: 1; member_uuid: "b5c0f6a7-43a8-11e9-9a42-caebf8fa458a"; single-primary mode: "true"; group_replication_auto_increment_increment: 7; '
2023-02-23T16:49:58.908989+08:00 832 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='<NULL>', master_port= 0, 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=''.
2023-02-23T16:49:58.913674+08:00 516 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!'
2023-02-23T16:49:58.913680+08:00 835 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'FIRST' at position 0, relay log './dht-mysql1-relay-bin-group_replication_applier.000001' position: 4
2023-02-23T16:49:58.913707+08:00 516 [Note] Plugin group_replication reported: 'auto_increment_increment is set to 7'
2023-02-23T16:49:58.913736+08:00 516 [Note] Plugin group_replication reported: 'auto_increment_offset is set to 1'
2023-02-23T16:49:58.913842+08:00 0 [Note] Plugin group_replication reported: 'XCom protocol version: 3'
2023-02-23T16:49:58.913875+08:00 0 [Note] Plugin group_replication reported: 'XCom initialized and ready to accept incoming connections on port 33060'
2023-02-23T16:50:01.057168+08:00 516 [Note] Plugin group_replication reported: 'This server is working as secondary member with primary member address dht-mysql3:3306.'
2023-02-23T16:50:01.057407+08:00 838 [Note] Plugin group_replication reported: 'Establishing group recovery connection with a possible donor. Attempt 1/10'
2023-02-23T16:50:01.057461+08:00 0 [Note] Plugin group_replication reported: 'Group membership changed to dht-mysql2:3306, dht-mysql3:3306, dht-mysql1:3306 on view 15646222293475941:61.'
2023-02-23T16:50:01.064211+08:00 838 [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='dht-mysql2', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2023-02-23T16:50:01.071484+08:00 838 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor 2846d819-43ad-11e9-bfad-967b93319469 at dht-mysql2 port: 3306.'
2023-02-23T16:50:01.071673+08:00 840 [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.
2023-02-23T16:50:01.071953+08:00 841 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in log 'FIRST' at position 0, relay log './dht-mysql1-relay-bin-group_replication_recovery.000001' position: 4
2023-02-23T16:50:01.072594+08:00 840 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'zl@dht-mysql2:3306',replication started in log 'FIRST' at position 4
2023-02-23T16:50:01.073731+08:00 840 [ERROR] Error reading packet from server for channel 'group_replication_recovery': The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs containing GTIDs that the slave requires. (server_errno=1236)
2023-02-23T16:50:01.073762+08:00 840 [ERROR] Slave I/O for channel 'group_replication_recovery': Got fatal error 1236 from master when reading data from binary log: 'The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs containing GTIDs that the slave requires.', Error_code: 1236
2023-02-23T16:50:01.073774+08:00 840 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'FIRST', position 4
2023-02-23T16:50:01.073799+08:00 838 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and purging the corresponding logs.'
2023-02-23T16:50:01.073858+08:00 841 [Note] Error reading relay log event for channel 'group_replication_recovery': slave SQL thread was killed
2023-02-23T16:50:01.073886+08:00 841 [Note] Slave SQL thread for channel 'group_replication_recovery' exiting, replication stopped in log 'FIRST' at position 0
2023-02-23T16:50:01.080469+08:00 838 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='dht-mysql2', 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=''.
2023-02-23T16:50:01.087093+08:00 838 [Note] Plugin group_replication reported: 'Retrying group recovery connection with another donor. Attempt 2/10'
2023-02-23T16:50:01.093783+08:00 838 [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='dht-mysql3', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2023-02-23T16:50:01.099978+08:00 838 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor 5043db66-543d-11e9-8603-0e61941e46c9 at dht-mysql3 port: 3306.'
2023-02-23T16:50:01.100115+08:00 842 [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.
2023-02-23T16:50:01.100400+08:00 843 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in log 'FIRST' at position 0, relay log './dht-mysql1-relay-bin-group_replication_recovery.000001' position: 4
2023-02-23T16:50:01.100692+08:00 842 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'zl@dht-mysql3:3306',replication started in log 'FIRST' at position 4