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

ALTER TABLE ADD COLUMN with default will cause Hybrid SQL reconstruction to fail

XMLWordPrintable

    • False
    • Hide

      None

      Show
      None
    • False

      Bug report

      While generating a scenario where Logminer fails to reconstruct the columns of an insert, I am able to create a scenario where when the Oracle connector is in Hybrid mode it fails to handle this as expected.

      What Debezium connector do you use and what version?

      I'm using the Oracle connector running in Debezium Server. Oracle connector is built off of this pull request: https://github.com/debezium/debezium/pull/6343

      What is the connector configuration?

      Application.properties file is attached

      What is the captured database version and mode of deployment?

      Oracle 19C running locally

      What behavior do you expect?

      In all cases, I expect Hybrid to be able to correctly map the column from LOGMINER_CONTENTS

      What behavior do you see?

      Connector crashes with parser error.

      Do you see the same behaviour using the latest released Debezium version?

      Not yet tested

      Do you have the connector logs, ideally from start till finish?

      Debug logs are attached to the ticket

      How to reproduce the issue using our tutorial deployment?

      1) Create table with supplemental logging
      2) In session 1, insert 1000 rows at a time every ten seconds
      3) In session 2, repeatedly add/remove column. Eventually connector will crash as shown in debug logs

      SQL code for tests I ran also attached

        1. application.properties
          4 kB
        2. DBZ8937-DATA-EXTRACT.csv
          7 kB
        3. output.log
          7.72 MB
        4. sql_tests
          3 kB

              ccranfor@redhat.com Chris Cranford
              nathan-smit-1 Nathan Smit
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated: