Search Postgresql Archives

Re: calling store procedure / insert statement never complete

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux