Skip site navigation (1) Skip section navigation (2)

Re: ERROR: could not read block

From: Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: icub3d(at)gmail(dot)com, mha(at)sollentuna(dot)net, pgsql-admin(at)postgresql(dot)org
Subject: Re: ERROR: could not read block
Date: 2005-11-16 00:07:34
Message-ID: Pine.LNX.4.58.0511151904560.551@eon.cs (view raw or flat)
Thread:
Lists: pgsql-admin

On Tue, 15 Nov 2005, Kevin Grittner wrote:

> I got the error log working on Windows (with redirect_stderr).  I had
> to stop and restart postgres to do so.  I ran the query (for the fourth
> time), and it completed successfully.

Strange - the phyiscal read for the 2nd, 3rd, 4th time should be the
same, if we intent to think of the IO presure.

>
> Is there anything that anyone wants me to do at this point, to try
> to pin down a cause, or do I drop it here?
>

Since you can reproduce the error with big chance, I think it is a good
chance to pin down a cause now. It would be useful to know the
GetLastError() instead of a tranlated errno. Can you patch the code like
this (patch smgrread()):

http://archives.postgresql.org/pgsql-bugs/2005-10/msg00050.php


Regards,
Qingqing


In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2005-11-16 00:25:47
Subject: Re: ERROR: could not read block
Previous:From: Kevin KeithDate: 2005-11-15 23:36:45
Subject: Re: ERROR: could not read block

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group