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

DDL statement couldn't be parsed mismatched input '`encrypted`

XMLWordPrintable

    • False
    • False

      seems like encrypted setting causing issue

       ) ENGINE=InnoDB DEFAULT CHARSET=utf8 `encrypted`=yes' mismatched input '`encrypted`' expecting {<EOF>, '-'} at 

       

      2022-02-02 09:51:07,949 ERROR [io.deb.pip.ErrorHandler] (debezium-mysqlconnector-db-change-event-source-coordinator) Producer failure: io.debezium.DebeziumException: io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE TABLE `xxmytablexx` (
      `column` bigint(20) NOT NULL,
      `column` bigint(20) NOT NULL,
      `column` bigint(20) NOT NULL,
      `column` bigint(20) NOT NULL,
      `column` bigint(20) NOT NULL,
      `column` bigint(20) NOT NULL,
      `column` bigint(20) NOT NULL,
      `column` blob,
      `column` varchar(64) DEFAULT NULL,
      PRIMARY KEY (`column`),
      KEY `idx_xyz` (`column`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8 `encrypted`=yes'
      mismatched input '`encrypted`' expecting {<EOF>, '-'}
      at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:85)
      at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:153)
      at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:135)
      at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:108)
      at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
      at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
      at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
      at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
      at java.base/java.lang.Thread.run(Thread.java:829)
      Caused by: io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE TABLE `xxmytablexx` (
      `column` bigint(20) NOT NULL,
      `column` bigint(20) NOT NULL,
      `column` bigint(20) NOT NULL,
      `column` bigint(20) NOT NULL,
      `column` bigint(20) NOT NULL,
      `column` bigint(20) NOT NULL,
      `column` bigint(20) NOT NULL,
      `column` blob,
      `column` varchar(64) DEFAULT NULL,
      PRIMARY KEY (`column`),
      KEY `idx_xyz` (`column`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8 `encrypted`=yes'
      mismatched input '`encrypted`' 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:963)
      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.parseSnapshotDdl(MySqlDatabaseSchema.java:203)
      at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.addSchemaEvent(MySqlSnapshotChangeEventSource.java:303)
      at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.lambda$createSchemaEventsForTables$5(MySqlSnapshotChangeEventSource.java:373)
      at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:558)
      at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:499)
      at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.createSchemaEventsForTables(MySqlSnapshotChangeEventSource.java:371)
      at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.readTableStructure(MySqlSnapshotChangeEventSource.java:360)
      at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.readTableStructure(MySqlSnapshotChangeEventSource.java:47)
      at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:113)
      at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:76)
      ... 8 more
      Caused by: org.antlr.v4.runtime.InputMismatchException
      at org.antlr.v4.runtime.DefaultErrorStrategy.sync(DefaultErrorStrategy.java:270)
      at io.debezium.d 

              Unassigned Unassigned
              ismailsimsek ismail simsek (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: