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

Supplemental log check fails when restarting connector after table dropped

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major 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  

      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"

        1. debez_error.txt
          2 kB

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

                Created:
                Updated:
                Resolved: