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

oracle connector fails because of Supplemental logging not properly configured

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 1.9.0.CR1
    • 1.9.0.Alpha1
    • oracle-connector
    • None
    • False
    • None
    • False
    • Hide
      • Create new table
      • stop debez container
      • start debez container
      • while starting the debezium is stopped and an error message is produced

      before the stop and start of debezium everything work ok and i do get cdc events for the new table i created. only after the restart i get the error message.
      After execute the alter command for this table debezium starts successfully

      Show
      Create new table stop debez container start debez container while starting the debezium is stopped and an error message is produced before the stop and start of debezium everything work ok and i do get cdc events for the new table i created. only after the restart i get the error message. After execute the alter command for this table debezium starts successfully

    Description

      Debezium fails on start because of missing supplemental login configuration:

      io.debezium.DebeziumException: Supplemental logging not properly configured for table ORCLPDB1.C##DBZUSER.TEST_CLOB. Use: ALTER TABLE C##DBZUSER.TEST_CLOB ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS
      at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.checkDatabaseAndTableState(LogMinerStreamingChangeEventSource.java:623)
      at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:138)
      at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:57)
      at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:173)
      at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:140)
      at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109)
      at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
      at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
      at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
      at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
      at java.base/java.lang.Thread.run(Thread.java:829)

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: