How much memory do you have on your instance? I would say the fetch size should be bigger then the Max Rows…
> On 1. Mar 2021, at 06:37, Vibhath Ileperuma <vibhatharunapr...@gmail.com> > wrote: > > Hi all, > > I tried to fetch a large dataset from postgresql using the ExcureSQL > processor. > The configurations I used is, > Fetch Size : 100 > Max Rows per flow file 200000 > Output Batch Size 1 > > When I start the processor, after some time, NIFI web frontend disconnects. I > checked the app log, but there were no errors. > > I would be grateful if you could suggest to me the reason for this issue and > a way to overcome this. > > Thanks & Regards > Vibhath Ileperuma >