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

None of log files contains offset SCN (SCN offset is no longer available in the online redo logs)

    XMLWordPrintable

Details

    Description

      Versions:
      debezium - 1.6 SNAPSHOT
      Oracle - 19c (19.0) on RHEL

       

      This error occurs after a certain idle time for the oracle connector (log.mining.strategy = online_catalog)

      IllgealStateException: None of log files contains offset SCN: 3961693, re-snapshot is reuired

      setLogFilesMining(LogMinerHelper.java:446)

       

      If we do not find this SCN in the logs, then what's the point of throwing an runtime exception and stopping the connector in the setLogFilesForming method ?

      Can you specify any workaround for Oracle 19c?

       

       

      Attachments

        Issue Links

          is incorporated by

          Task - Represents a small unit of work that is not end-user facing. DBZ-3645 Change CLOB/BLOB data type support to an opt-in feature

          • Blocker - To be worked above all other priorities. This term is chosen when the severity of the issue is very high, has no workaround, or the effort for the change is comparatively low. Issues that may be very publicly visible and could generate significant media attention may also drive a higher priority.
          • Closed
          is related to

          Task - Represents a small unit of work that is not end-user facing. DBZ-4408 Remove log.mining.log.file.query.max.retries configuration property

          • Minor - To be worked after urgent, high, and medium priorities are resolved. This term is chosen when the severity of the issue is low, or the complexity or effort to correct it may be higher, relatively speaking. For low priority issues, known workarounds exist or are not needed due to the trivial effort needed to address the issue.
          • Closed

          Enhancement - An enhancement to or refactoring of existing functionality that is not configurable by an end user (typically a change made by an internal team that affects users) DBZ-4900 Use back-off strategy for log availability check

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed
          relates to

          Bug - A problem that impairs or prevents the functions of the product. DBZ-3808 None of log files contains offset SCN

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              ccranfor@redhat.com Chris Cranford
              sergeyts Sergey Tsimbalov (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: