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

      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

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

              Dates

              Created:
              Updated:
              Resolved: