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

Oracle XStream 11g does not match the schema

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Blocker
    • None
    • 1.5.0.CR1
    • oracle-connector
    • None
    • False
    • False
    • Undefined

    Description

      Hello, I am collecting Oracle 11g with XStream, and an exception occurred during the collection process.
      The exception information is:
      Caused by: java.lang.IllegalArgumentException: No metadata registered for captured table orcl1.ORACLE_XSTREAM_CDC.oracle_cdc_source
      at io.debezium.pipeline.EventDispatcher.errorOnMissingSchema(EventDispatcher.java:262)
      at io.debezium.pipeline.EventDispatcher.dispatchDataChangeEvent(EventDispatcher.java:195)

      I debugged the code and found the following problems.
      The value "orcl1.oracle_xstream_cdc.oracle_cdc_source" is Obtained by the method shown in the figure below.

       

       

      Since the Oracle database I am using is 11g, the tableID returned by it will be processed as follows:
      ORACL1.ORACLE_XSTREAM_CDC.ORACLE_CDC_SOURCE --> orcl1.ORACLE_XSTREAM_CDC.oracle_cdc_source

      However, when I construct the OracleDatabaseSchema, I will call the method in the following image.

       

      so the generated TableID will be processed as follows:
      ORACL1. ORACLE_XSTREAM_CDC. ORACLE_CDC_SOURCE ->ORACL1.ORACLE_XSTREAM_CDC.oracle_cdc_source

      Therefore, the above exception is thrown.

      My solution is to increase this setting items."database.tablename.case.insensitive": "false" and didn't deal with tableID.
      The value of catalogName is in uppercase ORCL1. I'm not sure if my database is not working properly or if this is a bug.

      Attachments

        1. ~M53CN8VAUY@U]KS`(6DU6S.png
          ~M53CN8VAUY@U]KS`(6DU6S.png
          23 kB
        2. ~U3V]LH8[FMSX2I9IJ8P079.png
          ~U3V]LH8[FMSX2I9IJ8P079.png
          11 kB
        3. (%YJCA~Y8E1M7{U6J_N1MWP.png
          (%YJCA~Y8E1M7{U6J_N1MWP.png
          26 kB
        4. 0IY)Q{`N9OG([J8O)2}C{HV.png
          0IY)Q{`N9OG([J8O)2}C{HV.png
          10 kB
        5. 0IY)Q{`N9OG([J8O)2}C{HV-1.png
          0IY)Q{`N9OG([J8O)2}C{HV-1.png
          10 kB
        6. S_1PTWSO1Z5(}AL_17POX`L.png
          S_1PTWSO1Z5(}AL_17POX`L.png
          13 kB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              qyw919867774 yongwang qu (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: