Re: calling store procedure / insert statement never complete

2021-09-02 Thread Ninad Shah
Kindly consider checking tcp_keepalive in PostgreSQL as well as OS kernel. By default, it is 2 hours(7200). Regards, Ninad Shah On Thu, 2 Sept 2021 at 11:43, Trang Le wrote: > Hi Mladen, > > I missed previous emails, so I am creating a new one. > > I think the problem is coming from front-end

calling store procedure / insert statement never complete

2021-09-01 Thread Trang Le
Hi Mladen, I missed previous emails, so I am creating a new one. I think the problem is coming from front-end side. when I run store procedure, job in pg_locks is done, data is inserted, log table shows that job completed with number of insert. However, store procedure in front-end side is still