天堂售票处 2023-02-23 17:15 采纳率: 16.7%
浏览 63
已结题

mysql mgr从库恢复同步错误

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

  • 写回答

7条回答 默认 最新

  • pzzhao 2023-02-23 20:02
    关注

    基于chatGPT:

    根据报错信息,可能是MySQL主库已经清除了从库需要的GTID,导致从库无法恢复。建议检查MySQL主库的binlog日志,确认是否有从库需要的GTID,如果没有,可以尝试重新配置从库,或者从其他主库恢复从库。

    评论

报告相同问题?

问题事件

  • 系统已结题 3月3日
  • 创建了问题 2月23日

悬赏问题

  • ¥15 如何能达到用ping0.cc检测成这样?如图
  • ¥15 关于#DMA固件#的问题,请各位专家解答!
  • ¥15 matlab生成的x1图不趋于稳定,之后的图像是稳定的水平线
  • ¥15 请问华为OD岗位的内部职业发展通道都有哪些,以及各个级别晋升的要求
  • ¥20 微信小程序 canvas 问题
  • ¥15 系统 24h2 专业工作站版,浏览文件夹的图库,视频,图片之类的怎样删除?
  • ¥15 怎么把512还原为520格式
  • ¥15 MATLAB的动态模态分解出现错误,以CFX非定常模拟结果为快照
  • ¥15 求高通平台Softsim调试经验
  • ¥15 canal如何实现将mysql多张表(月表)采集入库到目标表中(一张表)?