| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Mohit Kumar Sahni <Mohit(dot)Sahni(at)india(dot)nec(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Cc: | Maneesh Kumar Singh <maneesh(dot)singh(at)india(dot)nec(dot)com> |
| Subject: | Re: Connection Drop from PostgreSQL Database Server |
| Date: | 2019-03-06 00:49:28 |
| Message-ID: | 4fe719b0-1566-76c4-36c3-3f6548e31f5e@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 3/5/19 4:19 AM, Mohit Kumar Sahni wrote:
> I have done a setup over Azure Cloud for my PostgreSQL DB.
> It's Ubuntu 18.04 LTS (4vCPU, 8GB RAM) machine with PostgreSQL 9.6 version.
> The problem that occurring is, when the connection to the postgresql db stays idle for some time let's say 2 to 10 minutes then the connection to the db does not respond such that it doesn't fulfil the request and keep processing the query.
> Same goes with my JAVA Springboot Application. The connection doesn't respond and the query keep processing.
Is there anything in the Postgres log that is relevant?
The same for the OS system log?
>
> This happens randomly such that the timing is not traceable sometimes it happens in 2 minutes, sometimes in 10 minutes & sometimes don't.
> I have tried with PostgreSQL Configuration file parameters. I have tried:
> tcp_keepalive_idle, tcp_keepalive_interval, tcp_keepalive_count.
> Also statement_timeout & session_timeout parameters but it doesn't change anyway.
What values for the above?
>
> Thank you
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | 范国腾 | 2019-03-06 01:57:58 | How to make PAF use psql to login with password |
| Previous Message | Mark Fletcher | 2019-03-06 00:26:12 | Non-pausing table scan on 9.6 replica? |