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

INSERT statements being written to db history topic

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Minor Minor
    • 0.7.0
    • None
    • mysql-connector
    • None

      Every five minutes I am seeing a message like this written to the db history topic

      {
      "source" : {
      "server" : "sled"
      },
      "position" : {
      "ts_sec" : 1510678117,
      "file" : "mysql-bin-changelog.164775",
      "pos" : 219,
      "server_id" : 430194409,
      "event" : 1
      },
      "databaseName" : "mysql",
      "ddl" : "INSERT INTO mysql.rds_heartbeat2(id, value) values (1,1510678117058) ON DUPLICATE KEY UPDATE value = 1510678117058"
      }
      

      I verified that the binlog format of the DB is ROW

      show variables like 'binlog_format';
      +---------------+-------+
      | Variable_name | Value |
      +---------------+-------+
      | binlog_format | ROW |
      +---------------+-------+
      1 row in set (0.02 sec)
      

      My issue is that it is creating a lot of noise in the topic. I.E. a message every 5 minutes in a topic that can't be cleaned up.

            jpechane Jiri Pechanec
            ekreiser_jira Eric Kreiser (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: