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 followed up by

          Enhancement - An enhancement or refactoring of existing functionality DBZ-3062 Add support for snapshot.include.collection.list

          • Major - A request that should be considered seriously but is not a show stopper.
          • Open
          relates to

          Bug - A problem which 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 - A request that should be considered seriously but is not a show stopper.
          • Closed

            Activity

              People

              Assignee:
              ccranfor Chris Cranford
              Reporter:
              integratemukesh Mukesh Sharma (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: