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

SQL Server connector does not persist LSNs in Kafka

    XMLWordPrintable

Details

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

    Description

      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}

      ).

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: