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字段的值(把第一步中查询的值更新到这里)