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
      

      Attachments

        Issue Links

          Activity

            People

              jpechane Jiri Pechanec
              grzegorz.kolakowski Grzegorz KoĊ‚akowski (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: