Re: [BUGS] postgres client connection issue - Mailing list pgsql-bugs
Thanks Tom for acknowledge my mail. Below is the detail as you requested:
PG Version DBD::Pg : 2.10.3
TCP parameters in postgresql.conf configuration file:
#tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds; # 0 selects the system default #tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds; # 0 selects the system default #tcp_keepalives_count = 0 # TCP_KEEPCNT; # 0 selects the system default |
Postgers server logs:
2017-02-01 10:56:27 LOG: could not receive data from client: Connection reset by peer 2017-02-01 10:56:27 LOG: unexpected EOF on client connection 2017-02-01 10:57:19 LOG: could not receive data from client: Connection reset by peer 2017-02-01 10:57:19 LOG: unexpected EOF on client connection 2017-02-01 11:50:56 LOG: could not receive data from client: Connection reset by peer 2017-02-01 11:50:56 LOG: unexpected EOF on client connection 2017-02-01 12:11:48 LOG: could not receive data from client: Connection reset by peer 2017-02-01 12:11:48 LOG: unexpected EOF on client connection 2017-02-01 12:11:54 LOG: could not receive data from client: Connection reset by peer 2017-02-01 12:11:54 LOG: unexpected EOF on client connection 2017-02-01 12:32:42 LOG: could not receive data from client: Connection reset by peer 2017-02-01 12:32:42 LOG: unexpected EOF on client connection 2017-02-01 13:00:01 LOG: unexpected EOF on client connection 2017-02-01 13:00:01 LOG: unexpected EOF on client connection 2017-02-01 13:00:01 LOG: unexpected EOF on client connection 2017-02-01 13:30:01 LOG: unexpected EOF on client connection 2017-02-01 14:00:23 LOG: could not receive data from client: Connection reset by peer 2017-02-01 14:00:23 LOG: unexpected EOF on client connection 2017-02-01 14:10:02 LOG: unexpected EOF on client connection 2017-02-01 14:13:33 LOG: unexpected EOF on client connection 2017-02-01 14:13:36 LOG: unexpected EOF on client connection 2017-02-01 14:58:47 LOG: could not receive data from client: Connection reset by peer 2017-02-01 14:58:47 LOG: unexpected EOF on client connection 2017-02-01 15:01:36 LOG: could not receive data from client: Connection reset by peer 2017-02-01 15:01:36 LOG: unexpected EOF on client connection 2017-02-01 15:46:34 LOG: could not receive data from client: Connection reset by peer 2017-02-01 15:46:34 LOG: unexpected EOF on client connection 2017-02-01 15:48:02 LOG: could not receive data from client: Connection reset by peer 2017-02-01 15:48:02 LOG: unexpected EOF on client connection 2017-02-01 16:28:29 LOG: could not receive data from client: Connection reset by peer 2017-02-01 16:28:29 LOG: unexpected EOF on client connection 2017-02-01 16:40:04 LOG: could not receive data from client: Connection reset by peer 2017-02-01 16:40:04 LOG: unexpected EOF on client connection 2017-02-01 16:53:10 LOG: could not receive data from client: Connection reset by peer 2017-02-01 16:53:10 LOG: unexpected EOF on client connection 2017-02-01 16:56:48 LOG: could not receive data from client: Connection reset by peer 2017-02-01 16:56:48 LOG: unexpected EOF on client connection 2017-02-01 17:22:46 LOG: could not receive data from client: Connection reset by peer 2017-02-01 17:22:46 LOG: unexpected EOF on client connection 2017-02-01 17:38:44 LOG: could not receive data from client: Connection reset by peer 2017-02-01 17:38:44 LOG: unexpected EOF on client connection 2017-02-01 18:06:12 LOG: could not receive data from client: Connection reset by peer 2017-02-01 18:06:12 LOG: unexpected EOF on client connection 2017-02-01 18:18:00 LOG: could not receive data from client: Connection reset by peer 2017-02-01 18:18:00 LOG: unexpected EOF on client connection 2017-02-01 19:22:37 LOG: could not receive data from client: Connection reset by peer 2017-02-01 19:22:37 LOG: unexpected EOF on client connection 2017-02-01 20:57:29 LOG: could not receive data from client: Connection reset by peer 2017-02-01 20:57:29 LOG: unexpected EOF on client connection |
Thanks & Regards,
Ranjeet Singh
Technology Analyst, Infosys Ltd
Electronics City, Bengaluru, Karnataka, India 560100
M: +91 9663748161
E: ranjeet_singh03@infosys.com
Telstra Internet Direct (TID)
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Friday, 3 February 2017 8:21 PM
To: Ranjeet Singh03 <Ranjeet_Singh03@infosys.com>
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] postgres client connection issue
Ranjeet Singh03 <Ranjeet_Singh03@infosys.com> writes:
> Below is the error logged in log file:
> DBD::Pg::st execute failed: server closed the connection unexpectedly
> This probably means the server terminated abnormally
What appears in the server's log when this happens? What PG version is it?
regards, tom lane
pgsql-bugs by date: