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 2017/10/17 01:45:00 UTC
[jira] [Commented] (NIFI-4490) Repetitive events detected on
changing the incorrect driver name in CaptureChangeMySQL
[ https://issues.apache.org/jira/browse/NIFI-4490?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16206897#comment-16206897 ]
Matt Burgess commented on NIFI-4490:
------------------------------------
The "Error creating binlog enrichment JDBC connection" does not stop the binlog client from running, so events may have been received but not processed (because initialization failed so onTrigger is not called). If the problem is fixed, presumably the user would want to keep those events and have them processed the next time the processor starts. However if a RESET MASTER is issued to the DB, then all binlog events are cleared (unbeknownst to the processor). The fix seems to be to not start the binlog client until the JDBC enrichment connection has been created successfully.
> Repetitive events detected on changing the incorrect driver name in CaptureChangeMySQL
> --------------------------------------------------------------------------------------
>
> Key: NIFI-4490
> URL: https://issues.apache.org/jira/browse/NIFI-4490
> Project: Apache NiFi
> Issue Type: Bug
> Reporter: Matt Burgess
>
> Followed the below steps
> 1. In CaptureChangeMySQL, set the driver name to "com.mysql.some.driver"
> 2. Create a table in the test database and start the CaptureChangeMySQL processor
> 3. "Error creating binlog enrichment JDBC connection" error message is thrown which is correct.
> This completes the first test. Next do the following
> 1. Correct the driver name
> 2. Reset the binlog events by running "RESET MASTER"
> 3. Clear the state of the CaptureChangeMySQL processor.
> 4. Start the CaptureChangeMySQL processor.
> Result : The Create statement which was triggered when the driver was invalid is detected thrice in the tests that I carried out by CaptureChangeMySQL processor
> Expected : The event should not have been detected at all since the binlogs have been deleted, state reset and the database pattern hardcoded to a single db
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)