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

Better handling of invalid SQL Server connector configuration

XMLWordPrintable

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

      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'.
      ...
      

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

                Created:
                Updated:
                Resolved: