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

Better handling of invalid SQL Server connector configuration

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Minor
    • 1.6.0.Beta1
    • 1.5.0.Final
    • sqlserver-connector
    • None
    • False
    • False
    • Undefined

    Description

      When the filter specified in column.include.list applied to the list of columns of a certain table produces an empty list, the connector still tries to perform a knowingly invalid SQL query that selects no columns.

      Steps to reproduce
      1. Configure the connector with column.include.list=.^ – there's no column name that will match this regular expression.
      2. Run the connector.
      Expected behavior
      1. The connector doesn't attempt to perform a knowingly invalid query.
      2. There is a log message that helps identify the invalid configuration.
      Actual behavior
      Producer failure   [io.debezium.pipeline.ErrorHandler]
      io.debezium.DebeziumException: org.apache.kafka.connect.errors.ConnectException: Snapshotting of table testDB.dbo.tablea failed
      ...
      Caused by: org.apache.kafka.connect.errors.ConnectException: Snapshotting of table testDB.dbo.tablea failed
      ...
      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'FROM'.
      ...
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            sergeimorozov Sergei Morozov
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: