-
Bug
-
Resolution: Done
-
Major
-
3.2.0.Final
-
None
-
False
-
-
False
-
-
When setting log.mining.archive.log.only.mode to true, the connector will continue to remine the same archive log repeatedly even if there is no more data available in the log to be mined. This is because the logic to trigger the pause does not account for all corner cases.
2025-07-31 01:47:09,117 INFO Oracle||streaming Fetching results for SCN [28986987, 28986995] [io.debezium.connector.oracle.logminer.buffered.BufferedLogMinerStreamingChangeEventSource] 2025-07-31 01:47:09,124 INFO Oracle||streaming BatchMetrics: jdbcRows=0, processedRows=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=0, rollbackCount=0, partialRollbackCount=0, tableMetadataCount=0. [io.debezium.connector.oracle.logminer.AbstractLogMinerStreamingChangeEventSource] 2025-07-31 01:47:09,124 INFO Oracle||streaming Processed in PT0.000045548S ms. Lag 2560. Active Transactions: 0. Sleep: 1000. Offsets: OracleOffsetContext [scn=28986987, txId=0a00040086410000, commit_scn=["28986987:1:0a001c0025420000"], lcr_position=null] [io.debezium.connector.oracle.logminer.AbstractLogMinerStreamingChangeEventSource] 2025-07-31 01:47:10,136 INFO Oracle||streaming LastProcessedScn=28986987, StartScn=28986987, EndScn=28986995 [io.debezium.connector.oracle.logminer.buffered.BufferedLogMinerStreamingChangeEventSource] 2025-07-31 01:47:10,164 INFO Oracle||streaming Fetching results for SCN [28986987, 28986995] [io.debezium.connector.oracle.logminer.buffered.BufferedLogMinerStreamingChangeEventSource] 2025-07-31 01:47:10,172 INFO Oracle||streaming BatchMetrics: jdbcRows=0, processedRows=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=0, rollbackCount=0, partialRollbackCount=0, tableMetadataCount=0. [io.debezium.connector.oracle.logminer.AbstractLogMinerStreamingChangeEventSource] 2025-07-31 01:47:10,172 INFO Oracle||streaming Processed in PT0.000046505S ms. Lag 2560. Active Transactions: 0. Sleep: 1000. Offsets: OracleOffsetContext [scn=28986987, txId=0a00040086410000, commit_scn=["28986987:1:0a001c0025420000"], lcr_position=null] [io.debezium.connector.oracle.logminer.AbstractLogMinerStreamingChangeEventSource]