Canal报错

来源:12-4 canal索引构建进阶(4)

慕函数2082699

2019-12-20

[destination = example , address = /127.0.0.1:33060 , EventParser] ERROR c.a.otter.canal.parse.inbound.mysql.MysqlConnection -
java.io.IOException: ErrorPacket [errorNumber=1193, fieldCount=-1, message=Unknown system variable ‘binlog_checksum’, sqlState=HY000, sqlStateMarker=#]
with command: select @@global.binlog_checksum
at com.alibaba.otter.canal.parse.driver.mysql.MysqlQueryExecutor.query(MysqlQueryExecutor.java:61) ~[canal.parse.driver-1.1.3.jar:na]
at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.query(MysqlConnection.java:106) [canal.parse-1.1.3.jar:na]
at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.loadBinlogChecksum(MysqlConnection.java:522) [canal.parse-1.1.3.jar:na]
at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.dump(MysqlConnection.java:227) [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_221]

是不是Mysql版本要在5.6.2以上才行?

写回答

1回答

龙虾三少

2019-12-20

端口写错了吧 33060是什么 检查下错误日志上的具体问题描述

0
0

ES7+Spark 构建高匹配度搜索服务+千人千面推荐系统

ElasticSearch实现高相关性搜索,Spark MLlib实现个性化推荐

1384 学习 · 559 问题

查看课程