pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Qingqing Zhou <zhouqq@cs.toronto.edu>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: icub3d@gmail.com
Cc: pgsql-admin@postgresql.org
Subject: Re: ERROR: could not read block
Date: Wed, 16 Nov 2005 13:58:13 -0500
Message-ID: <9705.1132167493@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.58.0511161317440.13032@eon.cs>
References: <437B21E90200002500000781@gwmta.wicourts.gov>
	<Pine.LNX.4.58.0511161317440.13032@eon.cs>

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



view thread (41+ messages)  latest in thread

Message-ID: <9705.1132167493@sss.pgh.pa.us>
Permalink:  ../9705.1132167493@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/9705.1132167493@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, zhouqq@cs.toronto.edu, Kevin.Grittner@wicourts.gov, icub3d@gmail.com
  Subject: Re: ERROR: could not read block
  In-Reply-To: <9705.1132167493@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox