Uploaded image for project: 'Apache NiFi'
  1. Apache NiFi
  2. NIFI-3749

CaptureChangeMySQL should filter Query and XID events by database regex

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.2.0
    • 1.2.0
    • Extensions
    • None

    Description

      Although Query events including BEGIN/COMMIT and DDL statements do not have corresponding TableMap event, they still have 'database' name. So, it's possible to apply 'database' filter regex to filter out unnecessary events.

      Currently, Queries executed against a database which is not in interest can generate FlowFiles, and it can cause unexpected behavior.

      When we fix this, we should be careful about XID event and 'inTransaction' flag as XID event only has transaction id, we may need to add checking 'skipTable', too.

      Also, we need to pass database to DDLEventInfo.tableInfo to write database name into outgoing FlowFile.

      Finally, Begin/CommitTransactionEventInfo currently don't have database property or TableInfo in it. Adding database property to these class might be a right approach.

      Attachments

        Issue Links

          Activity

            People

              mattyb149 Matt Burgess
              ijokarumawak Koji Kawamura
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: