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

Intermittent test failure on CI - SqlServerChangeTableSetIT#readHistoryAfterRestart()

    XMLWordPrintable

Details

    Description

      https://api.travis-ci.org/v3/job/699898005/log.txt

      [ERROR]   SqlServerChangeTableSetIT.readHistoryAfterRestart:554 expected size:<4> but was:<5> for <[{
        "source" : {
          "server" : "server1"
        },
        "position" : {
          "commit_lsn" : "00000026:00000428:0003",
          "snapshot" : true,
          "snapshot_completed" : false
        },
        "databaseName" : "testDB",
        "schemaName" : "dbo",
        "tableChanges" : [ {
          "type" : "CREATE",
          "id" : "\"testDB\".\"dbo\".\"tablea\"",
          "table" : {
            "defaultCharsetName" : null,
            "primaryKeyColumnNames" : [ "id" ],
            "columns" : [ {
              "name" : "id",
              "jdbcType" : 4,
              "typeName" : "int",
              "typeExpression" : "int",
              "charsetName" : null,
              "length" : 10,
              "scale" : 0,
              "position" : 1,
              "optional" : false,
              "autoIncremented" : false,
              "generated" : false
            }, {
              "name" : "cola",
              "jdbcType" : 12,
              "typeName" : "varchar",
              "typeExpression" : "varchar",
              "charsetName" : null,
              "length" : 30,
              "position" : 2,
              "optional" : true,
              "autoIncremented" : false,
              "generated" : false
            } ]
          }
        } ]
      }, {
        "source" : {
          "server" : "server1"
        },
        "position" : {
          "commit_lsn" : "00000026:00000428:0003",
          "snapshot" : true,
          "snapshot_completed" : false
        },
        "databaseName" : "testDB",
        "schemaName" : "dbo",
        "tableChanges" : [ {
          "type" : "CREATE",
          "id" : "\"testDB\".\"dbo\".\"tableb\"",
          "table" : {
            "defaultCharsetName" : null,
            "primaryKeyColumnNames" : [ "id" ],
            "columns" : [ {
              "name" : "id",
              "jdbcType" : 4,
              "typeName" : "int",
              "typeExpression" : "int",
              "charsetName" : null,
              "length" : 10,
              "scale" : 0,
              "position" : 1,
              "optional" : false,
              "autoIncremented" : false,
              "generated" : false
            }, {
              "name" : "colb",
              "jdbcType" : 12,
              "typeName" : "varchar",
              "typeExpression" : "varchar",
              "charsetName" : null,
              "length" : 30,
              "position" : 2,
              "optional" : true,
              "autoIncremented" : false,
              "generated" : false
            } ]
          }
        } ]
      }, {
        "source" : {
          "server" : "server1"
        },
        "position" : {
          "commit_lsn" : "00000026:00000428:0003",
          "snapshot" : true,
          "snapshot_completed" : false
        },
        "databaseName" : "testDB",
        "schemaName" : "dbo",
        "tableChanges" : [ {
          "type" : "CREATE",
          "id" : "\"testDB\".\"dbo\".\"tablec\"",
          "table" : {
            "defaultCharsetName" : null,
            "primaryKeyColumnNames" : [ "id" ],
            "columns" : [ {
              "name" : "id",
              "jdbcType" : 4,
              "typeName" : "int",
              "typeExpression" : "int",
              "charsetName" : null,
              "length" : 10,
              "scale" : 0,
              "position" : 1,
              "optional" : false,
              "autoIncremented" : false,
              "generated" : false
            }, {
              "name" : "colc",
              "jdbcType" : 12,
              "typeName" : "varchar",
              "typeExpression" : "varchar",
              "charsetName" : null,
              "length" : 30,
              "position" : 2,
              "optional" : true,
              "autoIncremented" : false,
              "generated" : false
            } ]
          }
        } ]
      }, {
        "source" : {
          "server" : "server1"
        },
        "position" : {
          "transaction_id" : null,
          "event_serial_no" : 1,
          "commit_lsn" : "00000026:00000428:0003",
          "change_lsn" : "NULL"
        },
        "databaseName" : "testDB",
        "schemaName" : "dbo",
        "ddl" : "N/A",
        "tableChanges" : [ {
          "type" : "ALTER",
          "id" : "\"testDB\".\"dbo\".\"tableb\"",
          "table" : {
            "defaultCharsetName" : null,
            "primaryKeyColumnNames" : [ "id" ],
            "columns" : [ {
              "name" : "id",
              "jdbcType" : 4,
              "typeName" : "int",
              "typeExpression" : "int",
              "charsetName" : null,
              "length" : 10,
              "scale" : 0,
              "position" : 1,
              "optional" : false,
              "autoIncremented" : false,
              "generated" : false
            }, {
              "name" : "colb",
              "jdbcType" : 12,
              "typeName" : "varchar",
              "typeExpression" : "varchar",
              "charsetName" : null,
              "length" : 30,
              "position" : 2,
              "optional" : true,
              "autoIncremented" : false,
              "generated" : false
            } ]
          }
        } ]
      }, {
        "source" : {
          "server" : "server1"
        },
        "position" : {
          "transaction_id" : null,
          "event_serial_no" : 1,
          "commit_lsn" : "00000026:00000d28:001c",
          "change_lsn" : "00000026:00000d28:001b"
        },
        "databaseName" : "testDB",
        "schemaName" : "dbo",
        "ddl" : "N/A",
        "tableChanges" : [ {
          "type" : "ALTER",
          "id" : "\"testDB\".\"dbo\".\"tableb\"",
          "table" : {
            "defaultCharsetName" : null,
            "primaryKeyColumnNames" : [ "id" ],
            "columns" : [ {
              "name" : "id",
              "jdbcType" : 4,
              "typeName" : "int",
              "typeExpression" : "int",
              "charsetName" : null,
              "length" : 10,
              "scale" : 0,
              "position" : 1,
              "optional" : false,
              "autoIncremented" : false,
              "generated" : false
            } ]
          }
        } ]
      }]>
      [INFO] 
      [ERROR] Tests run: 82, Failures: 1, Errors: 0, Skipped: 0
      

      Attachments

        Activity

          People

            ccranfor@redhat.com Chris Cranford
            gunnar.morling Gunnar Morling
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: