From: Qingqing Zhou <zhouqq@cs.toronto.edu>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: icub3d@gmail.com
Cc: mha@sollentuna.net
Cc: pgsql-admin@postgresql.org
Subject: Re: ERROR: could not read block
Date: Tue, 15 Nov 2005 19:07:34 -0500 (EST)
Message-ID: <Pine.LNX.4.58.0511151904560.551@eon.cs> (raw)
In-Reply-To: <4379FE9B020000250000072F@gwmta.wicourts.gov>
References: <4379FE9B020000250000072F@gwmta.wicourts.gov>
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
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: zhouqq@cs.toronto.edu, Kevin.Grittner@wicourts.gov, icub3d@gmail.com, mha@sollentuna.net
Subject: Re: ERROR: could not read block
In-Reply-To: <Pine.LNX.4.58.0511151904560.551@eon.cs>
* 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