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

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

      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.

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

                Created:
                Updated:
                Resolved: