mysql 8.0.15 和 canal 1.1.2 版本 同步数据总是error "Invalid

环境信息

canal version 1.1.2 mysql version 8.0.15

问题描述

发现同步数据时总是提示： Caused by: java.lang.IllegalArgumentException: Invalid charset id: 255 at com.taobao.tddl.dbsync.binlog.CharsetConversion.getEntry(CharsetConversion.java:41) at com.taobao.tddl.dbsync.binlog.CharsetConversion.getJavaCharset(CharsetConversion.java:299) at com.taobao.tddl.dbsync.binlog.event.QueryLogEvent.(QueryLogEvent.java:503) at com.taobao.tddl.dbsync.binlog.LogDecoder.decode(LogDecoder.java:168) at com.taobao.tddl.dbsync.binlog.LogDecoder.decode(LogDecoder.java:111) at com.alibaba.otter.canal.parse.inbound.mysql.MysqlMultiStageCoprocessor$SimpleParserStage.onEvent(MysqlMultiStageCoprocessor.java:264) at com.alibaba.otter.canal.parse.inbound.mysql.MysqlMultiStageCoprocessor$SimpleParserStage.onEvent(MysqlMultiStageCoprocessor.java:246) at com.lmax.disruptor.BatchEventProcessor.processEvents(BatchEventProcessor.java:168) at com.lmax.disruptor.BatchEventProcessor.run(BatchEventProcessor.java:125) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)

查看com.taobao.tddl.dbsync.binlog.CharsetConversion类下的所有charsetId 范围是1~243对应mysql数据库的Collections表 254单独配置为utf-8

我尝试修改数据库,表和字段的charset的配置为utf-8，客户端连接配置也是utf-8 但是clientCharset = buffer.getUint16();依然返回255.

代码如下: com.taobao.tddl.dbsync.binlog.event.QueryLogEvent.unpackVariables(line:630) clientCharset = buffer.getUint16();

这是否是我的配置问题?

原提问者GitHub用户wade009