Support Questions

Find answers, ask questions, and share your expertise

Who agreed with this topic

ExecuteSQL does not let go of threads

avatar
Explorer

Hi,

 

I am using the ExecuteSQL processor in NiFi to write records to PostgreSQL.

The problem I have is when running on multi-thread (for example 10), the processor gets stuck and runs too slow. This doesn't happen in a single thread. However, single thread is not efficient so doesn't work for me.

After getting slow, I stop the processor, terminate it, and start it again. For almost 5-10 seconds everything is ok and then the same problem.

I also have a similar problem with the InvokeHTTP processor.

 

Thank you in advance.

Who agreed with this topic