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

DDL parser issue

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 1.9.7.Final
    • 1.8.1.Final
    • mysql-connector
    • None
    • False
    • None
    • False
    • Critical

    Description

      In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type.

      Bug report

      For bug reports, provide this information, please:

      What Debezium connector do you use and what version?

      Java connector 1.8.1.Final

      Caused by: io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE TABLE `ssb_warp`.`test_view` (

        `mview$pk` bigint DEFAULT NULL,
        `LO_OrderKey` bigint NOT NULL,
        `LO_LineNumber` tinyint NOT NULL,
        `LO_CustKey` int NOT NULL,
        `LO_PartKey` int NOT NULL,
        `LO_SuppKey` int NOT NULL,
        `LO_OrderDateKey` int NOT NULL,
        `LO_OrderPriority` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
        `LO_ShipPriority` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
        `LO_Quantity` tinyint DEFAULT NULL,
        `LO_ExtendedPrice` int DEFAULT NULL,
        `LO_OrdTotalPrice` int DEFAULT NULL,
        `LO_Discount` int DEFAULT NULL,
        `LO_Revenue` int DEFAULT NULL,
        `LO_SupplyCost` int DEFAULT NULL,
        `LO_Tax` tinyint DEFAULT NULL,
        `LO_CommitDateKey` int NOT NULL,
        `LO_ShipMode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
        `mview$hash` bigint unsigned NOT NULL DEFAULT '0'
      ) START TRANSACTION ENGINE=InnoDB'
      mismatched input 'ENGINE' expecting {<EOF>, '-'}
          at io.debezium.antlr.ParsingErrorListener.syntaxError(ParsingErrorListener.java:43)
          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.reportInputMismatch(DefaultErrorStrategy.java:327)
          at org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:139)
          at io.debezium.ddl.parser.mysql.generated.MySqlParser.root(MySqlParser.java:967)
          at io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:73)
          at io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:45)
          at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:82)
          at io.debezium.connector.mysql.MySqlDatabaseSchema.parseDdl(MySqlDatabaseSchema.java:223)
          at io.debezium.connector.mysql.MySqlDatabaseSchema.parseStreamingDdl(MySqlDatabaseSchema.java:209)
          at io.debezium.connector.mysql.MySqlStreamingChangeEventSource.handleQueryEvent(MySqlStreamingChangeEventSource.java:576)
          at io.debezium.connector.mysql.MySqlStreamingChangeEventSource.lambda$execute$14(MySqlStreamingChangeEventSource.java:832)
          at io.debezium.connector.mysql.MySqlStreamingChangeEventSource.handleEvent(MySqlStreamingChangeEventSource.java:349)
          ... 6 more
      Caused by: org.antlr.v4.runtime.InputMismatchException
          at org.antlr.v4.runtime.DefaultErrorStrategy.sync(DefaultErrorStrategy.java:270)
          at io.debezium.ddl.parser.mysql.generated.MySqlParser.root(MySqlParser.java:950)
          ... 14 more
      Engine terminated

       

      Reading from MySQL 8.0.30 - the issue happens after a CREATE TABLE .. AS SELECT statement with GTID_MODE=ON

      Attachments

        Activity

          People

            Unassigned Unassigned
            greenlion@gmail.com Justin Swanhart (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: