You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@nifi.apache.org by "Matt Burgess (Jira)" <ji...@apache.org> on 2022/12/16 19:02:00 UTC

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

     [ https://issues.apache.org/jira/browse/NIFI-9323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Matt Burgess resolved NIFI-9323.
--------------------------------
    Resolution: Duplicate

I believe the cause of this to be a duplicate of NIFI-6428, which has been fixed in NiFi 1.19.1 and will be 1.20. If you find this error remains in either of those releases, please feel free to reopen the case with comments.

> 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
>            Priority: Major
>         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.20.10#820010)