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

Re: Could not read block error question

From: Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Could not read block error question
Date: 2010-09-28 14:38:41
Message-ID: AANLkTimg59574Akqne1s5kcV1_s3Oyhz4=YnsGkGDP9t@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
I would provide all the needed information if I only had them. The
thing is it happened on one of our client's machine and all he did was
reporting the problem without providing us the data folder. So I asked
the question just to know whether it is possible to read from a higher
block number than the highest physical number. Thank You for Your
attention.

2010/9/28 Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>:
> Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com> wrote:
>
>> I got an error "Could not read block <no.> of relation...." it
>> appeared to be in pg_trigger
>
> If you'd pasted in the message as it appeared, we wouldn't need to
> guess whether you're right.
>
>> the block number was 110 and the file has only 67 pages. So the
>> question is how is it possible?
>
> That could be, if your reading of things is right, database
> corruption.  Before you do anything else, shutdown the database
> server and make a copy of the data directory and all its
> subdirectories.  (Don't try to pick one database or otherwise pick
> and choose files.)  Save that backup until you've recovered from the
> problem and things have been stable for at least a few weeks.
>
> Next, read this page and repost with more information:
>
> http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
>
> So far you haven't given us much to work with.
>
> -Kevin
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>



-- 
Łukasz Brodziak
II MU Bioinformatyka

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2010-09-28 14:40:29
Subject: Re: Could not read block error question
Previous:From: Kevin GrittnerDate: 2010-09-28 14:03:09
Subject: Re: Could not read block error question

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