What Debezium connector do you use and what version?
Oracle connector 2.1.4.Final
What is the captured database version and mode of deployment?
Oracle 19.c
Do you see the same behaviour using the latest released Debezium version?
I'm not sure
Do you have the connector logs, ideally from start till finish?
| [
{"running":false,"name":"1808307413221855233",
"connector":\{"state":"RUNNING","worker_id":"10.244.29.51:8083"}
,
"tasks":[
{"id":0,"state":"FAILED","worker_id":"10.244.29.51:8083","trace":"org.apache.kafka.connect.errors.ConnectException:
An exception occurred in the change event producer. This connector will be stopped. 
at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:53) 
at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:225) 
at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:59) 
at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:174) 
at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:141) 
at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109) 
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 "MONITOR"."BARRIER_GATE_MANAGE" (
"ID" VARCHAR2(64 BYTE) NOT NULL,
"CREATE_BY" VARCHAR2(64 BYTE) ,
"CREATE_DATE" DATE ,
"UPDATE_BY" VARCHAR2(64 BYTE) ,
"UPDATE_DATE" DATE ,
"REMARKS" NVARCHAR2(255) ,
"DEL_FLAG" VARCHAR2(64 BYTE) ,
"BARRIER_GATE_NAME" VARCHAR2(64 BYTE) ,
"BARRIER_GATE_CODE" VARCHAR2(64 BYTE) ,
"DOOR_CODE" VARCHAR2(64 BYTE) ,
"LIGHT_ALARM_ID" VARCHAR2(64 BYTE) ,
"BARRIER_STATUS_ID" VARCHAR2(64 BYTE) ,
"BARRIER_GATE_TYPE" VARCHAR2(1 BYTE) ,
"DAHUA_ID" VARCHAR2(255 BYTE) ,
"OLD_SYSTEM_ID" VARCHAR2(255 BYTE) )
LOGGINGNOCOMPRESSPCTFREE 10INITRANS 1STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS 2147483645
BUFFER_POOL DEFAULT
)PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT;
'mismatched input 'NOCACHE' expecting \{'AS', 'USAGE', ';'}
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:49843) 
at io.debezium.ddl.parser.oracle.generated.PlSqlParser.unit_statement(PlSqlParser.java:2528) 
at io.debezium.ddl.parser.oracle.generated.PlSqlParser.sql_script(PlSqlParser.java:2094) 
at io.debezium.connector.oracle.antlr.OracleDdlParser.parseTree(OracleDdlParser.java:73) 
at io.debezium.connector.oracle.antlr.OracleDdlParser.parseTree(OracleDdlParser.java:32) 
at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:78) 
at io.debezium.connector.oracle.antlr.OracleDdlParser.parse(OracleDdlParser.java:68) 
at io.debezium.connector.oracle.OracleSchemaChangeEventEmitter.emitSchemaChangeEvent(OracleSchemaChangeEventEmitter.java:84) 
at io.debezium.pipeline.EventDispatcher.dispatchSchemaChangeEvent(EventDispatcher.java:317) 
at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.handleSchemaChange(AbstractLogMinerEventProcessor.java:646) 
at io.debezium.connector.oracle.logminer.processor.memory.MemoryLogMinerEventProcessor.handleSchemaChange(MemoryLogMinerEventProcessor.java:219) 
at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processRow(AbstractLogMinerEventProcessor.java:308) 
at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processResults(AbstractLogMinerEventProcessor.java:255) 
at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.process(AbstractLogMinerEventProcessor.java:194) 
at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:212) ... 9 more
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:49814) ... 23 more"}]}] |
Bug
Major