Re: BUG #15054: intermittent error: An I/O error occured while sending to the backend.

Hi,

Our JDBC driver version is kind of outdated (9.1). But upgrading to 42.2.1 makes no difference. Still failed with around the same rate.

Restarting the DB client or DB server makes no difference.

We only have one DB client app connecting to the database. Therefore, we can't tell whether this is a general problem or not.

Could you advise how I could do to collect the server log which can contain most of the information you need to troubleshoot?

Thanks!

Ming

On 07/02/2018 9:51 AM, David G. Johnston wrote:
On Wed, Feb 7, 2018 at 7:42 AM, PG Bug reporting form <noreply(at)postgresql(dot)org<mailto:noreply(at)postgresql(dot)org>> wrote:
The following bug has been logged on the website:

Bug reference: 15054
Logged by: Ming Chen
Email address: czmy(at)hotmail(dot)com<mailto:czmy(at)hotmail(dot)com>
PostgreSQL version: 9.3.20
Operating system: Redhat Enterprise 6
Description:

We experienced intermittent error about "An I/O error occured while sending
to the backend" recently.

​You will need to report your pgJDBC ​driver version and if its not the newest you should probably upgrade and confirm the problem still exists.

You say it "resets" after restarting the server...does simply reconnecting the client make a difference. Does it afflict all connected clients or just one?

Server logs probably will be useful to examine.

David J.