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

SQL Server: rows inserted around snapshot time replicated twice even with snapshot.isolation.mode = exclusive

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Critical
    • None
    • 1.6.1.Final, 1.7.0.Alpha1
    • sqlserver-connector
    • None
    • False
    • False
    • undefined
    • Hide

      See comment

      Show
      See comment

    Description

      Rows inserted close to the snapshot time are reflected twice in the Kafka topic. Once with snapshot=true and then exactly the same row with snapshot=false:

      {"before":null,"after":{"sql_server.dbo.update_table_pk.Value":{"key_col":"key1","value_col":{"string":"value1"}}},"source":{"version":"1.6.0.Final","connector":"sqlserver","name":"sql-server","ts_ms":1629880691917,"snapshot":{"string":"true"},"db":"test","sequence":null,"schema":"dbo","table":"update_table_pk","change_lsn":null,"commit_lsn":{"string":"00000027:00000f50:001d"},"event_serial_no":null},"op":"r","ts_ms":{"long":1629880691917},"transaction":null}
...
{"before":null,"after":{"sql_server.dbo.update_table_pk.Value":{"key_col":"key1","value_col":{"string":"value1"}}},"source":{"version":"1.6.0.Final","connector":"sqlserver","name":"sql-server","ts_ms":1629880688853,"snapshot":{"string":"false"},"db":"test","sequence":null,"schema":"dbo","table":"update_table_pk","change_lsn":{"string":"00000028:00000e68:0020"},"commit_lsn":{"string":"00000028:00000e68:0021"},"event_serial_no":{"long":1}},"op":"c","ts_ms":{"long":1629880695076},"transaction":null}

      Attachments

        Issue Links

          duplicates

          Bug - A problem that impairs or prevents the functions of the product. DBZ-3375 SQL Server connector produces the same record during snapshot and streaming

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Pull Request Sent

          Activity

            People

              jpechane Jiri Pechanec
              philip_stoev Philip Stoev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: