Details
-
Bug
-
Resolution: Done
-
Major
-
1.7.0.Final
-
None
-
False
-
False
Description
Oracle connector fails with the following parser exception:
[2021-10-13 03:12:43,998] ERROR Mining session stopped due to the {} (io.debezium.connector.oracle.logminer.LogMinerHelper)
[36mconnect |[0m io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'create table "IFSAPP".CMP4$94648 organization heap tablespace "IFSAPP_DATA" compress for all operations nologging as select /+ DYNAMIC_SAMPLING(0) / * from "IFSAPP".CMP3$94648 mytab;'
[36mconnect |[0m no viable alternative at input 'compress for all'
[36mconnect |[0m at io.debezium.antlr.ParsingErrorListener.syntaxError(ParsingErrorListener.java:43)
[36mconnect |[0m at org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41)
[36mconnect |[0m at org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:544)
[36mconnect |[0m at org.antlr.v4.runtime.DefaultErrorStrategy.reportNoViableAlternative(DefaultErrorStrategy.java:310)
[36mconnect |[0m at org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:136)
[36mconnect |[0m at io.debezium.ddl.parser.oracle.generated.PlSqlParser.segment_attributes_clause(PlSqlParser.java:58450)
[36mconnect |[0m at io.debezium.ddl.parser.oracle.generated.PlSqlParser.physical_properties(PlSqlParser.java:58810)
[36mconnect |[0m at io.debezium.ddl.parser.oracle.generated.PlSqlParser.relational_table(PlSqlParser.java:50808)
[36mconnect |[0m at io.debezium.ddl.parser.oracle.generated.PlSqlParser.create_table(PlSqlParser.java:49092)
[36mconnect |[0m at io.debezium.ddl.parser.oracle.generated.PlSqlParser.unit_statement(PlSqlParser.java:2433)
[36mconnect |[0m at io.debezium.ddl.parser.oracle.generated.PlSqlParser.sql_script(PlSqlParser.java:2005)
[36mconnect |[0m at io.debezium.connector.oracle.antlr.OracleDdlParser.parseTree(OracleDdlParser.java:68)
[36mconnect |[0m at io.debezium.connector.oracle.antlr.OracleDdlParser.parseTree(OracleDdlParser.java:32)
[36mconnect |[0m at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:82)
[36mconnect |[0m at io.debezium.connector.oracle.antlr.OracleDdlParser.parse(OracleDdlParser.java:63)
[36mconnect |[0m at io.debezium.connector.oracle.OracleSchemaChangeEventEmitter.emitSchemaChangeEvent(OracleSchemaChangeEventEmitter.java:84)
[36mconnect |[0m at io.debezium.pipeline.EventDispatcher.dispatchSchemaChangeEvent(EventDispatcher.java:305)
[36mconnect |[0m at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.handleSchemaChange(AbstractLogMinerEventProcessor.java:265)
[36mconnect |[0m at io.debezium.connector.oracle.logminer.processor.memory.MemoryLogMinerEventProcessor.handleSchemaChange(MemoryLogMinerEventProcessor.java:318)
[36mconnect |[0m at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processRow(AbstractLogMinerEventProcessor.java:189)
[36mconnect |[0m at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processResults(AbstractLogMinerEventProcessor.java:161)
[36mconnect |[0m at io.debezium.connector.oracle.logminer.processor.memory.MemoryLogMinerEventProcessor.process(MemoryLogMinerEventProcessor.java:116)
[36mconnect |[0m at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:162)
[36mconnect |[0m at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:54)
[36mconnect |[0m at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:166)
[36mconnect |[0m at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:127)
[36mconnect |[0m at java.