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

oracle connector fails because of Supplemental logging not properly configured

XMLWordPrintable

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

      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)

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

                Created:
                Updated:
                Resolved: