SQL Server random test failure - stopCurrentIncrementalSnapshotWithoutCollectionsAndTakeNewNewIncrementalSnapshotAfterRestart [DBZ-5447]

Migrated from [DBZ-5447](https://issues.redhat.com/browse/DBZ-5447)

{noformat}
2022-07-25T18:28:19.7442812Z [ERROR] Tests run: 14, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 328.002 s <<< FAILURE! - in io.debezium.connector.sqlserver.IncrementalSnapshotWithRecompileIT
2022-07-25T18:28:19.7444660Z [ERROR] io.debezium.connector.sqlserver.IncrementalSnapshotWithRecompileIT.stopCurrentIncrementalSnapshotWithoutCollectionsAndTakeNewNewIncrementalSnapshotAfterRestart Time elapsed: 29.664 s <<< FAILURE!
2022-07-25T18:28:19.7446322Z org.junit.ComparisonFailure: expected:<[tru]e> but was:<[fals]e>
2022-07-25T18:28:19.7447583Z at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2022-07-25T18:28:19.7448366Z at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
2022-07-25T18:28:19.7449351Z at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2022-07-25T18:28:19.7450531Z at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
2022-07-25T18:28:19.7451174Z at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
2022-07-25T18:28:19.7452111Z at org.fest.assertions.ConstructorInvoker.newInstance(ConstructorInvoker.java:36)
2022-07-25T18:28:19.7452861Z at org.fest.assertions.ComparisonFailureFactory.newComparisonFailure(ComparisonFailureFactory.java:60)
2022-07-25T18:28:19.7461899Z at org.fest.assertions.ComparisonFailureFactory.comparisonFailure(ComparisonFailureFactory.java:46)
2022-07-25T18:28:19.7463010Z at org.fest.assertions.Fail.comparisonFailed(Fail.java:83)
2022-07-25T18:28:19.7463449Z at org.fest.assertions.Fail.failIfNotEqual(Fail.java:71)
2022-07-25T18:28:19.7463879Z at org.fest.assertions.GenericAssert.isEqualTo(GenericAssert.java:217)
2022-07-25T18:28:19.7464330Z at org.fest.assertions.BooleanAssert.isEqualTo(BooleanAssert.java:73)
2022-07-25T18:28:19.7464775Z at org.fest.assertions.BooleanAssert.isTrue(BooleanAssert.java:55)
2022-07-25T18:28:19.7465331Z at io.debezium.embedded.AbstractConnectorTest.assertNoRecordsToConsume(AbstractConnectorTest.java:914)
2022-07-25T18:28:19.7466319Z at io.debezium.pipeline.source.snapshot.incremental.AbstractIncrementalSnapshotTest.startConnector(AbstractIncrementalSnapshotTest.java:285)
2022-07-25T18:28:19.7467288Z at io.debezium.pipeline.source.snapshot.incremental.AbstractIncrementalSnapshotTest.startConnector(AbstractIncrementalSnapshotTest.java:294)
2022-07-25T18:28:19.7468869Z at io.debezium.pipeline.source.snapshot.incremental.AbstractIncrementalSnapshotTest.stopCurrentIncrementalSnapshotWithoutCollectionsAndTakeNewNewIncrementalSnapshotAfterRestart(AbstractIncrementalSnapshotTest.java:582)
2022-07-25T18:28:19.7470162Z at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2022-07-25T18:28:19.7470727Z at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
2022-07-25T18:28:19.7471358Z at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2022-07-25T18:28:19.7471871Z at java.base/java.lang.reflect.Method.invoke(Method.java:568)
2022-07-25T18:28:19.7472312Z at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59)
2022-07-25T18:28:19.7472837Z at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
2022-07-25T18:28:19.7473388Z at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56)
2022-07-25T18:28:19.7473926Z at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
2022-07-25T18:28:19.7474461Z at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
2022-07-25T18:28:19.7474975Z at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
2022-07-25T18:28:19.7475416Z at org.junit.rules.TestWatcher$1.evaluate(TestWatcher.java:61)
2022-07-25T18:28:19.7475805Z at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
2022-07-25T18:28:19.7476255Z at org.junit.runners.BlockJUnit4ClassRunner$1.evaluate(BlockJUnit4ClassRunner.java:100)
2022-07-25T18:28:19.7476694Z at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366)
2022-07-25T18:28:19.7477161Z at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:103)
2022-07-25T18:28:19.7477683Z at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:63)
2022-07-25T18:28:19.7478130Z at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
2022-07-25T18:28:19.7478516Z at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
2022-07-25T18:28:19.7478935Z at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
2022-07-25T18:28:19.7479344Z at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
2022-07-25T18:28:19.7479745Z at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
2022-07-25T18:28:19.7480331Z at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
2022-07-25T18:28:19.7480726Z at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
2022-07-25T18:28:19.7481275Z at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:377)
2022-07-25T18:28:19.7481841Z at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:284)
2022-07-25T18:28:19.7482413Z at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:248)
2022-07-25T18:28:19.7482957Z at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:167)
2022-07-25T18:28:19.7483519Z at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:456)
2022-07-25T18:28:19.7484069Z at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:169)
2022-07-25T18:28:19.7484565Z at org.apache.maven.surefire.booter.ForkedBooter.run(ForkedBooter.java:595)
2022-07-25T18:28:19.7485047Z at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:581)
{noformat}

Start with io.debezium.connector.sqlserver.IncrementalSnapshotWithRecompileIT and the failing stopCurrentIncrementalSnapshotWithoutCollectionsAndTakeNewNewIncrementalSnapshotAfterRestart test. Read AbstractIncrementalSnapshotTest.startConnector and AbstractConnectorTest.assertNoRecordsToConsume at the reported lines, then reproduce the SQL Server failure. Done means identifying and correcting the intermittent behavior so the test reliably passes without unexpected records.

Written by the indexing model from the issue text.