Debezium connector java.net.SocketException during snapshotting
Issue
When a connector is in a snapshot phase, the following is observed:
ERROR [inventory-connector-postgresql|task-0] Error in finally block (io.debezium.relational.RelationalSnapshotChangeEventSource) [debezium-postgresconnector-...]
java.lang.RuntimeException: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
at io.debezium.relational.RelationalSnapshotChangeEventSource.rollbackTransaction(RelationalSnapshotChangeEventSource.java:723)
at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:183)
at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnap
Caused by: java.net.SocketException: Connection reset by peer
This error occurs when a firewall terminates idle connections.
Environment
- Red Hat Build of Debezium
- 2.5.4
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.