Re: ERROR: could not read block - Mailing list pgsql-admin

From Tom Lane
Subject Re: ERROR: could not read block
Date
Msg-id 9705.1132167493@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: could not read block  (Qingqing Zhou <zhouqq@cs.toronto.edu>)
List pgsql-admin
Qingqing Zhou <zhouqq@cs.toronto.edu> writes:
> On Wed, 16 Nov 2005, Kevin Grittner wrote:
>> [2005-11-16 11:59:29.015 ] 4904 <dtr dtr 165.219.88.22(60649)> LOG:
>> read failed on relation 1663/16385/1494810: -1 bytes, 1450

> 1450 ERROR_NO_SYSTEM_RESOURCES
> Insufficient system resources exist to complete the requested service

Hmm ... seems like win32/error.c ought to be mapping that to something
more helpful than EINVAL.  The link you mention suggests that we ought
to retry the read, so maybe mapping it to EINTR would be the most useful
thing.  I seem to recall that we've heard about read() sometimes failing
with EINTR on Unix-with-NFS configurations ...

            regards, tom lane

pgsql-admin by date:

Previous
From: Qingqing Zhou
Date:
Subject: Re: ERROR: could not read block
Next
From: Bruno Wolff III
Date:
Subject: Re: Reg: Changing Column type