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

Connector automatically restart on ORA-26653

    XMLWordPrintable

Details

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: