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

SQL Server connector does not persist LSNs in Kafka

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 0.9.0.CR1
    • 0.9.0.Beta1
    • sqlserver-connector
    • None

      I have several connectors running for at least a month. A few of them seem not to store proper offsets in Kafka topic. Below are two sample entries in Kafka offset topic:

      CreateTime:1546609528972    ["prod.XXXX",{"server":"prod.XXXX"}]    {"change_lsn":"0003d5c5:0000bcdd:00ca"}
      CreateTime:1546609528974    ["prod.YYYY",{"server":"prod.YYYY"}]    {"snapshot":true,"snapshot_completed":true}
      

      Both connectors are continuously processing events and continuously persisting to offset topic. The first one persists increasing lsns while the second one always persists the same information (

      {"snapshot":true,"snapshot_completed":true}

      ).

              jpechane Jiri Pechanec
              grzegorz.kolakowski Grzegorz KoĊ‚akowski (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: