-
Bug
-
Resolution: Done
-
Major
-
0.10.0.CR1
-
None
-
dockerized ubuntu 18 running the following files -
protobuf-java-2.6.1.jar
antlr4-runtime-4.7.jar
mysql-connector-java-8.0.13.jar
mysql-binlog-connector-java-0.19.1.jar
debezium-ddl-parser-0.10.0.Beta2.jar
debezium-connector-mysql-0.10.0.Beta2.jar
debezium-core-0.10.0.Beta2.jarwith a connector config -
{"connector.class":"io.debezium.connector.mysql.MySqlConnector","database.user":"<use>","transforms.changeTopic.replacement":"starterview-tables","database.server.id":"1","tasks.max":"1","database.history.kafka.bootstrap.servers":"<brokers>","database.history.kafka.topic":"schema-changes.general","transforms":"changeTopic","database.server.name":"dbsnap-01","database.port":"3306","transforms.changeTopic.regex":"dbsnap-01.starterview(.*)","transforms.changeTopic.type":"org.apache.kafka.connect.transforms.RegexRouter","database.hostname":"<hostname>","database.password":"<pwd>","name":"debezium-starterview_3","database.whitelist":"starterview","snapshot.mode":"schema_only"}
{"name":"debezium-starterview_3","config":dockerized ubuntu 18 running the following files - protobuf-java-2.6.1.jar antlr4-runtime-4.7.jar mysql-connector-java-8.0.13.jar mysql-binlog-connector-java-0.19.1.jar debezium-ddl-parser-0.10.0.Beta2.jar debezium-connector-mysql-0.10.0.Beta2.jar debezium-core-0.10.0.Beta2.jar with a connector config - {"name":"debezium-starterview_3","config": {"connector.class":"io.debezium.connector.mysql.MySqlConnector","database.user":"<use>","transforms.changeTopic.replacement":"starterview-tables","database.server.id":"1","tasks.max":"1","database.history.kafka.bootstrap.servers":"<brokers>","database.history.kafka.topic":"schema-changes.general","transforms":"changeTopic","database.server.name":"dbsnap-01","database.port":"3306","transforms.changeTopic.regex":"dbsnap-01.starterview(.*)","transforms.changeTopic.type":"org.apache.kafka.connect.transforms.RegexRouter","database.hostname":"<hostname>","database.password":"<pwd>","name":"debezium-starterview_3","database.whitelist":"starterview","snapshot.mode":"schema_only"}
Upon working with Debezium 0.9.5 (checked for Debezium 10.0.0.Beta2 too) I've encountered a problem while reading the binlog. I've changed the table name to <table>.
"tasks":[{"id":0,"state":"FAILED","worker_id":"10.8.147.153:8083","trace":"org.apache.kafka.connect.errors.ConnectException: no viable alternative at input 'GRANT DELETE ON <table>'\n\tat io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:230)\n\tat io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:208)\n\tat io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:517)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.notifyEventListeners(BinaryLogClient.java:1095)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:943)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:580)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:825)\n\tat java.lang.Thread.run(Thread.java:748)\nCaused by: io.debezium.text.ParsingException: no viable alternative at input 'GRANT DELETE ON <table>'\n\tat io.debezium.antlr.ParsingErrorListener.syntaxError(ParsingErrorListener.java:40)\n\tat org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41)\n\tat org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:544)\n\tat org.antlr.v4.runtime.DefaultErrorStrategy.reportNoViableAlternative(DefaultErrorStrategy.java:282)\n\tat org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:121)\n\tat io.debezium.ddl.parser.mysql.generated.MySqlParser.sqlStatements(MySqlParser.java:1078)\n\tat io.debezium.ddl.parser.mysql.generated.MySqlParser.root(MySqlParser.java:812)\n\tat io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:68)\n\tat io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:41)\n\tat io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:80)\n\tat io.debezium.connector.mysql.MySqlSchema.applyDdl(MySqlSchema.java:305)\n\tat io.debezium.connector.mysql.BinlogReader.handleQueryEvent(BinlogReader.java:709)\n\tat io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:501)\n\t... 5 more\nCaused by: org.antlr.v4.runtime.NoViableAltException\n\tat org.antlr.v4.runtime.atn.ParserATNSimulator.noViableAlt(ParserATNSimulator.java:2023)\n\tat org.antlr.v4.runtime.atn.ParserATNSimulator.execATN(ParserATNSimulator.java:467)\n\tat org.antlr.v4.runtime.atn.ParserATNSimulator.adaptivePredict(ParserATNSimulator.java:393)\n\tat io.debezium.ddl.parser.mysql.generated.MySqlParser.sqlStatements(MySqlParser.java:886)\n\t... 12 more
- is duplicated by
-
DBZ-1611 ParsingException for GRANT SELECT on
-
- Closed
-