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

MySQL Antlr runtime.NoViableAltException

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 0.9.0.Beta2
    • 0.9.0.Beta1
    • mysql-connector
    • None

    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

          is related to

          Task - Represents a small unit of work that is not end-user facing. DBZ-992 Don't hard code list of supported MySQL storage engines in Antlr grammar

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed
          relates to

          Bug - A problem that impairs or prevents the functions of the product. DBZ-1036 Debezium is not able to take snapshot for one of the Mysql table

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          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: