[jira] [Created] (NIFI-9323) CaptureChangeMySQL throw exception: "COMMIT event received while not processing a transaction (i.e. no corresponding BEGIN event)"

["louiskakashi (Jira)" <ji...@apache.org>]

louiskakashi created NIFI-9323:
----------------------------------

             Summary: CaptureChangeMySQL throw exception: "COMMIT event received while not processing a transaction (i.e. no corresponding BEGIN event)"
                 Key: NIFI-9323
                 URL: https://issues.apache.org/jira/browse/NIFI-9323
             Project: Apache NiFi
          Issue Type: Bug
            Reporter: louiskakashi
         Attachments: Screen Shot 2021-10-22 at 17.40.02.png

I'm trying to replicate data from MySQL by CaptureChangeMySQL. It's worked when I started the first time. But when I just stop processor CaptureChangeMySQL and start it again and don't change any config or clear state, it throw exception :
CaptureChangeMySQL[id=397630b9-a92c-1bcd-ad4b-bb6023e5656c] Failed to process session due to java.io.IOException: COMMIT event received while not processing a transaction (i.e. no corresponding BEGIN event). This could indicate that your binlog position is invalid.: java.io.IOException: COMMIT event received while not processing a transaction (i.e. no corresponding BEGIN event). This could indicate that your binlog position is invalid.
↳ causes: org.apache.nifi.processor.exception.ProcessException: java.io.IOException: COMMIT event received while not processing a transaction (i.e. no corresponding BEGIN event). This could indicate that your binlog position is invalid.
 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)