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

Oracle split table partition does not support online mode

XMLWordPrintable

      When executing the following DDL:

      alter table test1 split partition p_MAXV AT (TO_DATE('01/01/2030', 'DD/MM/YYYY')) INTO (partition p_2029 TABLESPACE users, partition p_MAXV) online;
      

      The parser fails with the following error:

      2025-07-20T11:58:40,728 ERROR  ||  WorkerSourceTask{id=oracle-logminer-connector-0} Task threw an uncaught and unrecoverable exception. Task is being killed and will not recover until manually restarted   [org.apache.kafka.connect.runtime.WorkerTask]
      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:67) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
              at io.debezium.connector.oracle.logminer.AbstractLogMinerStreamingChangeEventSource.execute(AbstractLogMinerStreamingChangeEventSource.java:214) ~[debezium-connector-oracle-3.2.0.Final.jar:3.2.0.Final]
              at io.debezium.connector.oracle.logminer.AbstractLogMinerStreamingChangeEventSource.execute(AbstractLogMinerStreamingChangeEventSource.java:88) ~[debezium-connector-oracle-3.2.0.Final.jar:3.2.0.Final]
              at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:326) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
              at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:207) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
              at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:147) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
              at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572) ~[?:?]
              at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317) ~[?:?]
              at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?]
              at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?]
              at java.base/java.lang.Thread.run(Thread.java:1583) [?:?]
      Caused by: io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'alter table test1 split partition p_MAXV AT (TO_DATE('01/01/2030', 'DD/MM/YYYY')) INTO (partition p_2029 TABLESPACE users,
      partition p_MAXV) online;'
      extraneous input 'online' expecting {<EOF>, '/', ';'}
              at io.debezium.antlr.ParsingErrorListener.syntaxError(ParsingErrorListener.java:43) ~[debezium-ddl-parser-3.2.0.Final.jar:3.2.0.Final]
              at org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41) ~[antlr4-runtime-4.10.1.jar:4.10.1]
              at org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:543) ~[antlr4-runtime-4.10.1.jar:4.10.1]
              at org.antlr.v4.runtime.DefaultErrorStrategy.reportUnwantedToken(DefaultErrorStrategy.java:377) ~[antlr4-runtime-4.10.1.jar:4.10.1]
              at org.antlr.v4.runtime.DefaultErrorStrategy.singleTokenDeletion(DefaultErrorStrategy.java:548) ~[antlr4-runtime-4.10.1.jar:4.10.1]
              at org.antlr.v4.runtime.DefaultErrorStrategy.sync(DefaultErrorStrategy.java:266) ~[antlr4-runtime-4.10.1.jar:4.10.1]
              at io.debezium.ddl.parser.oracle.generated.PlSqlParser.sql_script(PlSqlParser.java:2145) ~[debezium-ddl-parser-3.2.0.Final.jar:3.2.0.Final]
              at io.debezium.connector.oracle.antlr.OracleDdlParser.parseTree(OracleDdlParser.java:75) ~[debezium-connector-oracle-3.2.0.Final.jar:3.2.0.Final]
              at io.debezium.connector.oracle.antlr.OracleDdlParser.parseTree(OracleDdlParser.java:32) ~[debezium-connector-oracle-3.2.0.Final.jar:3.2.0.Final]
              at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:73) ~[debezium-ddl-parser-3.2.0.Final.jar:3.2.0.Final]
              at io.debezium.connector.oracle.antlr.OracleDdlParser.parse(OracleDdlParser.java:70) ~[debezium-connector-oracle-3.2.0.Final.jar:3.2.0.Final]
              at io.debezium.connector.oracle.OracleSchemaChangeEventEmitter.emitSchemaChangeEvent(OracleSchemaChangeEventEmitter.java:104) ~[debezium-connector-oracle-3.2.0.Final.jar:3.2.0.Final]
              at io.debezium.pipeline.EventDispatcher.dispatchSchemaChangeEvent(EventDispatcher.java:411) ~[debezium-core-3.2.0.Final.jar:3.2.0.Final]
              at io.debezium.connector.oracle.logminer.AbstractLogMinerStreamingChangeEventSource.dispatchSchemaChangeEventInternal(AbstractLogMinerStreamingChangeEventSource.java:1217) ~[debezium-connector-oracle-3.2.0.Final.jar:3.2.0.Final]
              at io.debezium.connector.oracle.logminer.buffered.BufferedLogMinerStreamingChangeEventSource.handleSchemaChangeEvent(BufferedLogMinerStreamingChangeEventSource.java:547) ~[debezium-connector-oracle-3.2.0.Final.jar:3.2.0.Final]
              at io.debezium.connector.oracle.logminer.AbstractLogMinerStreamingChangeEventSource.processEvent(AbstractLogMinerStreamingChangeEventSource.java:473) ~[debezium-connector-oracle-3.2.0.Final.jar:3.2.0.Final]
              at io.debezium.connector.oracle.logminer.AbstractLogMinerStreamingChangeEventSource.executeAndProcessQuery(AbstractLogMinerStreamingChangeEventSource.java:397) ~[debezium-connector-oracle-3.2.0.Final.jar:3.2.0.Final]
              at io.debezium.connector.oracle.logminer.buffered.BufferedLogMinerStreamingChangeEventSource.process(BufferedLogMinerStreamingChangeEventSource.java:231) ~[debezium-connector-oracle-3.2.0.Final.jar:3.2.0.Final]
              at io.debezium.connector.oracle.logminer.buffered.BufferedLogMinerStreamingChangeEventSource.executeLogMiningStreaming(BufferedLogMinerStreamingChangeEventSource.java:157) ~[debezium-connector-oracle-3.2.0.Final.jar:3.2.0.Final]
              at io.debezium.connector.oracle.logminer.AbstractLogMinerStreamingChangeEventSource.execute(AbstractLogMinerStreamingChangeEventSource.java:209) ~[debezium-connector-oracle-3.2.0.Final.jar:3.2.0.Final]
              ... 9 more
      

              ccranfor@redhat.com Chris Cranford
              ccranfor@redhat.com Chris Cranford
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: