-
Bug
-
Resolution: Done
-
Major
-
1.6.0.Beta1
-
None
-
False
-
False
-
Undefined
-
Yesterday after we fetched and pulled the latest code from master.
It ran several hours and hit this exception.
version: debezium-connector-oracle-1.6.0-SNAPSHOT
our oracle DB version: 19c
[2021-05-21 07:26:54,500] ERROR Mining session stopped due to the {} (io.debezium.connector.oracle.logminer.LogMinerHelper:491) io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'create global temporary table sys.ora_temp_1_ds_1550399 sharing=none on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring xmlindex_sel_idx_tbl opt_param('optimizer_inmemory_aware' 'false') no_substrb_pad */"ENTRYUUID", rowid SYS_DS_ALIAS_0 from "IDENTITYDB"."OAUTH2_CLIENT_CHANGE_LOGS" sample ( 10.0000000000) t WHERE 1 = 2;' mismatched input 'sharing' expecting {'AS', 'CACHE', 'COLUMN', 'DISABLE', 'ENABLE', 'FILESYSTEM_LIKE_LOGGING', 'FLASHBACK', 'INITRANS', 'LOB', 'LOGGING', 'NESTED', 'NOCACHE', 'NOLOGGING', 'NO', 'NOPARALLEL', 'NOROWDEPENDENCIES', 'OF', 'ON', 'PARALLEL', 'PARTITION', 'PCTFREE', 'PCTUSED', 'RESULT_CACHE', 'ROWDEPENDENCIES', 'ROW', 'SEGMENT', 'STORAGE', 'TABLESPACE', 'VARRAY', 'XMLTYPE', '(', ';'} 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.oracle.generated.PlSqlParser.create_table(PlSqlParser.java:49034) at io.debezium.ddl.parser.oracle.generated.PlSqlParser.unit_statement(PlSqlParser.java:2416) at io.debezium.connector.oracle.antlr.OracleDdlParser.parseTree(OracleDdlParser.java:68) at io.debezium.connector.oracle.antlr.OracleDdlParser.parseTree(OracleDdlParser.java:32) at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:82) at io.debezium.connector.oracle.antlr.OracleDdlParser.parse(OracleDdlParser.java:63) at io.debezium.connector.oracle.OracleSchemaChangeEventEmitter.emitSchemaChangeEvent(OracleSchemaChangeEventEmitter.java:81) at io.debezium.pipeline.EventDispatcher.dispatchSchemaChangeEvent(EventDispatcher.java:297) at io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor.processResult(LogMinerQueryResultProcessor.java:166) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:198) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:159) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:122) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.antlr.v4.runtime.InputMismatchException at org.antlr.v4.runtime.DefaultErrorStrategy.sync(DefaultErrorStrategy.java:270) at io.debezium.ddl.parser.oracle.generated.PlSqlParser.create_table(PlSqlParser.java:48995) ... 16 more [2021-05-21 07:26:54,515] ERROR Producer failure (io.debezium.pipeline.ErrorHandler:31)
- is cloned by
-
DBZ-3554 DDL ParsingException on alter table
-
- Closed
-