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

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

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 0.6
    • Fix Version/s: 0.6.1
    • Component/s: mysql-connector
    • Labels:
      None
    • Environment:

      connect-0.11.0.0-cp1

      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.

        Gliffy Diagrams

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: