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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-09-28 14:40:29 | Re: Could not read block error question |
Previous Message | Kevin Grittner | 2010-09-28 14:03:09 | Re: Could not read block error question |