开发者社区> 问答> 正文

master--1.1.3-SNAPSHOT版本,启用GTID,启动失败

环境信息

canal version master--1.1.3-SNAPSHOT

mysql version 5.6.28-cdb2016-log

问题描述

canal.properties 配置的HA canal.zkServers =10.50.8.6:2181 canal.instance.global.spring.xml = classpath:spring/default-instance.xml

example的instance.properties配置为 canal.instance.gtidon=true

canal.instance.master.address=127.0.0.1:3306 canal.instance.master.journal.name= canal.instance.master.position= canal.instance.master.timestamp= canal.instance.master.gtid=61724ebf-67d8-11e8-82af-6c92bf5dc258:1-4652108982, b6eb3e25-975a-11e5-a87b-0241b539c4e5:242-58439:58442-115485, cc5b5f77-91a6-11e5-834b-02b39697b809:357187369-381556259:383857565-384113697

canal.instance.defaultDatabaseName =shop canal.instance.filter.regex=... 其他都是默认设置

启动报下面错误。

2018-12-14 14:23:08.104 [destination = example , address = 127.0.0.1:3306 , EventParser] WARN c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - ---> find start position successfully, EntryPosition[included=false,journalName=mysql-bin.001462,position=24358459,serverId=90255,gtid=,timestamp=1544765205000] cost : 420ms , the next step is binlog dump 2018-12-14 14:24:14.922 [destination = example , address = 127.0.0.1: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 = The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs containing GTIDs that the slave requires. at com.alibaba.otter.canal.parse.inbound.mysql.dbsync.DirectLogFetcher.fetch(DirectLogFetcher.java:102) ~[classes/:na] at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.dump(MysqlConnection.java:253) [classes/:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:250) [classes/:na] at java.lang.Thread.run(Thread.java:748) [na:1.8.0_151]

原提问者GitHub用户gsfeng179

展开
收起
古拉古拉 2023-05-08 16:50:45 77 0
1 条回答
写回答
取消 提交回答
  • show variables like '%gtid%',看一下对应的gtid_purge的值

    原回答者GitHub用户agapple

    2023-05-09 18:26:18
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
低代码开发师(初级)实战教程 立即下载
冬季实战营第三期:MySQL数据库进阶实战 立即下载
阿里巴巴DevOps 最佳实践手册 立即下载