Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-3339

Allow retry when SQL Server is down temporarily

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Optional Optional
    • 1.6.0.Beta1
    • None
    • sqlserver-connector
    • None

      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?

       

              jpechane Jiri Pechanec
              siufay325 Fanbin Zeng (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: