Broken pipe (Write failed) - Retriable Exception?

101 views
Skip to first unread message

Shiva Prathipati

unread,
Jun 20, 2022, 8:03:19 PM6/20/22
to debezium
I believe the following exception is not considered a retriable exception in SQL Server Connector:
com.microsoft.sqlserver.jdbc.SQLServerException: Broken pipe (Write failed)

Because of which the connector task is killed and the following statement is logged:
ERROR WorkerSourceTask{id=***********-0} Task is being killed and will not recover until manually restarted (org.apache.kafka.connect.runtime.WorkerTask:187)

Is it possible to make this SQLServerException with "Broken pipe (Write failed)" message a retriable exception?

Thank you,
Shiva

Chris Cranford

unread,
Jun 21, 2022, 8:31:07 AM6/21/22
to debe...@googlegroups.com, Shiva Prathipati
Hi Shiva -

Absolutely, could you please raise an enhancement request for this in Jira, https://issues.redhat.com/projects/DBZ?

Thanks,
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 on the web visit https://groups.google.com/d/msgid/debezium/120acdbe-4c0a-4b0d-849e-670f0fa8a615n%40googlegroups.com.

Shiva Prathipati

unread,
Jun 21, 2022, 2:50:40 PM6/21/22
to debezium
Will do.

Thank you,
Shiva

Shiva Prathipati

unread,
Jun 22, 2022, 6:13:02 PM6/22/22
to debezium
Hi CC,

I created the enhancement request - https://issues.redhat.com/browse/DBZ-5292

Thank you,
Shiva

sumit jain

unread,
Apr 22, 2023, 2:10:10 AM4/22/23
to debezium
Hi, can anyone confirm if the Broken pipe error happens during the snapshot phase and Debezium internally does a retry, whether the snapshot starts from the beginning or resumes from the state when the error occurred? 

Chris Cranford

unread,
Apr 24, 2023, 12:42:09 AM4/24/23
to debe...@googlegroups.com
Hi,

If it's the initial traditional snapshot, it will start from the beginning.  Only incremental snapshots using signals are resumable after a failure or connector restart.

Chris
Reply all
Reply to author
Forward
0 new messages