-
Bug
-
Resolution: Done
-
Major
-
0.9.0.Beta1
-
None
MySQL server connector failed at the beginning of initial snapshot while fetching DDLs. However, it works when legacy parser is used.
Please be advised that the connector has been run on MariaDB.
Table and field names have been changed.
Caused by: io.debezium.text.ParsingException: no viable alternative at input 'CREATE TABLE `table_name` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `field_1` int(11) NOT NULL,\n `field_2` int(11) NOT NULL,\n `field_3` int(11) NOT NULL,\n `field_4` int(11) NOT NULL,\n `field_5` tinytext COLLATE utf8_unicode_ci NOT NULL,\n `field_6` tinytext COLLATE utf8_unicode_ci NOT NULL,\n `field_6` tinytext COLLATE utf8_unicode_ci NOT NULL COMMENT 'CSV'' at io.debezium.antlr.ParsingErrorListener.syntaxError(ParsingErrorListener.java:40) at org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41) at org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:544) at org.antlr.v4.runtime.DefaultErrorStrategy.reportNoViableAlternative(DefaultErrorStrategy.java:282) at org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:121) at io.debezium.ddl.parser.mysql.generated.MySqlParser.sqlStatements(MySqlParser.java:1071) at io.debezium.ddl.parser.mysql.generated.MySqlParser.root(MySqlParser.java:805) at io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:71) at io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:44) at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:80) at io.debezium.connector.mysql.MySqlSchema.applyDdl(MySqlSchema.java:300) at io.debezium.connector.mysql.SnapshotReader.lambda$execute$12(SnapshotReader.java:442) at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:436) at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:377) at io.debezium.connector.mysql.SnapshotReader.execute(SnapshotReader.java:440) ... 3 more Caused by: org.antlr.v4.runtime.NoViableAltException at org.antlr.v4.runtime.atn.ParserATNSimulator.noViableAlt(ParserATNSimulator.java:2023) at org.antlr.v4.runtime.atn.ParserATNSimulator.execATN(ParserATNSimulator.java:467) at org.antlr.v4.runtime.atn.ParserATNSimulator.adaptivePredict(ParserATNSimulator.java:393) at io.debezium.ddl.parser.mysql.generated.MySqlParser.sqlStatements(MySqlParser.java:879) ... 12 more
