Issue with Debezium Postgres Source Connectors on AWS RDS

[Mukesh Kumar]

I am running Debezium with PostgreSQL on AWS RDS as the source, using JDBC source connectors. The setup includes ~15 databases with 15 corresponding source connectors (all running on the same host).

Recently, I started observing issues with 2 of the connectors. The errors include:

Could not execute heartbeat action Error 08006 [io.debezium.heartbeat.DatabaseHeartbeatImpl]  
util.PSQLException: An I/O error occurred while sending to the backend  
SocketException: Socket Closed  
Producer Failure

This issue seems specific to only those 2 connectors, as the others continue to run without errors.

Could you please help diagnose what might be causing these errors and suggest the next steps to resolve them

Regards
Mukesh

[Chris Cranford]

Hi Mukesh -

It would seem, based on the data you have given thus far, that it could have been some network issue or the database terminated the connection for the heartbeat.
Does this happen randomly or does it happen repeatedly?

-cc

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/debezium/80e6fa95-3d14-4eca-b80d-c23397b1d396n%40googlegroups.com.