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

SQL Server fails to read CDC events if there is a schema change ahead

XMLWordPrintable

    • False
    • False
    • Hide
      1. Update io.debezium.connector.sqlserver.util.TestHelper#defaultConfig by adding the following:
        .with(SqlServerConnectorConfig.MAX_TRANSACTIONS_PER_ITERATION, 1)
        
      1. Run io.debezium.connector.sqlserver.SqlServerChangeTableSetIT#addColumnToTableEndOfBatch
      2. Observe the failure.

      There are a few more tests in the suite that will fail with this configuration.

      Show
      Update io.debezium.connector.sqlserver.util.TestHelper#defaultConfig by adding the following: .with(SqlServerConnectorConfig.MAX_TRANSACTIONS_PER_ITERATION, 1) Run  io.debezium.connector.sqlserver.SqlServerChangeTableSetIT#addColumnToTableEndOfBatch Observe the failure. There are a few more tests in the suite that will fail with this configuration.

      The issue is reproducible only if all of the following conditions are met:

      1. max.iteration.transactions is set to a non-empty value (see DBZ-3486).
      2. There's a schema change N transactions or more ahead of the current position of the connector, where N is the value of max.iteration.transactions.

      While trying to query the next batch of CDC events, the connector uses invalid SPROC parameters and fails with the following error:

      An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes_ ... .

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

              Created:
              Updated:
              Resolved: