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

DDL statement couldn't be parsed. 'mismatched input 'NOCACHE' expecting {'AS', 'USAGE', ';'}

XMLWordPrintable

      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.&nbsp at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:53)&nbsp at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:225)&nbsp at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:59)&nbsp at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:174)&nbsp at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:141)&nbsp at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109)&nbsp at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)&nbsp at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)&nbsp at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)&nbsp at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)&nbsp 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)&nbsp
       at org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41)&nbsp
       at org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:544)&nbsp
       at org.antlr.v4.runtime.DefaultErrorStrategy.reportInputMismatch(DefaultErrorStrategy.java:327)&nbsp
       at org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:139)&nbsp
       at io.debezium.ddl.parser.oracle.generated.PlSqlParser.create_table(PlSqlParser.java:49843)&nbsp
       at io.debezium.ddl.parser.oracle.generated.PlSqlParser.unit_statement(PlSqlParser.java:2528)&nbsp
       at io.debezium.ddl.parser.oracle.generated.PlSqlParser.sql_script(PlSqlParser.java:2094)&nbsp
       at io.debezium.connector.oracle.antlr.OracleDdlParser.parseTree(OracleDdlParser.java:73)&nbsp
       at io.debezium.connector.oracle.antlr.OracleDdlParser.parseTree(OracleDdlParser.java:32)&nbsp
       at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:78)&nbsp
       at io.debezium.connector.oracle.antlr.OracleDdlParser.parse(OracleDdlParser.java:68)&nbsp
       at io.debezium.connector.oracle.OracleSchemaChangeEventEmitter.emitSchemaChangeEvent(OracleSchemaChangeEventEmitter.java:84)&nbsp
       at io.debezium.pipeline.EventDispatcher.dispatchSchemaChangeEvent(EventDispatcher.java:317)&nbsp
       at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.handleSchemaChange(AbstractLogMinerEventProcessor.java:646)&nbsp
       at io.debezium.connector.oracle.logminer.processor.memory.MemoryLogMinerEventProcessor.handleSchemaChange(MemoryLogMinerEventProcessor.java:219)&nbsp
       at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processRow(AbstractLogMinerEventProcessor.java:308)&nbsp
       at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processResults(AbstractLogMinerEventProcessor.java:255)&nbsp
       at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.process(AbstractLogMinerEventProcessor.java:194)&nbsp
       at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:212)&nbsp... 9 more
       Caused by: org.antlr.v4.runtime.InputMismatchException&nbspat org.antlr.v4.runtime.DefaultErrorStrategy.sync(DefaultErrorStrategy.java:270)&nbsp
       at io.debezium.ddl.parser.oracle.generated.PlSqlParser.create_table(PlSqlParser.java:49814)&nbsp... 23 more"}]}]

              anmohant Anisha Mohanty
              diumin qiumin xiang
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: