5

Using postgres source connector in kafka. It works properly for some time and suddently stops with above error. Please assist if someone knows this issue.

Joseph N
  • 540
  • 8
  • 28

1 Answers1

1

This happens if the database is not available and the only way to fix it to restart the connector. I would advise you to check the database logs and see if database is going down or refusing connection to Kafka Connect

sandy
  • 11
  • 2
  • Thanks sandy. I think it is failed due to master slave architecture of my database. whenever master fails, slave comes up and kafka connector fails. Now i have set dag which checks connector status every minute and rePOST it if this error occures. It will be really great if you can tell me, can i use replication slot on slave server also? – Joseph N Mar 02 '20 at 12:27
  • At the time of this writing no, you can't use logical replication slots for slave servers: https://debezium.io/documentation/reference/1.8/connectors/postgresql.html#supported-postgresql-topologies – Renato Vassão Jan 18 '22 at 17:15