Re: An I/O error occurred while sending to the backend (PG 13.4)

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: ldh(at)laurent-hasson(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: An I/O error occurred while sending to the backend (PG 13.4)
Date: 2022-03-01 19:26:41
Message-ID: 20220301192641.GA15744@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Mar 01, 2022 at 04:28:31PM +0000, ldh(at)laurent-hasson(dot)com wrote:
> Now, there is an additional component I think... Storage is on an array and I am not getting a clear answer as to where it is 😊 Is it possible that something is happening at the storage layer? Could that be reported as a network issue vs a storage issue for Postgres?

No. If there were an error with storage, it'd be reported as a local error,
and the query would fail, rather than failing with client-server communication.

> Also, both machines are actually VMs. I forgot to mention that and not sure if that's relevant.

Are they running on the same hypervisor ? Is that hyperv ?
Lacking other good hypotheses, that does seem relevant.

--
Justin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ranier Vilela 2022-03-02 01:15:49 Re: An I/O error occurred while sending to the backend (PG 13.4)
Previous Message Andrew Zakharov 2022-03-01 18:43:43 RE: Simple task with partitioning which I can't realize