首页 > 其他 > 详细

断重启从库故障:电Last_Error: Slave failed to initialize relay log info structure from the repository

时间:2017-11-10 22:23:29      阅读:861      评论:0      收藏:0      [点我收藏+]

断电重启故障

2017-11-10T21:27:52.791849+08:00 0 [ERROR] Error in Log_event::read_log_event(): ‘read error‘, data_len: 68, event_type: 2
2017-11-10T21:27:52.791889+08:00 0 [Warning] Error reading GTIDs from relaylog: -1
2017-11-10T21:27:52.793147+08:00 0 [Note] Slave: MTS group recovery relay log info based on Worker-Id 1, group_relay_log_name /home/mysql57/relay/relay-bin.000083, group_relay_log_pos 95280470 group_master_log_name mysql-bin.000048, group_master_log_pos 95280257
2017-11-10T21:27:52.793191+08:00 0 [ERROR] Error looking for file after /home/mysql57/relay/relay-bin.000084.
2017-11-10T21:27:52.793405+08:00 0 [ERROR] Failed to initialize the master info structure
2017-11-10T21:27:52.793414+08:00 0 [ERROR] Failed to create or recover replication info repositories.
2017-11-10T21:27:52.793417+08:00 0 [Note] Check error log for additional messages. You will not be able to start replication until the issue is resolved and the server restarted.
2017-11-10T21:27:52.842687+08:00 0 [Note] Event Scheduler: Loaded 0 events
2017-11-10T21:27:52.842824+08:00 0 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: ‘5.7.9-log‘ socket: ‘/home/mysql57/run/mysql.sock‘ port: 3306 Source distribution
2017-11-10T21:28:06.755717+08:00 0 [Note] InnoDB: Buffer pool(s) load completed at 171110 21:28:06
2017-11-10T21:38:12.848189+08:00 732 [ERROR] Slave SQL for channel ‘‘: Slave failed to initialize relay log info structure from the repository, Error_code: 1872bug

 

#########bug导致:

https://bugs.mysql.com/bug.php?id=83713 

修复:保存好从库位点信息

reset  slave  ; 

start slave;   

#####################

 

断重启从库故障:电Last_Error: Slave failed to initialize relay log info structure from the repository

原文:http://www.cnblogs.com/long2-20160310/p/7816728.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!