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:
Show quoted text
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