Show master status 错误

[129duckflew]

数据库版本 : MySQL8.4 jdk: 21

运行脚本:

java -jar .\canal2sql-1.1.3.jar -mode online -u root -p 12345678 -P 9000 -h 192.168.103.30

连接出现报错 提示是 show master status命令有错误

com.alibaba.otter.canal.parse.exception.CanalParseException: command : 'show master status' has an error!
Caused by: java.io.IOException: ErrorPacket [errorNumber=1064, fieldCount=-1, message=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'master status' at line 1, sqlState=42000, sqlStateMarker=#]
 with command: show master status
        at com.alibaba.otter.canal.parse.driver.mysql.MysqlQueryExecutor.query(MysqlQueryExecutor.java:61) ~[canal.parse.driver-1.1.5.jar!/:na]
        at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.query(MysqlConnection.java:107) ~[canal.parse-1.1.5.jar!/:na]
        at com.alibaba.otter.canal.parse.inbound.mysql.MysqlEventParser.findEndPosition(MysqlEventParser.java:663) ~[canal.parse-1.1.5.jar!/:na]
        at com.alibaba.otter.canal.parse.inbound.mysql.MysqlEventParser.findEndPositionWithMasterIdAndTimestamp(MysqlEventParser.java:380) ~[canal.parse-1.1.5.jar!/:na]
        at com.alibaba.otter.canal.parse.inbound.mysql.MysqlEventParser.findStartPositionInternal(MysqlEventParser.java:438) ~[canal.parse-1.1.5.jar!/:na]
        at com.alibaba.otter.canal.parse.inbound.mysql.MysqlEventParser.findStartPosition(MysqlEventParser.java:357) ~[canal.parse-1.1.5.jar!/:na]
        at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$1.run(AbstractEventParser.java:191) ~[canal.parse-1.1.5.jar!/:na]
        at java.base/java.lang.Thread.run(Thread.java:1583) ~[na:na]
# totally cost:19629 ms

[zhuchao941]

你去你的mysql实例上执行下show master status试下看

[zhuchao941]

我看了下 8.4.0 把这个命令删了 那不好意思 暂时不支持了这里

[129duckflew]

我看了下 8.4.0 把这个命令删了 那不好意思 暂时不支持了这里

8.4 改成 show binary status了