开发者社区> 问答> 正文

docker下canal运行一段时间报错

2019-07-19 10:31:44.126 [destination = example , address = mysql/172.19.0.2:3306 , EventParser] WARN c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - ---> find start position successfully, EntryPosition[included=false,journalName=mysql-bin.000032,position=93461075,serverId=1,gtid=,timestamp=1563359494000] cost : 6ms , the next step is binlog dump 2019-07-19 10:31:44.170 [destination = example , address = mysql/172.19.0.2:3306 , EventParser] ERROR c.a.o.canal.parse.inbound.mysql.dbsync.DirectLogFetcher - I/O error while reading from client socket java.io.IOException: Received error packet: errno = 1236, sqlstate = HY000 errmsg = binlog truncated in the middle of event; consider out of disk space on master; the first event 'mysql-bin.000032' at 93461075, the last event read from './mysql-bin.000032' at 123, the last byte read from './mysql-bin.000032' at 93461094. at com.alibaba.otter.canal.parse.inbound.mysql.dbsync.DirectLogFetcher.fetch(DirectLogFetcher.java:102) ~[canal.parse-1.1.3.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.dump(MysqlConnection.java:235) [canal.parse-1.1.3.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:257) [canal.parse-1.1.3.jar:na] at java.lang.Thread.run(Thread.java:748) [na:1.8.0_181] 2019-07-19 10:31:44.170 [destination = example , address = mysql/172.19.0.2:3306 , EventParser] ERROR c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - dump address mysql/172.19.0.2:3306 has an error, retrying. caused by java.io.IOException: Received error packet: errno = 1236, sqlstate = HY000 errmsg = binlog truncated in the middle of event; consider out of disk space on master; the first event 'mysql-bin.000032' at 93461075, the last event read from './mysql-bin.000032' at 123, the last byte read from './mysql-bin.000032' at 93461094. at com.alibaba.otter.canal.parse.inbound.mysql.dbsync.DirectLogFetcher.fetch(DirectLogFetcher.java:102) ~[canal.parse-1.1.3.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.dump(MysqlConnection.java:235) ~[canal.parse-1.1.3.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:257) ~[canal.parse-1.1.3.jar:na] at java.lang.Thread.run(Thread.java:748) [na:1.8.0_181] 2019-07-19 10:31:44.171 [destination = example , address = mysql/172.19.0.2:3306 , EventParser] ERROR com.alibaba.otter.canal.common.alarm.LogAlarmHandler - destination:example[java.io.IOException: Received error packet: errno = 1236, sqlstate = HY000 errmsg = binlog truncated in the middle of event; consider out of disk space on master; the first event 'mysql-bin.000032' at 93461075, the last event readfrom './mysql-bin.000032' at 123, the last byte read from './mysql-bin.000032' at 93461094. at com.alibaba.otter.canal.parse.inbound.mysql.dbsync.DirectLogFetcher.fetch(DirectLogFetcher.java:102) at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.dump(MysqlConnection.java:235) at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:257) at java.lang.Thread.run(Thread.java:748) ]

提问221.png

原提问者GitHub用户kervin521

展开
收起
数据大拿 2023-05-04 11:42:52 158 0
1 条回答
写回答
取消 提交回答
  • errmsg = binlog truncated in the middle of event; consider out of disk space on master; the first event 'mysql-bin.000032' at 93461075, the last event read from './mysql-bin.000032' at 123, the last byte read from './mysql-bin.000032' at 93461094.

    位点错误,重置一下binlog

    原回答者GitHub用户agapple

    2023-05-05 10:19:08
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
应用 Docker 进行持续交付:用技术改变交付路程 立即下载
从Docker到容器服务 立即下载
构建基因数据应用生态系统—— docker in Bio/informatics 立即下载