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

MySQL connector does not filter out DROP TEMP TABLE statements from DB history topic

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 0.6.1
    • 0.6
    • mysql-connector
    • None

    Description

      We have a source database which creates and drops a lot of temp tables during the day. We are seeing our dbhistory topic get flooded with a lot of messages like this:

      "ddl" : "DROP TEMPORARY TABLE IF EXISTS `iready`.`xx_temp_table_test2` /* generated by server */"
      

      We're not seeing any events for the corresponding create statements or any data events for the insert statements, which is good. It appears the DROP's are making it through the filter.

      Attachments

        Activity

          People

            jpechane Jiri Pechanec
            richoconnell rich oconnell (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: