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

Supplemental log check fails when restarting connector after table dropped

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 1.9.0.CR1
    • 1.8.1.Final, 1.9.0.Alpha1
    • oracle-connector
    • None
    • False
    • None
    • False
    • Hide

      1. table CONTACTS exists in oracle and its SUPPLEMENTAL configuration is not enabled
      2. run debezium 
      3. oracle connector fails because the SUPPLEMENTAL configuration is not enabled for the table CONTACTS 
      4. Drop the table CONTACTS (debezium is down)    
      5. restart debezium
      6. debezium fails again with the same error message of  the SUPPLEMENTAL configuration although the table was dropped from the database

       

      Show
      1. table CONTACTS exists in oracle and its SUPPLEMENTAL configuration is not enabled 2. run debezium  3. oracle connector fails because the SUPPLEMENTAL configuration is not enabled for the table CONTACTS  4. Drop the table CONTACTS (debezium is down)     5. restart debezium 6. debezium fails again with the same error message of  the SUPPLEMENTAL configuration although the table was dropped from the database  

    Description

      oracle connector fails with error message on a table that was dropped from the database:

      "io.debezium.DebeziumException: Supplemental logging not properly configured for table ORCLPDB1.C##DBZUSER.CONTACTS. Use: ALTER TABLE C##DBZUSER.CONTACTS ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS"

      Attachments

        Activity

          People

            ccranfor@redhat.com Chris Cranford
            gali.levin gal levin
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: