Loading...

XML

Word

Printable

Blocked:
False
Ready:
False
Target Release:

1.9.GA
Steps to Reproduce:
Hide

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

max.iteration.transactions is set to a non-empty value (see ~~DBZ-3486~~).
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_ ... .

relates to

DBZ-3486 SQL Server connector buffers all CDC events in memory if more than one table is captured