Thread: calling store procedure / insert statement never complete
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 show running until the sever closed connection. The same problem when I run the query statement only, insert about 190k rows, when check target table, data is insert, but in the front-end side is still show wait until server close connection.
I use pgamin4 5.3.
Error: Server closed the connection unexpectedly. This probably means the server terminated abnormally before or while processing the request.
Could you please double check?
Thanks and regards,
Trang
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 <trang.le@evizi.com> wrote:
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 show running until the sever closed connection. The same problem when I run the query statement only, insert about 190k rows, when check target table, data is insert, but in the front-end side is still show wait until server close connection.I use pgamin4 5.3.Error: Server closed the connection unexpectedly. This probably means the server terminated abnormally before or while processing the request.Could you please double check?Thanks and regards,Trang