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

Oracle DDL parser fails using NOMONITORING clause

XMLWordPrintable

      In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type.

      Bug report

      For bug reports, provide this information, please:

      What Debezium connector do you use and what version?

      Oracle Connector 2.6.2

      What behaviour do you see?

      2024-06-21 12:32:11,643 ERROR [debezium-connector|task-0] Mining session stopped due to error. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource) [debezium-oracleconnector-debezium_ds-change-event-source-coordinator]
      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE TABLE DWH_INT_DBT.sensors_raw
      (
        SOURCE                 VARCHAR2(50),
        EVENTTS                VARCHAR2(30),
        TEMP_CPU               NUMBER,
        TEMP_GPU               NUMBER,
        TEMP_WATER_IN          NUMBER,
        TEMP_WATER_OUT         NUMBER,
        POWER_CPU              NUMBER,
        POWER_GPU              NUMBER,
        POWER_MB               NUMBER,
        RPM_FANS_LEFT          NUMBER,
        RPM_FANS_RIGHT         NUMBER,
        RPM_PUMP_LEFT          NUMBER,
        RPM_PUMP_RIGHT         NUMBER,
        RPM_FLOW               NUMBER,
        LOAD_CPU               NUMBER,
        LOAD_CPU_AVERAGE       NUMBER,
        LOAD_MAXCPUTHREAD      NUMBER,
        LOAD_GPU               NUMBER,
        LOAD_VRAM              NUMBER,
        LOAD_RAM               NUMBER,
        USAGE_RAM              NUMBER,
        USAGE_VRAM             NUMBER,
        CLOCK_GPU              NUMBER,
        CLOCK_VRAM             NUMBER,
        CLOCK_CPU_EFFECTIVE    NUMBER,
        CLOCK_CPU_PERFORMANCE  NUMBER,
        TEMP_WATER_DELTA       NUMBER,
        LPM_FLOW               NUMBER,
        LPH_FLOW               NUMBER,
        RPM_FANS               NUMBER,
        RPM_PUMPS              NUMBER
      )
      STORAGE    (
                  BUFFER_POOL      DEFAULT
                  FLASH_CACHE      DEFAULT
                  CELL_FLASH_CACHE DEFAULT
                 )
      NOCOMPRESS
      NOCACHE
      RESULT_CACHE (MODE DEFAULT)
      NOPARALLEL
      NOMONITORING;'
      extraneous input 'NOMONITORING' 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:543)
              at org.antlr.v4.runtime.DefaultErrorStrategy.reportUnwantedToken(DefaultErrorStrategy.java:377)
              at org.antlr.v4.runtime.DefaultErrorStrategy.singleTokenDeletion(DefaultErrorStrategy.java:548)
              at org.antlr.v4.runtime.DefaultErrorStrategy.sync(DefaultErrorStrategy.java:266)
              at io.debezium.ddl.parser.oracle.generated.PlSqlParser.sql_script(PlSqlParser.java:2142)
              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:104)
              at io.debezium.pipeline.EventDispatcher.dispatchSchemaChangeEvent(EventDispatcher.java:379)
              at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.handleSchemaChange(AbstractLogMinerEventProcessor.java:818)
              at io.debezium.connector.oracle.logminer.processor.memory.MemoryLogMinerEventProcessor.handleSchemaChange(MemoryLogMinerEventProcessor.java:176)
              at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processRow(AbstractLogMinerEventProcessor.java:401)
              at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processResults(AbstractLogMinerEventProcessor.java:320)
              at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.process(AbstractLogMinerEventProcessor.java:241)
              at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:246)
              at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:61)
              at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:280)
              at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:197)
              at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:140)
              at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
              at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
              at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
              at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
              at java.base/java.lang.Thread.run(Thread.java:840)

            ccranfor@redhat.com Chris Cranford
            meretri Meret Ringwald (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: