java-debezium无法解析ddl(create proc)语句mysql connector

deikduxw  于 2021-06-07  发布在  Kafka
关注(0)|答案(1)|浏览(537)

我已经在kafka connect中集成了debezium连接器来流式传输mysql数据库的更改。对于某些过程,无法读取binlog文件。有什么建议或解决办法吗?被这个问题困住了。我可以在mysql中指定不将ddl日志放入binlog文件吗?

2017-10-10 15:20:22,314 ERROR  MySQL|dbStreamer|binlog  Failed due to error: Error processing binlog event            [io.debezium.connector.mysql.BinlogReader]
org.apache.kafka.connect.errors.ConnectException: Unexpected exception (One or more errors trying to parse statement at line 1, column 8) parsing at line 1, column 8
at io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:164)
at io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:142)
at io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:332)
at com.github.shyiko.mysql.binlog.BinaryLogClient.notifyEventListeners(BinaryLogClient.java:902)
at com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:760)
at com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:472)
at com.github.shyiko.mysql.binlog.BinaryLogClient$5.run(BinaryLogClient.java:657)
at java.lang.Thread.run(Thread.java:748)
Caused by: io.debezium.text.ParsingException: Unexpected exception (One or more errors trying to parse statement at line 1, column 8) parsing at line 1, column 8
at io.debezium.relational.ddl.DdlParser.parsingFailed(DdlParser.java:660)
at io.debezium.relational.ddl.DdlParser.parse(DdlParser.java:294)
at io.debezium.relational.ddl.DdlParser.parse(DdlParser.java:267)
at io.debezium.connector.mysql.MySqlSchema.applyDdl(MySqlSchema.java:354)
at io.debezium.connector.mysql.BinlogReader.handleQueryEvent(BinlogReader.java:461)
at io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:319)
... 5 more
Caused by: One or more errors trying to parse statement at line 1, column 8
io.debezium.text.ParsingException: Expecting VIEW at line 1, column 35 but found 'PROCEDURE': =`root`@`localhost`  ===>> PROCEDURE `azuga`.`c
io.debezium.text.ParsingException: No more content
r7knjye2

r7knjye21#

您需要在问题跟踪程序中提出问题。ddl解析器能够处理(跳过)语句来创建过程,但并不完美。如果你能提供有问题的代码,我们可以fi解析器。

相关问题