-
Bug
-
Resolution: Duplicate
-
Critical
-
None
-
1.6.1.Final, 1.7.0.Alpha1
-
None
-
False
-
False
-
undefined
-
-
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}
- duplicates
-
DBZ-3375 SQL Server connector produces the same record during snapshot and streaming
- Pull Request Sent