Debezium connector java.net.SocketException during snapshotting

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content