problem with setting of Time Duration property from group variable

2019-09-16 Thread l vic
I am trying to set Time Duration property in ControlRate processor from processor group variable. I have INTERVAL variable set to 20 and I tried to set Time Duration as ${INTERVAL} mins ${INTERVAL:toNumber() mins} I each case i have error like the following: Time duration validated against

ExecuteSQLRecord Bug

2019-09-16 Thread Bimal Mehta
Hi, We are using ExecuteSQLRecord processor that reads the query and certain attributes from the previous flow, We have the following properties set; Max Rows Per Flow File: 5 Output Batch Size: 5 In our case we have 1 mn records coming from the source. 20 flowfiles get created that get

RE: NiFi cluster heavy cpu usage

2019-09-16 Thread Williams, Jim
Lei, I have seen this on 1.9.2 standalone and cluster deployments. Every time I have seen this so far, the reason has been an input port in a process group which is not connected by an output port. The input port can be identified in the user interface by drilling down to the active thread.

CaptureChangeMySQL log event entry exceeded max_allowed_packet

2019-09-16 Thread wangl...@geekplus.com.cn
Is there any other method except increasing max_allowed_packet on master? For example, i can just skip it. But how can i do that? 2019-09-16 20:15:44,370 ERROR [Timer-Driven Process Thread-2] o.a.n.c.m.processors.CaptureChangeMySQL CaptureChangeMySQL[id=95aa3f6e-e015-1bcf-adf3-2764233af36d]

NiFi cluster heavy cpu usage

2019-09-16 Thread wangl...@geekplus.com.cn
I deployed a nifi cluster with two virtual machines, each 4 core, 16 GB memroy The cpu is more than 100% even there's no processor running. Often the cpu is about 300% after i start some processors. [root@iZuf6agrzcolqeja3if7kbZ ~]# ps -mp 3429 -o THREAD,tid,time | sort -k2 -n -r |less