Re: BUG #15054: intermittent error: An I/O error occured whilesending to the backend. - Mailing list pgsql-bugs

From ZhongMing C
Subject Re: BUG #15054: intermittent error: An I/O error occured whilesending to the backend.
Date
Msg-id CO1PR14MB0901D2BA641ECB753F0018D4C2FC0@CO1PR14MB0901.namprd14.prod.outlook.com
Whole thread Raw
In response to Re: BUG #15054: intermittent error: An I/O error occured whilesending to the backend.  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs

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@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      15054
Logged by:          Ming Chen
Email address:      czmy@hotmail.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.


pgsql-bugs by date:

Previous
From: David Kohn
Date:
Subject: Re: BUG #15036: Un-killable queries Hanging in BgWorkerShutdown
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #15054: intermittent error: An I/O error occured whilesending to the backend.