-
Bug
-
Resolution: Done
-
Major
-
3.2.0.Final
-
None
-
False
-
-
False
-
-
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