-
Bug
-
Resolution: Done
-
Major
-
None
-
None
-
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