maxwell 报错Could not find first log file name in binary log index file

maxwell日志:

11:52:37,079 INFO BinlogConnectorLifecycleListener - Binlog disconnected. 11:52:37,139 WARN BinlogConnectorReplicator - replicator stopped at position: mysql-bin.000164:314728447 -- restarting 11:52:37,228 INFO BinaryLogClient - Connected to 192.168.20.80:61306 at mysql-bin.000164/314728447 (sid:23, cid:2670867) 11:52:37,228 INFO BinlogConnectorLifecycleListener - Binlog connected. 11:52:37,268 WARN BinlogConnectorLifecycleListener - Communication failure. com.github.shyiko.mysql.binlog.network.ServerException: Could not find first log file name in binary log index file at com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:882) [mysql-binlog-connector-java-0.16.1.jar:0.16.1] at com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:559) [mysql-binlog-connector-java-0.16.1.jar:0.16.1] at com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:793) [mysql-binlog-connector-java-0.16.1.jar:0.16.1] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202] 

问题说明:

因为maxwell是读取mysql的binlog,而maxwell的positions配置文件中的binlog_file,binlog_position俩字段的值不正确(或者说落后了),导致找不到binlog文件

解决步骤:

1、到maxwell所监听的mysql的数据库,执行 show master status;

2、再到maxwell的数据库,找到报错的任务,更新binlog_file,binlog_position字段的值(把第一步中查询的值更新到这里)

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值