Slave failed to initialize relay log info structure from the repository, Error_code: 1872
来源:互联网 发布:残疾人婚恋软件 编辑:程序博客网 时间:2024/06/10 17:17
root@localhost [(none)]>reset master;
Query OK, 0 rows affected (0.04 sec)
root@localhost [(none)]>
[root@mysqlcentos01 mysqlback]# mysql -S /tmp/mysql3306.sock -u root -p <test-20170616.sql
Enter password:
[root@mysqlcentos01 mysqlback]#
root@localhost [(none)]>CHANGE MASTER TO MASTER_HOST='10.194.41.231', MASTER_PORT=3306, MASTER_USER='repl', MASTER_PASSWORD='evis123', MASTER_AUTO_POSITION=1;
Query OK, 0 rows affected, 2 warnings (0.01 sec)
root@localhost [(none)]>start slave;
ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository
root@localhost [(none)]>
2017-08-28T01:22:26.153487Z 4 [ERROR] Slave SQL for channel '': Slave failed to initialize relay log info structure from the repository, Error_code: 1872
2017-08-28T01:22:54.169173Z 4 [Note] 'CHANGE MASTER TO FOR CHANNEL '' executed'. Previous state master_host='10.194.41.231', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='10.194.41.231', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2017-08-28T01:22:58.137705Z 4 [ERROR] Slave SQL for channel '': Slave failed to initialize relay log info structure from the repository, Error_code: 1872
root@localhost [(none)]>reset slave all;
Query OK, 0 rows affected (0.06 sec)
root@localhost [(none)]>CHANGE MASTER TO MASTER_HOST='10.194.41.231', MASTER_PORT=3306, MASTER_USER='repl', MASTER_PASSWORD='evis123', MASTER_AUTO_POSITION=1;
Query OK, 0 rows affected, 2 warnings (0.01 sec)
root@localhost [(none)]>start slave;
Query OK, 0 rows affected (0.00 sec)
root@localhost [(none)]
- Slave failed to initialize relay log info structure from the repository, Error_code: 1872
- Slave failed to initialize relay log info structure from the repository, Error_code: 1872
- Slave failed to initialize relay log info structure from the repository
- MySQL Error: Failed to open the relay log
- 数据库同步报错Failed to open the relay log
- 17.2.2.1 The Slave Relay Log
- 17.2.2.1 The Slave Relay Log Slave中继日志
- master-info-repository=TABLE && relay-log-info-repository=TABLE 后的一些对应参照
- Could not initialize master info structure; more error messages can be found in the MySQL error log
- MySQL Slave环境出现ERROR 1201 (HY000): Could not initialize master info structure的案例
- mysql relay-log.info, master.info
- The incident LOST_EVENTS occured on the master. Message: error writing to the binary log, Error_code
- The incident LOST_EVENTS occured on the master. Message: error writing to the binary log, Error_code
- Failed to initialize the PowerShell host 解决方案
- Mysql log文件之 relay log、master log info、relay log info
- mysql relay-log.info 丢失问题
- mysql Could not initialize master info structure;
- 故障案例:级联主从change master to Could not initialize master info structure
- BootStrap框架学习-下拉款Select搜索功能
- PLSQL创建表空间并且导入.dmp文件
- Activity 生命周期
- 支付宝电脑网站支付,也就是老版的即时到账
- 读《读库1704》
- Slave failed to initialize relay log info structure from the repository, Error_code: 1872
- Hibernate添加log4j的实现
- 【背包专题】J
- pycharm2016.2.X中出现“Parent module ‘YOUR_MODULE_HERE’ not found while handling absolute import ”解决方法
- ArrayList和Vector的区别
- java编程思想第一章 对象
- 我的第一个博客
- 域服务篇 04. 组 ❀ Windows Server 2016
- code-push-server的部署(docker)