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

SQLException for Global temp tables from OracleDatabaseMetaData.getIndexInfo() makes Debezium snapshotting fail

    XMLWordPrintable

Details

    Description

      i am using debzium 1.4.1.final for CDC on oracle. I have setup logminer for replication. and using ojdbc8 driver 19.3.0.0. Oracle version is : 18c

      There are some global temp tables in my schema which when processed by debezium makes the snapshotting fail. Reason - The  OracleDatabaseMetaData.getIndexInfo()  in jdbc class throws sqlexception which eventually makes the snaphot process rollback.

       

      Please suggest if this can be addressed via a previous version of oracle driver or debezium or via connector configuration changes.

      Attachments

        Issue Links

          is related to

          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-3062 Add support for snapshot.include.collection.list

          • 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-3151 Final stage of snapshot analyzes tables not present in table.include.list thus stumbles upon unsupported XMLTYPE table

          • 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
              integratemukesh@gmail.com Mukesh Sharma (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: