Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-1028

MySQL Antlr runtime.NoViableAltException

    XMLWordPrintable

    Details

      Description

      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
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  jpechanec Jiri Pechanec
                  Reporter:
                  grzegorzk Grzegorz KoĊ‚akowski
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: