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

Producer does not send any new events to Kafka after snapshot when using MySQL 5.5

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Minor
    • 0.3.3, 0.4
    • 0.3.1
    • mysql-connector
    • None

    Description

      During the snapshot the Kafka topic receives events (confirmed using the console consumer). After the snapshot it seems like the connector is connected to the correct binlog file/pos (see log below) but no events show up on the same Kafka topic

      2016-09-03 16:39:27,003 INFO   MySQL|mysql-server-dbstg2|task  Step 0: Get all known binlogs from MySQL   [io.debezium.connector.mysql.MySqlConnectorTask]
2016-09-03 16:39:27,012 INFO   MySQL|mysql-server-dbstg2|task  MySQL has the binlog file 'dbstg2-20-bin-log.000097' required by the connector   [io.debezium.connector.mysql.MySqlConnectorTask]
Sep 03, 2016 4:39:27 PM com.github.shyiko.mysql.binlog.BinaryLogClient connect
INFO: Connected to 172.30.43.2:3306 at dbstg2-20-bin-log.000097/74864 (sid:20, cid:1169)
2016-09-03 16:39:27,085 INFO   MySQL|mysql-server-dbstg2|binlog  Connected to MySQL binlog at 172.30.43.2:3306, starting at binlog file 'dbstg2-20-bin-log.000097', pos=74864, row=0   [io.debezium.connector.mysql.BinlogReader]
2016-09-03 16:39:27,085 INFO   ||  Source task WorkerSourceTask{id=optimis-staging-cc-0} finished initialization and start   [org.apache.kafka.connect.runtime.WorkerSourceTask]

      Attachments

        Issue Links

          is related to

          Bug - A problem that impairs or prevents the functions of the product. DBZ-124 MySQL connector generates warning "Error registering AppInfo mbean"

          • Critical - To be worked on immediately following BLOCKER issues.
          • Closed
          relates to

          Bug - A problem that impairs or prevents the functions of the product. DBZ-128 MySQL connector should fail or warn when MySQL isn't using row-level binlog

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              rhauch Randall Hauch (Inactive)
              uchouhan Umang Chouhan (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: