-
Feature Request
-
Resolution: Done
-
Optional
-
None
-
None
-
False
-
False
-
Undefined
-
For SQL Server failover cluster instance, there will be a short period of downtime during the failover. The Debezium connector will restart after the retriable error "SHUTDOWN is in progress.", then fail when trying to establish the new DB connection:
java.lang.RuntimeException: Couldn't obtain database name at io.debezium.connector.sqlserver.SqlServerConnection.retrieveRealDatabaseName(SqlServerConnection.java:489) at io.debezium.connector.sqlserver.SqlServerConnection.<init>(SqlServerConnection.java:120) at io.debezium.connector.sqlserver.SqlServerConnectorTask.start(SqlServerConnectorTask.java:76) ... Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host XXXXX, port 1433 has failed. Error: "Connection refused (Connection refused). Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall." ... |
Is there any way to change the code to allow retry on connection error?