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

SQL Server CI test errors: SqlServerConnectorIT restartInTheMiddleOfTx, restartInTheMiddleOfTxAfterCompletedTx, restartInTheMiddleOfTxAfterSnapshot

    XMLWordPrintable

Details

    • False
    • None
    • False

    Description

      Likely somewhat related with DBZ-6849 but SQL Server randomly fails on these tests as well.

      All test failures in the run were:

      2024-03-15T18:58:19.7877064Z [ERROR] Failures: 
      2024-03-15T18:58:19.7883653Z [ERROR]   IncrementalSnapshotWithRecompileIT.stopCurrentIncrementalSnapshotWithAllCollectionsAndTakeNewNewIncrementalSnapshotAfterRestart:176->AbstractIncrementalSnapshotTest.stopCurrentIncrementalSnapshotWithAllCollectionsAndTakeNewNewIncrementalSnapshotAfterRestart:596->AbstractSnapshotTest.startConnector:288->AbstractSnapshotTest.startConnector:279->AbstractConnectorTest.assertNoRecordsToConsume:991 expected:<[tru]e> but was:<[fals]e>
      2024-03-15T18:58:19.7890792Z [ERROR]   IncrementalSnapshotWithRecompileIT>AbstractIncrementalSnapshotTest.stopCurrentIncrementalSnapshotWithoutCollectionsAndTakeNewNewIncrementalSnapshotAfterRestart:541->AbstractSnapshotTest.startConnector:288->AbstractSnapshotTest.startConnector:279->AbstractConnectorTest.assertNoRecordsToConsume:991 expected:<[tru]e> but was:<[fals]e>
      2024-03-15T18:58:19.7894932Z [ERROR]   SqlServerConnectorIT.restartInTheMiddleOfTxAfterSnapshot:1951->restartInTheMiddleOfTx:1870 
      2024-03-15T18:58:19.7896103Z Expected size:<30> but was:<11> in:
      2024-03-15T18:58:19.7903006Z <[SourceRecord{sourcePartition={server=server1, database=testDB1}, sourceOffset={event_serial_no=1, commit_lsn=00000027:00000d18:0057, change_lsn=00000027:00000d18:0002}} ConnectRecord{topic='server1.testDB1.dbo.tablea', kafkaPartition=null, key=Struct{id=10}, keySchema=Schema{server1.testDB1.dbo.tablea.Key:STRUCT}, value=Struct{after=Struct{id=10,cola=a},source=Struct{version=2.6.0-SNAPSHOT,connector=sqlserver,name=server1,ts_ms=1710527724437,db=testDB1,ts_us=1710527724437000,ts_ns=1710527724437000000,schema=dbo,table=tablea,change_lsn=00000027:00000d18:0002,commit_lsn=00000027:00000d18:0057,event_serial_no=1},op=c,ts_ms=1710527728927,ts_us=1710527728927486,ts_ns=1710527728927486919}, valueSchema=Schema{server1.testDB1.dbo.tablea.Envelope:STRUCT}, timestamp=null, headers=ConnectHeaders(headers=)},
      2024-03-15T18:58:19.7911836Z     SourceRecord{sourcePartition={server=server1, database=testDB1}, sourceOffset={event_serial_no=1, commit_lsn=00000027:00000d18:0057, change_lsn=00000027:00000d18:001c}} ConnectRecord{topic='server1.testDB1.dbo.tableb', kafkaPartition=null, key=Struct{id=10}, keySchema=Schema{server1.testDB1.dbo.tableb.Key:STRUCT}, value=Struct{after=Struct{id=10,colb=b},source=Struct{version=2.6.0-SNAPSHOT,connector=sqlserver,name=server1,ts_ms=1710527724437,db=testDB1,ts_us=1710527724437000,ts_ns=1710527724437000000,schema=dbo,table=tableb,change_lsn=00000027:00000d18:001c,commit_lsn=00000027:00000d18:0057,event_serial_no=1},op=c,ts_ms=1710527728927,ts_us=1710527728927512,ts_ns=1710527728927512397}, valueSchema=Schema{server1.testDB1.dbo.tableb.Envelope:STRUCT}, timestamp=null, headers=ConnectHeaders(headers=)},
      2024-03-15T18:58:19.7921721Z     SourceRecord{sourcePartition={server=server1, database=testDB1}, sourceOffset={event_serial_no=1, commit_lsn=00000027:00000d18:0057, change_lsn=00000027:00000d18:001d}} ConnectRecord{topic='server1.testDB1.dbo.tablea', kafkaPartition=null, key=Struct{id=11}, keySchema=Schema{server1.testDB1.dbo.tablea.Key:STRUCT}, value=Struct{after=Struct{id=11,cola=a},source=Struct{version=2.6.0-SNAPSHOT,connector=sqlserver,name=server1,ts_ms=1710527724437,db=testDB1,ts_us=1710527724437000,ts_ns=1710527724437000000,schema=dbo,table=tablea,change_lsn=00000027:00000d18:001d,commit_lsn=00000027:00000d18:0057,event_serial_no=1},op=c,ts_ms=1710527728927,ts_us=1710527728927520,ts_ns=1710527728927520732}, valueSchema=Schema{server1.testDB1.dbo.tablea.Envelope:STRUCT}, timestamp=null, headers=ConnectHeaders(headers=)},
      2024-03-15T18:58:19.7930868Z     SourceRecord{sourcePartition={server=server1, database=testDB1}, sourceOffset={event_serial_no=1, commit_lsn=00000027:00000d18:0057, change_lsn=00000027:00000d18:001e}} ConnectRecord{topic='server1.testDB1.dbo.tableb', kafkaPartition=null, key=Struct{id=11}, keySchema=Schema{server1.testDB1.dbo.tableb.Key:STRUCT}, value=Struct{after=Struct{id=11,colb=b},source=Struct{version=2.6.0-SNAPSHOT,connector=sqlserver,name=server1,ts_ms=1710527724437,db=testDB1,ts_us=1710527724437000,ts_ns=1710527724437000000,schema=dbo,table=tableb,change_lsn=00000027:00000d18:001e,commit_lsn=00000027:00000d18:0057,event_serial_no=1},op=c,ts_ms=1710527728927,ts_us=1710527728927526,ts_ns=1710527728927526092}, valueSchema=Schema{server1.testDB1.dbo.tableb.Envelope:STRUCT}, timestamp=null, headers=ConnectHeaders(headers=)},
      2024-03-15T18:58:19.7941707Z     SourceRecord{sourcePartition={server=server1, database=testDB1}, sourceOffset={event_serial_no=1, commit_lsn=00000027:00000d18:0057, change_lsn=00000027:00000d18:001f}} ConnectRecord{topic='server1.testDB1.dbo.tablea', kafkaPartition=null, key=Struct{id=12}, keySchema=Schema{server1.testDB1.dbo.tablea.Key:STRUCT}, value=Struct{after=Struct{id=12,cola=a},source=Struct{version=2.6.0-SNAPSHOT,connector=sqlserver,name=server1,ts_ms=1710527724437,db=testDB1,ts_us=1710527724437000,ts_ns=1710527724437000000,schema=dbo,table=tablea,change_lsn=00000027:00000d18:001f,commit_lsn=00000027:00000d18:0057,event_serial_no=1},op=c,ts_ms=1710527728927,ts_us=1710527728927531,ts_ns=1710527728927531101}, valueSchema=Schema{server1.testDB1.dbo.tablea.Envelope:STRUCT}, timestamp=null, headers=ConnectHeaders(headers=)},
      2024-03-15T18:58:19.7950575Z     SourceRecord{sourcePartition={server=server1, database=testDB1}, sourceOffset={event_serial_no=1, commit_lsn=00000027:00000d18:0057, change_lsn=00000027:00000d18:0020}} ConnectRecord{topic='server1.testDB1.dbo.tableb', kafkaPartition=null, key=Struct{id=12}, keySchema=Schema{server1.testDB1.dbo.tableb.Key:STRUCT}, value=Struct{after=Struct{id=12,colb=b},source=Struct{version=2.6.0-SNAPSHOT,connector=sqlserver,name=server1,ts_ms=1710527724437,db=testDB1,ts_us=1710527724437000,ts_ns=1710527724437000000,schema=dbo,table=tableb,change_lsn=00000027:00000d18:0020,commit_lsn=00000027:00000d18:0057,event_serial_no=1},op=c,ts_ms=1710527728927,ts_us=1710527728927535,ts_ns=1710527728927535700}, valueSchema=Schema{server1.testDB1.dbo.tableb.Envelope:STRUCT}, timestamp=null, headers=ConnectHeaders(headers=)},
      2024-03-15T18:58:19.7957172Z     SourceRecord{sourcePartition={server=server1, database=testDB1}, sourceOffset={event_serial_no=1, commit_lsn=00000027:00000d18:0057, change_lsn=00000027:00000d18:0021}} ConnectRecord{topic='server1.testDB1.dbo.tablea', kafkaPartition=null, key=Struct{id=13}, keySchema=Schema{server1.testDB1.dbo.tablea.Key:STRUCT}, value=Struct{after=Struct{id=13,cola=a},source=Struct{version=2.6.0-SNAPSHOT,connector=sqlserver,name=server1,ts_ms=1710527724437,db=testDB1,ts_us=1710527724437000,ts_ns=1710527724437000000,schema=dbo,table=tablea,change_lsn=00000027:00000d18:0021,commit_lsn=00000027:00000d18:0057,event_serial_no=1},op=c,ts_ms=1710527728927,ts_us=1710527728927540,ts_ns=1710527728927540359}, valueSchema=Schema{server1.testDB1.dbo.tablea.Envelope:STRUCT}, timestamp=null, headers=ConnectHeaders(headers=)},
      2024-03-15T18:58:19.7963818Z     SourceRecord{sourcePartition={server=server1, database=testDB1}, sourceOffset={event_serial_no=1, commit_lsn=00000027:00000d18:0057, change_lsn=00000027:00000d18:0022}} ConnectRecord{topic='server1.testDB1.dbo.tableb', kafkaPartition=null, key=Struct{id=13}, keySchema=Schema{server1.testDB1.dbo.tableb.Key:STRUCT}, value=Struct{after=Struct{id=13,colb=b},source=Struct{version=2.6.0-SNAPSHOT,connector=sqlserver,name=server1,ts_ms=1710527724437,db=testDB1,ts_us=1710527724437000,ts_ns=1710527724437000000,schema=dbo,table=tableb,change_lsn=00000027:00000d18:0022,commit_lsn=00000027:00000d18:0057,event_serial_no=1},op=c,ts_ms=1710527728927,ts_us=1710527728927544,ts_ns=1710527728927544978}, valueSchema=Schema{server1.testDB1.dbo.tableb.Envelope:STRUCT}, timestamp=null, headers=ConnectHeaders(headers=)},
      2024-03-15T18:58:19.7970505Z     SourceRecord{sourcePartition={server=server1, database=testDB1}, sourceOffset={event_serial_no=1, commit_lsn=00000027:00000d18:0057, change_lsn=00000027:00000d18:0023}} ConnectRecord{topic='server1.testDB1.dbo.tablea', kafkaPartition=null, key=Struct{id=14}, keySchema=Schema{server1.testDB1.dbo.tablea.Key:STRUCT}, value=Struct{after=Struct{id=14,cola=a},source=Struct{version=2.6.0-SNAPSHOT,connector=sqlserver,name=server1,ts_ms=1710527724437,db=testDB1,ts_us=1710527724437000,ts_ns=1710527724437000000,schema=dbo,table=tablea,change_lsn=00000027:00000d18:0023,commit_lsn=00000027:00000d18:0057,event_serial_no=1},op=c,ts_ms=1710527728927,ts_us=1710527728927549,ts_ns=1710527728927549626}, valueSchema=Schema{server1.testDB1.dbo.tablea.Envelope:STRUCT}, timestamp=null, headers=ConnectHeaders(headers=)},
      2024-03-15T18:58:19.7977297Z     SourceRecord{sourcePartition={server=server1, database=testDB1}, sourceOffset={event_serial_no=1, commit_lsn=00000027:00000d18:0057, change_lsn=00000027:00000d18:0024}} ConnectRecord{topic='server1.testDB1.dbo.tableb', kafkaPartition=null, key=Struct{id=14}, keySchema=Schema{server1.testDB1.dbo.tableb.Key:STRUCT}, value=Struct{after=Struct{id=14,colb=b},source=Struct{version=2.6.0-SNAPSHOT,connector=sqlserver,name=server1,ts_ms=1710527724437,db=testDB1,ts_us=1710527724437000,ts_ns=1710527724437000000,schema=dbo,table=tableb,change_lsn=00000027:00000d18:0024,commit_lsn=00000027:00000d18:0057,event_serial_no=1},op=c,ts_ms=1710527728927,ts_us=1710527728927554,ts_ns=1710527728927554275}, valueSchema=Schema{server1.testDB1.dbo.tableb.Envelope:STRUCT}, timestamp=null, headers=ConnectHeaders(headers=)},
      2024-03-15T18:58:19.7984726Z     SourceRecord{sourcePartition={server=server1, database=testDB1}, sourceOffset={event_serial_no=1, commit_lsn=00000027:00000d18:0057, change_lsn=00000027:00000d18:0025}} ConnectRecord{topic='server1.testDB1.dbo.tablea', kafkaPartition=null, key=Struct{id=15}, keySchema=Schema{server1.testDB1.dbo.tablea.Key:STRUCT}, value=Struct{after=Struct{id=15,cola=a},source=Struct{version=2.6.0-SNAPSHOT,connector=sqlserver,name=server1,ts_ms=1710527724437,db=testDB1,ts_us=1710527724437000,ts_ns=1710527724437000000,schema=dbo,table=tablea,change_lsn=00000027:00000d18:0025,commit_lsn=00000027:00000d18:0057,event_serial_no=1},op=c,ts_ms=1710527728927,ts_us=1710527728927558,ts_ns=1710527728927558853}, valueSchema=Schema{server1.testDB1.dbo.tablea.Envelope:STRUCT}, timestamp=null, headers=ConnectHeaders(headers=)}]>
      2024-03-15T18:58:19.7987940Z [INFO] 
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            ccranfor@redhat.com Chris Cranford
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: