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

Allow retry when SQL Server is down temporarily

    XMLWordPrintable

Details

    Description

      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?

       

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: