-
Enhancement
-
Resolution: Done
-
Major
-
2.6.0.Alpha2
-
None
-
False
-
None
-
False
-
-
When the Oracle XStream adapter attempts to attach to the outbound server, the client can throw an ORA-23656 error if a timeout is reached while waiting for the XStream process to attach, shown below:
oracle.streams.StreamsException: ORA-23656: Timeout occurred while starting XStream process DBZXOUT at oracle.streams.XStreamOut.XStreamOutAttachNative(Native Method) at oracle.streams.XStreamOut.attachInternal(Unknown Source) at oracle.streams.XStreamOut.attach(Unknown Source) at io.debezium.connector.oracle.xstream.XstreamStreamingChangeEventSource.performAttachWithRetries(XstreamStreamingChangeEventSource.java:181) at io.debezium.connector.oracle.xstream.XstreamStreamingChangeEventSource.execute(XstreamStreamingChangeEventSource.java:122) at io.debezium.connector.oracle.xstream.XstreamStreamingChangeEventSource.execute(XstreamStreamingChangeEventSource.java:45) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:274) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:197) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:140) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:833)
As the performAttachWithRetries already has a retry hook for ORA-26653, we should add ORA-23656 as well.