Retry logic for "No more data to read from socket" is too strict

[2021-04-27 05:45:04,682] ERROR Producer failure (io.debezium.pipeline.ErrorHandler:31)

io.debezium.DebeziumException: java.lang.RuntimeException: java.sql.SQLException: No more data to read from socket

         at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:82)

         at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:105)

         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)

Caused by: java.lang.RuntimeException: java.sql.SQLException: No more data to read from socket

         at io.debezium.relational.RelationalSnapshotChangeEventSource.rollbackTransaction(RelationalSnapshotChangeEventSource.java:478)

         at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:152)

         at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:71)

         ... 6 more

Caused by: java.sql.SQLException: No more data to read from socket

         at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)

         at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:350)

         at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)

         at oracle.jdbc.driver.T4C7Ocommoncall.doOROLLBACK(T4C7Ocommoncall.java:68)

         at oracle.jdbc.driver.T4CConnection.doRollback(T4CConnection.java:725)

         at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:3954)

         at io.debezium.relational.RelationalSnapshotChangeEventSource.rollbackTransaction(RelationalSnapshotChangeEventSource.java:475)

         ... 8 more

[2021-04-27 05:45:04,683] INFO Connected metrics set to 'false' (io.debezium.pipeline.metrics.StreamingChangeEventSourceMetrics:60)

[2021-04-27 05:45:04,686] INFO WorkerSourceTask\{id=ORACLECDC12-0} Committing offsets (org.apache.kafka.connect.runtime.WorkerSourceTask:424)

[2021-04-27 05:45:04,689] INFO WorkerSourceTask\{id=ORACLECDC12-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask:441)

[2021-04-27 05:45:04,689] ERROR WorkerSourceTask\{id=ORACLECDC12-0} Task threw an uncaught and unrecoverable exception (org.apache.kafka.connect.runtime.WorkerTask:186)

org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped.

         at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:42)

         at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:121)

         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)

Caused by: io.debezium.DebeziumException: java.lang.RuntimeException: java.sql.SQLException: No more data to read from socket

         at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:82)

         at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:105)

         ... 5 more

Caused by: java.lang.RuntimeException: java.sql.SQLException: No more data to read from socket

         at io.debezium.relational.RelationalSnapshotChangeEventSource.rollbackTransaction(RelationalSnapshotChangeEventSource.java:478)

         at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:152)