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

Archive log only mode does not pause mining when no more data available

XMLWordPrintable

      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]
      

              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: