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

Connector automatically restart on ORA-26653

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Minor Minor
    • 1.5.0.CR1
    • 1.5.0.Beta1
    • oracle-connector
    • None

      The Oracle connector may fail to attach to the remote outbound server:

      oracle.streams.StreamsException: ORA-26653: Apply DBZXOUT did not start properly and is currently in state INITIALI
      
      	at oracle.streams.XStreamOut.XStreamOutAttachNative(Native Method)
      	at oracle.streams.XStreamOut.attachInternal(XStreamOut.java:373)
      	at oracle.streams.XStreamOut.attach(XStreamOut.java:343)
      	at io.debezium.connector.oracle.xstream.XstreamStreamingChangeEventSource.execute(XstreamStreamingChangeEventSource.java:79)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:140)
      	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:113)
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      	at java.lang.Thread.run(Thread.java:748)
      

      Either the streaming source should be tolerant and try to re-attach on its own or at the very least allow this exception to be caught by the error handler and be retried.

              ccranfor@redhat.com Chris Cranford
              ccranfor@redhat.com Chris Cranford
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: