| From: | Mohit Kumar Sahni <Mohit(dot)Sahni(at)india(dot)nec(dot)com> |
|---|---|
| To: | "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: | Connection Drop from PostgreSQL Database Server |
| Date: | 2019-03-05 12:19:35 |
| Message-ID: | TYAPR01MB2063E77CF28C350045ABEACFBC720@TYAPR01MB2063.jpnprd01.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
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.
Thank you
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Boris Sagadin | 2019-03-05 12:39:01 | Slave server sometimes locks up |
| Previous Message | Arthur Zakirov | 2019-03-05 10:30:18 | Re: query logging of prepared statements |