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

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

      See comment

      Show
      See comment

      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}
      

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

                Created:
                Updated:
                Resolved: