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

When blocking snapshot running, Debezium did not stop streaming

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Blocker Blocker
    • None
    • 2.4.0.Final
    • mysql-connector
    • None
    • False
    • None
    • False
    • Critical

      Hi, When I run a blocking snapshot with kafka signal, Debezium did not stop streaming, Incremental data was still collected, including snapshot tables and other tables, If data modification occurs at the same time, and the snapshot of the same data is later than the streaming, the final streaming data will be overwritten, as follows:

      Bug report

      For bug reports, provide this information, please:

      What Debezium connector do you use and what version?

      2.4.0.Final

      What is the connector configuration?

      {
          "name": "mysql_cdc_test_10000000000003",
          "config":

      { "snapshot.locking.mode": "none", "connector.class": "io.debezium.connector.mysql.MySqlConnector", "tasks.max": "1", "database.history.kafka.topic": "mysql_cdc_test_100000000000002_history.dy_test",   "transforms": "Reroute",         "transforms.Reroute.topic.regex": "(.*)", "transforms.Reroute.topic.replacement": "mysql_cdc_test_100000000000002_all", "transforms.Reroute.type": "io.debezium.transforms.ByLogicalTableRouter",   "topic.prefix": "mysql_cdc_test_100000000000002", "decimal.handling.mode": "string", "schema.history.internal.kafka.topic": "mysql_cdc_test_100000000000002_history.dy_test",         "schema.history.internal.kafka.bootstrap.servers": "127.0.0.1:9092",   "database.user": "root", "database.server.id": "100000000000002", "database.history.kafka.bootstrap.servers": "127.0.0.1:9092", "database.server.name": "mysql_cdc_test_100000000000002", "database.port": "3306", "database.connectionTimeZone": "Asia/Shanghai", "database.hostname": "127.0.0.1", "database.password": "xxxxx",   "snapshot.mode": "initial",         "table.include.list":"dy_test.dy_test_80_test_init_data_1",           "signal.enabled.channels": "kafka",         "signal.kafka.bootstrap.servers": "127.0.0.1:9092" }

      }

      What is the captured database version and mode of depoyment?

      5.7

      What behaviour do you expect?

      Stop streaming of snapshot table

      What behaviour do you see?

      If data modification occurs at the same time, and the snapshot of the same data is later than the streaming, the final streaming data will be overwritten

      Do you see the same behaviour using the latest relesead Debezium version?

      yes

      Do you have the connector logs, ideally from start till finish?

      (You might be asked later to provide DEBUG/TRACE level log)

      <Your answer>

      How to reproduce the issue using our tutorial deployment?

      <Your answer>

      Feature request or enhancement

      For feature requests or enhancements, provide this information, please:

      Which use case/requirement will be addressed by the proposed feature?

      <Your answer>

      Implementation ideas (optional)

      <Your answer>

              Unassigned Unassigned
              351114671@qq.com QuanFeng Yao (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: