[ 
https://issues.apache.org/jira/browse/NIFI-6501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17429331#comment-17429331
 ] 

Lei Wang commented on NIFI-6501:
--------------------------------

I have used  NIFI-6501 by setting offertimeout as a high value in our prod 
environment for about two years.

It runs good. I think we can accept the pull request

 

Thanks,
Lei

 

> Add config to limit buffer queue size in CaptureChangeMySQL
> -----------------------------------------------------------
>
>                 Key: NIFI-6501
>                 URL: https://issues.apache.org/jira/browse/NIFI-6501
>             Project: Apache NiFi
>          Issue Type: Bug
>          Components: Configuration
>    Affects Versions: 1.9.2, 1.14.0, 1.13.1, 1.13.2
>            Reporter: Purushotham Pushpavanthar
>            Assignee: Purushotham Pushpavanthar
>            Priority: Critical
>              Labels: easyfix
>         Attachments: image-2019-08-02-11-29-10-829.png
>
>          Time Spent: 2h 10m
>  Remaining Estimate: 0h
>
> CaptureChangeMySQL processor registers a listener with Blocking Queue as 
> buffer with the BinLogClient. When the thread polling from the Queue is 
> slower compared to writer, the queue grows uncontrollably and brings down the 
> node.
> Since the flow writing to listeners in 
> [mysql-binlog-connector-java|[https://github.com/shyiko/mysql-binlog-connector-java]]
>  is blocking, we should initialize the queue with *initial size* and *queue 
> offer timeout* specified by the user based in cluster configuration.
> [http://apache-nifi-developer-list.39713.n7.nabble.com/NiFi-Cluster-crashes-while-running-CaptureChangeMySQL-for-CDC-td20895.html]



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

Reply via email to